def clone_data(data): mc = mysql_connect.cursor() query = "SELECT * FROM bot_user WHERE bot_user_id IN (%s) " ids = ", ".join(data) mc.execute(query % ids) result = mc.fetchall() return result
def count_data(): mc = mysql_connect.cursor() query = "SELECT * FROM task_value_group" mc.execute(query) mc.fetchall() count = mc.rowcount return count
def count_data(): mc = mysql_connect.cursor() query = "SELECT * FROM task_function_category" mc.execute(query) mc.fetchall() count = mc.rowcount return count
def count_data(): mc = mysql_connect.cursor() query = "SELECT * FROM bot_task_template" mc.execute(query) mc.fetchall() count = mc.rowcount return count
def get_bottasktemplate(checkbox_id): mc = mysql_connect.cursor() query = "SELECT b.bot_task_template_name FROM bot_task AS a LEFT JOIN bot_task_template as b ON b.bot_task_template_id=a.bot_task_template_id WHERE a.bot_task_id = %s " # query = "SELECT bot_task_template_name FROM bot_task WHERE bot_task_id = %s " mc.execute(query,(checkbox_id) ) result = mc.fetchone() return result
def get_task_function(start, limit): mc = mysql_connect.cursor() # query = "SELECT * FROM bot_task_template_tf LIMIT %s,%s " query = "SELECT a.*, b.scene_name, c.scene_category_name, d.task_value_type_name FROM bot_task_template_tf as a LEFT JOIN scene as b ON b.scene_id = a.scene_id LEFT JOIN scene_category as c ON c.scene_category_id=a.scene_category_id LEFT JOIN task_value_type as d ON d.task_value_type_id=a.task_value_type_id ORDER BY a.bot_task_template_tf_id ASC LIMIT %s,%s " mc.execute(query, (start, limit)) result = mc.fetchall() return result
def count_clone_data(data): mc = mysql_connect.cursor() query = "SELECT * FROM task_value WHERE task_value_id IN (%s) " ids = ", ".join(data) mc.execute(query % ids) mc.fetchall() count = mc.rowcount return count
def save_data(name, description, filename, filerow): mc = mysql_connect.cursor() query = "INSERT INTO bot_task_template_file (name, description, file_name, file_row) VALUES (%s,%s,%s,%s)" data = (name, description, filename, filerow) mc.execute(query, (data)) mysql_connect.commit() result = mc.fetchall() return result
def save_bot_task(name, checkId, sn): mc = mysql_connect.cursor() now = datetime.now() query = "INSERT INTO bot_task (bot_task_name, bot_task_template_id, SN, created_at ) VALUES (%s,%s,%s,%s)" data = (name, checkId, sn, now) mc.execute(query, (data)) mysql_connect.commit() result = mc.fetchall() return result
def save_data(name, sn_range, group_name, last_sn): mc = mysql_connect.cursor() now = datetime.now() query = "INSERT INTO bot_task_template (bot_task_template_name, sn_range, bot_user_group_name, cloned_create_bot_task_groups ,created_at ) VALUES (%s,%s,%s,%s,%s)" data = (name, sn_range, group_name, last_sn, now) mc.execute(query, (data)) mysql_connect.commit() result = mc.fetchall() return result
def save_data(name, description): mc = mysql_connect.cursor() now = datetime.now() query = "INSERT INTO bot_user_group (bot_user_group_name, created_at ) VALUES (%s,%s)" data = (name, now) mc.execute(query, (data)) mysql_connect.commit() result = mc.fetchall() return result
def update_data(c1, c2): mc = mysql_connect.cursor() query = "UPDATE bot_task SET run_count = %s WHERE bot_task_id = %s" data = (c1,c2) mc.execute(query,(data)) mysql_connect.commit() result = mc.fetchall() print("Record Updated successfully ") return result
def save_data(kategori,name,description): mc = mysql_connect.cursor() now = datetime.now() query = "INSERT INTO scene (scene_category_id, scene_name, created_at ) VALUES (%s,%s,%s)" data = (kategori,name,now) mc.execute(query,(data) ) mysql_connect.commit() result = mc.fetchall() return result
def update_log(log, task): mc = mysql_connect.cursor() now = datetime.now() query = "INSERT INTO log (log_description, bot_task_group_id, log_start_date_time, log_end_date_time, created_at ) VALUES (%s,%s,%s,%s,%s)" data = (log, task, now, now, now) mc.execute(query, (data)) mysql_connect.commit() result = mc.fetchall() return result
def import_data(file_path): mc = mysql_connect.cursor() csv_data = csv.reader(open(file_path)) next(csv_data) now = datetime.now() for row in csv_data: mc.execute('INSERT INTO task_value(task_value_name, task_value_category ,created_at) VALUES (%s, %s, %s)' , (row[0],row[1],now) ) mysql_connect.commit() mc.close()
def import_data(file_path): mc = mysql_connect.cursor() csv_data = csv.reader(open(file_path)) next(csv_data) # today = date.today() now = datetime.now() for row in csv_data: mc.execute('INSERT INTO bot_user(bot_user_name,created_at) VALUES (%s, %s)', (row, now)) mysql_connect.commit() mc.close()
def search_data3(data3): mc = mysql_connect.cursor() query = "SELECT a.*, b.scene_category_name, c.scene_name, d.task_value_group_name, e.task_value_type_name FROM task_value as a \ LEFT JOIN scene_category as b ON b.scene_category_id = a.scene_category_id \ LEFT JOIN scene as c ON c.scene_id = a.scene_id \ LEFT JOIN task_value_group as d ON d.task_value_group_id = a.task_value_group_id \ LEFT JOIN task_value_type as e ON e.task_value_type_id = a.task_value_type_id \ WHERE task_value_name = %s " mc.execute(query,(data3) ) result = mc.fetchall() return result
def get_data(start,limit): mc = mysql_connect.cursor() query = "SELECT a.*, b.scene_category_name, c.scene_name, d.task_value_group_name, e.task_value_type_name FROM task_value as a \ LEFT JOIN scene_category as b ON b.scene_category_id = a.scene_category_id \ LEFT JOIN scene as c ON c.scene_id = a.scene_id \ LEFT JOIN task_value_group as d ON d.task_value_group_id = a.task_value_group_id \ LEFT JOIN task_value_type as e ON e.task_value_type_id = a.task_value_type_id \ LIMIT %s,%s " mc.execute(query,(start,limit) ) result = mc.fetchall() return result
def import_data(file_path): mc = mysql_connect.cursor() csv_data = csv.reader(open(file_path)) next(csv_data) now = datetime.now() for row in csv_data: id2 = int(row[2]) id4 = int(row[4]) id6 = int(row[6]) mc.execute( 'INSERT INTO task_function(task_function_name, task_function_content , task_function_category_id , task_function_category, task_value_group_id ,task_value_group, created_at) VALUES (%s, %s, %s, %s, %s, %s, %s)', (row[0], row[1], id2, row[3], id4, row[5], id6, now)) mysql_connect.commit() mc.close()
def save_data(task_function_id, task_function_name, scene_category_id, scene_category, scene_id, scene, task_value_type_id, task_value_type_name, task_value_group_id, task_value_group_name, task_value_count, unique_value, comment): mc = mysql_connect.cursor() now = datetime.now() query = "INSERT INTO bot_task_template_tf (task_function_id, task_function, scene_category_id, scene_category, scene_id, scene, task_value_type_id, task_value_type, task_value_group_id, task_value_group, task_value_count, unique_task_value, comment, created_at) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)" data = (task_function_id, task_function_name, scene_category_id, scene_category, scene_id, scene, task_value_type_id, task_value_type_name, task_value_group_id, task_value_group_name, task_value_count, unique_value, comment, now) mc.execute(query, (data)) result = mc.fetchall() return result
def delete_data(data): mc = mysql_connect.cursor() query = "SELECT * FROM bot_task_template WHERE bot_task_template_name = %s ORDER BY bot_task_template_id DESC" mc.execute(query, (data)) result = mc.fetchall() return result
def get_data(start, limit): mc = mysql_connect.cursor() query = "SELECT * FROM bot_task_template ORDER BY bot_task_template_id DESC LIMIT %s,%s " mc.execute(query, (start, limit)) result = mc.fetchall() return result
def retrieve_data(): mc = mysql_connect.cursor() query = "SELECT * FROM bot_task_template ORDER BY bot_task_template_id DESC LIMIT 0,20 " mc.execute(query) result = mc.fetchall() return result
def retrieve_data(): mc = mysql_connect.cursor() query = "SELECT * FROM log LIMIT 0,20 ORDER BY log_id DESC" mc.execute(query) result = mc.fetchall() return result
def search_data(data): mc = mysql_connect.cursor() query = "SELECT * FROM log WHERE log_description = %s ORDER BY log_id DESC" mc.execute(query, (data)) result = mc.fetchall() return result
def delete_data(data): mc = mysql_connect.cursor() query = "SELECT * FROM task_value_group WHERE task_value_group_name = %s ORDER BY task_value_group_id DESC" mc.execute(query, (data)) result = mc.fetchall() return result
def get_data(start, limit): mc = mysql_connect.cursor() query = "SELECT * FROM task_value_group ORDER BY task_value_group_id DESC LIMIT %s,%s " mc.execute(query, (start, limit)) result = mc.fetchall() return result
def retrieve_data(): mc = mysql_connect.cursor() query = "SELECT * FROM task_value_group ORDER BY task_value_group_id DESC LIMIT 0,20 " mc.execute(query) result = mc.fetchall() return result
def retrieve_data(): mc = mysql_connect.cursor() query = "SELECT * FROM bot_user LIMIT 0,20 " mc.execute(query) result = mc.fetchall() return result
def search_data3(data): mc = mysql_connect.cursor() query = "SELECT * FROM bot_user WHERE last_name = %s " mc.execute(query, (data)) result = mc.fetchall() return result