def findById(self, id):
db = self.learnXdB.openDataBase()
c = db.cursor()
t = (id,)
c.execute("Select * From Decks Where id = ?", t)
deck = None
for row in c:
deck = Deck(row[1], row[2], row[3], row[4], row[5], row[6], row[0], row[7], row[8], row[9], row[10], row[11], row[12], row[13], row[14], row[15], row[16])
if deck.fields:
deck.fields = pickle.loads(str(deck.fields))
if deck.posOptions:
deck.posOptions = pickle.loads(str(deck.posOptions))
db.commit()
c.close()
return deck
def list(self):
db = self.learnXdB.openDataBase()
c = db.cursor()
c.execute("select * from Decks")
decks = []
for row in c:
deck = Deck(row[1], row[2], row[3], row[4], row[5], row[6], row[0], row[7], row[8], row[9], row[10], row[11], row[12], row[13], row[14], row[15], row[16])
if deck.fields:
deck.fields = pickle.loads(str(deck.fields))
if deck.posOptions:
deck.posOptions = pickle.loads(str(deck.posOptions))
decks.append(deck)
c.close()
return decks