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

3 votes134 views1 answer
Postgres select max value
SQL
9 votes134 views1 answer
Oracle get table schema
SQL
4 votes124 views2 answers
Insert current date in mysql
SQL
0 vote127 views1 answer
Wp_query raw sql
SQL
0 vote186 views1 answer
Show mysql account privilleges
SQL
1 vote153 views1 answer
Postgresql pass array in function
SQL
1 vote131 views1 answer
Mariadb get column names from table
SQL
0 vote118 views1 answer
Update if else mysql
SQL
0 vote129 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote303 views1 answer
Power bi connect to postgresql
SQL