mannas006 commented on issue #1722:
URL: https://github.com/apache/age/issues/1722#issuecomment-2051859667
It appears that the upsert_triplet_test function's object parameter contains
a single quotation, which is causing the error. 'Technology busin be run by
product people' is one of the syntactic errors that the warning particularly
addresses. This is probably because the Cypher query contains a syntax mistake
because the single quote in the string is being read as the end of the string.
To handle this case, you can escape the single quote within the object
parameter. In Python, you can escape a single quote by using another single
quote. Here's how you can modify your function call to handle the single quote
in the object parameter:
```python
upsert_triplet_test(
"I", "Learned", "It''s better for technology companies to be run by
product people"
)
```
By replacing the single quote with two single quotes (''), you escape the
single quote within the string, ensuring that it is interpreted correctly in
the Cypher query.
Your modified Cypher query should look like this:
```sql
SELECT * FROM ag_catalog.cypher('graph_store', $$
MERGE (n1:`Entity` {id: 'I'})
MERGE (n2:`Entity` {id: 'It''s better for technology companies to be run
by product people'})
MERGE (n1)-[:`Learned`]->(n2)
$$) AS (a ag_catalog.agtype);
```
--
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
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
