def process(dataFilePath,logfilename = 'sqliteDataProcess.log'):
import log
DBlog = log.set_logger(filename = logfilename, isOnlyFile = False)
DBlog.debug('sqlite start！')
global sqlite3Obj
sqlite3Obj = DBHelper.Sqlite3Helper(dataFilePath)
sqlite3Obj.open(check_same_thread=False)
while True:
role,index = yield
if isinstance(role, str):
return
try:
# 跳过账号登陆不成功的
if role.ERRORList[0] != 0:
# 首次录入
firstEntering(role, sqlite3Obj)
# 查询本学期成绩 并更新数据库
# currentEntering(role, sqlite3Obj)
# 更新学生个人信息
# updateStudentInfo(role, sqlite3Obj)
DBlog.info('%d : %s firstEntering Success!' % (index, role.userId))
except Exception as e:
DBlog.error('%d : %s firstEntering Exception!\n -- %s' % (index,role.userId, traceback.format_exc()))
else:
pass
finally:
pass
r = session.post("http://192.168.4.106/setReportParams",
data=payload,
stream=True)
# print(r.text)
m = re.search(r'report1_saveAsText.*?src = "(.*?);', r.text, re.S)
url = m.group(1)
while True:
r = requests.get(url)
if r.text.find("SGT") != -1:
break
print(r.text)
os._exit(0)
Role.eduUrl = 'http://192.168.4.106'
dbHepler = DBHelper.Sqlite3Helper('database\demodatabase.db')
dbHepler.open(check_same_thread=False)
# 从数据库里获得用户密码信息
# tupleList = URPCrawlerDAO.StudentsGradeDao.getallStudentAccounsInfo(dbHepler)
# tupleLen = len(tupleList)
# index = 0
# 角色队列1
roleInfoQueue = queue.Queue()
# 角色队列2
roleInfoSqlliteQueue = queue.Queue()
# 用户密码元组队列
UPQueue = queue.Queue()
# 从微信服务端获取用户密码信息
UPList = NET.getAllIdAndPwd()
for item in UPList:
UPQueue.put(item)
