comment SQL query with variables in python

Question

I'm working with Cloud Function. I have the following query working correctly:

# this is working
q = """ SELECT col1, col2
        FROM `my_table` 
        WHERE col1 = {} AND col2 = '{}'""".format(var1, var2)

however when trying to add a comment I have a Keyerror:

# this is not working
q = """ /* "{'query': 'some_name' */ 
        SELECT col1, col2
        FROM `my_table` 
        WHERE col1 = {} AND col2 = '{}'""".format(var1, var2)

The query is working with the comment if I'm removing the variables:

# this is working
q = """ /* "{'query': 'some_name' */ 
        SELECT col1, col2
        FROM `my_table` """

I'm using the following function to run my query:

def run_query(q):
    client = bigquery.Client()
    df_result = client.query(q).to_dataframe()
    return df_result

Why do I get this error? How should I comment in this context?

It seems you need to escape a curly brace in your comment by adding one more curly brace like this : /* "{{'query': 'some_name' */ — Jaytiger
– Jaytiger, Commented May 13, 2022 at 15:50

Rogelio Monter · Accepted Answer · 2022-05-13 21:46:00Z

1

As stated in the comments by @Jaytiger:

you need to escape a curly brace in your comment by adding one more curly brace like this :
/* "{{'query': 'some_name' */

Collectives™ on Stack Overflow

comment SQL query with variables in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related