ylrz_saas_his_scrm/scripts/test_tenant_job_db.py

# -*- coding: utf-8 -*-
import pymysql

conn = pymysql.connect(
    host='cq-cdb-8fjmemkb.sql.tencentcdb.com',
    port=27220,
    user='root',
    password='Ylrz_1q2w3e4r5t6y',
    database='ylrz_saas',
    charset='utf8mb4',
)
cur = conn.cursor()
cur.execute("SELECT user_id,user_name,password,status FROM sys_user WHERE user_name='admin' LIMIT 3")
print('admin users:', cur.fetchall())
cur.execute("SELECT template_id,template_code,job_name,scope,status FROM sys_job_template LIMIT 10")
print('templates:', cur.fetchall())
cur.execute("SELECT COUNT(*) FROM tenant_job_config")
print('tenant_job_config count:', cur.fetchone())
cur.execute("SELECT id,tenant_code,status FROM tenant_info LIMIT 5")
print('tenants:', cur.fetchall())
cur.execute("SELECT menu_id,menu_name,parent_id,path,component,perms FROM sys_menu WHERE perms LIKE '%monitor:job%' LIMIT 20")
print('job menus:', cur.fetchall())
conn.close()