def insert(self, k_number, name):
user = Users()
user.k_number = k_number
user.name = name
session.add(user)
session.flush()
session.commit()
def insert(self, thesis_id, title):
thesis = Thesis()
thesis.thesis_id = thesis_id
thesis.title = title
session.add(thesis)
session.flush()
session.commit()
def insert(user_id, session_id, expiration_id):
sessions = Sessions()
sessions.user_id = user_id
sessions.session_id = session_id
sessions.expiration_id = expiration_id
session.add(session)
session.flush()
session.commit()
def insert(self, user_id, book_id, date):
lending = Lending()
lending.user_id = user_id
lending.book_id = book_id
lending.date = date
session.add(lending)
session.flush()
session.commit()
def insert(self, isbn, title, place):
isbn = int(isbn.replace("-", ""))
book = Books()
book.isbn = isbn
book.title = title
book.place = place
session.add(book)
session.flush()
session.commit()
def insert(*value):
if len(value) == 3 and isinstance(value[0], str):
isbn, title, place = value
"""
isbnをintに変換する処理が必要
"""
book = Books()
book.isbn = isbn
book.title = title
book.place = place
session.add(book)
session.commit()
elif len(value) == 3 and isinstance(value[0], int):
user_id, session_id, expiration_id = value
sessions = Sessions()
sessions.user_id = user_id
sessions.session_id = session_id
sessions.expiration_id = expirarion_id
session.add(session)
session.commit()
elif len(value) == 2 and isinstance(value[0], str):
k_number, name = value
user = Users()
user.k_number = k_number
user.name = name
session.add(user)
session.commit()
elif len(value) == 2 and isinstance(value[0], int):
user_id, book_id = value
lending = Lending()
lending.user_id = user_id
lending.book_id = book_id
session.add(lending)
session.commit()
else:
print('Error:Invalid argument')
sys.exit()
def delete(self, id_):
session_ = session.query(Sessions).filter(Sessions.id == id_).first()
session.delete(session_)
session.commit()
def delete(self, id_):
lending = session.query(Lending).filter(Lending.id == id_).first()
session.delete(lending)
session.commit()
def delete(self, id_):
user = session.query(Users).filter(Users.id == id_).first()
session.delete(user)
session.commit()
def delete(self, id_):
book = session.query(Books).filter(Books.id == id_).first()
session.delete(book)
session.commit()
def delete(self, id_):
thesis = session.query(Thesis).filter(Thesis.id == id_).first()
session.delete(thesis)
session.commit()
