parser.add_argument(
'location',
help='CABM site name. Options: Alert, ETL, Egbert, Resolute, Whistler ',
type=str)
parser.add_argument('instr_number',
help='SP2 number. Options: 17, 44, 58 ',
type=int)
parser.add_argument('-bi',
'--binning_interval',
help='binning interval length in hours (default is 6)',
default=6,
type=int)
args = parser.parse_args()
#create db connection and cursor
database_connection = dbConnection('CABM_SP2')
cnx = database_connection.db_connection
cursor = database_connection.db_cur
#set inputs
start_analysis = args.start_time
end_analysis = args.end_time
instr_location_ID = CABM_utilities.getLocationID(args.location)
instr_ID = CABM_utilities.getInstrID(args.instr_number)
min_VED = 80 # in nm
max_VED = 220 # in nm
binning_increment = 20 # in nm
interval_length = args.binning_interval * 3600 # in seconds
database_name = 'CABM_SP2'
import os
import argparse
import SP2_utilities
import CABM_utilities
from mysql_db_connection import dbConnection
#set arguments
parser = argparse.ArgumentParser(description='''
This script should be run once to modify the database when updating the CABM_sp2 code from version 1.0 to version 1.1
This script will add columns "chamber_temp" and "chamber_pressure" to the housekeeping data tables.
''')
args = parser.parse_args()
db_name = 'CABM_SP2'
#create db connection and cursor
database_connection = dbConnection(db_name)
cnx = database_connection.db_connection
cursor = database_connection.db_cur
def tableExists(location):
table_name = 'sp2_hk_data_locn' + str(location)
cursor.execute(
'''SELECT TABLE_NAME
FROM information_schema.tables
WHERE
TABLE_SCHEMA = %s
AND TABLE_NAME = %s''', (db_name, 'sp2_hk_data_locn' + str(location)))
table_exists = cursor.fetchall()
if table_exists == []: