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