def createAll(self): cursor = self.cursor cb = db.cb1(cursor, '_xprtinfo') t1 = 'create table groupchat ( groupname varchar(50),members varchar(10))' t2 = 'create table sequrity (userName varchar(50),seqQ text,name text,seqA text,userPass text)' t3 = 'create table usergrouplist (user varchar(50),rRecv blob,recvType varchar(50),recvShape varchar(50),\ rSent blob,rsentType varchar(50), rsentShape varchar(50),gName blob,gNameType varchar(50),\ gNameShape varchar(50))' t4 = 'create table Information (userName varchar(50),notification varchar(10),\ friendRequest varchar(10),GroupRequest varchar(10))' t5 = 'create table profile(userName varchar(40),name\ varchar(40),locProfilePic text,identityU text,gender varchar(10),\ contactNo varchar(20),email varchar(100),dateOfBirth varchar(20),\ discription Text,hideProfile varchar(10))' t6 = 'create table feedback(userName varchar(30),feedback text)' t7 = 'create table DataRFController(userName varchar(30),sCameraRes varchar(30),sScreenRes varchar(30),\ sCameraFps varchar(30),sScreenFps varchar(30),rCameraRes varchar(30), rScreenRes varchar(30),\ sendFileBuff varchar(30),recvDataBuff varchar(30),recvFileBuff varchar(30))' cursor.execute(t1) cursor.execute(t2) #cursor.execute(t3) cursor.execute(t4) cursor.execute(t5) cursor.execute(t6) cursor.execute(t7)
def __init__(self,mycursor): self.mycursor=mycursor #self.mycursor.execute('use xprtinfo') self.cb=db.cb1(self.mycursor,'_xprtinfo')
def getBefColByCol(self, tableName, col): cb = db.cb1(self.mycursor, self.database) cols = cb.getColName(tableName) ind = cols.index(col) data = cols[:ind] return data
def deleteAllRecords(self): self.cb.deleteData('blocklist') self.cb.deleteData('infolist') self.cb.deleteData('profile') self.cb.deleteData('sequrity') #self.cb.deleteData('user') cb=db.cb1(self.mycursor,'xprtnot') cb.dropAllTables()
def handleHFile(self,data,dtype): if dtype=='HF': fName=data['fName'] fsize=data['fsize'] floc=data['floc'] tName=floc #tName=self.location+fName file=open(tName,'ab') size=os.stat(tName).st_size self.hfileNames[fName]=tName self.hfilef[fName]=file self.hfileSize[fName]=fsize self.hfileTempSize[fName]=size self.hfileStatus[fName]=0 elif dtype=='HM': d=data['Data'] d=bytes(d,'utf-8') d=decb(d) fName=data['fName'] file=self.hfilef[fName] file.write(d) self.hfileTempSize[fName]=self.hfileTempSize[fName]+len(d) self.hfileStatus[fName]=1 elif dtype=='HE': d=data['Data'] fName=data['fName'] file=self.hfilef[fName] eType=data['eType'] if eType=='False': mydb=db.genMdb() cursor=mydb.cursor() cb=db.cb1(mycursor,'filesaver') cond=cb.checkData('fSave','fName',fName) loc=self.hfileNames[fName] if not cond: cb.insertDataN('fsave',[fName,loc]) file.close() self.hfileStatus[fName]=2 else: print("This is An Error Which will never arise")
def getColByData(self, tableName, word): cb = db.cb1(self.mycursor, self.database) cols = cb.getColName(tableName) data = [] for i in cols: cond = cb.checkData(tableName, i, word) if (cond): data.append(i) data = ms.modifySqlResult(data) return data
def selectWhByWhCheck(self, tableName, word): cb = db.cb1(self.mycursor, self.database) col = cb.getColName(tableName) data = [] for i in col: d = cb.selectByMulAndCond(tableName, [i], [word]) if (d is not None): for i in d: data.append(i) if (len(data) == 0): return None else: return data
def getNextColByLength(self, tableName, ident, length): cb = db.cb1(self.mycursor, self.database) cols = cb.getColName(tableName) if (ident in cols): index = cols.index(ident) index = index + length - 1 if (len(cols) - 2 >= index): if (index < -1): print('out of range') else: return cols[index + 1] else: print('out of range') else: print('cols is not present in table')
def __init__(self, mycursor): self.mycursor = mycursor self.cb = db.cb1(self.mycursor, '_xprtinfo')
#TrialJarvisDataBase import dbquery2 as db import time import myStringLib as ms mydb = db.genMdb() cursor = mydb.cursor() cb = db.cb1(cursor, 'jar') class DataBase: def __init__(self): pass def inputData(self, time, data): #The data must be in single row cb.insertDataN('timedata', [time, data[0], data[1], data[2], data[3]]) mydb.commit() def deleteAllRecord(self): cb.deleteData('timedata') mydb.commit() def selectByType(self, typeVal, typeIn='_T1'): data = cb.selectAllCheckData('timedata', typeIn, typeVal) data = ms.modifySqlResult(data) return data def select1Data(self, time, _TimeInfo='_TimeInfo'):