def main():
#connect to data base
cnx = SQL.connect(user='******', database='sciencedata', password='******')
#create Ameriflux entries
# Handle.getRoot()
# Handle.CURR_DIR = Handle.FILE_SYS.root
# files = AMERIFLUX_L2_STD.findCO2ByDate(Handle.CURR_DIR, "201412")
# addData(cnx,files,"Ameriflux_TW")
# print("Data Complete")
# Handle.FILE_SYS = 0
# Handle.CURR_DIR = 0
#create OCO2_LITE Barrow entries
# Handle.getRoot()
# Handle.CURR_DIR = Handle.FILE_SYS.root
# long_ = input("Enter longitude.")
# lat_ = input("Enter Latitude.")
# files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"")
# addData(cnx,files,"OCO2_Barrow")
# print("Data Complete")
# Handle.FILE_SYS = 0
# Handle.CURR_DIR = 0
#create OCO2_LITE Twitchell entries
# Handle.getRoot()
# Handle.CURR_DIR = Handle.FILE_SYS.root
# long_ = input("Enter longitude.")
# lat_ = input("Enter Latitude.")
# files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"")
# addData(cnx,files,"OCO2_Twitchell")
# print("Data Complete")
# Handle.FILE_SYS = 0
# Handle.CURR_DIR = 0
#create OCO2_LITE Fort Peck entries
# Handle.getRoot()
# Handle.CURR_DIR = Handle.FILE_SYS.root
# long_ = input("Enter longitude.")
# lat_ = input("Enter Latitude.")
# files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"")
# addData(cnx,files,"OCO2_FortPeck")
# print("Data Complete")
# Handle.FILE_SYS = 0
# Handle.CURR_DIR = 0
#create OCO2_LITE Fort Peck entries
# Handle.getRoot()
# Handle.CURR_DIR = Handle.FILE_SYS.root
# long_ = input("Enter longitude.")
# lat_ = input("Enter Latitude.")
# files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"")
# addData(cnx,files,"OCO2_K34")
# print("Data Complete")
# Handle.FILE_SYS = 0
# Handle.CURR_DIR = 0
#create OCO2_World entries
Handle.getRoot()
Handle.CURR_DIR = Handle.FILE_SYS.root
long_ = input("Enter longitude.")
lat_ = input("Enter Latitude.")
files = OCO2_LITE.findFilesByCoords(Handle.CURR_DIR, long_, lat_,"")
print("Adding data now...")
addData(cnx,files,"OCO2_World")
print("Data Complete")
Handle.FILE_SYS = 0
Handle.CURR_DIR = 0
