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

2 votes163 views2 answers
Laravel query builder toSql
SQL
6 votes157 views1 answer
Oracle rank() over (partition)
SQL
0 vote160 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote171 views1 answer
Sql server isnull function nor working count
SQL
-1 vote169 views1 answer
How to switch user in mysql
SQL
0 vote176 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
5 votes164 views1 answer
Sql use database
SQL
20 votes157 views1 answer
Sql change column types
SQL
0 vote172 views1 answer
Oracle create table auto generated primary key
SQL
0 vote173 views1 answer
H2 auto increment and unique
SQL