示例#1
0
def copy_to_tmp():
	con = Help.connect_global()
	with con as cur:
		__copy_table(cur, Table_Global.computer, Table_Global.computer_tmp)
		__copy_table(cur, Table_Global.mysql, Table_Global.mysql_tmp)
		__copy_table(cur, Table_Global.zone, Table_Global.zone_tmp)
		__copy_table(cur, Table_Global.process, Table_Global.process_tmp)
		cur.close()
	con.close()
示例#2
0
def copy_from_tmp():
	con = Help.connect_global()
	with con as cur:
		__copy_table(cur, Table_Global.computer_tmp, Table_Global.computer)
		__copy_table(cur, Table_Global.mysql_tmp, Table_Global.mysql)
		__copy_table(cur, Table_Global.zone_tmp, Table_Global.zone)
		__copy_table(cur, Table_Global.process_tmp, Table_Global.process)
		cur.close()
	con.close()
示例#3
0
def add_mysql(mysql_name, mysql_ip, mysql_port, mysql_user, mysql_pwd):
	con = Help.connect_global()
	with con as cur:
		cur.execute("insert into computer_tmp (mysql_name, mysql_ip, mysql_port, mysql_user, mysql_pwd) values(%s, %s);", (computer_name, computer_ip))
		cur.close()
	con.close()
示例#4
0
def add_computer(computer_name, computer_ip):
	con = Help.connect_global()
	with con as cur:
		cur.execute("insert into computer_tmp (computer_name, computer_ip) values(%s, %s);", (computer_name, computer_ip))
		cur.close()
	con.close()