19 lines
820 B
Python
19 lines
820 B
Python
# -*- coding: utf-8 -*-
|
|
import io, sys, pymysql, datetime
|
|
sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8')
|
|
|
|
# 1. 周一~周五（不含节假日）
|
|
weekdays = [datetime.date(2026,6,i) for i in range(1,31) if datetime.date(2026,6,i).weekday()<5]
|
|
print("2026-06 周一~周五天数:", len(weekdays), [d.day for d in weekdays])
|
|
|
|
# 2. Constant.vacationDateMap 里的 6 月节假日
|
|
conn = pymysql.connect(host='192.168.1.161', user='devgps', password='dev@2021GPS',
|
|
database='zentao_dev_2026', charset='utf8mb4')
|
|
cur = conn.cursor()
|
|
cur.execute("SHOW TABLES LIKE '%vacation%'")
|
|
print("vacation 表:", cur.fetchall())
|
|
cur.execute("SHOW TABLES LIKE '%holiday%'")
|
|
print("holiday 表:", cur.fetchall())
|
|
cur.execute("SHOW TABLES LIKE '%constant%'")
|
|
print("constant 表:", cur.fetchall())
|