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")