def get_all_records(table_name, prediction_column):
query = 'SELECT * FROM ' + table_name + ' where ' + prediction_column + ' <> "' + settings.classes_values[
0] + '" order by ' + prediction_column + ';'
cursor = db_op.query_db(query)
data_array = []
for c in cursor:
data_array.append(list(c))
return data_array
def traffic_home():
try:
query = "SHOW columns FROM " + settings.traffic_table_name
cursor = db_op.query_db(query)
columns = []
for infos in cursor:
columns.append(infos[0])
except:
columns = ["Hata: İlgili tablodan sütun bilgisi getirilemedi!"]
return render_template('traffic.html', columns=columns)
def get_database_records(draw, start, length, table_name):
try:
query = "SELECT * FROM " + table_name + " limit %s, %s;" % (start,
length)
cursor = db_op.query_db(query)
data_array = []
for c in cursor:
data_array.append(list(c))
query_count = 'SELECT TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = "' + table_name + '";'
cursor_count = db_op.query_db(query_count)
count = cursor.fetchone()[0]
result = '{ "draw": ' + str(draw) + ', "recordsTotal": ' + str(
count) + ', "recordsFiltered": ' + str(count) + ', "data": ' + str(
data_array) + '}'
result = result.replace("'", '"')
return result
except Exception as e:
result = '{ "draw": 0, "recordsTotal": 0, "recordsFiltered": 0, "data": []}'
return result
def get_tree_image(tr):
image_path = 'utils/tree/sma_agac_' + tr.lower() + '_tree_diagram.png'
algorithm_status = ""
query = ("select " + settings.configs_table_value_column + " from " +
settings.configs_table_name + " where " +
settings.configs_table_parameter_column +
" = \"{}\"".format(settings.configs_algorithm_status_parameter))
cursor = db_op.query_db(query)
if cursor.rowcount == 0:
set_config(parameter, settings.configs_sample_status_values[0])
algorithm_status = settings.configs_sample_status_values[0]
else:
algorithm_status = cursor.fetchone()[0]
if ((algorithm_status == tr) or (algorithm_status == "All")):
return (os.path.isfile('./' + image_path), image_path)
else:
return (False, image_path)
def expert(id, cls):
query = 'UPDATE ' + settings.expert_data_table_name + ' SET ' + settings.expert_prediction_column_name + '="' + cls + '" where ' + settings.expert_data_primarykey_column + '=' + id
cursor = db_op.query_db(query)
print(query)
db_op.query_commit()
return "ok"