sqlalchemy 如何 执行 insert into if not exists?

[wuwukai007]

这种 sql，怎么用 sqlalchemy 写？

INSERT INTO table_listnames (name, address, tele)
SELECT * FROM (SELECT 'Rupert', 'Somewhere', '022') AS tmp
WHERE NOT EXISTS (
    SELECT name FROM table_listnames WHERE name = 'Rupert'
) LIMIT 1;

[RockShake]

https://docs.sqlalchemy.org/en/14/tutorial/data_insert.html#insert-from-select
https://docs.sqlalchemy.org/en/14/tutorial/data_select.html

这两个应该能完美解决你的问题

[knightdf]

.prefix_with('IGNORE')应该也可以解决

[wuwukai007]

@RockShake 谢谢
@knightdf 这个会导致自动 ID 不对