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()