def test_weibo():
# add
form = dict(
content='hello',
)
user_id = 1
Weibo.add(form, user_id)
# update
form = dict(
id=1,
content='well done',
user_id=1,
)
weibo_id = 1
Weibo.update(weibo_id, **form)
# comments
w = Weibo.one(id=1)
form = dict(
content='hello',
weibo_id=1,
)
c = Comment(form)
c.add(1)
form = dict(
content='hello233',
weibo_id=1,
)
c = Comment(form)
c.add(1)
cs = w.comments()
log('test comments cs', cs)
def add(request):
log('routes weibo add')
u = current_user(request)
form = request.form()
Weibo.add(form, u.id)
return redirect('/weibo/index')
def add(request):
"""
用于增加新 todo 的路由函数
"""
form = request.form()
u = current_user(request)
Weibo.add(u.id, form)
return redirect('/weibo')
def add(request):
"""
用于增加新 weibo 的路由函数
"""
u = current_user(request)
form = request.form()
Weibo.add(form, u.id)
return redirect('/weibo/index')
def add(request):
"""
新微博发送的数据在这里处理
"""
form = request.form()
uid = form.get('user_id', -1)
weibo = Weibo(form)
Weibo.add(weibo, uid)
return redirect(f'/weibo/index?user_id={str(uid)}')
def add():
"""
用于增加新 weibo 的路由函数
"""
u = current_user()
form: ImmutableMultiDict = request.form
Weibo.add(form.to_dict(), u.id)
# 浏览器发送数据过来被处理后, 重定向到首页
# 浏览器在请求新首页的时候, 就能看到新增的数据了
return redirect('/weibo/index')
def add(request):
"""
用于增加新 weibo 的路由函数
"""
u = current_user(request)
form = request.form()
Weibo.add(form, u.id)
# 浏览器发送数据过来被处理后, 重定向到首页
# 浏览器在请求新首页的时候, 就能看到新增的数据了
return redirect('/weibo/index')
def add():
form = request.get_json()
# 创建一个 weibo
u = current_user()
w = Weibo.add(form, u.id, u.username)
# 把创建好的 weibo 返回给浏览器
return jsonify(w.json())
def add(request):
# 得到浏览器发送的表单, 浏览器用 ajax 发送 json 格式的数据过来
# 所以这里我们用新增加的 json 函数来获取格式化后的 json 数据
form = request.json()
# 创建一个 Weibo
u = current_user(request)
t = Weibo.add(form, u.id)
# 把创建好的 Weibo 返回给浏览器
return json_response(t.json())
def add(request):
# 浏览器用 ajax 发送 json 格式的数据来到后端
# request.json() 解析 json 格式数据转字典
form = request.json()
# 创建一个 weibo
u = current_user(request)
t = Weibo.add(form, u.id)
# model.json() 对象数据转字典
return json_response(t.json())
def add(request):
# 得到浏览器发送的表单, 浏览器用 ajax 发送 json 格式的数据过来
form = request.json()
# 创建一个 weibo
u = current_user(request)
t = Weibo.add(form, u.id)
t.username = u.username
# 把创建好的 weibo 返回给浏览器
return json_response(t.json())
def add(request):
# 得到浏览器发送的表单, 浏览器用 ajax 发送 json 格式的数据过来
# 所以这里我们用新增加的 json 函数来获取格式化后的 json 数据
form = request.json()
u = current_user(request)
w = Weibo.add(form, u.id)
w = w.json()
# 用该函数拿到指定数据的字典
weibo = useful_weibos(w)
return json_response(weibo)
def weibo_add(request):
'''
拿到浏览器发送的数据
用数据创建一个新的 weibo 返回给浏览器
'''
# 得到浏览器发送的表单, 浏览器用 ajax 发送 json 格式的数据过来
# 所以用新增加的 dejson 函数来获取解析后的 json 数据
form = request.dejson()
# 创建一个 weibo ，并给 weibo 带上对应的用户名
u = current_user(request)
form['user_id'] = u.id
w = Weibo.add(form)
return json_response(w.to_dict())
def add(request):
# 得到浏览器发送的表单, 浏览器用 ajax 发送 json 格式的数据过来
# 所以这里我们用新增加的 json 函数来获取格式化后的 json 数据
form = request.json()
# 创建一个 weibo
u = current_user(request)
t = Weibo.add(form, u.id)
form = {
'weibo': t.json(),
'user': u.username
}
log('xnzidm1', form)
# 把创建好的 WEIBO 返回给浏览器
return json_response(form)
def test_data():
SQLModel.init_db()
form = dict(
username='******',
password='******',
role=UserRole.normal,
)
u, result = User.register(form)
form = dict(
content='test weibo',
comment='[]'
)
w = Weibo.add(form, u.id)
def add(request):
# 得到浏览器发送的表单, 浏览器用 ajax 发送 json 格式的数据过来
# 所以这里我们用新增加的 json 函数来获取格式化后的 json 数据
form = request.json()
# 创建一个 todo
user = current_user(request)
u = dict(
id=user.id,
username=user.username,
)
w = Weibo.add(form, user.id)
log('whats w in json', w.json())
weibo = [u, w.json()]
# 把创建好的 todo 返回给浏览器
return json_response(weibo)
def test_data():
SQLModel.init_db()
form = dict(
username='******',
password='******',
role=UserRole.normal,
)
u, result = User.register(form)
form = dict(content='test weibo', )
w = Weibo.add(form, u.id)
form = dict(
content='test comment',
weibo_id=w.id,
)
Weibo.comment_add(form, u.id)
def fake_data():
SQLModel.init_db()
Test.new({})
form = dict(
username='******',
password='******',
role=UserRole.normal,
)
u, result = User.register(form)
Session.add(u.id)
form = dict(title='test todo ajax', )
todo = Todo.add(form, u.id)
t = TodoAjax.add(form, u.id)
form = dict(content='test weibo', )
weibo = Weibo.add(form, u.id)
comment = Comment.add(form, u.id)
def test():
connection = pymysql.connect(host='localhost',
user='******',
password=database_password,
charset='utf8mb4',
cursorclass=pymysql.cursors.DictCursor)
with connection.cursor() as cursor:
cursor.execute('DROP DATABASE IF EXISTS `test_database`')
cursor.execute('CREATE DATABASE `test_database` CHARACTER SET utf8mb4')
cursor.execute('USE `test_database`')
cursor.execute(User.sql_create)
cursor.execute(Session.sql_create)
cursor.execute(Todo.sql_create)
cursor.execute(Comment.sql_create)
cursor.execute(Weibo.sql_create)
connection.commit()
connection.close()
form = dict(
username='******',
password='******',
)
User.register_user(form)
u, result = User.login_user(form)
assert u is not None, result
form = dict(
username='******',
password='******',
)
User.register_user(form)
session_id = random_string()
form = dict(
session_id=session_id,
user_id=u.id,
)
Session.new(form)
s: Session = Session.one(session_id=session_id)
assert s.session_id == session_id
form = dict(
title='test todo',
user_id=u.id,
)
t = Todo.add(form, u.id)
assert t.title == 'test todo'
form = dict(
content='111',
user_id=u.id,
)
w = Weibo.add(form, u.id)
assert w.content == '111'
form = dict(
content='2222',
user_id=u.id,
)
w2 = Weibo.add(form, u.id)
assert w2.content == '2222'
form = dict(
content='123333',
user_id=u.id,
weibo_id=w.id,
)
c = Comment.new(form)
assert c.content == '123333'
def add():
form = request.get_json()
u = current_user()
w = Weibo.add(form, u.id)
w.username = u.username
return jsonify(w.json())
def fake_data():
log('fake data')
SQLModel.init_db()
Test.new({})
form1 = dict(
username='******',
password='******',
role=UserRole.normal,
)
form2 = dict(
username='******',
password='******',
role=UserRole.normal,
)
u2, result = User.register(form1)
u1, result = User.register(form2)
Session.add(u1.id)
Session.add(u2.id)
form = dict(title='test todo ajax', )
t = TodoAjax.add(form, u1.id)
# weibo
form1 = dict(
content="weibo test user zjt",
user_id=u1.id,
)
form2 = dict(
content="weibo test user abc",
user_id=u2.id,
)
w1 = Weibo.add(form1, u1.id).id
w2 = Weibo.add(form2, u2.id).id
w1 = Weibo.add(form1, u2.id).id
w2 = Weibo.add(form2, u1.id).id
# comment
form1 = dict(
content="weibo test user zjt",
user_id=u1.id,
weibo_id=w1,
)
form2 = dict(
content="weibo test user abc",
user_id=u2.id,
weibo_id=w1,
)
# comment
form3 = dict(
content="weibo test user zjt",
user_id=u1.id,
weibo_id=w2,
)
form4 = dict(
content="weibo test user abc",
user_id=u2.id,
weibo_id=w2,
)
Comment.new(form1)
Comment.new(form2)
Comment.new(form3)
Comment.new(form4)
SQLModel.connection.close()
def add(request):
u = current_user(request)
form = request.form()
Weibo.add(form, u.id)
log('weibo add', u, form)
return redirect('/weibo/index')
def add(request):
u = current_user(request)
form = request.form()
Weibo.add(form, u.id)
# 处理好新的数据，重定向到首页，可以看到新增数据
return redirect('/weibo/index')
def add(request):
form = request.json()
u = current_user(request)
t = Weibo.add(form, u.id)
return json_response(t.json())
