How to handle the param if there're single quotes in it?

[0xnoahzhu]

Describe the bug
An error is observed when a property parameter includes a single quote.

How are you accessing AGE (Command line, driver, etc.)?

• I'm using the apache-age-python package in a python project.

What data setup do we need to do?

def upsert_triplet_test(subj: str, rel: str, obj: str) -> None:
    prepared_statement = f"""
        MERGE (n1:`Entity` {{id: %s}})
        MERGE (n2:`Entity` {{id: %s}})
        MERGE (n1)-[:`{rel.replace(" ", "_").upper()}`]->(n2)
    """

    ag.execCypher(
        prepared_statement,
        params=(
            subj,
            obj,
        ),
    )

    ag.commit()


upsert_triplet_test(
    "I", "Learned", "It's better for technology companies to be run by product people"
)

This is the error

    cursor.execute(stmt)
psycopg2.errors.SyntaxError: syntax error at or near "'s better for technology companies to be run by product people'"

What is the necessary configuration info needed?

• nothing

What is the command that caused the error?

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);

Not sure how to handle this case

ERROR:  syntax error at or near "s"
LINE 3:      MERGE (n2:`Entity` {id: 'It's better for technology com...

Expected behavior
This merge operation should be succeed.

Environment (please complete the following information):

• Version: package version 0.0.7
• AGE Version: 1.5.0

Additional context
no

[0xnoahzhu]

When I use Neo4j, I can create like this, the edge label can also include single quote

MERGE (n1:`TEST`{id: 'a\'bb'})
MERGE (n2:`TEST`{id: 'bb \'s abc'})
MERGE (n1)-[:`ABC_I'S_a`]->(n2)

[jrgemignani]

@noahxzhu Did you try using the backslash for the cypher query? Your example above doesn't show it.

psql-16.1-5432-pgsql=# SELECT * from ag_catalog.cypher('test', $$
     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);
 a
---
(0 rows)

psql-16.1-5432-pgsql=# SELECT * FROM cypher('test', $$ MATCH (v) RETURN v $$) AS (v agtype);
                                                                      v

------------------------------------------------------------------------------------------------------------------------------------
----------
 {"id": 844424930131969, "label": "Entity", "properties": {"id": "I"}}::vertex
 {"id": 844424930131970, "label": "Entity", "properties": {"id": "It's better for technology companies to be run by product people"}
}::vertex
(2 rows)

psql-16.1-5432-pgsql=#

[jrgemignani]

@noahxzhu Additionally, this sounds more like a question than a bug.

[markgomer]

Can you put double quotes around the string?

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 worked for me alright

[0xnoahzhu]

Can you put double quotes around the string?

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 worked for me alright

@markgomer
I just copy and paste yours, it seems not work

[0xnoahzhu]

@noahxzhu Did you try using the backslash for the cypher query? Your example above doesn't show it.

psql-16.1-5432-pgsql=# SELECT * from ag_catalog.cypher('test', $$
     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);
 a
---
(0 rows)

psql-16.1-5432-pgsql=# SELECT * FROM cypher('test', $$ MATCH (v) RETURN v $$) AS (v agtype);
                                                                      v

------------------------------------------------------------------------------------------------------------------------------------
----------
 {"id": 844424930131969, "label": "Entity", "properties": {"id": "I"}}::vertex
 {"id": 844424930131970, "label": "Entity", "properties": {"id": "It's better for technology companies to be run by product people"}
}::vertex
(2 rows)

psql-16.1-5432-pgsql=#

@jrgemignani
not work on my side, I need to investigate the reason

[markgomer]

Can you put double quotes around the string?

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 worked for me alright

@markgomer I just copy and paste yours, it seems not work

Try setting the search_path:

SET search_path TO ag_catalog;

I'm not sure why it is not working without this, though.

[0xnoahzhu]

Can you put double quotes around the string?

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 worked for me alright

@markgomer I just copy and paste yours, it seems not work

Try setting the search_path:

SET search_path TO ag_catalog;

I'm not sure why it is not working without this, though.

After setting the search_path, now it's working, but why?

[0xnoahzhu]

Another question, should this work as it in Neo4j?

SELECT * from ag_catalog.cypher('graph_store', $$
	MERGE (n1:`TEST`{id: 'a\'bb'})
	MERGE (n2:`TEST`{id: 'bb \'s abc'})
	MERGE (n1)-[:`ABC_I'S_a`]->(n2)
$$) as (a ag_catalog.agtype);

[0xnoahzhu]

I still have the problem with the python driver, how to handle it with a param which contains single quotes, I digged into the python code, it do set the search_path, but not works

[jrgemignani]

@noahxzhu

After setting the search_path, now it's working, but why?

The search path is needed to see Cypher

[jrgemignani]

Another question, should this work as it in Neo4j?

SELECT * from ag_catalog.cypher('graph_store', $$
	MERGE (n1:`TEST`{id: 'a\'bb'})
	MERGE (n2:`TEST`{id: 'bb \'s abc'})
	MERGE (n1)-[:`ABC_I'S_a`]->(n2)
$$) as (a ag_catalog.agtype);

I'm not sure I understand what you are asking. Also, keep in mind that you will likely need to backslash all non wrapping quote characters.