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)