Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # 第1题 简单实现django内置装饰器require_POST(不是POST方法的请求,提前返回一个错误提示JSON)
- @require_POST
- def fake_func(request):
- pass
- # 第2题 有一个多重嵌套字典,检查value值,如果value=1,提取key
- {"a'": 1, "b": { "c": 1, "d": {"e": 1}, "a": 1}}
- ["a", "c", "e"]
- # 第3题 表名为fake_table1
- # +---------------------+-----------+-------+
- # | log_time | log_user | value |
- # | 2018-01-02 12:23:11 | 123456 | 1 |
- # .......................................
- # +---------------------+-----------+-------+
- 表名为fake_table2
- # +---------------------+-----------+-------+
- # | log_time | log_user | value |
- # | 2018-01-02 12:23:11 | 123456 | 1 |
- # .......................................
- # +---------------------+-----------+-------+
- # 3.1 sql语句查询fake_table1,以 log_time日期 为分组,统计log_user去重数量,由低至高排序显示前3条
- # 3.2 sql语句修改fake_table1,将log_user在100到200区间的记录,把它们的value改为2
- # 3.3 sql语句查找log_user交集,fake_table1的value值大于100,fake_table2的value值小于100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement