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'):
