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, ))
def book_issue(self, member_number, book_barcode): member = Member() member.number = member_number memberdboperation = getAdapter(member, IDbOperation) member = memberdboperation.get()[0] book = Book() book.number = book_barcode bookdboperation = getAdapter(book, IDbOperation) book = bookdboperation.get()[0] circulation = Circulation() circulation.member = member circulation.book = book circulationdboperation = getAdapter(circulation, IDbOperation) circulationdboperation.add()