示例#1
0
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']
示例#2
0
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',
示例#4
0
#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()

        
示例#5
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() + '/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
示例#7
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() + '/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()
示例#9
0
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:
示例#11
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() + '/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()
示例#12
0
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)
示例#13
0
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():
示例#15
0
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()
示例#17
0
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
示例#18
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()
示例#19
0
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