def getMID(self, mID) :
conn = sqlite3.connect(str(self.ui.db_lineEdit.text()))
result = db.getMatteID(conn, mID)
record = []
for each in result :
record.append(each)
conn.close()
return record
def checkmID(self, mID) :
conn = sqlite3.connect(str(self.ui.db_lineEdit.text()))
result = db.getMatteID(conn, mID)
ids = []
for each in result :
ids.append(each[0])
conn.close()
return ids
def getDbMatteID(self, conn, mID) :
result = db.getMatteID(conn, mID)
info = []
if result :
for each in result :
info.append(each)
if len(info) == 1 :
return info[0]
if len(info) > 1 :
trace('More than one id match %s' % mID)
return info[0]
def getMatteIDValue(self, matteIDs) :
if matteIDs :
mIDs = eval(matteIDs[0])
project = str(self.ui.dbPath_lineEdit.text())
conn = sqlite3.connect(project)
matteIDValue = []
for eachID in mIDs :
result = db.getMatteID(conn, eachID)
for each in result :
if not each in matteIDValue :
matteIDValue.append(each)
return matteIDValue
def checkMatteIDRecord(self, matteIds) :
conn = sqlite3.connect(str(self.ui.db_lineEdit.text()))
result = db.getAllMID(conn)
rMatteIDs = [a[0] for a in result]
allow = True
ex = []
for eachId in matteIds :
if eachId in rMatteIDs :
allow = False
result = db.getMatteID(conn, eachId)
print 'Existing record ...'
for each in result :
print each
conn.close()
return allow
