def pwd(): newpwd = Requester(request).value("newpwd") account = Account(db, pops="id") user = account.findBy()["data"] res = {"success": False, "msg": "密码错误"} if len(user) > 0 and account.password == user[0]["password"]: row = {"password": account.md5(newpwd)} # clause = "where name='{0}' and password='******'".format(author.name, author.password) optRes = account.model.update(row, clause="where id={0}".format( account.id)) res["success"] = optRes["success"] res["msg"] = optRes["msg"] return json.dumps(res)
def init_base_db(db, app): mode = app.config.get("MODE") super = app.config.get("SUPER") admin = app.config.get("ADMIN") pat = app.config.get("PATTERN", mode.DEFAULT.value if mode else 1) sheets = app.config.get("SHEETS", {}) # 版本 version version = db.model( "version", { "id": "integer not null primary key autoincrement unique", # 主键 "number": "integer default 1", "time": "DATE DEFAULT (datetime('now','localtime'))", "pattern": "integer default 1", "intro": "text" }) versionRes = version.find("*", clause="where number=1.0") if len(versionRes["data"]) == 0: version.insert({ "number": "1.0", "pattern": pat, "intro": "后台配置版:主页,表单,路由配置" }) # version.update({"pattern": pat}, clause="where number=3.7") # 账号 account from app.models.Account import Account account = db.model( "account", { "id": "integer not null primary key autoincrement unique", # 主键 "number": "integer default 1", "name": "text not null unique", # 账号 "password": "******", "nickname": "text", "time": "DATE DEFAULT (datetime('now','localtime'))", "rank": "integer default 100", "right": "text default null", "tel": "text default null", "email": "text default null" }) heroAge = account.find("*", clause="where name='heroAge'") other_admin = account.find("*", clause="where name='admin'") if len(heroAge["data"]) == 0: account.insert({ "id": super.ID.val, "number": super.NUMBER.val, "name": super.NAME.val, "nickname": super.NICKNAME.val, "password": Account.md5(super.PASSWORD.val), "rank": super.RANK.value }) if len(other_admin["data"]) == 0: account.insert({ "id": admin.ID.val, "number": admin.NUMBER.val, "name": admin.NAME.val, "nickname": admin.NICKNAME.val, "password": Account.md5(admin.PASSWORD.val), "rank": admin.RANK.value }) # >>>>set 系统设置 # 展区管理 exhibit_opt = sheets.get("exhibit", {}) exhibit_col, exhibit_data = exhibit_opt.get("column", {}), exhibit_opt.get( "data", []) exhibit = db.model( "exhibit", exhibit_col if exhibit_col else { "id": "integer not null primary key autoincrement unique", # 主键 "number": "integer default 1", # 展厅序号 "type": "text not null", # 所展示的类型 "name": "text" # 展厅名字 }) exhibitRes = exhibit.find("*") if len(exhibitRes["data"]) == 0 and exhibit_data: exhibit.insert(exhibit_data) # 主题管理 # theme_opt = sheets.get("theme", {}) # theme_col, theme_data = theme_opt.get("column", {}), theme_opt.get("data", []) # theme = db.model("theme", theme_col if theme_col else { # "id": "integer not null primary key autoincrement unique", # 主键 # "number": "integer default 1", # 主题序号 # "type": "text not null", # 所展示的类型 # "name": "text not null" # 主题名字 # }) # themeRes = theme.find("*") # if len(themeRes["data"]) == 0 and theme_data: # theme.insert(theme_data) # 标签管理 label = db.model( "label", { "id": "integer not null primary key autoincrement unique", # 主键 "number": "integer default 1", # 标签序号 "name": "text not null" # 标签名字 }) labelRes = label.find("*", clause="where id=0") if len(labelRes["data"]) == 0: label.insert({"number": 0, "id": 0, "name": "未标签"})