Exemplo n.º 1
0
 def test_10_run_job_mysql_text_local(self, class_home):
     #操作步骤:清楚目标文本内容,运行,下载目标文件，读取目标文件name，读取数据库表name，断言
     Remote().cmd(dd.remote_ip, dd.remote_port, dd.remote_username,
                  dd.remote_pwd, dd.delete_cmd)
     DesignerPage(class_home[0]).run_job_MySQL_text('local')
     Remote().get_file(dd.remote_ip, dd.remote_port, dd.remote_username,
                       dd.remote_pwd, dd.remote_dir,
                       dir_config.ftp_auto_text_01)
     mysql_name = DoMysql().select_table_1()
     assert DoFile().get_file_name() == mysql_name[0][1]
Exemplo n.º 2
0
 def test_9_run_job_distributed(self, class_home):
     #操作步骤:发布，运行，查询表1、2，对比表2与表1，清空表2内容
     DoMysql().deletc_data()
     DesignerPage(class_home[0]).run_job('no_local')
     res = DoMysql().select_table_2()
     assert DoMysql().select_table_1() == res
Exemplo n.º 3
0
def delete_table_ar_control_point():
    DoMysql().delete_all_datas_from_table('ar_control_point')
Exemplo n.º 4
0
# -*- coding: utf-8 -*-
# @Time     : 2019/6/5 11:07
# @Author   : l7
# @Email    :[email protected]
# @File     : do_text.py
# @Software : PyCharm
from numpy.compat import basestring

from Common.do_mysql import DoMysql
from Common import dir_config
f = open(dir_config.ftp_auto_text_01, encoding='utf-8')

lines = f.read()

txt = lines
print("txt取到的信息" + txt[2] + txt[3] + txt[4])
f.close()
t1 = DoMysql().select_table_1()
res = t1[0]
print(t1[0][1])
print(res[1])
# print(txt[2]+txt[3]+txt[4]==res[1])
# ff=open("D:\YOYO\\auto_web_echo_v1\TestDatas\demo_1.txt","w+")
# ff.truncate()
#
# ff.close()
Exemplo n.º 5
0
def delete_table_ar_monitor_equipment():
    DoMysql().delete_all_datas_from_table('ar_monitor_equipment')
Exemplo n.º 6
0
def delete_table_sys_area():
    DoMysql().delete_all_datas_from_table('sys_area')
Exemplo n.º 7
0
def delete_table_ar_switch_cabinet():
    DoMysql().delete_all_datas_from_table('ar_switch_cabinet')
Exemplo n.º 8
0
def delete_table_ar_transformer():
    DoMysql().delete_all_datas_from_table('ar_transformer')
Exemplo n.º 9
0
def delete_table_ar_distribution_room():
    DoMysql().delete_all_datas_from_table('ar_distribution_room')
Exemplo n.º 10
0
def delete_table_sys_user():
    # sql = 'DELETE FROM sys_user WHERE login_name <> "{}" and login_name <> "{}" and login_name <> "{}"'.format('thinkgem', 'idrmstest', 'idrmstest1')
    sql = 'DELETE FROM sys_user WHERE login_name <> "{}"'.format('thinkgem')
    DoMysql().delete_datas_from_table_with_sql(sql)
Exemplo n.º 11
0
 def test_8_run_job_local(self, class_home):
     #操作步骤:发布，运行，查询表1、2，对比表2与表1，清空表2内容
     DoMysql().deletc_data(dd.sql_delete_t2)
     DesignerPage(class_home[0]).run_job('local')
     res = DoMysql().do_mysql(dd.select_table_2)
     assert DoMysql().do_mysql(dd.select_table_1) == res