后端BUG

1. 无法添加新设备 （2020.7.9）：已解决

sqlalchemy.exc.ProgrammingError: (psycopg2.ProgrammingError) permission denied for sequence lab_id_seq
报这个错误的原因是对自增序列没有给对应角色授权，但是对表授予了该角色操作权限导致。
解决办法
GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO database_user;
即对所有的序列授予给角色database_user权限。

2. 修改土壤水分参数报错 （2020.7.9): 数组id解决，单个数据id可能因为脏数据问题暂时无法解决也无法测试

不知是否因为脏数据, id数据为空，是否为数据库问题未知

[{'eid': 'HZG04DZN23', 'station_name': '土壤水分测试站2', 'e_code': '0102', 'longitude': Decimal('115.000000'), 'latitude': Decimal('37.000000'), 'creator': None, 'message_push': True, 'address': '河南省郑州市郑东新区博学路36号', 'create_time': 1592377200, 'station_id': None, 'sub_device': [], 'extend_data': {'column': ['0201', '0202'], 'id': [2, 4], 'data': [['71.648', '43.523'], ['71.648', '43.523'], ['71.648', '43.523'], ['71.648', '43.523'], ['71.648', '43.523'], ['71.648', '43.523'], ['71.648', '43.523'], ['71.648', '43.523']]}}]

b'{"extend_data":[["71.648","43.523"],["71.648","43.523"],["71.648","43.523"],["71.648","43.523"],["71.648","43.523"],["71.648","43.523"],["71.648","43.523"],["71.648","43.523"],["12","12"]],"id":[],"single":[{"id":"","value":"1"},{"id":"","value":""}]}'

Internal Server Error: /manage_parameter
Traceback (most recent call last):
File "/usr/local/python37/lib/python3.7/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/usr/local/python37/lib/python3.7/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/usr/local/python37/lib/python3.7/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "./weatherSys/views.py", line 304, in manage_parameter
d = json_transfer(request.body)
File "./weatherSys/views.py", line 357, in json_transfer
data = chinese_transfer(data)
File "./weatherSys/views.py", line 373, in chinese_transfer
y = parse.unquote(y)
File "/usr/local/python37/lib/python3.7/urllib/parse.py", line 627, in unquote
string.split
AttributeError: 'list' object has no attribute 'split'
[pid: 21123|app: 0|req: 60/585] 117.158.216.252 () {46 vars in 812 bytes} [Thu Jul 9 09:38:29 2020] POST /manage_parameter => generated 72994 bytes in 35 msecs (HTTP/1.1 500) 6 headers in 196 bytes (1 switches on core 0)

12. 修改用户设备关联报错:   

cursor already closed

无法复现Bug

13.修改关联后设备页面无法获取数据：

manage_connection()某个操作之后cursor close

cursor already closed  

15. equip_all_info, x[2] = '0208': print(x)

0208,0209数据库内无数据

17.实时数据null无法解析：已解决

替换null为 -- 

18.新建账号后关联项目：

cursor already closed

新建用户，项目内关联用户