print("================================================================================") selected_db = input("Please, select the number of the db that you want to process: ") print("================================================================================") selected_db_name = database_list[selected_db][0] #user selected database name print("Selected database: {0}".format(selected_db_name)) user_db_access = Connect(host, username, password, selected_db_name) user_db_connect = user_db_access.mysql() #cursors user_db_cursor = user_db_connect.cursor() user_tb_cursor = user_db_connect.cursor() #find all tables in the selected schema user_db_query = "select TABLE_NAME, engine, TABLE_COLLATION, TABLE_COMMENT from information_schema.tables where table_schema='{0}'" #make folder structure writer = Writer(selected_db_name) 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)