Convert list into comma separate values inside multiline sql query for python

Question

I have a method like this:

def build_query(self, ids):
    return '''select   
        d.name as degree,
        fs.student_id
        from form_status fs
        left join form_fills fc
        on fs.id = fc.form_fills_id
        ...
        where fs.student_id in (*ids);
    '''

and ids is a list that looks like this: [1,2,3,100,10000]

How do I do this properly? I like the triple quoted strings because they allow me to indent the sql string and not look weird. Can I maintain this?

blhsing · Accepted Answer · 2019-11-26 23:45:26Z

2

Since tuples in Python happen to be enclosed in parentheses too, you can convert ids to a tuple in an f-string to make the code look aesthetically to your expectation:

def build_query(self, ids):
    return f'''select   
        d.name as degree,
        fs.student_id
        from form_status fs
        left join form_fills fc
        on fs.id = fc.form_fills_id
        ...
        where fs.student_id in {(*ids,)};
    '''

answered Nov 26, 2019 at 23:45

blhsing

109k9 gold badges88 silver badges132 bronze badges

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

2 Comments

Jwan622 Over a year ago

Why do I need the trailing comma? What is going on here exactly?

blhsing Over a year ago

The trailing comma is syntactically required for a tuple with exactly one item. Please see stackoverflow.com/questions/7992559/…

Collectives™ on Stack Overflow

Convert list into comma separate values inside multiline sql query for python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related