def db_init():
cursor, db = getDBLink(2)
return db.cursor()
import pymysql, datetime, uuid, time, queue, threading from time import sleep, ctime from 补数据专区 import bsUtil, xiancheng sql = "SELECT * from tss_member_attend_class_record a where a.createTime is null;" cursor, db = bsUtil.getDBLink(1) cursor.execute(sql) contents = cursor.fetchall()
import pymysql, datetime, uuid, time
from 补数据专区.bsUtil import getDBLink
sql = "SELECT aa.* ,d.schoolName from (SELECT a.* ,sum(b.amount) as amount " \
"from tss_member_check_attendance_history a LEFT JOIN " \
"tss_right_statistic b on a.checkAttendanceId = b.attendanceId" \
" where a.attendenceStatus =4 and b.isDelete=0 GROUP BY a.checkAttendanceId )aa" \
" LEFT JOIN sys_admin_user c on c.id = aa.adminUserId LEFT JOIN" \
" sys_school d on d.id =c.schoolId where aa.amount !=0.00 and" \
" d.schoolName not in ('线上测试投资','线上测试园2督导专用') "
cursor, db = getDBLink(1)
cursor.execute(sql)
contents = cursor.fetchall()
courseIdSql = "SELECT * from tss_right_statistic where attendanceId ='%s' and isDelete =0"
one = 0
for s in contents:
cursor.execute(courseIdSql % s[1])
courseIds = cursor.fetchall()
if (courseIds is not None and len(courseIds) == 1):
print(s[1] + " is 只有一条")
one += 1
insetSql = "INSERT INTO `tss`.`tss_right_statistic`(`id`, `stuId`, `type`, `responsibilityType`, " \
"`attendanceId`, `paymentId`, `returnPremiumId`, `memberPackageId`, `amount`, `adminUserId`, " \
"`isDelete`, `createTime`, `updateTime`, `version`, `appointmentManageId`, `addsubtractId`, " \
"`supplementaryTime`, `importTime`) VALUES (" \
"'%s', " \
"'%s', " \
"%d, %d, '%s', " \
"%s, %s, %s, %s, " \