def insert_data_into_sql(self): db = Database() # Create the Train Table create_command = 'create table if not exists train (trainid INT AUTO_INCREMENT,' collist = '' for column in self.df.columns: create_command += column + ' TEXT,' collist += column + ',' collist = collist[:-1] + ");" create_command += 'primary key (trainid));' db.execute_query_with_params(create_command, {}) # Load the Training File base_path = os.getcwd().replace('\\', '/') + '/' load_command = "LOAD DATA LOCAL INFILE '" + base_path + self.input_file + \ "' INTO TABLE train FIELDS TERMINATED BY ',' " \ "LINES TERMINATED BY '\\n' " \ "IGNORE 1 LINES (" + collist db.execute_query_with_params(load_command, {}) return