1# 获取对应学生成绩单
2GET /students?instance={instance_name}&table={table_name}&name={name}
3
4# 上传/修改学生成绩单
5POST/PUT /students
6{
7    "instance": "<实例名称>",
8    "table": "<数据表名称>",
9    "name": "<学生姓名>",
10    "cells": {
11        "chinese": "<语文成绩>",
12        "math": "<数学成绩>",
13        "english": "<英语成绩>",
14        "physics": "<物理成绩>",
15        "chemistry": "<化学成绩>",
16        "biology": "<生物成绩>"
17    }
18}
19
20# 删除学生信息
21DELETE /students?instance={instance_name}&table={table_name}&name={name}

1@app.route('/students', method='GET')
2def get_row():
3    """
4    @param: request: bottle request
5    @return: http return
6
7    本方法用于从 TableStorage 中获取数据
8    """
9    instance = bytes(request.query.instance, encoding='utf8')
10    table = bytes(request.query.table, encoding='utf8')
11    name = bytes(request.query.name, encoding='utf8')
12
13    bts = init_bts_client()
14    query_row_arg = QueryRowArgs()
15    query_row_arg.rowkey = name
16    try:
17        res = bts.get_row(instance, table, query_row_arg)
18        if res is None:
19            return HTTPResponse(body={'error': 'resource not found'}, status_code=404)
20        return HTTPResponse(body={'body': str(res.result[0])}, status_code=200)
21    except Exception as exception:
22        return HTTPResponse(body={'error': str(exception)}, status_code=400)
23
24
25@app.route('/students', method=['POST', 'PUT'])
26def put_row():
27    """
28    @param: bottle request
29    @return: http response
30
31    本方法用于将输入数据存储于 TableStorage 中
32    """
33    bts = init_bts_client()
34    body = request.json
35    instance = bytes(body['instance'], encoding='utf8')
36    table = bytes(body['table'], encoding='utf8')
37    name = bytes(body['name'], encoding='utf8')
38    cells_data = body['cells']
39    cells = []
40    for key, value in cells_data.items():
41        cells.append(Cell(key, value).__dict__)
42
43    row = Row()
44    row.rowkey = name
45    row.cells = cells
46    try:
47        bts.put_row(instance, table, row)
48        return HTTPResponse(status_code=200)
49    except Exception as exception:
50        return HTTPResponse(status_code=400, body={'error': str(exception)})
51
52
53@app.route('/students', method='DELETE')
54def delete_row():
55    """
56    @param: bottle request
57    @return: http response
58
59    本方法用于从百度云 TableStorage 中删除对应数据
60    """
61    bts = init_bts_client()
62    instance = bytes(request.query.instance, encoding='utf8')
63    table = bytes(request.query.table, encoding='utf8')
64    name = bytes(request.query.name, encoding='utf8')
65    query_row_args = QueryRowArgs()
66    query_row_args.rowkey = name
67
68    try:
69        bts.delete_row(instance, table, query_row_args)
70        return HTTPResponse(status_code=204)
71    except Exception as exception:
72        return HTTPResponse(status_code=400, body={'error': str(exception)})

1curl --location --request POST 'https://<HTTP 触发器域名>/students' \
2--header 'Content-Type: application/json' \
3--data-raw '{
4    "instance": "<实例名称>",
5    "table": "<数据表名称>",
6    "name": "<学生姓名>",
7    "cells": {
8        "chemistry": "<化学成绩>",
9        "chinese": "<语文成绩>",
10        "math": "<数学成绩>",
11        "english": "<英语成绩>",
12        "physics": "<物理成绩>",
13        "biology": "<生物成绩>"
14    }
15}'

1curl --location --request GET 'https://<HTTP 触发器域名>/students?instance=<实例名称>&table=<数据表名称>&name=<学生姓名>' \
2--header 'Content-Type: application/json'

1curl --location --request DELETE 'https://<HTTP 触发器域名>/students?instance=<实例名称>&table=<数据表名称>&name=<学生姓名>' \
2--header 'Content-Type: application/json'