def get_author_of_book(self, book_id):
database_query = 'get_author_of_book'
database_response = database.get_entity_by_id(database_query, book_id)
if database_response['status'] != 200:
return database_response
return database_response
def get_book_of_bookstore(self, book_id):
database_query = 'get_book_of_bookstore'
database_response = database.get_entity_by_id(database_query, book_id)
if database_response["status"] != 200:
return database_response
return database_response
def get_bookstore_by_id(self, book_id):
database_query = 'get_bookstore_by_id'
database_response = database.get_entity_by_id(database_query, book_id)
print(database_response)
if database_response['status'] != 200:
return database_response
return database_response
def get_book_of_author(self, book_id):
database_query = 'get_book_of_author'
database_response = database.get_entity_by_id(database_query, book_id)
if database_response != 200:
return database_response["status"]
database_response['type'] = {'type': database_response['type']}
database_response['message'] = {'author': database_response['message']}
return database_response
book_info3 = ('Carte4', 'Autor5', 'tip2')
author1 = (1, "Autor1")
author2 = (1, "Autor2", 1)
bookstore1 = ('1', 'bookstore1')
bookstore2 = ('2', 'bookstore1')
print(database.post_entity('insert_book', book_info1))
print(database.post_entity('insert_book', book_info2))
print(database.post_entity('insert_book', book_info3))
print(database.post_entity('insert_author', author1))
print(database.post_entity('insert_author', author2))
print(database.post_entity('insert_bookstore', bookstore1))
print(database.post_entity('insert_bookstore', bookstore2))
database.view_tables()
print(database.put_entity_by_id('update_author_by_id', author2))
database.view_tables()
print(database.get_entity_by_id('get_author_of_book', 1))
# database.view_tables()
run_server(TreadingHTTPServer, My_Request_Handler)
# # # database.execute_query()
# database.view_tables()
# # # print(database.get_all_entities('get_all_bookstores'))
# # # print(database.get_entity_by_id('get_book_by_id', '2'))
# book_info1 = ('Carte2', 'Autor2', 'tip2')
# # book_info2 = ('Carte3', 'Autor2', 'tip2')
# print(database.post_entity('insert_book', book_info1))
# database.view_tables()
# # # print(database.delete_all_entities('delete_all_authors'))
# # print(database.put_entity_by_id('update_book_by_id', book_info2))
# # database.view_tables()