10 lines
486 B
Plaintext
10 lines
486 B
Plaintext
result = [{'value': '', 'text': '全部'}]
|
|
try:
|
|
async with get_sor_context(request._run_ns, 'pipeline') as sor:
|
|
rows = await sor.sqlExe("select k as value, v as text from appcodes_kv where parentid=${parentid}$ order by v", {'parentid': 'sd_env_status'})
|
|
result = [{'value': '', 'text': '全部'}] + list(rows)
|
|
return json.dumps(result, ensure_ascii=False)
|
|
except Exception as e:
|
|
debug(f'search error: {e}')
|
|
return json.dumps(result, ensure_ascii=False)
|