Files
TJWaterServer/api/s40_schema.py
2025-03-28 20:39:59 +08:00

31 lines
1.2 KiB
Python

from .database import *
from .s0_base import *
def get_scheme_schema(name: str) -> dict[str, dict[Any, Any]]:
return { 'id' : {'type': 'str' , 'optional': False , 'readonly': True },
'name' : {'type': 'str' , 'optional': False , 'readonly': False},
'type' : {'type': 'str' , 'optional': False , 'readonly': False},
"create_time": {'type': 'str' , 'optional': False , 'readonly': True },
"start_time" : {'type': 'str' , 'optional': False , 'readonly': True },
"detail" : {'type': 'str' , 'optional': False , 'readonly': True } }
def get_scheme(name: str, schema_name: str) -> dict[Any, Any]:
t = try_read(name, f"select * from scheme_list where scheme_name = '{schema_name}'")
if t == None:
return {}
d = {}
d['id'] = str(t['scheme_id'])
d['name'] = str(t['scheme_name'])
d['type'] = str(t['scheme_type'])
d['create_time'] = str(t['create_time'])
d['start_time'] = str(t['start_time'])
d['detail'] = str(t['detail'])
return d
def get_all_schemes(name: str) -> list[dict[Any, Any]]:
return read_all(name, "select * from scheme_list")