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

0 vote169 views1 answer
Sql not exists
SQL
1 vote256 views1 answer
SQL server query column yes or no
SQL
0 vote181 views1 answer
Convert polygon to text in mysql
SQL
4 votes156 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote157 views1 answer
Sql server select rows by distinct column
SQL
0 vote169 views1 answer
Sqlite higher or equal
SQL
0 vote136 views1 answer
Mysql date + 1 day
SQL
1 vote168 views2 answers
Group_concat limit mysql
SQL
5 votes183 views1 answer
Mysql where one year ago
SQL
0 vote166 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL