def __init__(self,dbaseName,name,status='new',**kwargs):
self.dbaseName = dbaseName;
self.pConn = sqlite3.connect(dbaseName)
self.pCosmetics = pycosmetics()
self.keysTab = name+'keys'
self.dataTab = name+'data'
if status == 'new':
title = kwargs['title']
lbins = kwargs['lbins']
hbins = kwargs['hbins']
self.pConn.execute('DROP TABLE IF EXISTS '+self.keysTab)
query = 'CREATE TABLE '+self.keysTab+'( NAME VARCHAR, TITLE VARCHAR, DATATAB VARCHAR)'
##print query
self.pConn.execute(query)
self.pConn.commit()
query = 'INSERT INTO '+self.keysTab+" VALUES ('"+name+"', '"+title+"', '"+name+"data')"
##print query
self.pConn.execute(query)
query = 'CREATE TABLE '+name+'data'+' (binLowEdge NUMBER, binHighEdge NUMBER, CONTENT NUMBER, ERROR NUMBER)'
self.pConn.execute('DROP TABLE IF EXISTS '+name+'data')
self.pConn.execute(query)
for l,h in zip(lbins,hbins):
query = 'INSERT INTO '+name+'data'+' VALUES('+str(l)+', '+str(h)+', 0, 0)'
self.pConn.execute(query)
self.pConn.commit()
def __init__(self,dbaseName,name,status='new',**kwargs):
self.dbaseName = dbaseName;
self.pConn = sqlite3.connect(dbaseName)
self.pCosmetics = pycosmetics()
self.keysTab = name+'keys'
self.dataTab = name+'data'
self.xType = None
self.yType = None
self.title = None
self.name = None
def extract_arg(token):
if token not in kwargs:
raise ValueError(token+' missing\n')
else: return kwargs[token]
if status == 'new':
self.name = name
self.title = extract_arg('title')
x = extract_arg('x')
self.xType = extract_arg('xType')
y = extract_arg('y')
self.yType = extract_arg('yType')
self.pConn.execute('DROP TABLE IF EXISTS '+self.keysTab)
query = 'CREATE TABLE '+self.keysTab+'( NAME VARCHAR, TITLE VARCHAR, XTYPE VARCHAR, YTYPE VARCHAR, DATATAB VARCHAR)'
##print query
self.pConn.execute(query)
self.pConn.commit()
query = 'INSERT INTO '+self.keysTab+" VALUES ("+"','".join(["'"+name,self.title,self.xType,self.yType,self.dataTab+"'"])+")"
print query
##print query
self.pConn.execute(query)
query = 'CREATE TABLE '+self.dataTab+' (x '+self.xType+', y '+self.yType+ ', ERROR NUMBER)'
self.pConn.execute('DROP TABLE IF EXISTS '+self.dataTab)
print query
self.pConn.execute(query)
for v,val in zip(x,y):
query = 'INSERT INTO '+self.dataTab+' VALUES('+str(v)+', '+str(val)+',0)'
self.pConn.execute(query)
self.pConn.commit()
