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 vote353 views1 answer
Mysql search like order by best match
SQL
1 vote330 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote315 views1 answer
Mysql money value
SQL
0 vote318 views1 answer
Many rows to 1 string mysql
SQL
0 vote336 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote327 views1 answer
Oracle sql procedure return value
SQL
0 vote343 views3 answers
Database restoring error
SQL
14 votes341 views3 answers
Alter foreign key
SQL
14 votes346 views3 answers
Delete all records from table except sql
SQL
0 vote358 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL