Sqlalchemy existing database

Sqlalchemy existing db file

from sqlalchemy.ext.automap import automap_base
from sqlalchemy.orm import Session
from sqlalchemy import create_engine

Base = automap_base()

# engine, suppose it has two tables 'user' and 'address' set up
engine = create_engine("sqlite:///mydatabase.db")

# reflect the tables
Base.prepare(engine, reflect=True)

# mapped classes are now created with names by default
# matching that of the table name.
User = Base.classes.user
Address = Base.classes.address

session = Session(engine)

# rudimentary relationships are produced
session.add(Address(email_address="foo@bar.com", user=User(name="foo")))
session.commit()

# collection-based relationships are by default named
# "<classname>_collection"
print (u1.address_collection)

Source: stackoverflow.com

Similar codes

1 vote341 views1 answer
Sysdate in sql
SQL
0 vote328 views1 answer
Procedures sql insert mysql
SQL
0 vote322 views1 answer
Difference between varchar and varchar2
SQL
0 vote378 views1 answer
Mysql relationships between tables
SQL
1 vote355 views1 answer
Create new table from old table with data
SQL
0 vote339 views1 answer
Create tables from xsd to sql server database c#
SQL
4 votes376 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote340 views1 answer
Sql get number of days between two dates
SQL
0 vote326 views1 answer
Dns slave zone convert
SQL
10 votes358 views6 answers
Sql between
SQL