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
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
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
> 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
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