writer.make_base_dir()
writer.make_controller_dir()
writer.make_model_dir()
controller = Controller(selected_db_name)
model = Model(selected_db_name)
user_db_cursor.execute(user_db_query.format(selected_db_name))
start_time = datetime.datetime.now()
counter_tables = 1
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,
