def all_users(self):
'''查询当前数据表中所有的用户列表'''
sql_execute = "select username from auto_post_users"
try:
self.execute(sql_execute)
usernames = self.cur.fetchall()
except Exception:
db_err("查询用户表中所有用户列表失败！")
return usernames
def update(self, page_info):
sql = PageExtractorDB.sql_creator(page_info)
try:
self.db.execute(sql)
except Exception as e:
db_err("[%s]更新数据错误[%s] %s %s " %
(self.__name__, page_info['house_id'], str(e), sql))
else:
db_info("[%s]成功更新数据[%s]" % (self.__name__, page_info["house_id"]))
def insert_house_info(self, house_info):
'''插入房源信息'''
from .sql_template import insert_house_info_sql
sql_execute = insert_house_info_sql % house_info
try:
self.execute(sql_execute)
except Exception as e:
db_err("向房源表中插入一条数据失败！e:%s, SQL: %s" % (str(e), sql_execute))
def update_user(self, username, password, usertype, name=""):
'''更新某一用户的账户信息'''
from .sql_template import update_user_sql
sql_execute = update_user_sql.format(username=username, password=password,\
usertype=usertype, name=name)
try:
self.execute(sql_execute)
except Exception:
db_err("修改用户表中【{username}】信息错误！".format(user_name=username))
def insert_user(self, username, password, usertype, name=""):
'''向表中插入一条数据'''
from .sql_template import insert_user_sql
sql_execute = insert_user_sql.format(username=username, password=password,\
usertype=usertype, name=name)
try:
self.execute(sql_execute)
except Exception as e:
db_err("向用户表中插入一条数据失败！ e:%s, SQL: %s"%(str(e),sql_execute))