can not insert JSON data

[bindi-mo]

If there is a single quote in the JSON data, it will be enclosed in double quotes, causing a syntax error and making it impossible to insert.

Value.to_query() in query.py

if value.find("'") != -1:
    return f'"{value}"'

What should I do?

[thombashi]

Thank you for your report.
Could you possibly provide some example code to reproduce the problem?

[bindi-mo]

Not only for JSON Data, but if the content contains a mixture of double and single quotes, an error will occur.

He say "It’s like something out of Teenage Mutant Ninja Turtles."

to_query() is

"He say "It’s like something out of Teenage Mutant Ninja Turtles.""

json.dumps() uses escape sequences, so there is no need to enclose it in double quotes.

But, Unable to determine whether single quotes in content are escaped.

>>> "It’s like something out of Teenage Mutant Ninja Turtles.".find("'")
-1
>>> "It\’s like something out of Teenage Mutant Ninja Turtles.".find("'")
-1
>>> "It\’s like something out of Teenage Mutant Ninja Turtles.".find("\'")
-1
>>> "It’s like something out of Teenage Mutant Ninja Turtles.".find("\'")
-1

I can't come up with any good ideas.

I do replace ' to unicode 0x2019 now.