Пример #1
0
 def getAllNewCards(self, decksId):
     
     db = self.learnXdB.openDataBase()
     c = db.cursor()
     
     sql = "select c.id, c.deck_id,  c.fact_id, c.anki_card_id, c.status, c.status_changed, c.last_updated, d.deck_path "
     sql += "from Cards c, Decks d where c.status = 0 and c.deck_id = d.id "
     
     t = []
     if decksId != None and len(decksId) > 0:
         sql += "and ("
         i = 1
         for deckId in decksId:
             t.append(deckId)
             sql += "d.id = ?"
             if i < len(decksId):
                 sql += " or "
             i += 1
         sql += ")"
     
     if len(t) > 0:
         c.execute(sql, t)
     else:
         c.execute(sql)
     
     cards = []
     for row in c:
         card = Card(row[1],row[2],row[3],row[5],row[6],row[0])
         card.deckPath = row[7]
         cards.append(card)
     
     return cards
Пример #2
0
    def findById(self, deck, ankiCardId):
        
        db = self.learnXdB.openDataBase()
        
        c = db.cursor()
        
        t = (deck.id, ankiCardId)
        c.execute("Select * From Cards Where deck_id = ? and anki_card_id = ?", t)
        
        card = None
        for row in c:
            card = Card(row[1], row[2], row[3], row[4], row[5], row[6], row[0])
            card.deck = deck

        c.close()
        
        return card
Пример #3
0
    def getCardsOrderByScore(self, decksId):
        
        db = self.learnXdB.openDataBase()
        
        c = db.cursor()
        
        sql = "Select c.id, c.deck_id, c.fact_id, c.anki_card_id, c.status, c.status_changed, c.last_updated, d.deck_path "
        sql += "From Decks d, Cards c, Facts f "
        sql += "Where c.fact_id = f.id and c.deck_id = d.id "
        
        t = []
        if decksId != None and len(decksId) > 0:
            sql += "and ("
            i = 1
            for deckId in decksId:
                t.append(deckId)
                sql += "d.id = ?"
                if i < len(decksId):
                    sql += " or "
                i += 1
            sql += ")"
        
        sql += " order by f.score asc"
        
        if len(t) > 0:
            c.execute(sql, t)
        else:
            c.execute(sql)
        
        cards = []
        for row in c:
            card = Card(row[1],row[2],row[3],row[5],row[6],row[0])
            card.deckPath = row[7]
            cards.append(card)

        c.close()
        
        return cards