Python SQL throws error for single quote like

Asked Aug 07 '19 at 22:30

Active Aug 07 '19 at 23:11

Viewed 37 times

I am executing a query in python using cs.execute() and I have a bunch of like clauses which is throwing an error. Below is the query:

cs.execute("select * from "
"production.finance.invoice_transactions a "
"inner join production.core.merchant_info b "
"WHERE  a.status IN ( 'refundSettledSuccessfully', 'returnedItem' ) "
"AND b.mid_partner_id in (%s) "
"AND a.customer_profile_id LIKE 'W_%' "
"AND a.customer_profile_id NOT LIKE '%@%' "
"AND to_date(settle_time_local) between %s and %s "
"AND to_date(b.created_at) = %s ", (id, dt1, dt2, dt1))

I am getting the error at the lines where I have the like clause. I have confirmed this by removing the like clause and the query executes successfully. I am not sure how I can resolve this error. The error specifically says its due to the single quotes. Below is the error.

ValueError: unsupported format character ''' (0x27) at index 1754

edited Aug 07 '19 at 22:36

asked Aug 07 '19 at 22:30

Ravi

Have you tried doing `cs.execute` on a single triple-quote string? That gives you a bit more flexibility in using single/double quotes in the query itself. – Jeremy H Aug 07 '19 at 22:33
1

Are you sure this is your real query? You have `select * from FROM ...` – John Gordon Aug 07 '19 at 22:33
I am not sure how to use the single triple-quote string in this case – Ravi Aug 07 '19 at 22:36
@JohnGordon Fixed the type, yes this is the actual query, i just removed the column names – Ravi Aug 07 '19 at 22:37
Change `LIKE 'W_%'` to `LIKE 'W_%%'` and `NOT LIKE '%@%' to `NOT LIKE '%%@%%'` – Barmar Aug 07 '19 at 23:14

Python SQL throws error for single quote like

0 Answers0