cpcc/wwwroot/handy/get_cpcnodes.dspy
2025-07-16 14:32:09 +08:00

13 lines
316 B
Plaintext

debug(f'{params_kw=}')
db = DBPools()
dbname = get_module_dbname('cpcc')
ns = {
"cpcid":params_kw.cpcid
}
async with db.sqlorContext(dbname) as sor:
sql = "select * from cpcnode where cpcid=${cpcid}$ and node_status = '0'"
recs = await sor.sqlExe(sql, ns.copy())
return recs
exception(f'{sql=},{ns=}')
return []