blob: 35d16c87542c5230619d6fd55bb9ca25cd8223df (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
#!/usr/bin/python3
# coding=utf-8
import time
import pymysql.cursors
import ast
from datetime import datetime
def get_group_id(app, api_host):
mysql_host = api_host[7:]
if "https" in api_host:
mysql_host = api_host[8:]
if "192.168.44.3" in api_host:
db = pymysql.connect(host=mysql_host,
user='test',
password='test@cm',
database='tsg-bifang')
else:
db = pymysql.connect(host=mysql_host,
user='test',
password='test',
database='tsg-bifang')
group_id_list = []
# 该方法用于将字符串类型的['ssl', 'http']转换为list类型的['ssl', 'http']（在无法使用list函数直接转换的情况下）
app = ast.literal_eval(app)
for app_name in app:
sql = "select object_uuid from app_id_dict where app_name= 'appname'"
sql = sql.replace("appname", app_name)
# 连接数据库
mycursor = db.cursor()
# 根据sql查询
mycursor.execute(sql)
# 获取查询结果
myresult = mycursor.fetchall()
# 处理查询结果，获取id
group_id = myresult[0][0]
group_id_list.append(group_id)
return group_id_list
if __name__ == '__main__':
print(datetime.now().strftime("%Y-%m-%d %H:%M:%S"), str(datetime.now().microsecond)[:3], "test")
|
