Python Multi Line SQL Statement, insert variable with single quotes

Question

Question is similar to Pythonic way to create a long multi-line string

However, I need to insert a variable wrapped in single quotes into my query. Cant seem to get it to work. Whenver I output my query I am just getting 2019-03-13 and I think it should be '2019-03-13'

businessDate = '2019-03-13'


    sql = f"""   
#query goes in here.
 and businessdate = {businessDate}

    """

error msg:

': ('42883', '[42883] ERROR 4286: Operator does not exist: date = int\nHINT: No operator matches the given name and argument type(s). You may need to add explicit type casts\n (4286) (SQLExecDirectW)')

Gro · Accepted Answer · 2019-04-10 13:10:14Z

3

Pythonic way of achieving String interpolation is

businessDate = '2019-03-13'
sql = """   
 #query goes in here.
 and businessdate = '%s'
""" %businessDate

print(sql) #to check the end result

answered Apr 10, 2019 at 13:10

Gro

1,6931 gold badge14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Anton Rasmussen · Accepted Answer · 2019-04-08 20:31:35Z

1

Just make it a raw string:

businessDate = r"'2019-03-13'"

answered Apr 8, 2019 at 20:31

Anton Rasmussen

525 bronze badges

3 Comments

excelguy Over a year ago

Thanks anton, what if I wanted to use businessDate in my function as an argument. Ie. def stack(businessDate):

Anton Rasmussen Over a year ago

Shouldn't make a difference, as long as you use the r" 'blah' " syntax: Just play around in the shell: >>> biz_date=r"'1000'" >>> print(biz_date) '1000' >>> def blah(blah): ... print(blah) ... >>> blah(biz_date) '1000' Note that print casts to str.... so, depending on your functionality, you may have to explicitly cast it like str(blah)

excelguy Over a year ago

Sorry Anton im having trouble following, can I message you?

Aashutosh Kumar · Accepted Answer · 2023-09-14 16:50:23Z

0

Try this below code

query = """
    SELECT *
    FROM insider_trading
    WHERE (column1|| column1) ILIKE %s
    ORDER BY accepted_datetime
"""
cursor.execute(query, ('%' + search_query + '%',))
rows = cursor.fetchall()

answered Sep 14, 2023 at 16:50

Aashutosh Kumar

82911 silver badges16 bronze badges

Collectives™ on Stack Overflow

Python Multi Line SQL Statement, insert variable with single quotes

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related