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()
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()
