channelDBConverter Namespace Reference

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

Variable Documentation

list channelDBConverter.args = sys.argv[1:]

Definition at line 77 of file channelDBConverter.py.

channelDBConverter.calibs

Initial value:

= ['crt_channelstatus_data',
          'detpedestals_data',
          'detpmtgains_data',
          'dqdx_xnorm_data',
          'dqdx_xshape_plane0_data',
          'dqdx_xshape_plane0_mc',
          'dqdx_xshape_plane1_data',
          'dqdx_xshape_plane1_mc',
          'dqdx_xshape_plane2_data',
          'dqdx_xshape_plane2_mc',
          'dqdx_yz_plane0_data',
          'dqdx_yz_plane0_mc',
          'dqdx_yz_plane1_data',
          'dqdx_yz_plane1_mc',
          'dqdx_yz_plane2_data',
          'dqdx_yz_plane2_mc',
          'electronicscalib_data',
          'elifetime_data',
          'lightyieldscale_data']

Definition at line 32 of file channelDBConverter.py.

list channelDBConverter.calibs_dev

Initial value:

= ['crt_channelstatus_data',
              'detpedestals_data',
              'detpmtgains_data',
              'dqdx_xnorm_data',
              'dqdx_xshape_plane0_data',
              'dqdx_xshape_plane1_data',
              'dqdx_xshape_plane2_data',
              'dqdx_yz_plane0_data',
              'dqdx_yz_plane0_mc',
              'dqdx_yz_plane1_data',
              'dqdx_yz_plane1_mc',
              'dqdx_yz_plane2_data',
              'dqdx_yz_plane2_mc',
              'electronicscalib_data',
              'elifetime_data',
              'lightyieldscale_data']

Definition at line 52 of file channelDBConverter.py.

list channelDBConverter.column_name = row[0]

Definition at line 148 of file channelDBConverter.py.

tuple channelDBConverter.conn = psycopg2.connect(host=host, port=port, dbname=db, user=user, password=pw)

Definition at line 106 of file channelDBConverter.py.

tuple channelDBConverter.cur = conn.cursor()

Definition at line 107 of file channelDBConverter.py.

list channelDBConverter.data_type = row[1]

Definition at line 149 of file channelDBConverter.py.

string channelDBConverter.db = os.environ['PUB_PSQL_READER_DB']

Definition at line 95 of file channelDBConverter.py.

string channelDBConverter.dev = ''

Definition at line 76 of file channelDBConverter.py.

int channelDBConverter.devel = 0

Definition at line 75 of file channelDBConverter.py.

list channelDBConverter.element = row[n]

Definition at line 251 of file channelDBConverter.py.

channelDBConverter.first = True

Definition at line 146 of file channelDBConverter.py.

string channelDBConverter.host = os.environ['PUB_PSQL_READER_HOST']

Definition at line 92 of file channelDBConverter.py.

list channelDBConverter.max_iov_id = 0

Definition at line 206 of file channelDBConverter.py.

int channelDBConverter.n = 0

Definition at line 249 of file channelDBConverter.py.

tuple channelDBConverter.now = datetime.datetime.now()

Definition at line 241 of file channelDBConverter.py.

list channelDBConverter.null = row[2]

Definition at line 150 of file channelDBConverter.py.

tuple channelDBConverter.port = int(os.environ['PUB_PSQL_READER_PORT'])

Definition at line 93 of file channelDBConverter.py.

list channelDBConverter.pw = os.environ['PUB_PSQL_READER_PASS']

Definition at line 96 of file channelDBConverter.py.

string channelDBConverter.q = 'select column_name, data_type, is_nullable from information_schema.columns where table_name=%s'

Definition at line 143 of file channelDBConverter.py.

string channelDBConverter.qtbl = 'CREATE TABLE IF NOT EXISTS %s ('

Definition at line 139 of file channelDBConverter.py.

string channelDBConverter.qval = 'VALUES('

Definition at line 247 of file channelDBConverter.py.

tuple channelDBConverter.row = cur.fetchone()

Definition at line 210 of file channelDBConverter.py.

tuple channelDBConverter.rows = cur.fetchall()

Definition at line 145 of file channelDBConverter.py.

dictionary channelDBConverter.schema = {}

Definition at line 125 of file channelDBConverter.py.

tuple channelDBConverter.sqlite_conn = sqlite3.connect(sqlite_database)

Definition at line 120 of file channelDBConverter.py.

tuple channelDBConverter.sqlite_cur = sqlite_conn.cursor()

Definition at line 121 of file channelDBConverter.py.

string channelDBConverter.sqlite_database = '%s.db'

Definition at line 117 of file channelDBConverter.py.

string channelDBConverter.sqlite_type = ''

Definition at line 159 of file channelDBConverter.py.

list channelDBConverter.suffixes = ['tags', 'iovs', 'tag_iovs', 'data']

Definition at line 71 of file channelDBConverter.py.

string channelDBConverter.table_name = '%s_%s'

Definition at line 133 of file channelDBConverter.py.

list channelDBConverter.user = os.environ['PUB_PSQL_READER_USER']

Definition at line 94 of file channelDBConverter.py.

list channelDBConverter.values = []

Definition at line 248 of file channelDBConverter.py.