ns = { 'id':params_kw['id'], } userorgid = await get_userorgid() if not userorgid: return { "widgettype":"Error", "options":{ "title":"Authorization Error", "timeout":3, "cwidth":16, "cheight":9, "message":"Please login" } } ns['resellerid'] = userorgid db = DBPools() dbname = get_module_dbname('supplychain') async with db.sqlorContext(dbname) as sor: # Cascade delete contract items first await sor.D('supply_contract_items', {'contract_id': params_kw['id'], 'resellerid': userorgid}) r = await sor.D('supply_contracts', ns) debug('delete success'); return { "widgettype":"Message", "options":{ "title":"Delete Success", "timeout":3, "cwidth":16, "cheight":9, "message":"ok" } } debug('Delete failed'); return { "widgettype":"Error", "options":{ "title":"Delete Error", "timeout":3, "cwidth":16, "cheight":9, "message":"failed" } }