def post(self, post_id, comment_id):
# checks if user is logged in
if user_logged_in(self):
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
key = db.Key.from_path('Comment',
int(comment_id),
parent=comment_key())
comment = db.get(key)
if not comment:
return self.error(404)
# checks if the user owns the comment
if user_owns_comment(self, comment):
content = self.request.get('content')
if content:
comment.content = content
comment.put()
time.sleep(0.1)
self.redirect('/blog/%s/comment' % str(post_id))
else:
error = "Some content is required!"
self.render("editComment.html",
content=content,
error=error)
else:
return self.redirect('/')
async def add_handler(request):
# http://localhost:8000/add?name=dynamic_hello&code=xxx&web_path=xxx
name = get_req_key(request, "name")
code = get_req_key(request, "code")
web_path = get_req_key(request, "web_path")
logging.debug("add_handler name:{} code:{} web_path:{}".format(
name, code, web_path))
err = _check_code(name, code, web_path)
if err != "":
ret = {"err": models.errors.code_is_incorrect, "err_msg": err}
return json(ret)
db = models.db.FileDB()
tp = db.get(name)
if tp:
if tp.type == "system":
return system_error_ret("{} is a system func".format(tp.name))
else:
tp = models.db.FuncItem()
tp.name = name
tp.file_path = ""
tp.type = "user"
tp.web_path = web_path
tp.last_update = utils.time.now_str()
tp.code = code
db.set(name, tp)
ret = {
"err": 0,
}
return json(ret)
def get(cls, id):
tw = db.get(id)
if tw:
tweet_json = json.loads(tw)
else:
tweet_json = {}
return cls.load_json(tweet_json)
def authNewUser(id):
"""管理员通过信用户申请"""
sql = "select * from tempuser where id='%s';" % (clean(id))
user = db.get(sql)
name = user['name']
pwd = user['pwd']
type = user['type']
email = user['email']
if type == 't':
sql = "insert into Teacher (idTeacher,name,pwd,email) values ('%s','%s','%s','%s');" \
% (clean(id), name, pwd, email)
db.execute(sql)
sql = "delete from tempuser where id='%s';" % (clean(id))
db.execute(sql)
return 'success'
elif type == 's':
sql = "insert into Student (idStudent,name,pwd,email) values ('%s','%s','%s','%s');" \
% (clean(id), name, pwd, email)
db.execute(sql)
sql = "delete from tempuser where id='%s';" % (clean(id))
db.execute(sql)
return 'success'
else:
return 'fail'
def authNewUser(id):
"""管理员通过信用户申请"""
sql = "select * from tempuser where id='%s';" % (clean(id))
user = db.get(sql)
name = user['name']
pwd = user['pwd']
type = user['type']
email = user['email']
if type == 't':
sql = "insert into Teacher (idTeacher,name,pwd,email) values ('%s','%s','%s','%s');" \
% (clean(id), name, pwd, email)
db.execute(sql)
sql = "delete from tempuser where id='%s';" % (clean(id))
db.execute(sql)
return 'success'
elif type == 's':
sql = "insert into Student (idStudent,name,pwd,email) values ('%s','%s','%s','%s');" \
% (clean(id), name, pwd, email)
db.execute(sql)
sql = "delete from tempuser where id='%s';" % (clean(id))
db.execute(sql)
return 'success'
else:
return 'fail'
def post(self, post_id):
# checks if user is logged in
if not user_logged_in(self):
return self.redirect('/')
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
# checks if the user owns the post
if not user_owns_post(self, post):
return self.redirect('/')
title = self.request.get('title')
content = self.request.get('content')
if title and content:
post.title = title
post.content = content
post.put()
self.redirect('/blog')
else:
error = "Both subject and content are required!"
self.render("newPostPage.html",
title=title,
content=content,
error=error)
def simple_sort():
json_data = []
for key in db.scan_iter():
json_data += [Tweet.load_json(json.loads(db.get(key))).__dict__]
return heapq.nlargest(10,
json_data,
key=lambda data: data['count_retweet'])
def get_info_by_infoid_all(Iid):
"""使用信息id号查找消息 02"""
sql='''
select I.idInfo,I.title,I.date,I.type,T.name,I.tid,I.detail
from Teacher as T,Info as I
where T.idTeacher=I.tid and I.idInfo = %s
''' % clean(Iid)
return db.get(sql)
def get(self, post_id, comment_id):
if user_logged_in(self):
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
key = db.Key.from_path('Comment',
int(comment_id),
parent=comment_key())
comment = db.get(key)
if not comment:
return self.error(404)
# checks if the user owns the comment
if user_owns_comment(self, comment):
params = dict(content=post.content, user=self.user)
self.render('editComment.html', **params)
else:
return self.redirect('/')
def get(self, post_id, comment_id):
if user_logged_in(self):
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
key = db.Key.from_path('Comment',
int(comment_id),
parent=comment_key())
comment = db.get(key)
if not comment:
return self.error(404)
if user_owns_comment(self, comment):
comment.delete()
time.sleep(0.1)
self.redirect('/blog/%s/comment' % str(post_id))
else:
self.redirect('/')
def get(self, post_id):
if user_logged_in(self):
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
if user_owns_post(self, post):
post.delete()
self.redirect('/blog')
else:
self.redirect('/')
def get(self, post_id):
if not user_logged_in(self):
return self.redirect('/')
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
if user_owns_post(self, post):
params = dict(title=post.title,
content=post.content,
user=self.user)
self.render('editPostPage.html', **params)
else:
return self.redirect('/')
def get(self, post_id):
if user_logged_in(self):
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
comments = db.GqlQuery(
"SELECT * FROM Comment WHERE parent_post = :post ORDER BY created DESC",
post=post)
self.render('postComments.html',
post=post,
comments=comments,
user=self.user)
else:
return self.redirect('/')
def post(self, post_id):
if user_logged_in(self):
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
# Only posts non-owners can comment
if not user_owns_post(self, post):
content = self.request.get('content')
comment = Comment(parent=comment_key(),
content=content,
author=self.user,
parent_post=post)
comment.put()
time.sleep(0.1)
self.redirect('/blog/%s/comment' % str(post_id))
else:
return self.redirect('/blog')
def get(self, post_id):
if user_logged_in(self):
key = db.Key.from_path('Post', int(post_id), parent=post_key())
post = db.get(key)
if not post:
return self.error(404)
if not user_owns_post(self, post):
self.redirect('/')
if post.liked(self.user):
l = db.GqlQuery(
"SELECT * FROM Like WHERE author=:user AND parent_post=:post",
user=self.user,
post=post).get()
l.delete()
self.redirect('/blog')
else:
l = Like(author=self.user, parent_post=post)
l.put()
self.redirect('/blog')
else:
return self.redirect('/')
def getTeacher(uid):
"""获取某位教师信息"""
sql = "select * from Teacher where idTeacher='%s'" % (clean(uid))
return db.get(sql)
def teaLogin(uid, pwd):
"""教师登陆"""
# return db.Teacher.find_one({}, {'user': clean(uid), 'password': clean(pwd)})
sql = 'select * from Teacher where idTeacher="%s" and pwd="%s"' % (
clean(uid), clean(pwd))
return db.get(sql)
def get_homework(hid):
"""根据作业id，获取某次作业"""
sql = "select * from Homework where idHomework='%s';" % (clean(hid))
return db.get(sql)
def get_homework(hid):
"""根据作业id，获取某次作业"""
sql = "select * from Homework where idHomework='%s';" % (clean(hid))
return db.get(sql)
def get_info(idInfo):
"""按照infoId获取info内容"""
sql = "select * from Info where idInfo = '%s';" % (clean(idInfo))
return db.get(sql)
def getStudent(uid):
"""获取某位学生信息"""
sql = 'select * from Student where idStudent = "%s"' % (clean(uid))
return db.get(sql)
def get_info(idInfo):
"""按照infoId获取info内容"""
sql = "select * from Info where idInfo = '%s';" % (clean(idInfo))
return db.get(sql)
def getTeacher(uid):
"""获取某位教师信息"""
sql = "select * from Teacher where idTeacher='%s'" % (clean(uid))
return db.get(sql)
def get_student_course(uid):
"""获取学生参加的课程"""
sql = 'select * from Course where idCourse in (select cid from Student where idStudent="%s");' % (clean(uid))
return db.get(sql)
def stuLogin(uid, pwd):
"""学生登陆"""
# return db.Student.find_one({}, {'user': clean(uid), 'password': clean(pwd)})
sql = 'select * from Student where idStudent="%s" and pwd="%s"' % (clean(uid), clean(pwd))
return db.get(sql)
def getStudent(uid):
"""获取某位学生信息"""
sql = 'select * from Student where idStudent = "%s"' % (clean(uid))
return db.get(sql)
def teaLogin(uid, pwd):
"""教师登陆"""
# return db.Teacher.find_one({}, {'user': clean(uid), 'password': clean(pwd)})
sql = 'select * from Teacher where idTeacher="%s" and pwd="%s"' % (clean(uid), clean(pwd))
return db.get(sql)
def getATempUser(uid):
"""获取某一位临时用户"""
sql = 'select * from tempuser where id="%s"' % (clean(uid))
return db.get(sql)
def get_info_by_infoid(Iid):
"""使用信息id号查找消息"""
sql = "select * from Info where idInfo='%s';" % (clean(Iid))
return db.get(sql)
def stuLogin(uid, pwd):
"""学生登陆"""
# return db.Student.find_one({}, {'user': clean(uid), 'password': clean(pwd)})
sql = 'select * from Student where idStudent="%s" and pwd="%s"' % (
clean(uid), clean(pwd))
return db.get(sql)
def getATempUser(uid):
"""获取某一位临时用户"""
sql = 'select * from tempuser where id="%s"' % (clean(uid))
return db.get(sql)
def get_course(cid):
"""获取某个课序号的所有信息"""
sql = "select * from Course where idCourse='%s';" % (clean(cid))
return db.get(sql)
def get_info_by_infoid(Iid):
"""使用信息id号查找消息"""
sql = "select * from Info where idInfo='%s';" % (clean(Iid))
return db.get(sql)
