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