def GET(self): page = xutils.get_argument("page", 1, type=int) db = xtables.get_dict_table() items = db.select(order="id", limit=PAGE_SIZE, offset=(page-1)*PAGE_SIZE) def convert(item): v = Storage() v.name = item.key v.summary = item.value v.mtime = item.mtime v.ctime = item.ctime v.url = "#" v.priority = 0 return v items = map(convert, items) count = db.count() page_max = math.ceil(count / PAGE_SIZE) return xtemplate.render("note/view.html", show_aside = True, files = list(items), file_type = "group", show_opts = False, page = page, page_max = page_max, page_url = "/note/dict?page=")
def GET(self, name=""): name = xutils.unquote(name) table = xtables.get_dict_table() item = table.select_first(where=dict(key=name)) value = "" if item != None: value = item.value return xtemplate.render("dict/dict_edit.html", name=name, value=value)
def POST(self, name=""): key = xutils.get_argument("name", "") value = xutils.get_argument("value", "") if key != "" and value != "": key = xutils.unquote(key) table = xtables.get_dict_table() item = table.select_first(where=dict(key=key)) if item != None: table.update(value=value, where=dict(key=key)) else: table.insert(key=key, value=value) return self.GET(name)
def POST(self): key = xutils.get_argument("key") value = xutils.get_argument("value") db = xtables.get_dict_table() item = db.select_first(where=dict(key=key)) current = xutils.format_datetime() if key == "" or key is None: return dict(code="fail", message="key is empty") if item is None: db.insert(key=key, value=value, ctime=current, mtime=current) else: db.update(value=value, mtime=current, where=dict(key=key)) return db.select_first(where=dict(key=key))
def GET(self): page = xutils.get_argument("page", 1, type=int) db = xtables.get_dict_table() items = db.select(order="id", limit=PAGE_SIZE, offset=(page-1)*PAGE_SIZE) items = map(convert_dict_func, items) count = db.count() page_max = math.ceil(count / PAGE_SIZE) return xtemplate.render("dict/dict_list.html", show_aside = True, files = list(items), file_type = "group", show_opts = False, page = page, page_max = page_max, pathlist = [Storage(name = "词典", url = "#")], show_pagination = True, page_url = "/note/dict?page=", **SEARCH_KEYWORDS)
def GET(self): key = xutils.get_argument("key") page = xutils.get_argument("page", 1, type=int) db = xtables.get_dict_table() where_sql = "key LIKE %s" % left_match_escape(key) items = db.select(order="key", where = where_sql, limit=PAGE_SIZE, offset=(page-1)*PAGE_SIZE) items = map(convert_dict_func, items) count = db.count(where = where_sql) page_max = math.ceil(count / PAGE_SIZE) return xtemplate.render("dict/dict_list.html", show_aside = True, files = list(items), file_type = "group", show_opts = False, page = page, page_max = page_max, pathlist = [Storage(name = "词典", url = "#")], show_pagination = True, page_url = "/dict/search?key=%s&page=" % encode_uri_component(key), **SEARCH_KEYWORDS)
def count_dict(user_name): import xtables return xtables.get_dict_table().count()