def login():
name = request.form["name"]
session["user"] = name
session["regin"] = 1
quilltexts = db.get_quill_header_by_regin(1,name)
headers = []
for i in quilltexts:
headers.append({"header":i.header,
"id":i.id})
return json.dumps(headers)
def regin():
regin = request.form["regin"]
session["regin"] = regin
name = session.get("user",None)
if name:
quilltext = db.get_quill_header_by_regin(regin,name)
result = []
for i in quilltext:
result.append({"id":i.id,
"header":i.header})
return json.dumps(result)
else:
return "no user found", 401
def main():
regins = db.get_regins()
regin = session.get("regin",None)
if not regin:
session["regin"] = 1
regin = 1
else:
regin = int(regin)
values = []
for i in regins:
values.append({"title":i.title,
"id":i.id,
"selected":i.id == regin
})
user = session.get("user",None)
if not user:
quilltexts = []
else:
quilltexts=db.get_quill_header_by_regin(regin,user)
return render_template("index.html", quilltext=quilltexts,\
regins=values,user=user)
# -*- coding: cp936 -*-
import db
##values = {"header":"testpybbb","text":"pythonsdft",
## "html":"<div>python test result</div>",
## "user_id":"abc",
## "regin_id":1}
##quil = db.add_quill(values)
##print quil.id
##
for i in db.get_quill_header_by_regin(1, "test"):
print i.header, i.click_count
db.add_click_quill(1)
##print db.get_quill_by_id(1).text
##values = {"text":"change","html":"<div>chagne</div>"}
##db.update_quill(1,values)
##values = {"title":u"Éú»î"}
##regin = db.add_regin(values)
##print regin.id, regin.title
##for i in db.query_text(u"±ØÒª"):
## print i.id
## print "+++"
# -*- coding: cp936 -*-
import db
##values = {"header":"testpybbb","text":"pythonsdft",
## "html":"<div>python test result</div>",
## "user_id":"abc",
## "regin_id":1}
##quil = db.add_quill(values)
##print quil.id
##
for i in db.get_quill_header_by_regin(1,"test"):
print i.header, i.click_count
db.add_click_quill(1)
##print db.get_quill_by_id(1).text
##values = {"text":"change","html":"<div>chagne</div>"}
##db.update_quill(1,values)
##values = {"title":u"Éú»î"}
##regin = db.add_regin(values)
##print regin.id, regin.title
##for i in db.query_text(u"±ØÒª"):
## print i.id
## print "+++"
