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 vote203 views4 answers
Restart mysql server ubuntu
SQL
1 vote199 views1 answer
Oracle schema size
SQL
1 vote183 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote194 views1 answer
Mysql check if lowercase
SQL
1 vote185 views1 answer
Check constraint to check if date greater than todays date
SQL
12 votes222 views6 answers
Distinct in sql server
SQL
0 vote185 views1 answer
Sql select most frequent value in group
SQL
0 vote204 views1 answer
Prodection ready postgres database step by step
SQL
21 votes190 views6 answers
Docker run mysql
SQL
2 votes196 views3 answers
Write sql query to find the second highest salary of employee
SQL