MYsql Stored procedure only work the second time i execute it through python
I'm using python to create a data warehouse in MySQL. I'm using the MySQLdb package to connect python to MySQL. I am trying to create a table which will contain all dates from 2005 to 2018. First, I create the relevant table: cursor.execute(""" CREATE TABLE IF NOT EXISTS dim_date ( date_id int(11) NOT NULL AUTO_INCREMENT, date date, day int(11), month int(11), year int(11), day_name varchar(45), PRIMARY KEY (date_id), INDEX date_index (date)) """) Then, I run the following command to create and run the stored procedure that will fill in the dates: cursor.execute("DROP PROCEDURE IF EXISTS BuildDate;") cursor.execute("SET #currdate := '2005-01-01';") cursor.execute("SET #enddate := '2018-01-01';") cursor.execute(""" CREATE PROCEDURE BuildDate() BEGIN WHILE #currdate < #enddate DO INSERT INTO ntr_yelp_dw.dim_date (date, day, month, year, day_name) VALUES ( #currdate, DAY(#currdate), MONTH(#currdate), YEAR(#currdate), DAYNAME(#currdate) ); SET #currdate := DATE_ADD(#currdate, INTERVAL 1 DAY); END WHILE; END """) cursor.callproc("BuildDate") The thing is that when I run the stored procedure code, the stored procedure is created, but the data isn't filled. Only when I run it a second time, the data is created and inserted into the table. Any thoughts?
Updating a value in a Pandas dataframe seems to update all dataframes
4 entry box nummeric keypad
os.walk for loop not executing [duplicate]
python matplotlib polar plot
Django - not showing properly one of my tables in template
Datalab: How to export Big Query standard SQL query to dataframe?
Pandas: count difference between dates
Skip one line in .csv file by using genfromtxt function in python
Dealing with NaNs in Pandas
Python Script? - Logging serial output from arduino
Iterate links from selenium into bs4 and print stripped strings
Query for only part of objects of related_name (from ForeignKey)
How to fill in missing sequence lines in a TSV file
Django website optimization: Too many calls to core python functions?
How to post issues to gitlab using python?
Coverage and nose shows files from django and not just my tests