def main(Level1):
# Assemble the states files
import sys
sys.path.append("/Users/rsfletch/Dropbox/Fall2014/"
"Research/ClimateData/code/python/")
import Mysql_Procedure_creator
import mysql.connector
Config = {
'user': '******',
'password': '******',
'host': '127.0.0.1',
'database': 'ClimateData',
}
cnx = mysql.connector.connect(**Config)
cursor = cnx.cursor()
cursor.execute("Select Distinct(Lvl2) From"
" Join_2013_05_05 Where"
" Lvl1=\'" + Level1 + "\';")
for state in cursor:
Level2 = ''.join(state)
Level2 = str(Level2)
Mysql_Procedure_creator.get_data(
Level1, Level2, "1998", "2013")
def main():
# Assemble the states files
import sys
sys.path.append("/Users/rsfletch/Dropbox/Fall2014/"
"Research/ClimateData/code/python/")
import Mysql_Procedure_creator
states = {
'AK': 'Alaska',
'AL': 'Alabama',
'AR': 'Arkansas',
'AZ': 'Arizona',
'CA': 'California',
'CO': 'Colorado',
'CT': 'Connecticut',
'DE': 'Delaware',
'FL': 'Florida',
'GA': 'Georgia',
'HI': 'Hawaii',
'IA': 'Iowa',
'ID': 'Idaho',
'IL': 'Illinois',
'IN': 'Indiana',
'KS': 'Kansas',
'KY': 'Kentucky',
'LA': 'Louisiana',
'MA': 'Massachusetts',
# 'MD': 'Maryland',
'ME': 'Maine',
'MI': 'Michigan',
'MN': 'Minnesota',
'MO': 'Missouri',
'MS': 'Mississippi',
'MT': 'Montana',
'NC': 'North Carolina',
'ND': 'North Dakota',
'NE': 'Nebraska',
'NH': 'New Hampshire',
'NJ': 'New Jersey',
'NM': 'New Mexico',
'NV': 'Nevada',
'NY': 'New York',
'OH': 'Ohio',
'OK': 'Oklahoma',
'OR': 'Oregon',
'PA': 'Pennsylvania',
'RI': 'Rhode Island',
'SC': 'South Carolina',
'SD': 'South Dakota',
'TN': 'Tennessee',
# 'TX': 'Texas',
'UT': 'Utah',
'VA': 'Virginia',
'VT': 'Vermont',
'WA': 'Washington',
'WI': 'Wisconsin',
'WV': 'West Virginia',
'WY': 'Wyoming'
}
for state in states.itervalues():
Mysql_Procedure_creator.get_data(
"United States of Ame",
state, "1998", "2013")
