/
create_mysql_tables.py
executable file
·37 lines (26 loc) · 1.03 KB
/
create_mysql_tables.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
#!/usr/bin/python
import dbs
def drop_chronojump_table(db_mysql, cur_mysql):
cur_mysql.execute("DROP DATABASE chronojump")
cur_mysql.execute("CREATE DATABASE chronojump")
def add_person_id(sql):
sql = sql.replace(" (", "( serverPersonId INT, ")
return sql
def fix_unique_id_primary_key(sql):
# this should create a new primary key based on (serverPersonId, uniqueID)
sql = sql.replace("uniqueID INTEGER PRIMARY KEY", "uniqueID INTEGER")
return sql
def main():
(db_mysql, cur_mysql) = dbs.connect_mysql()
(db_sqlite, cur_sqlite) = dbs.connect_sqlite()
drop_chronojump_table(db_mysql, cur_mysql)
(db_mysql, cur_mysql) = dbs.connect_mysql()
# Creates tables
table_names = dbs.get_name_of_tables_sqlite(cur_sqlite)
for table_name in table_names:
sql_table = dbs.get_create_table(cur_sqlite, table_name)
sql_table = add_person_id(sql_table)
sql_table = fix_unique_id_primary_key(sql_table)
cur_mysql.execute(sql_table)
if __name__ == '__main__':
main()