Пример #1
0
 def readAllNameIdPairs(self):        
     pair = NameIdPair()
     l = []
     sql = "SELECT id, name FROM menu"
     
     self.execute(sql)
     
     for (id, name) in self._cursor:      
         pair.id = id 
         pair.name = name
         
         l.append(pair)
     
     return l
Пример #2
0
    def readAllNameIdPairs(self):
        l = []
        sql = "SELECT id, name FROM " + Transaction.MY_TABLE_NAME + " ORDER BY name ASC"

        self.execute(sql)

        for (id, name) in self._cursor:
            pair = NameIdPair()
            pair.id = id
            pair.name = name

            l.append(pair)

        return l
Пример #3
0
    def readAllNameIdPairs(self):
        l = []
        sql = "SELECT id, name FROM additive_group ORDER BY name ASC"

        self.execute(sql)

        for (id, name) in self._cursor:
            pair = NameIdPair()
            pair.id = id
            pair.name = name

            l.append(pair)

        return l
Пример #4
0
 def readAllNameIdPairs(self):        
     l = []
     sql = "SELECT id, name FROM " + MovementType.MY_TABLE_NAME + " ORDER BY name ASC"
     
     self.execute(sql)
     
     for (id, name) in self._cursor:
         pair = NameIdPair()    
         pair.id = id 
         pair.name = name
         
         l.append(pair)
     
     return l
Пример #5
0
 def readAllNameIdPairs(self):        
     l = []
     sql = "SELECT id, name FROM partner WHERE is_enabled=1 ORDER BY name ASC"
     
     self.execute(sql)
     
     for (id, name) in self._cursor:
         pair = NameIdPair()    
         pair.id = id 
         pair.name = name
         
         l.append(pair)
     
     return l
Пример #6
0
    def readAllNameIdPairs(self):
        l = []
        sql = "SELECT id, name FROM partner WHERE is_enabled=1 ORDER BY name ASC"

        self.execute(sql)

        for (id, name) in self._cursor:
            pair = NameIdPair()
            pair.id = id
            pair.name = name

            l.append(pair)

        return l
Пример #7
0
 def readAllNameIdPairs(self):        
     l = []
     sql = "SELECT id, name FROM additive_group ORDER BY name ASC"
     
     self.execute(sql)
     
     for (id, name) in self._cursor:
         pair = NameIdPair()    
         pair.id = id 
         pair.name = name
         
         l.append(pair)
     
     return l