Re: [sqlalchemy] Generic File Loader issue with Booleans

2020-10-28 Thread Mike Bayer
OK please include: database backend, version database driver (DBAPI) in use, version use of special libraries, int() called on 0 or 1 suggests these are not Python integers, please specify any numpy or pandas use and read https://docs.sqlalchemy.org/en/13/faq/thirdparty.html python version

Re: [sqlalchemy] Generic File Loader issue with Booleans

2020-10-28 Thread Andrew Martin
I will reproduce this when I get done with work this evening and give the specifics. On Wednesday, October 28, 2020 at 7:46:26 AM UTC-5, Mike Bayer wrote: > > > > On Tue, Oct 27, 2020, at 11:56 PM, Andrew Martin wrote: > > This is probably a weirdly specific question, but I have a workflow that

Re: [sqlalchemy] Generic File Loader issue with Booleans

2020-10-28 Thread Mike Bayer
On Tue, Oct 27, 2020, at 11:56 PM, Andrew Martin wrote: > This is probably a weirdly specific question, but I have a workflow that > involves loading lots of CSVs into Postgres. Some of them are very large, so > I want to cut overhead and not use CSV Dictreader. Wanted to use named tuples >

[sqlalchemy] Generic File Loader issue with Booleans

2020-10-27 Thread Andrew Martin
This is probably a weirdly specific question, but I have a workflow that involves loading lots of CSVs into Postgres. Some of them are very large, so I want to cut overhead and not use CSV Dictreader. Wanted to use named tuples instead. Here's a header and a line from a file: