Re: [sqlalchemy] Bulk upsert using on_conflict_do_update

2016-12-02 Thread mike bayer
On 12/02/2016 02:37 PM, Katie Wurman wrote: What's the proper syntax for doing a bulk upsert using the new on_conflict_do_update clause? In postgres there is apparently a special table called 'excluded' which contains all the rows to be inserted, so the raw query looks like this: INSERT into M

[sqlalchemy] Bulk upsert using on_conflict_do_update

2016-12-02 Thread Katie Wurman
What's the proper syntax for doing a bulk upsert using the new on_conflict_do_update clause? In postgres there is apparently a special table called 'excluded' which contains all the rows to be inserted, so the raw query looks like this: INSERT into MYTABLE(col1,col2,col3) VALUES (a,b,c),(d,e,f

Re: [sqlalchemy] Set query timeout

2016-12-02 Thread mike bayer
query timeouts are a database / driver dependent feature.It depends on what kind of database you're using and you'd need to check the documentation for that database on how that would be done. On 12/02/2016 02:32 AM, Антонио Антуан wrote: Hi Is there any ways to set timeout for particular