def login(self):
ret_dict = {'ret': 0, 'data': '', 'user': ''}
account = self.info['account']
password = self.info['password']
if not account or not password:
ret_dict['ret'] = 1
return ret_dict
secret_pwd = md5Str(password)
try:
user_info_obj = session.query(UserInfo).filter(
UserInfo.name == account, UserInfo.password == secret_pwd,
UserInfo.is_delete == 0).one()
print(user_info_obj)
except Exception as e:
print(e)
ret_dict['ret'] = 2
return ret_dict
result = self.request.set_secure_cookie("user",
account,
expires_days=10)
if result:
print("post登录成功,设置的cookie: %s" %
self.request.get_secure_cookie("user"))
else:
print("post登录成功,设置cookie失败")
ret_dict['user'] = account
return ret_dict
def test_query_root_menu(self):
# 查看所有的一级菜单
m = session.query(Menu).filter_by(parent_id=None).all()
for ml in m:
print(ml.title)
for ms in ml.childs:
print("---",ms)
def test_query_root_menu(self):
# 查看所有的一级菜单
ms = session.query(Menu).filter(Menu.parent_id.is_(None)).all()
for m in ms:
print(m.title)
for mc in m.childs:
print('|---', mc.title)
def post(self):
username = self.get_argument('username')
password = self.get_argument('passwd')
# password = my_md5(password)
#
# if not re.match('^\w{6,20}$', username):
# self.write("用户名不合法")
# return
# if not re.match('^\w{6,20}$', password):
# self.write("密码不合法")
# return
# 判断用户是否存在
users = session.query(User).filter_by(username=username,
password=password)
if users.count() > 0:
self.write("用户已注册")
return
# 添加用户
user = User()
user.username = username
user.password = password
try:
session.add(user)
session.commit()
except:
session.rollback()
session.flush()
self.write('注册失败')
else:
self.redirect(self.reverse_url('login'))
def test_get(self):
# 查询-session.query(模型类)
m = session.query(Menu).get(1)
print(m.title)
print('--查看是所有的子菜单---')
for cm in m.childs:
print(cm)
def get(self):
id = self.get_query_argument('id', '1')
blog_list = session.query(Blogs.id, Blogs.title, Blogs.content, Blogs.time, Category.name)\
.join(Category, Category.id == Blogs.id).all()
blog_con = session.query(Blogs.id, Blogs.title, Blogs.content, Blogs.time, Category.name)\
.join(Category, Category.id == Blogs.id)\
.filter(Blogs.id == id).first()
data = {
'blog_navs': self.blog_navs,
'blogs': blog_list,
'navs': self.navs,
'index': False,
'blog_con': blog_con
}
self.render('blog_list.html', **data)
def render(self, *args, **kwargs):
date = {}
for m in session.query(Menu).filter(Menu.parent_id.is_(None)).all():
date[m] = []
for n in m.childs:
date[m].append(n)
data = {'menu': date}
return self.render_string('ui/menu.html', **data)
def render(self):
# 准备数据（从缓存，从数据库）
data = {
'menus':
session.query(Menu).filter(Menu.parent_id.is_(None)).all()
}
# 渲染ui模块的模板
return self.render_string('ui/menu.html', **data)
def test_query_root_menu(self):
# 查看所有的一级菜单
ms = session.query(Menu).filter(Menu.parent_id.is_(None)).all()
for menu in ms:
print(menu)
# 查看二级菜单
for secondary in menu.childs:
print('-'*3, secondary)
def on_close(self):
username = self.get_cookie('username')
users = session.query(User).filter_by(username=username)
users.first().islogin = False
session.commit()
print('close')
self.clear_cookie('username')
# self.write("您已退出聊天...")
self.online_users.remove(self)
def get(self):
navs = session.query(Menu).filter(Menu.parent_id == '').all()
data = {
'msg': 'hi, Template',
'error_msg': None,
'navs': navs,
'index': True
}
for nav in navs:
print(nav.title)
self.render('base.html', **data)
def post(self):
username = self.get_argument('username')
password = self.get_argument('passwd')
users = session.query(User).filter_by(username=username,
password=password)
if users.count() == 0:
self.write('账号不存在...')
return
users.first().islogin = False
session.commit()
self.redirect(self.reverse_url('index'))
def get(self, *args, **kwargs):
# data = {
# "msg":"hi,disen",
# "error_msg":"error",
# 'age':20,
# 'menus':['主页','新闻','音乐','视频'],
# 'code':'<h3>hi,我是图片：8 > 5</h3>',
#
# }
data = {
"onetap":session.query(Menu).filter(Menu.parent_id.is_(None)).all()
}
# self.set_header(name='X-Content-Type-Options',value='nosniff')
self.render('user_curd.html',**data)
def post(self):
username = self.get_argument('username')
password = self.get_argument('passwd')
# password = my_md5(password)
users = session.query(User).filter_by(username=username,
password=password)
if users.count() == 0:
self.write('请先注册再登录...')
return
if users.first().islogin == True:
self.write('%s已经登录...' % username)
return
users.first().islogin = True
session.commit()
self.set_cookie('username', username)
self.redirect(self.reverse_url('chat'))
def post(self, *args, **kwargs):
face = self.get_argument('face')
username = self.get_argument('username')
if not (face and username):
self.render('register.html', error='注册信息请填写完整')
user = session.query(User).filter(User.username == username).first()
if user:
self.render('register.html', error='该账号已被使用')
img = face.split(',')[-1]
if not register_face_user(img, username):
self.render('register.html', error='注册失败')
user = User()
user.username = username
session.add(user)
session.commit()
file = base64.b64decode(img)
img_dir = os.path.join(IMAGE_DIR, username + '.jpg')
with open(img_dir, 'wb') as f:
f.write(file)
self.write('注册成功')
def post(self, *args, **kwargs):
face = self.get_argument('face')
username = self.get_argument('username')
if not (face and username):
self.render('login.html', error='请填写完整信息')
return
user = session.query(User).filter(User.username == username).first()
if not user:
self.render('login.html', error='用户没有注册')
return
img = face.split(',')[-1]
file = os.path.join(IMAGE_DIR, username + '.jpg')
file_exists = os.path.exists(file)
if not file_exists:
self.render('login.html', error='该账号没有注册')
return
score = match_face(img, file)
if score < 80:
self.render('login.html', error='匹配不成功')
return
self.set_cookie('username', username)
self.write('登录成功,人脸匹配度为：{0:.2f}%'.format(score))
def test_update(self):
m1 = session.query(Menu).get(1)
m1.title = '商品管理'
session.commit()
def get(self):
stus = session.query(Student).filter(
Student.s_name == 'xiaomi_0').all()
print(stus)
self.write('查询成功')
def get(self):
# stu = Student.query.filter(Student.s_name=='小明')
stus = session.query(Student).filter(Student.s_name == '小明').all()
stus = session.query(Student).filter_by(s_name='小明_0').all()
print(stus)
self.write('查询数据成功')
def test_update(self):
menu = session.query(Menu).get(5)
# menu.title = '合作伙伴'
menu.parent_id = 1
session.commit()
def test_remove(self):
menu = session.query(Menu).get(5)
session.delete(menu)
def test_query_root_menu(self):
ms = session.query(Menu).filter(Menu.parent_id.is_(None)).all()
for m in ms:
print(m.title)
def test_query_root_menu(self):
ms = session.query(Menu).filter(Menu.parent_id.is_(None)).all()
for menu in ms:
print(menu)
for childs in menu.childs:
print("-" * 3, childs)
def test_get(self):
m = session.query(Menu).get(1)
print(m.title)
print(m.children)
def render(self, template_name, **kwargs):
data = {
'menu': session.query(Menu).filter(Menu.parent_id.is_(None)).all()
}
return self.render_string('menu/index.html', **data)
def test_move(self):
mn = session.query(Menu).get(5)
session.delete(mn)
session.commit()
def test_delete(self):
m1 = session.query(Menu).get(1)
session.delete(m1)
session.commit()
def initialize(self):
# 左侧导航栏
self.navs = session.query(Menu).filter(Menu.parent_id == '').all()
# 管理员导航栏
self.admin_navs = session.query(Menu).filter(Menu.parent_id == 1)
def render(self, *args, **kwargs):
data = {
'menus': session.query(Menu).filter(Menu.parent_id.is_(None)).all(),
'menus_li': session.query(Menu).filter_by(parent_id=1).all()
}
return self.render_string('/', **data)
def render(self):
data = {
'menus': session.query(Menu).filter(Menu.parent_id.is_(None)).all()
}
return self.render_string('ui/menu.html',**data)
