def get(self): db = getUtility(IRelationalDatabase) cr = db.cursor() number = self.member.number if number: cr.execute("""SELECT id, number, name FROM members WHERE number = ?""", (number,)) else: cr.execute("""SELECT id, number, name FROM members""") rst = cr.fetchall() cr.close() members = [] for record in rst: id = record['id'] number = record['number'] name = record['name'] member = Member() member.id = id member.number = number member.name = name members.append(member) return members
def get(self): db = getUtility(IRelationalDatabase) cr = db.cursor() number = self.member.number if number: cr.execute( """SELECT id, number, name FROM members WHERE number = ?""", (number, )) else: cr.execute("""SELECT id, number, name FROM members""") rst = cr.fetchall() cr.close() members = [] for record in rst: id = record['id'] number = record['number'] name = record['name'] member = Member() member.id = id member.number = number member.name = name members.append(member) return members
def on_add_clicked(self, *args): number = self.number.get_text() name = self.name.get_text() member = Member() member.number = number member.name = name self.add(member) self.list_store.append((member, number, name,))
def on_add_clicked(self, *args): number = self.number.get_text() name = self.name.get_text() member = Member() member.number = number member.name = name self.add(member) self.list_store.append(( member, number, name, ))