[I] Failure to Execute simple CREATE Query in Python Driver [age]

[via GitHub]

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: dev-unsubscr...@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org