Building multi-line database queries in python

Question

Ran into a problem and something that seemed simple at first.

I want to do this (query has been dumbed down for brevity here, it's actually much longer and more complex):

    query  = ("""INSERT INTO %s " % cfg['mysql.table']
              "('hostname', 'timestamp', 'metric', 'average', 'peakhigh', 'peaklow', 'gsamp', 'zsamp', 'nsamp')"""
              "VALUES ( %s, %s, %s, %s, %s, %s, %s, %s, %s )"
             )

So how do I incorpoarate STR_TO_DATE into this query for the timestamp field?

Thanks for any help.

How do you do this component of the string using the triple quote approach though - "INSERT INTO %s " % cfg['mysql.table']? — BenH
– BenH, Commented May 27, 2016 at 15:54

Gadget · Accepted Answer · 2016-05-27 15:54:11Z

7

Put your string inside triple quotes:

query  = ("""INSERT INTO %s " % cfg['mysql.table']
              "('hostname', 'timestamp', 'metric', 'average', 'peakhigh', 'peaklow', 'gsamp', 'zsamp', 'nsamp')"
              "VALUES ( %s, %s, %s, %s, %s, %s, %s, %s, %s )"""
             )

answered May 27, 2016 at 15:54

Gadget

4032 silver badges7 bronze badges

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

3 Comments

BenH Over a year ago

Ok let me try that again, I must have fat-fingered something when I tried this approach before posting.

BenH Over a year ago

Any idea how I incoproate STR_TO_DATE for the timestamp field?

Gadget Over a year ago

Try changing the second %s with STR_TO_DATE(%s, '%d/%m/%Y') if that matches the dd/mm/YYYY format you require.

Collectives™ on Stack Overflow

Building multi-line database queries in python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related