channelDBConverter.py File Reference

Go to the source code of this file.

Namespaces
	channelDBConverter

Variables
list	channelDBConverter.calibs
list	channelDBConverter.calibs_dev
list	channelDBConverter.suffixes = ['tags', 'iovs', 'tag_iovs', 'data']
int	channelDBConverter.devel = 0
string	channelDBConverter.dev = ''
list	channelDBConverter.args = sys.argv[1:]
list	channelDBConverter.host = os.environ['PUB_PSQL_READER_HOST']
tuple	channelDBConverter.port = int(os.environ['PUB_PSQL_READER_PORT'])
list	channelDBConverter.user = os.environ['PUB_PSQL_READER_USER']
list	channelDBConverter.db = os.environ['PUB_PSQL_READER_DB']
list	channelDBConverter.pw = os.environ['PUB_PSQL_READER_PASS']
tuple	channelDBConverter.conn = psycopg2.connect(host=host, port=port, dbname=db, user=user, password=pw)
tuple	channelDBConverter.cur = conn.cursor()
string	channelDBConverter.sqlite_database = '%s.db'
tuple	channelDBConverter.sqlite_conn = sqlite3.connect(sqlite_database)
tuple	channelDBConverter.sqlite_cur = sqlite_conn.cursor()
dictionary	channelDBConverter.schema = {}
string	channelDBConverter.table_name = '%s_%s'
string	channelDBConverter.qtbl = 'CREATE TABLE IF NOT EXISTS %s ('
string	channelDBConverter.q = 'select column_name, data_type, is_nullable from information_schema.columns where table_name=%s'
tuple	channelDBConverter.rows = cur.fetchall()
	channelDBConverter.first = True
list	channelDBConverter.column_name = row[0]
list	channelDBConverter.data_type = row[1]
list	channelDBConverter.null = row[2]
string	channelDBConverter.sqlite_type = ''
int	channelDBConverter.max_iov_id = 0
tuple	channelDBConverter.row = cur.fetchone()
tuple	channelDBConverter.now = datetime.datetime.now()
string	channelDBConverter.qval = 'VALUES('
list	channelDBConverter.values = []
int	channelDBConverter.n = 0
list	channelDBConverter.element = row[n]