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
