sqlalchemy raw sql query limit using connection.execute()

Question

This python code should run statements on the database, but the sql statements are not executed:

from sqlalchemy import *
sql_file = open("test.sql","r")
sql_query = sql_file.read()
sql_file.close()
engine = create_engine(
    'postgresql+psycopg2://user:password@localhost/test', echo=False)

conn = engine.connect()
print sql_query
result = conn.execute(sql_query)
conn.close()

The test.sql file contains SQL statements which create 89 tables.

The tables are not created if I specify 89 tables, but if I reduce the number of tables to 2 to it works.

Is there a limit on the number of queries that can be executed within the conn.execute? How do a run any number of raw queries like this?

Seems like you are not committing your create table.

user330315
– user330315

2012-06-27 10:20:00 +00:00
Commented Jun 27, 2012 at 10:20 — user330315
– user330315, Commented Jun 27, 2012 at 10:20

Antonio Beamud · Accepted Answer · 2012-06-27 09:30:32Z

8

Perhaps, forcing the autocommit:

conn.execute(RAW_SQL).execution_options(autocommit=True))

Other approach is using transactions and doing the commit:

t = conn.begin()
try:
    conn.execute(RAW_SQL)
    t.commit()
except:
    t.rollback()

PD: You can put the execution_options in the create_engine parameters too.

answered Jun 27, 2012 at 9:30

Antonio Beamud

2,3511 gold badge16 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sqlalchemy raw sql query limit using connection.execute()

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related