def initRequiedVariables(self):
self.attacked = False
'''self.JsInjectAtacked=False'''
self.systemLinux = SystemLinux(self)
#inicjalizacja, że nie jest zaznaczony żaden host
self.selected = 0
self.sc = Scanner()
self.sqlHandler = SqlHandler()
self.hosts = []
def getStuPractice(self):
"""
返回某个学生某个练习题
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询练习题和成绩
"""
sql = """select ScoreDetail,FullScore from SCORE where PracticeId='{0}' and StuId='{1}'""".format(
self.practiceId, self.stuId)
# print(sql)
self.stuScore = dict(self.sqlhandler.executeQuerySQL(sql)[0])
sql = """select ExamDetail from PRACTICE where PracticeId='{0}'""".format(
self.practiceId)
self.stuExam = dict(self.sqlhandler.executeQuerySQL(sql)[0])
self.stuScoreExamDetail.update(self.stuScore, self.stuExam)
return True
return False
def getClassStuList(self):
"""
从数据库读取班级学生信息
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询该用户的信息 id+名字
"""
sql = "select student from CLASS where ClassId='{0}'".format(
self.classId)
stuIdList = str(
self.sqlhandler.executeQuerySQL(sql)[0]["Student"]).split(",")
for stuId in stuIdList:
sql = "select StuName from StuPersonInfo where StuId='" + stuId + "'"
stuName = self.sqlhandler.executeQuerySQL(sql)[0]["StuName"]
self.classStu.update({stuId: stuName})
return True
return False
def getClassStuList(self):
"""
从数据库读取班级学生信息
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询该用户的信息 id+名字
"""
sql = "select Student from CLASS where ClassId='{0}'".format(
self.classId)
stuIdList = self.sqlhandler.executeQuerySQL(sql)[0]["Student"]
if stuIdList is None:
self.classStu = {"length": 0}
return True
sql = "select StuName from StuPersonInfo where StuId in (" + stuIdList + ");"
print(sql)
self.classStu = self.sqlhandler.executeQuerySQL(sql)
return True
return False
def getStuCourseInfo(self):
"""
从数据库读取学生信息
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询该用户的课程信息
"""
sql = """select StuClass from StuPersonInfo where StuUid='{0}'""".format(
self.stuUid)
rs = self.sqlhandler.executeQuerySQL(sql)
if len(rs) == 1:
classid = eval(str(rs[0]["StuClass"]))
for clsid in classid:
sql = "select CourseName from CLASS where ClassId='" + clsid + "'"
rs = self.sqlhandler.executeQuerySQL(sql)
if len(rs) == 1:
self.courses.append(rs[0]["CourseName"])
print(self.courses)
return True
return False
def getClassTea(self):
"""
从数据库读取班级老师信息
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询该老师的信息 id+名字
"""
sql = "select Teacher from CLASS where ClassId='{0}'".format(
self.classId)
teaIdList = str(
self.sqlhandler.executeQuerySQL(sql)[0]["Teacher"]).split(",")
for teaId in teaIdList:
sql = "select TeaName from TeaPersonInfo where TeaId='" + teaId + "'"
teaName = self.sqlhandler.executeQuerySQL(sql)[0]["TeaName"]
self.classStu.update({teaId: teaName})
return True
return False
def getPractice(self):
"""
从数据库读取学生信息
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
获取具体习题
"""
sql = """select StuId from StuPersonInfo where StuUid='{0}'""".format(
self.stuUid)
rs = self.sqlhandler.executeQuerySQL(sql)
if len(rs) == 1:
sql = "select ExamDetail,TeaAnswer,FullScore from PRACTICE where PracticeId='{0}'".format(
self.practiceId)
rs = self.sqlhandler.executeQuerySQL(sql)
self.examDetail = rs[0]['ExamDetail']
return True
return False
def getPractice(self):
"""
从数据库读取学生信息
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
设置学生答案
"""
sql = """select StuId from StuPersonInfo where StuUid='{0}'""".format(
self.stuUid)
rs = self.sqlhandler.executeQuerySQL(sql)
print(rs)
if len(rs) == 1:
self.stuId = rs[0]['StuId']
sql = """insert into SCORE (PracticeId,StuId,StuAnswer) values("{0}","{1}","{2}")""".format(
self.practiceId, self.stuId, self.stuAnswer)
print(sql)
if self.sqlhandler.executeOtherSQL(sql):
return True
return False
def getTeaClass(self):
"""
返回老师的习题列表
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询班级列表
"""
# 获取班级id
sql = "select * from (select ClassId,CourseName,Practice from CLASS where Teacher=(select TeaId from TeaPersonInfo where TeaUid='" + self.UID + "')) as a inner join PRACTICE where FIND_IN_SET(PracticeId, a.Practice);"
classes = self.sqlhandler.executeQuerySQL(sql)
print(classes)
for rs in classes:
courseName = rs["CourseName"]
practiceId = str(rs["Practice"]).split(",")
self.teaClassPractice.append({
"id":
rs["PracticeId"],
"classId":
rs["ClassId"],
"title":
rs["PracticeId"],
"fullScore":
rs["FullScore"],
"questions":
json.loads(rs["ExamDetail"])
})
print(self.teaClassPractice)
return True
return False
def checkInfo(self):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询该老师的信息 id+pwd flag=0
"""
"""
查询该学生的信息 id+pwd flag=1
"""
if (self.flag == 0):
sql = "select * from TeaPersonInfo where TeaId='{0}' and TeaPassword='******'".format(
self.userId, self.userPassword)
elif (self.flag == 1):
sql = "select * from StuPersonInfo where StuId='{0}' and StuPassword='******'".format(
self.userId, self.userPassword)
if len(self.sqlhandler.executeQuerySQL(sql)) == 1:
return True
return False
def getTeaClass(self):
"""
返回老师的习题列表
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询班级列表
"""
# 获取班级id
sql = "select TeaClass from TeaPersonInfo where TeaId='" + self.teaId + "'"
teaClassId = str(
self.sqlhandler.executeQuerySQL(sql)[0]['TeaClass']).split(",")
for clsId in teaClassId:
# 获取班级名称，班级id
sql = "select CourseName,Practice from CLASS where ClassId='" + clsId + "'"
rs = self.sqlhandler.executeQuerySQL(sql)
courseName = rs[0]["CoureseName"]
practiceId = str(rs[0]["Practice"]).split(",")
self.teaClassPractice.update({courseName: practiceId})
return True
return False
def scrape():
#DELETING CURRENT DATABASE REMOVE THIS LATER
SqlHandler.drop_table('../data/web_items.db')
SqlHandler.create_database('../data/web_items.db')
if config.get_keywords().count is 0:
print("No keywords set, did you forget to load the config?")
#Load config
config.set_config("../data/config.json")
config.load_config()
#Scrape sites
ebay.add_keywords(config.get_keywords())
ebay.set_pages_to_scrape(config.get_pages_to_scrape())
ebay.scrape_site()
def getTeaClass(self):
"""
返回老师的习题列表
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询班级列表
"""
# 获取班级id
sql = "select TeaClass from TeaPersonInfo where TeaUid='" + self.UID + "'"
classes = self.sqlhandler.executeQuerySQL(sql)
teaClassId = str(classes[0]['TeaClass']).split(",")
if teaClassId[0] == 'None':
self.teaClass = []
return True
for clsId in teaClassId:
# 获取班级名称，班级id
sql = "select CourseName,Practice from CLASS where ClassId='" + clsId + "'"
rs = self.sqlhandler.executeQuerySQL(sql)
self.teaClass.append({
"classId":clsId,
"CourseName":rs[0]["CourseName"]
})
return True
return False
def SetTeaInfo(self):
"""
给学生设置个人信息
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = """select * from TeaPersonInfo where TeaUid='{0}'""".format(
self.teaUid)
rs = self.sqlhandler.executeQuerySQL(sql)
if len(rs) == 1:
sql = """UPDATE TeaPersonInfo SET TeaName='{1}',
TeaSex='{2}',
TeaAge='{3}',
TeaPassword='******',
TeaPhoneNumber='{5}',
TeaQQ='{6}',
TeaAddress='{7}' where TeaUid='{0}'""".format(
self.teaUid, self.teaName, self.teaSex, self.teaAge,
self.teaPassword, self.teaPhoneNumber, self.teaQQ,
self.teaAddress)
if self.sqlhandler.executeOtherSQL(sql):
return True
return False
def saveUid(self, uid):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "update AdminAccount set UID='{0}' WHERE AdminId='{1}';".format(uid, self.userId)
self.sqlhandler.executeOtherSQL(sql)
def updateUID(self):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "update StreamTeaAccount set TeaUid='{0}' where TeaId='{1}'".format(
self.uid, self.userId)
self.sqlhandler.executeOtherSQL(sql)
def __init__(self):
self.sqlHandler = sq.SqlHandler()
self.dba = DBA.DBA()
self.username = None
self.password = None
self.favorType = None
self.firstName = None
self.secondName = None
self.id = None
def download_thumbnails(item_list=None):
if item_list is None:
if items.count is not 0:
ebay.download_thumbnails(items)
else:
ebay.download_thumbnails(
SqlHandler.getTable('../data/web_items.db'))
else:
ebay.download_thumbnails(item_list)
def checkInfo(self):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "select * from AdminAccount where AdminId='{0}' and AdminPassword='******'".format(
self.userId, self.userPassword)
if len(self.sqlhandler.executeQuerySQL(sql)) == 1:
return True
return False
def page_parser(self, soup):
# Find main item area
itemList = soup.find('div', {'id': 'ResultSetItems'})
# Find individual Items
items = itemList.find_all(
'li', {
'class': [
'sresult lvresult clearfix li shic',
'sresult lvresult clearfix li'
]
})
for item in items:
item_id = item.get('listingid')
title = item.find('h3', {'class': 'lvtitle'}).find('a').contents[0]
if str(title) == "<span class=\"newly\">New listing</span>":
title = item.find('h3', {
'class': 'lvtitle'
}).find('a').contents[1]
title.strip()
price = item.find('span', {'class': 'bold'}).contents[0].strip()
image_container = item.find(
'div', {'class': 'lvpicinner full-width picW'})
item_link = image_container.find('a', href=True)['href']
image_link = image_container.find('img').get('src')
purchase_type = ""
if item.find('span', {'title': 'Buy it now'}) is not None:
purchase_type = "Buy it Now"
else:
purchase_type = "Bid"
SqlHandler.add_to_database(self.link_to_database, str(item_id),
str(title), str(price), str(item_link),
str(image_link), str(purchase_type),
"eBay")
def isUIDValid(self):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "select TeaId from StreamTeaAccount where TeaUid='{0}'".format(
self.get_cookie("UID", "no"))
result = self.sqlhandler.executeQuerySQL(sql)
print(result, self.request.full_url())
if len(result) == 1:
return True
return False
def deleteClass(self):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "DELETE FROM CLASS where ClassId='{0}'".format(self.classId)
if self.sqlhandler.executeOtherSQL(sql):
return True
return False
def updateUID(self):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
if (self.flag == 0):
sql = "update TeaPersonInfo set TeaUid='{0}' where TeaId='{1}'".format(
self.uid, self.userId)
elif (self.flag == 1):
sql = "update StuPersonInfo set StuUid='{0}' where StuId='{1}'".format(
self.uid, self.userId)
self.sqlhandler.executeOtherSQL(sql)
def AddTea(self):
"""
将老师信息写入数据库
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "INSERT INTO TeaPersonInfo(TeaId,TeaPassword,TeaName) VALUES('{0}','{1}','{2}')".format(
self.teaId, self.teaPassword, self.teaName)
if self.sqlhandler.executeOtherSQL(sql):
return True
return False
def getStuPractice(self):
"""
返回学生的习题列表
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
"""
查询练习题
"""
# 获取班级id
sql = "select StuClass,StuId from StuPersonInfo where StuUid='" + self.stuUid + "'"
rs = self.sqlhandler.executeQuerySQL(sql)
if len(rs) == 1:
stuClassId = eval(str(rs[0]['StuClass']))
stuId = str(rs[0]['StuId'])
print(stuClassId)
for clsId in stuClassId:
# 获取习题id
sql = "select Practice,CourseName from CLASS where ClassId='" + clsId + "'"
rs = self.sqlhandler.executeQuerySQL(sql)
if len(rs) == 0:
continue
stuPracticeId = eval(str(rs[0]['Practice']))
stuCourseName = str(rs[0]['CourseName'])
if self.subject not in stuCourseName:
continue
for practiceId in stuPracticeId:
# 判断该习题是否被做过
sql = """select StuAnswer from SCORE where PracticeId='{0}' and StuId='{1}'""".format(
practiceId, stuId)
rs = self.sqlhandler.executeQuerySQL(sql)
print(rs,len(rs))
if len(rs) == 1 and rs[0]['StuAnswer'] is not None:
isDone = True
else:
isDone = False
self.practicelist.append({
"practiceId": practiceId,
"isDone": isDone
})
return True
return False
def setClass(self):
"""
将班级信息写入数据库
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "UPDATE TeaPersonInfo SET TeaName='{0}', TeaSex='{1}',TeaPhoneNumber='{2}', TeaClass='{3}' WHERE TeaId='{4}';".format(
self.teaName, self.teaSex, self.teaPhoneNumber, self.teaClass,
self.teaId)
if self.sqlhandler.executeOtherSQL(sql):
return True
return False
def getTeaList(self):
"""
从数据库读取老师列表
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "select TeaId,TeaName from TeaPersonInfo"
self.teaList = self.sqlhandler.executeQuerySQL(sql)
return True
return False
def setClass(self):
"""
将班级信息写入数据库
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = "INSERT INTO CLASS(ClassId,CourseName,Teacher,StuNumber) VALUES('{0}','{1}','{2}','{3}')".format(
self.classId, self.courseName, self.teacher,
self.classStuNumber)
if self.sqlhandler.executeOtherSQL(sql):
return True
return False
def checkUserNmaeRepeat(self):
"""
判断用户名是否重复
"""
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
# sql = 'show tables from PersonDatabase'
"""
查询是否同用户名
"""
sql = "select * from StuPersonInfo where StuId='" + self.stuId + "'"
rows = self.sqlhandler.executeQuerySQL(sql)
if (len(rows) > 1):
return True
def getList(self):
self.sqlhandler = SqlHandler.SqlHandler(Host='139.159.176.78',
User='******',
Password='******',
DBName='PersonDatabase')
if self.sqlhandler.getConnection():
sql = """select TeaId, TeaName, b.CourseName, RoomNumber from
(select a.TeaId, TeaPersonInfo.TeaName, CourseName, RoomNumber from
(select TeaId, CLASS.CourseName, RoomNumber from StreamRoom left join CLASS on StreamRoom.ClassId=CLASS.ClassId) as a
left join TeaPersonInfo on a.TeaId=TeaPersonInfo.TeaId) as b;
"""
self.roomList = self.sqlhandler.executeQuerySQL(sql)
print(self.roomList)
return True