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