Re: [sqlalchemy] Bulk Operations with Joined Table Inheritance

2017-01-25 Thread Robert Sami
On Wed, Jan 25, 2017 at 7:02 AM, mike bayer wrote: > > > On 01/24/2017 07:40 PM, Robert Sami wrote: > >> Thanks for the response Mike, >> >> I agree that using Core is pretty clean. One approach I considered was >> the following: >> >> ``` >> res = conn.execute(FooBase.__table__.insert(returning=

Re: [sqlalchemy] Validators not called for unhashable items when replacing the collection

2017-01-25 Thread Pedro Werneck
Yes, I noticed the collection.decorator would imply doing the same validation in two different places. That will have to work for now, but I'll keep an eye on the issue for 1.2. Thanks Mike. On Wed, Jan 25, 2017 at 1:36 PM, mike bayer wrote: > > > On 01/24/2017 09:55 PM, Pedro Werneck wrote: >>

Re: [sqlalchemy] Proposal to discontinue pymssql in favor of pyodbc

2017-01-25 Thread Jonathan Vanasco
On Wednesday, January 25, 2017 at 11:01:41 AM UTC-5, Randy Syring wrote: > > >- pymssql has struggled to find maintainers who can devote time to it >and it is starting to languish. > > Have you tried speaking with the "new" Microsoft? Perhaps they'd be willing to contribute funds or en

Re: [sqlalchemy] Proposal to discontinue pymssql in favor of pyodbc

2017-01-25 Thread Randy Syring
Mike, While I have not done work recently committing to the project, I am one of the maintainers. I'm an owner of the pymssql Github organization, pay for the pymssql.org domain, and try to generally keep up with things as time permits. Regarding being an "active" project, that is debatable

Re: [sqlalchemy] Proposal to discontinue pymssql in favor of pyodbc

2017-01-25 Thread mike bayer
I don't see how it's appropriate to even suggest that an open source project close its doors simply because another project exists.If you were the maintainer of pymssql, that would be one thing, but looking at the commits it seems to continue to be an active project. pymssql handles our te

Re: [sqlalchemy] Validators not called for unhashable items when replacing the collection

2017-01-25 Thread mike bayer
On 01/24/2017 09:55 PM, Pedro Werneck wrote: I have a relationship with a validator to automatically convert dicts appended to the collection, so I can do something like this: my_obj.my_collection.append({"rel_type_id": x}) Instead of this: my_obj.my_collection.append(RelType(rel_type_id=x)

[sqlalchemy] Proposal to discontinue pymssql in favor of pyodbc

2017-01-25 Thread Randy Syring
There is a proposal open to discontinue pymssql development and point people towards pyodbc. Since pymssql is a documented backend for SA, I figured there might be some people here who are interested. If you have any skin in that game and want to comment, please visit the issue: https://github

Re: [sqlalchemy] Bulk Operations with Joined Table Inheritance

2017-01-25 Thread mike bayer
On 01/24/2017 07:40 PM, Robert Sami wrote: Thanks for the response Mike, I agree that using Core is pretty clean. One approach I considered was the following: ``` res = conn.execute(FooBase.__table__.insert(returning=[FooBase.id], values=[{} for i in range(10)])) conn.execute(FooDerived._