def main(): db = db_helper.create_connection() with open('create_tables.sql') as sqls: commands = str.split(sqls.read(), ';') for c in commands: try: db.execute(c) except Error as e: print("[ERROR]", e) db.commit() db_helper.close_connection(db) insert_movie_detail_api.main() insert_movie_detail_ranking_api.main() insert_movie_detail_credits_api.main() insert_my_collect_api.main()
def main(): db = db_helper.create_connection() data = helper.read_json('movie_detail_api') db_helper.close_connection(db)
def main(): db = db_helper.create_connection() data = helper.read_json('movie_detail_credits_api') insert_movie_celeb(db, data) db_helper.close_connection(db)
def main(): db = db_helper.create_connection() data = helper.read_json('movie_detail_ranking_api') insert_ranking(db, data) db_helper.close_connection(db)
def main(): db = db_helper.create_connection() data = helper.read_json() insert_table(db, data) db_helper.close_connection(db)