def populates_sqlite_file(file_name, person_id):
(db_mysql, cur_mysql) = dbs.connect_mysql()
(db_sqlite, cur_sqlite) = dbs.connect_sqlite()
name_of_tables = dbs.get_name_of_tables_mysql(cur_mysql)
new_sqlite = sqlite3.connect(file_name)
for name_of_table in name_of_tables:
copy_data(cur_mysql, new_sqlite, person_id, name_of_table)
def create_sqlite_file(file_name):
(conn, cursor) = dbs.connect_mysql()
new_sqlite_cursor = sqlite3.connect(file_name)
table_names = dbs.get_name_of_tables_mysql(cursor)
for table_name in table_names:
sql = dbs.get_create_table_mysql(cursor, table_name)
new_sqlite_cursor.execute(sql)
