Python Forum

Using mysql I can get this to work. I
want to get all missing days between 2 dates.
The table was last updated on 4-10-2020. Today is 4-16-2020
As of today below is the correct output.

Output:
 date field_id_id 2020-04-11	21 2020-04-12	21 2020-04-13	21 2020-04-14	21 2020-04-15	21 2020-04-16	21

Output:
set @i = -1; Select B.date, 21 as field_id_id from ( SELECT DATE(ADDDATE('2020-03-18', INTERVAL @i := @i + 1 DAY)) AS date FROM dummy HAVING @i < DATEDIFF('2020-04-16', '2020-03-18') )B left join ( Select date from dummy where field_id_id = 21 and date between '2020-03-18' and '2020-04-16' )C ON B.date = C.date where C.date is NULL

-- Below is the python giving me an error on "Interval %s "

 v_sql_tx = 'Select B.date, %s as field_id_id '\ ' from ( '\ ' SELECT DATE(ADDDATE(%s, INTERVAL %s:= %s + 1 DAY)) AS '\ ' date '\ ' FROM dummy '\ ' HAVING %s < DATEDIFF(%s, %s) '\ ' )B left join( '\ ' Select date '\ ' from dummy '\ ' where field_id_id = %s '\ ' and date between %s and %s '\ ' )C ON B.date = C.date '\ ' where C.date is NULL '

python version 3.6.8
Any suggestions to get this to work in python ?

TIA
Steve42

The code you've posted is just a string assignment. It wouldn't perform a sql query.

Line 3 also has a problem that there is a space after the backslash on the end, so as pasted, it would produce an error instead of completing the assignment. I'm not sure if that's in your code or a cut&paste error.

You need to learn how to use SQL for MySql find a good tutorial and run through it
search google for 'python 3 and mysql tutorial'
one example: https://www.mysqltutorial.org/python-mysql/