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

10 votes257 views1 answer
Oracle dba_dependencies
SQL
11 votes267 views1 answer
Oracle insert into where
SQL
123 votes413 views5 answers
Sql where contains
SQL
1 vote248 views3 answers
Postgresql connect to database
SQL
-2 votes253 views1 answer
Use of where in left join in mysql
SQL
0 vote242 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote244 views1 answer
Postgres 11 add primary key
SQL
0 vote258 views1 answer
Guid string to binary better
SQL
0 vote257 views2 answers
Sql query in dax power bi
SQL
3 votes275 views1 answer
Postgres count distinct
SQL