1. sql 写不出来了 2. 如何将这个 sql 翻译成 sqlalchemy 语句...

SELECT *
FROM django_info.auth_user 
LEFT OUTER JOIN (
    fd_users_groups_m2m AS fd_users_groups_m2m_1 
    INNER JOIN fd_group AS fd_group_1 
    ON fd_group_1.id = fd_users_groups_m2m_1.fd_group_id
    where fd_group_1.fabric_name != 'default') 
ON django_info.auth_user.id = fd_users_groups_m2m_1.fd_user_id

user

default'

fd_group_1

fd_group

4 replies

chaleaochexist

Jan 14, 2019

```
SELECT "posts_user"."id", "posts_user"."name"
FROM "posts_user"
WHERE NOT (
"posts_user"."id" IN (
SELECT U1."user_id" AS Col1
FROM "posts_user_group" U1
INNER JOIN "posts_group" U2
ON (U1."group_id" = U2."id")
WHERE U2."title" = 1)
)
```

chaleaochexist

Jan 14, 2019

但是如何翻译成 sqlalchemy...

Hanayok

Jan 14, 2019

如果你的 m2m 字段写在 auth 表的话就这样
django_info.auth_user.objects.exclude(fd_group__fabric_name='default').all()

xuanbg

Jan 15, 2019

select u.*
from django_info.auth_user u
join fd_users_groups_m2m r on r.user_id = i.id
join fd_group g on g.id = r.group_id
and g. fabric_name = 'default';