def performInitialSetup(DBFilePath=None, forceDBCreation=False, logFilePath=None, recordLog=False, quietShell=False): # Establish Global Variables global db_cursor global db_connection # Initialize Log if quietShell and not recordLog: recordLevel=log.INFO else: recordLevel=None EM_util.initializeLog(recordLog=recordLog, logFilePath=logFilePath, recordLevel=recordLevel) log.info('Log Initialized.') # Connect to FRED log.info('Connecting to FRED.') fred.key(EM_util.FREDAPIKey) # Create Database log.info('Connecting to Database: \n%s', DBFilePath) if DBFilePath is None: DBFilePath = EM_util.defaultDB if not isfile(DBFilePath): log.info('Database not found. Creating new database...') EM_DBMake.doOneTimeDBCreation(force=forceDBCreation, DBFilePath=DBFilePath) # Store Database Connection db_connection = sq.connect(DBFilePath) db_cursor = db_connection.cursor() log.info('Database opened successfully')
def performInitialSetup(DBFilePath=None, recordLog=False): # Establish Global Variables global db_cursor global db_connection EM_util.initializeLog(recordLog=recordLog) if DBFilePath is None: DBFilePath = EM_util.defaultDB log.info("Connecting to Database: \n%s", DBFilePath) # Create Database Connection db_connection = sq.connect(DBFilePath) db_cursor = db_connection.cursor() log.info("Database opened successfully")
def performInitialSetup(DBFilePath=None, fileFormat='rickshawJSON'): # Establish Global Variables global db_curs global db_conn global file_format file_format = EM_util.rawSeriesFormatTypes[fileFormat] EM_util.initializeLog() if DBFilePath is None: DBFilePath = EM_util.defaultDB log.info('Connecting to Database: \n%s', DBFilePath) # Create Database if not isfile(DBFilePath): raise Exception('Database not found.') # Create Database Connection db_conn = sq.connect(DBFilePath) db_curs = db_conn.cursor() log.info('Database opened successfully')