[sqlalchemy] Alembic 0.7.2 Released

2014-12-18 Thread Michael Bayer
Hey lists - Alembic 0.7.2 is released. This is a small bugfix release to catch some issues in the batch support, foreign key support, and new versioning system that are local to the SQLite, MySQL, and Oracle/MSSQL backends, respectively. Changelog is at http://alembic.readthedocs.org/en/late

[sqlalchemy] Re: aggregate data by date-window over multiple import files

2014-12-18 Thread Jonathan Vanasco
On Thursday, December 18, 2014 12:42:03 PM UTC-5, dewey wrote: > > Per file?? Even if it's a really large file?? Is the only limit on > transaction size available client memory or are their constraints on the > server side as well? > Usually, yes. If you fail partway through the file, you

[sqlalchemy] Re: aggregate data by date-window over multiple import files

2014-12-18 Thread dewey
Per file?? Even if it's a really large file?? Is the only limit on transaction size available client memory or are their constraints on the server side as well? Also, I think my example was over-simplified. There are many different types of attributes I need to accumulate and I'm having

Re: [sqlalchemy] double select in a raw sql?

2014-12-18 Thread Michael Bayer
> On Dec 17, 2014, at 10:32 PM, jichao liu wrote: > > hello, > in a scenario i want query two table at once : > > q = article_engine.execute('select * from table1;select * from table2') > for i in q: > print i.Name > > how can i get data from the second table? multiple statements

[sqlalchemy] Re: aggregate data by date-window over multiple import files

2014-12-18 Thread Jonathan Vanasco
Based on your specs, I think it would be simplest to store the rows in the DB then just run reports on them. You'd have a solution in minutes. You should be doing a transaction per Excel file, not per row. You could probably create a function or view that generates the record you want. -- Y