python Programming Glossary: engine.execute

Why is SQLAlchemy insert with sqlite 25 times slower than using sqlite3 directly?

http://stackoverflow.com/questions/11769366/why-is-sqlalchemy-insert-with-sqlite-25-times-slower-than-using-sqlite3-directly

test_sqlalchemy_core n 100000 init_sqlalchemy t0 time.time engine.execute Customer.__table__.insert name 'NAME ' str i for i in range..

Sqlite / SQLAlchemy: how to enforce Foreign Keys?

http://stackoverflow.com/questions/2614984/sqlite-sqlalchemy-how-to-enforce-foreign-keys

engine sqlalchemy.create_engine 'sqlite memory ' echo True engine.execute 'pragma foreign_keys on' ...but it is not working ...What am..

Efficiently updating database using SQLAlchemy ORM

http://stackoverflow.com/questions/270879/efficiently-updating-database-using-sqlalchemy-orm

True upd table.update values table.c.foo table.c.foo 1 engine.execute upd This is slightly slower but there's not much in it. Here's..

creating a temporary table from a query using sqlalchemy orm

http://stackoverflow.com/questions/9593610/creating-a-temporary-table-from-a-query-using-sqlalchemy-orm

Integer primary_key True Column 'number' Integer t.create engine.execute t.insert .values id 1 number 3 engine.execute t.insert .values.. t.create engine.execute t.insert .values id 1 number 3 engine.execute t.insert .values id 9 number 3 # create temp table temp cloneTable.. data ins InsertFromSelect temp t.select .where t.c.id 5 engine.execute ins # print result for r in engine.execute temp.select print..

How to create an SQL View with SQLAlchemy?

http://stackoverflow.com/questions/9766940/how-to-create-an-sql-view-with-sqlalchemy

createview CreateView 'viewname' t.select .where t.c.id 5 engine.execute createview v Table 'viewname' metadata autoload True for r in.. v Table 'viewname' metadata autoload True for r in engine.execute v.select print r Here is a working example from sqlalchemy import.. Integer primary_key True Column 'number' Integer t.create engine.execute t.insert .values id 1 number 3 engine.execute t.insert .values..