convertcalibPostGresToSQLite.py File Reference

Go to the source code of this file.

Namespaces
	convertcalibPostGresToSQLite

Variables
list	convertcalibPostGresToSQLite.calibs
list	convertcalibPostGresToSQLite.suffixes = ['tags', 'iovs', 'tag_iovs', 'data']
string	convertcalibPostGresToSQLite.host = 'Icarus-db'
string	convertcalibPostGresToSQLite.db = 'icarus_online_prd'
string	convertcalibPostGresToSQLite.user = 'calib_admin'
string	convertcalibPostGresToSQLite.port = '5434'
string	convertcalibPostGresToSQLite.pw = 'calib4adm'
tuple	convertcalibPostGresToSQLite.conn = psycopg2.connect(host=host, port=port, dbname=db, user=user, password=pw)
tuple	convertcalibPostGresToSQLite.cur = conn.cursor()
string	convertcalibPostGresToSQLite.sqlite_database = '%s.db'
tuple	convertcalibPostGresToSQLite.sqlite_conn = sqlite3.connect(sqlite_database)
tuple	convertcalibPostGresToSQLite.sqlite_cur = sqlite_conn.cursor()
dictionary	convertcalibPostGresToSQLite.schema = {}
string	convertcalibPostGresToSQLite.table_name = '%s_%s'
string	convertcalibPostGresToSQLite.qtbl = 'CREATE TABLE IF NOT EXISTS %s ('
string	convertcalibPostGresToSQLite.q = 'select column_name, data_type, is_nullable from information_schema.columns where table_name=%s'
tuple	convertcalibPostGresToSQLite.rows = cur.fetchall()
	convertcalibPostGresToSQLite.first = True
list	convertcalibPostGresToSQLite.column_name = row[0]
list	convertcalibPostGresToSQLite.data_type = row[1]
list	convertcalibPostGresToSQLite.null = row[2]
string	convertcalibPostGresToSQLite.sqlite_type = ''
int	convertcalibPostGresToSQLite.max_iov_id = 0
tuple	convertcalibPostGresToSQLite.row = cur.fetchone()
tuple	convertcalibPostGresToSQLite.now = datetime.datetime.now()
string	convertcalibPostGresToSQLite.qval = 'VALUES('
list	convertcalibPostGresToSQLite.values = []
int	convertcalibPostGresToSQLite.n = 0
list	convertcalibPostGresToSQLite.element = row[n]