popcon2dropbox Namespace Reference

Functions
def	checkFile
def	copy
def	run
def	saveFileForImportErrors
def	upload

Variables
string	auth_path_key = 'COND_AUTH_PATH'
tuple	consoleHandler = logging.StreamHandler(sys.stdout)
string	dateformatForFolder = "%Y-%m-%d-%H-%M-%S"
string	dateformatForLabel = "%Y-%m-%d %H:%M:%S"
string	errorInImportFileFolder = 'import_errors'
string	fmt_str = "[%(asctime)s] %(levelname)s: %(message)s"
list	levStr = os.environ[messageLevelEnvVar]
tuple	logFormatter = logging.Formatter(fmt_str)
tuple	logger = logging.getLogger()
	logLevel = logging.INFO
string	messageLevelEnvVar = 'POPCON_LOG_LEVEL'

Function Documentation

def popcon2dropbox.checkFile

(

dbName

)

Definition at line 32 of file popcon2dropbox.py.

References str.

Referenced by run().

def checkFile( dbName ):
    dbFileName = '%s.db' %dbName
    # check if the expected input file is there... 
    # exit code < 0 => error
    # exit code = 0 => skip
    # exit code = 1 => import                                                                                                                             
    if not os.path.exists( dbFileName ):
       logger.error('The file generated by PopCon with the data to be imported %s has not been found.'%dbFileName )
       return -1

    empty = True
    try:
       dbcon = sqlite3.connect( dbFileName )
       dbcur = dbcon.cursor()
       dbcur.execute("SELECT name FROM sqlite_master WHERE type='table' AND name='IOV'");
       if dbcur.fetchone() is None:
           logger.error('The condition database with the data to be imported has not been found in the file generated by PopCon: %s'%dbFileName )
           return -1
       dbcur.execute('SELECT * FROM IOV')
       rows = dbcur.fetchall()
       for r in rows:
          empty = False
       dbcon.close()
       if empty:
           logger.warning('The data set generated by PopCon contains no data to be imported. The import will be skipped.')
           return 0
       return 1
    except Exception as e:
       logger.error('Check on input data failed: %s' %str(e))
       return -2