27 lines
872 B
Python
27 lines
872 B
Python
from generate_data import tablesDict
|
|
from generate_data import give_path_file
|
|
from generate_data import remove_duplicata
|
|
from generate_data import convert_table_to_sql
|
|
|
|
if __name__ == '__main__':
|
|
###########################################################################
|
|
#
|
|
# To write `insert.sql`.
|
|
#
|
|
###########################################################################
|
|
|
|
# First, remove duplicatas.
|
|
for name in tablesDict:
|
|
remove_duplicata(give_path_file(name))
|
|
|
|
# Writing in `insert.sql`.
|
|
fileSql = open("src/insert.sql", 'w+')
|
|
fileSql.write("TRUNCATE " + ', '.join(tablesDict) + ";\n")
|
|
fileSql.write("\n")
|
|
fileSql.close()
|
|
|
|
with open("src/insert.sql", 'a') as fileSql:
|
|
for nameTable in tablesDict:
|
|
convert_table_to_sql(give_path_file(nameTable), nameTable)
|
|
|