def updSelf(self, user):
updSql = "update t_user set username = %s, password = %s where id = %s;"
self.__cursor.execute(
updSql,
[user.username, encrypt(user.password), user.ID])
db.commit()
return True
def upd(self, user):
# 检查重名
if self.selRepName(user):
return False
updSql = "update t_user set username = %s, password = %s where id = %s;"
self.__cursor.execute(
updSql,
[user.username, encrypt(user.password), user.ID])
db.commit()
return True
def ins(self, user):
# 检查重名
if self.selRepName(user):
return False
sqlIns = "insert into t_user values (default,%s,%s)"
result = self.__cursor.execute(
sqlIns, [user.username, encrypt(user.password)])
db.commit()
if result is None:
return False
else:
# 设置新ID
self.selId(user)
return True
def insList(self, entities):
"""
插入一次爬取的数据
"""
insSql = "insert into hot_spot values (default,%s,%s,%s,%s,%s);"
# 插入并获取date_id
spiderDateEntity = SpiderDateEntity(0, entities[0].crawlDate)
self.__spiderDateDao.ins(spiderDateEntity)
for item in entities:
self.__cursor.execute(insSql, [
item.rank, item.affair, item.view,
time.strftime("%Y-%m-%d %H:%M:%S",
time.localtime(item.crawlDate)),
spiderDateEntity.dateId
])
db.commit()
return True
def delete(self, ID):
delSql = "delete from t_user where id = %s"
self.__cursor.execute(delSql, ID)
db.commit()
return True
def delete(self, dateId):
delSql = "delete from spider_date where date_id = %s;"
self.__cursor.execute(delSql, dateId)
db.commit()
return True
def delByOneDate(self, dateId):
delSql = "delete from hot_spot where date_id = %s;"
self.__cursor.execute(delSql, dateId)
self.__spiderDateDao.delete(dateId)
db.commit()
return True