for row in user_db_cursor.fetchall():
#setting up all table variables
table_name = row[0]
table_engine = row[1]
table_collation = row[2]
table_comment = row[3]
#creating new files
controller_file = writer.make_controller_file(table_name)
model_file = writer.make_model_file(table_name)
field_query = "SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, COLUMN_KEY, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '{0}' AND TABLE_NAME = '{1}'"
user_tb_cursor.execute(field_query.format(selected_db_name, table_name))
field_in_table = user_tb_cursor.fetchall()
#make new controller
controller.new(
controller_file,
writer.pascal_casing(table_name),
table_comment,
field_in_table)
#make new model
model.new(model_file,
writer.pascal_casing(table_name),
table_comment,
table_engine,
table_collation,
field_in_table)
counter_tables += 1
finish_time = datetime.datetime.now()
total_time = (finish_time - start_time).total_seconds()
print("================================================================================")
print("|| {0} tables processed in {1} seconds".format(counter_tables, total_time))
print("================================================================================")
