lapp0 opened a new issue, #1318:
URL: https://github.com/apache/age/issues/1318
**Describe the bug**
Code:
```
ag = age.connect(graph=GRAPH_NAME, dsn=get_dsn())
query = """
CREATE
(
n:Entity
{name: %s}
)
RETURN n
"""
params = ('John',)
cursor = ag.execCypher(query, params)
```
Traceback:
```
File "/usr/src/app/graph_db_ops.py", line 27, in execute_query
cursor = ag.execCypher(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/age/age.py", line 198, in
execCypher
return execCypher(self.connection, self.graphName, cypherStmt,
cols=cols, params=params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/age/age.py", line 142, in
execCypher
raise cause
File "/usr/local/lib/python3.11/site-packages/age/age.py", line 138, in
execCypher
cursor.execute(stmt)
psycopg2.errors.SyntaxError: syntax error at or near "%"
LINE 1: SELECT * from cypher(NULL,NULL) as (John agtype);
```
database logs:
```
2023-10-27 09:13:06.315 UTC [80] ERROR: syntax error at or near "%" at
character 47
2023-10-27 09:13:06.315 UTC [80] STATEMENT: SELECT * from cypher(NULL,NULL)
as (John agtype);
```
I don't see any other bug reports, but this is a relatively simple query.
What am I missing?
**How are you accessing AGE (Command line, driver, etc.)?**
Python driver.
**Expected behavior**
Simple CREATE query works.
**Environment (please complete the following information):**
Attempted both PG15 and PG14
Attempted both apache-age-python 0.0.7 and 0.0.6
Currently
```
antlr4-python3-runtime==4.11.1
apache-age-python==0.0.7
greenlet==3.0.1
psycopg2==2.9.9
python-dotenv==1.0.0
SQLAlchemy==2.0.22
typing_extensions==4.8.0
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
