def post(self):
# 注册功能
# 获取数据
face = self.get_argument('face_img')
print(face)
img = face.split(',')[-1]
username = self.get_argument('username')
realname = self.get_argument('realname')
if face and username and realname:
# 注册（用户模型）
user = User()
user.username = username
user.realname = realname
session.add(user)
session.commit()
# 调用百度人脸注册接口
res = face_register(img, user.id)
if res:
# 注册成功，跳转到登录
self.redirect('/login/')
else:
# 注册失败,则跳转到注册页面
session.delete(user)
session.commit()
self.redirect('/register/')
else:
error = '请填写完整的参数'
self.render('register.html', error=error)
def test_adds(self):
session.add_all([
Menu(title='orderManage'),
Menu(title='vipManage', url='/user1', parent_id=1),
Menu(title='friend', url='/user2', parent_id=1)
])
session.commit()
def test_update(self):
menu = session.query(Menu).get(5)
# menu.title = '合作伙伴'
menu.parent_id = 1
# session.add(menu)
session.commit()
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 put(self):
id = self.get_argument('id')
res = session.query(Admin).filter(Admin.id == id).first()
res.purview = 0
res.deleted = 0
session.commit()
session.close()
def delete(self):
# stus2 = session.query(Student).filter(Student.s_name == 'qf_2').first()
# if stus2:
# session.delete(stus2)
# session.commit()
session.query(Student).filter(Student.s_name == 'qf_0').delete()
session.commit()
self.write("删除数据成功")
def test_adds(self):
session.add_all([
Menu(title='订单管理'),
Menu(title='会员管理', url='/user', parent_id=1),
Menu(title='派件员', url='/user2', parent_id=1),
Menu(title='合作商', url='/user3', parent_id=1),
Menu(title='订单统计', url='/order_cnt', parent_id=2),
])
session.commit()
def post(self):
stu_list = list()
for i in range(10):
stu = Student()
stu.s_name = 'xiaomi_%s' % i
stu_list.append(stu)
session.add_all(stu_list)
session.commit()
self.write('新增多条数据成功')
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 delete(self):
# 实现删除,第一种方式，session.delete()
stu = session.query(Student).filter_by(s_name='小明_1').first()
if stu:
session.delete(stu)
session.commit()
# 第二种，调用delete()方法
session.query(Student).filter(Student.s_name == '小明_2').delete()
session.commit()
self.write('删除数据成功')
def patch(self):
# stus2 = session.query(Student).filter(Student.s_name == 'qf_1').first()
# if stus2:
# stus2.s_name = 'kangbazi'
# session.add(stus2)
# session.commit()
session.query(Student).filter(Student.s_name == 'qf_5').update(
{'s_name': '88888'})
session.commit()
self.write("更新数据成功")
def test_add(self):
# m1 = Menu(title='用户管理')
# session.add(m1)
session.add_all([
Menu(title='订单管理'),
Menu(title='会员管理', url='/user1', parent_id=1),
Menu(title='派件员', url='/user2', parent_id=1),
Menu(title='合作商', url='/user3', parent_id=1),
Menu(title='订单统计', url='/order_cnt', parent_id=2)
])
session.commit()
def delete(self):
# 删除方式一：session.delete()
stu = session.query(Student).filter(
Student.s_name == 'xiaomi_9').first()
if stu:
session.delete(stu)
session.commit()
# 删除方式二：delete()方法
session.query(Student).filter(Student.s_name == 'xiaomi_8').delete()
session.commit()
self.write('删除成功')
def patch(self):
# 实现修改部分的属性
# 第一种方式：
# stu = session.query(Student).filter_by(s_name='小明_3').first()
# stu.s_name = '小花'
# session.add(stu)
# session.commit()
# 第二种凡是：update()
session.query(Student).filter(Student.s_name == '小花').update({'s_name': '小华'})
session.commit()
self.write('修改数据成功')
def post(self, *args, **kwargs):
# 获取数据
face = self.get_argument('face')
username = self.get_argument('username')
# 人脸注册
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()
self.write('注册成功')
def post(self):
# stu = Student(s_name="扛把子",s_age=18)
# session.add(stu)
# session.commit()
stus = []
for i in range(100):
stu = Student()
stu.s_name = 'qf_%s' % i
stu.s_age = i
stus.append(stu)
session.add_all(stus)
session.commit()
self.write("新增数据成功")
def patch(self):
# 修改方式一：
# stu = session.query(Student).filter(Student.s_name == 'xiaomi_1').first()
# stu.s_name = 'huawei'
# session.add(stu)
# session.commit()
# 修改方式二：update()
session.query(Student).filter(Student.s_name == 'xiaomi_2').update(
{'s_name': 'zhongxin'})
session.commit()
self.write('修改成功')
def post(self):
login_id = self.get_argument('login_id')
pwd = self.get_argument('pwd')
name = self.get_argument('name')
admin = Admin()
admin.name = name
admin.login_id = login_id
admin.password = hashlib.md5(pwd.encode('utf-8')).hexdigest()
admin.purview = 0
admin.deleted = 0
session.add(admin)
session.commit()
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 test_add(self):
m1 = Menu()
m1.title = '艹'
m1.name = ''
session.add(m1)
if session.commit():
print('success')
def post(self):
# 创建单条数据
# stu = Student()
# stu.s_name = '小明'
# session.add(stu)
# session.commit()
# 创建多条数据
stus = []
for i in range(10):
stu = Student()
stu.s_name = '小明_%s' % i
stus.append(stu)
session.add_all(stus)
session.commit()
self.write('新增数据成功')
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):
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 test_update(self):
m1 = session.query(Menu).get(1)
m1.title = '商品管理'
session.commit()
def post(self):
stu = Student()
stu.s_name = '小米'
session.add(stu)
session.commit()
self.write('添加数据成功')
def test_add(self):
m1 = Menu()
m1.title = '用户管理'
session.add(m1)
session.commit()
def test_update(self):
mn = session.query(Menu).get(5)
# mn.title = '合作伙伴'
mn.parent_id = 1
session.commit()
def test_remove(self):
menu = session.query(Menu).get(5)
session.delete(menu)
session.commit()
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()
