如何在sqlalchemy orm中编写以下查询的表达式?你知道吗
DELETE FROM ACCESS_STRING_DETAILS WHERE MENU_ID IN(SELECT MENU_ID FROM REDIRECTOR WHERE SERVICE=122)
DELETE FROM TIME_DETAILS WHERE MENU_ID IN(SELECT MENU_ID FROM REDIRECTOR WHERE SERVICE=122)
DELETE FROM REDIRECTOR_INPUT_PARAMS WHERE COMMAND_ID IN(SELECT KEYWORD FROM REDIRECTOR WHERE SERVICE=122)
DELETE FROM REDIRECTOR_COMMANDS WHERE COMMAND_ID IN(SELECT KEYWORD FROM REDIRECTOR WHERE SERVICE=122)
DELETE FROM RANGE_DETAILS WHERE COMMAND_ID IN(SELECT KEYWORD FROM REDIRECTOR WHERE SERVICE=122)
DELETE FROM CLIENT_RSP_DETAILS WHERE KEYWORD IN(SELECT KEYWORD FROM REDIRECTOR WHERE SERVICE=122)
DELETE FROM REDIRECTOR WHERE SERVICE=122
我基本上需要的是从表中删除所有与MENU_ID
和KEYWORD
匹配的记录,这些记录针对REDIRECTOR
表中的特定SERVICE
您可以首先分别捕获
SERVICE=122
上的过滤器;我假设您有与表名匹配的所有表的模型,使用camelcase。你知道吗菜单id和关键字选择也被存储以供重用:
现在,您可以将这些选择应用于所有删除查询:
这些示例使用^{} method 和select语句,将后者转换为subselect,以生成如下查询:
将
:service_1
参数设置为122
。你知道吗相关问题 更多 >
编程相关推荐