Hello there. (first post to group)
I've been having a problem with an incorrect rowcount for ResultProxies using Sqlite databases. Regardless of how many rows in the resultset, it gives me a rowcount of "-1". Best demonstrated with an example: from sqlalchemy import create_engine, __version__ from sqlalchemy.orm import create_session print "Testing sqlite rowcount with SqlAlchemy v%s" % __version__ engine = create_engine('sqlite:///:memory:') session = create_session(engine) session.execute("""CREATE TABLE IF NOT EXISTS users ( id INT(8) NOT NULL, status INT NOT NULL, name VARCHAR(100) NULL, PRIMARY KEY (id) );""") session.execute("INSERT INTO users (id, status, name) VALUES(1, 'Dan', 2)") session.execute("INSERT INTO users (id, status, name) VALUES(2, 'Dave', 1)") session.execute("INSERT INTO users (id, status, name) VALUES(3, 'Donald', 5)") result = session.execute("SELECT * FROM users") print result.rowcount allrows = result.fetchall() print len(allrows) session.close() Output is: Testing sqlite rowcount with SqlAlchemy v0.5.8 *-1* 3 Is this a bug? Am I doing something wrong? Regards, Adam -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.