[sqlalchemy] How can I keep SQLAlchemy DB connection alive for always?

I a create a session with these following lines; Base = declarative_base() engine = create_engine( 'mysql://sentio_reader:therea...@sentiodb.cloudapp.net/sentio') #engine = create_engine('mysql://erogol:ern88GOL!@sentioerogol.cloudapp.net/sentio_data') # engine.echo = True metadata =

[sqlalchemy] How can copy tables with only the data inside and without the foreign keys, constraints and relations, from a DB to another DB?

I try to do basic ETL job with SQLalchemy but it always enforces relations between tables. I only like to copy the tables with the raw data inside without the considration of table relations. How can I drop all those relations from the DB metadata and copy the tables. In addition I also need

Re: [sqlalchemy] How can copy tables with only the data inside and without the foreign keys, constraints and relations, from a DB to another DB?

: (IntegrityError) (1452, 'Cannot add or update a child row: a foreign key constraint fails (`s... On Friday, 10 October 2014 17:44:24 UTC+3, Michael Bayer wrote: On Oct 10, 2014, at 10:30 AM, Eren Gölge eren...@gmail.com javascript: wrote: I try to do basic ETL job with SQLalchemy