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()
