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

8 votes170 views2 answers
Change name of colum in sql table
SQL
0 vote149 views3 answers
Create and attach user to a postgresql database
SQL
0 vote147 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
0 vote158 views1 answer
Enable sql server full text indexing
SQL
1 vote172 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote139 views1 answer
Import local sql into remote mysql
SQL
0 vote137 views1 answer
Sql server inner join convert collation
SQL
5 votes141 views1 answer
Mysql select greater than yesterday
SQL
25 votes239 views6 answers
Change column name mysql
SQL
1 vote148 views1 answer
Mariadb case switch
SQL