Sorry guye, false alarm:
According to http://pyodbc.sourceforge.net/docs.html#cursor
pyodbc does not support rowcount.
On 30 Apr., 11:11, "Tobias Bender" <[EMAIL PROTECTED]> wrote:
> Hi Christoph,
>
> > > items = meta.metadata.tables.get(table).select().order_by(column)
>
> > I'm no SQLAlchemy guru. But with SQLAlchemy 0.4.* that should just be:
>
> > items = sqlalchemy.select([yourtable])
>
> This is a generic aproach to display/browse data in tables, which are
> *not* defined in my model. Instead I reflect the tables of a existing
> database and ask dynamically for the tablenames. This is the complete
> code:
>
> def table(self, table=None):
> if not table:
> c.tables = meta.metadata.table_iterator()
> return render('/databrowse/tables.html')
> current_page = request.GET.get('current_page', 0)
> c.table=table
> column = request.GET.get('column')
> c.columns = meta.metadata.tables.get(table).c
> print "old ",
> meta.Session.execute(meta.metadata.tables.get(table).select()).rowcount
> print "new ", meta.Session.execute(select([model.t_ml])).rowcount
> items = meta.metadata.tables.get(table).select().order_by(column)
> c.page = paginate.Page(items, sqlalchemy_session=meta.Session,
> current_page=current_page)
> return render('/databrowse/table.html')
>
> > What do you get if you run
>
> > meta.Session.execute(sqlalchemy.select([yourtable])).rowcount
>
> print "old ",
> meta.Session.execute(meta.metadata.tables.get(mytable).select()).rowcount
> print "new ", meta.Session.execute(select([model.mytable])).rowcount
>
> returns
> old -1
> new -1
>
> If I find the time, I will try to reproduce this with a small setup.
> By the way, I use mssql-engine with pyodbc. Perhhaps this is a bug in
> sqlalchemy (ms-sql/pyodbc)?
> Tobias
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
