from flask import request from flask import render_template import sys import os import csv from main import getPath sys.path.insert(1, getPath() + '/Scene category/model/') from model_CSV_scene_category import DataCSV from datetime import datetime class CSVController(): def CSV_controller(): start = request.form.get('start', default=0, type=int) limit = request.form.get('limit', default=20, type=int) logstart = datetime.now() if request.form.get('import_CSV'): file_path = request.form.get('CSV_file_name') DataCSV.import_data(file_path) csv_data = csv.reader(open(file_path)) row_count = (sum(1 for row in csv_data)) - 1 x = str(row_count) DataCSV.update_log('Import CSV - ' + x, 1, logstart) result = DataCSV.get_data(start, limit) elif request.form.get('Btn_delete'): data = request.form['name'] DataCSV.delete_data(data) elif request.form.get('Btn_save'): name = request.form['name']
from flask import request from flask import render_template import sys from main import getPath sys.path.insert(1, getPath() + '/Task function/model/') from model_LIST_task_function import DataList class ListController(): def list_controller(): start = request.form.get('start', default=0, type=int) limit = request.form.get('limit', default=20, type=int) text = request.form.get('search') text1 = request.form.get('search1') if request.form.get('search'): result = DataList.search_data(text) elif request.form.get('search1'): result = DataList.search_data1(text1) else: result = DataList.get_data(start, limit) count = DataList.count_data() return render_template('tmpl_LIST_task_function.html', title='List Task function', listdata=result, countdata=count)
from flask import request from flask import render_template import sys from main import getPath sys.path.insert(1, getPath() + '/Bot user/model/') from model_LIST_bot_user import DataList class ListController(): def list_controller(): start = request.form.get('start', default=0, type=int) limit = request.form.get('limit', default=20, type=int) data = request.form.get('search') data1 = request.form.get('search1') data2 = request.form.get('search2') data3 = request.form.get('search3') if request.form.get('search'): result = DataList.search_data(data) elif request.form.get('search1'): result = DataList.search_data1(data1) elif request.form.get('search2'): result = DataList.search_data2(data2) elif request.form.get('search3'): result = DataList.search_data3(data3) else: result = DataList.get_data(start, limit) count = DataList.count_data() return render_template('tmpl_LIST_bot_user.html',
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound from main import getPath import sys sys.path.insert(1, getPath()+'/Bot task/controller/') from controller_LIST_bot_task import ListController LIST_bot_task = Blueprint('LIST_bot_task', __name__, template_folder='template') @LIST_bot_task.route("/view_LIST_bot_task", methods=['GET', 'POST']) def view_LIST_bot_task(): return ListController.list_controller()
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound import sys from main import getPath sys.path.insert(1, getPath() + '/Scene/controller/') from controller_NEW_scene import NewController NEW_scene = Blueprint('NEW_scene', __name__, template_folder='template') @NEW_scene.route("/view_NEW_scene", methods=['GET', 'POST']) def view_NEW_scene(): return NewController.new_controller()
from flask import Flask import sys import csv import os.path from main import getPath sys.path.insert(1, getPath() + '/A_SYSTEM/') from connect_MYSQL_DB import mysql_connect from datetime import datetime class DataCSV(): 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_type(task_value_type_name, created_at) VALUES (%s,%s)', (row, now)) mysql_connect.commit() mc.close() def retrieve_data(): mc = mysql_connect.cursor() query = "SELECT * FROM task_value_type ORDER BY task_value_type_id DESC LIMIT 0,20 " mc.execute(query) result = mc.fetchall() return result
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound import sys from main import getPath sys.path.insert(1, getPath() + '/Task value type/controller/') from controller_NEW_task_value_type import NewController NEW_task_value_type = Blueprint('NEW_task_value_type', __name__, template_folder='template') @NEW_task_value_type.route("/view_NEW_task_value_type", methods=['GET', 'POST']) def view_NEW_task_value_type(): return NewController.new_controller()
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound import sys from main import getPath sys.path.insert(1, getPath() + '/Task function category/controller/') from controller_CSV_task_function_category import CSVController CSV_task_function_category = Blueprint('CSV_task_function_category', __name__, template_folder='template') @CSV_task_function_category.route("/view_CSV_task_function_category", methods=['GET', 'POST']) def view_CSV_task_function_category(): return CSVController.CSV_controller()
from flask import request from flask import render_template import sys from datetime import datetime from main import getPath sys.path.insert(1, getPath()+'/Task value group/model/') from model_NEW_task_value_group import DataList class NewController(): def new_controller(): start = request.form.get('start', default=0, type=int) limit= request.form.get('limit', default=20, type=int ) text= request.form.get('search') text1= request.form.get('search1') if request.form.get('search'): result_tv = DataList.search_data_tv(text) result = DataList.get_data(start,limit) elif request.form.get('search1'): result_tv = DataList.search_data1_tv(text1) result = DataList.get_data(start,limit) else: result = DataList.get_data(start,limit) result_tv = DataList.get_data_tv(start,limit) count = DataList.count_data() return render_template('tmpl_NEW_task_value_group.html', title='New Task value group',listdata_tv=result_tv, listdata=result, countdata=count) def save_controller():
from flask import request from flask import render_template import sys from main import getPath sys.path.insert(1, getPath() + '/Scene/model/') from model_LIST_scene import DataList from datetime import datetime class ListController(): def list_controller(): start = request.form.get('start', default=0, type=int) limit = request.form.get('limit', default=20, type=int) text = request.form.get('search') text1 = request.form.get('search1') logstart = datetime.now() if request.form.get('search'): result = DataList.search_data(text) elif request.form.get('search1'): result = DataList.search_data1(text1) elif request.form.get('Btn_save'): name = request.form['name'] description = request.form['description'] category = request.form['scene_category'] save_data = DataList.save_data(category, name, description) x = request.form['name'] DataList.update_log('Add New - ' + x, 1, logstart) result = DataList.get_data(start, limit) else:
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound import sys from main import getPath sys.path.insert(1, getPath() + '/Bot task template/controller/') from controller_LIST_bot_task_template import ListController LIST_bot_task_template = Blueprint('LIST_bot_task_template', __name__, template_folder='template') @LIST_bot_task_template.route("/view_LIST_bot_task_template", methods=['GET', 'POST']) def view_LIST_bot_task_template(): return ListController.list_controller()
from flask import request from flask import render_template import sys from main import getPath # sys.path.insert(1, 'C:/python/Automation/Run bot task/model/') sys.path.insert(1, getPath() + '/Run bot task/model/') from model_LIST_run_bot_task import DataList class ListController(): def list_controller(): start = request.form.get('start', default=0, type=int) limit = request.form.get('limit', default=20, type=int) text = request.form.get('search') from_sn = request.form.get('from_sn') to_sn = request.form.get('to_sn') if request.form.get('search'): result = DataList.search_data(text) elif request.form.get('from_sn'): result = DataList.search_data1(from_sn, to_sn) else: result = DataList.get_data(start, limit) count = DataList.count_data() return render_template('tmpl_LIST_run_bot_task.html', title='List Run bot task', listdata=result, countdata=count)
from flask import request from flask import render_template import sys import os import csv from main import getPath sys.path.insert(1, getPath() + '/Task function category/model/') from model_CSV_task_function_category import DataCSV class CSVController(): def CSV_controller(): start = request.form.get('start', default=0, type=int) limit = request.form.get('limit', default=20, type=int) if request.form.get('import_CSV'): file_path = request.form.get('CSV_file_name') DataCSV.import_data(file_path) csv_data = csv.reader(open(file_path)) row_count = (sum(1 for row in csv_data)) - 1 result = DataCSV.get_data(start, limit) elif request.form.get('Btn_delete'): data = request.form['name'] DataCSV.delete_data(data) elif request.form.get('Btn_save'): name = request.form['name'] description = request.form['description'] filename = request.form['filename'] filerow = request.form['filerow'] file_path = ''
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound import sys from main import getPath sys.path.insert(1, getPath() + '/Task value group/controller/') from controller_NEW_task_value_group import NewController NEW_task_value_group = Blueprint('NEW_task_value_group', __name__, template_folder='template') @NEW_task_value_group.route("/view_NEW_task_value_group", methods=['GET', 'POST']) def view_NEW_task_value_group(): return NewController.new_controller() @NEW_task_value_group.route("/clone_NEW_task_value_group", methods=['GET', 'POST']) def clone_NEW_task_value_group(): return NewController.clone_controller() @NEW_task_value_group.route("/save_NEW_task_value_group", methods=['GET', 'POST']) def save_NEW_task_value_group():
from flask import request from flask import render_template from main import getPath import sys import os import csv sys.path.insert(1, getPath() + '/Bot task template/model/') from model_CSV_bot_task_template import DataCSV class CSVController(): def CSV_controller(): start = request.form.get('start', default=0, type=int) limit = request.form.get('limit', default=20, type=int) if request.form.get('import_CSV'): file_path = request.form.get('CSV_file_name') DataCSV.import_data(file_path) csv_data = csv.reader(open(file_path)) row_count = (sum(1 for row in csv_data)) - 1 result = DataCSV.get_data(start, limit) elif request.form.get('Btn_delete'): data = request.form['name'] DataCSV.delete_data(data) elif request.form.get('Btn_save'): name = request.form['name'] description = request.form['description'] filename = request.form['filename'] filerow = request.form['filerow']
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound import sys from main import getPath sys.path.insert(1, getPath() + '/Bot user group/controller/') from controller_CSV_bot_user_group import CSVController CSV_bot_user_group = Blueprint('CSV_bot_user_group', __name__, template_folder='template') @CSV_bot_user_group.route("/view_CSV_bot_user_group", methods=['GET', 'POST']) def view_CSV_bot_user_group(): return CSVController.csv_controller()
from flask import request from flask import render_template import sys import os import csv from main import getPath sys.path.insert(1, getPath()+'/Bot task type/model/') from model_CSV_bot_task_type import DataCSV class CSVController(): def CSV_controller(): start = request.form.get('start', default=0, type=int) limit= request.form.get('limit', default=20, type=int ) if request.form.get('import_CSV'): file_path = request.form.get('CSV_file_name') DataCSV.import_data(file_path) csv_data = csv.reader(open(file_path)) row_count = (sum(1 for row in csv_data)) - 1 result = DataCSV.get_data(start,limit) elif request.form.get('Btn_delete'): data = request.form['name'] DataCSV.delete_data(data) elif request.form.get('Btn_save'): name = request.form['name'] description = request.form['description'] filename = request.form['filename'] filerow = request.form['filerow'] file_path = '' row_count = 0
#import blueprint from flask import Blueprint, render_template, abort from jinja2 import TemplateNotFound import sys from main import getPath sys.path.insert(1, getPath() + '/Log/controller/') from controller_CSV_log import CSVController CSV_log = Blueprint('CSV_log', __name__, template_folder='template') @CSV_log.route("/view_CSV_log", methods=['GET', 'POST']) def Csv_log(): return CSVController.csv_controller()
from flask import request from flask import render_template import sys import os import csv from main import getPath sys.path.insert(1, getPath()+'/Task value type/model/') from model_CSV_task_value_type import DataCSV class CSVController(): def CSV_controller(): start = request.form.get('start', default=0, type=int) limit= request.form.get('limit', default=20, type=int ) if request.form.get('import_CSV'): file_path = request.form.get('CSV_file_name') DataCSV.import_data(file_path) csv_data = csv.reader(open(file_path)) row_count = (sum(1 for row in csv_data)) - 1 result = DataCSV.get_data(start,limit) elif request.form.get('Btn_delete'): data = request.form['name'] DataCSV.delete_data(data) elif request.form.get('Btn_save'): name = request.form['name'] description = request.form['description'] filename = request.form['filename'] filerow = request.form['filerow'] file_path = '' row_count = 0