Re: Using alembic with two projects, one with foreign keys referencing the other

On 09/29/2016 07:52 PM, Wesley Weber wrote: I have an uncommon use case that might or might not be supported (or even a good idea): I have a main, independent project with its own tables. I would like to keep track of migrations of its database. I will also have several "plugin" projects,

Re: [sqlalchemy] twopahse for pyodbc dialect

On 09/29/2016 03:50 AM, Andrea Cassioli wrote: Hi, I am working with SQLAlchemy to insert data in a MSSQL database. Typically we need to make regular insert of say half million rows in few tables. Right now I am using Core flavour to make batch insertion via pyodbc and I have notice that in

Re: [sqlalchemy] on_conflict_do_update (ON CONFLICT ... Postgresql 9.5) WHERE clause problem

I just pushed that and it should close the bitbucket issue. On 09/29/2016 03:07 AM, pszynk wrote: I see you already looked into it. Thanks! W dniu środa, 28 września 2016 20:55:05 UTC+2 użytkownik Mike Bayer napisał: this is likely use cases that have been untested, if you can file this

Re: [sqlalchemy] Session / declarative_base scope

On 09/29/2016 01:38 AM, Warwick Prince wrote: Hi Mike I would like a little insight into the session object, and the declarative_base class. I have a process running many threads, where each thread may be connected to potentially a different engine/database. If the database connection

Re: [sqlalchemy] Feedback appreciated

On 09/28/2016 06:48 PM, Seth P wrote: On Wednesday, September 28, 2016 at 5:43:04 PM UTC-4, Mike Bayer wrote: looks incredibly difficult. I'm not really about to have the resources to work with a type that awkward anytime soon, unfortunately. If it could be made to be a

[sqlalchemy] twopahse for pyodbc dialect

Hi, I am working with SQLAlchemy to insert data in a MSSQL database. Typically we need to make regular insert of say half million rows in few tables. Right now I am using Core flavour to make batch insertion via pyodbc and I have notice that in the DB trace I have an entry per row declare @p1

Re: [sqlalchemy] How can I programmatically give a hybrid_property its name?

On Thu, Sep 29, 2016 at 6:32 AM, Jinghui Niu wrote: > The documentation shows that hybrid_property should used as a decorator, > like: > @hybrid_property > def my_property(self): > pass > > > What if I wanted to give this hybrid property a name by referring a variable >

Re: [sqlalchemy] on_conflict_do_update (ON CONFLICT ... Postgresql 9.5) WHERE clause problem

I see you already looked into it. Thanks! W dniu środa, 28 września 2016 20:55:05 UTC+2 użytkownik Mike Bayer napisał: > > this is likely use cases that have been untested, if you can file this > w/ a complete test case as a bug report on bitbucket we can start > looking into it. > > > On

[sqlalchemy] Re: SQLAlchemy - Bulk update using sqlalchemy core table.update() expects all columns in the values data

Mike, Thanx for your reply. I'll try out the 3rd option. It would still be better than updating record by record at object level. Thanx, Rajesh On Wednesday, September 28, 2016 at 1:59:38 PM UTC+5:30, Rajesh Rolo wrote: > > I'm trying to do a bulk update using core SQLAlchemy to a postgres >