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 vote395 views1 answer
Spark sql grows beyond 64 kb
SQL
0 vote350 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
1 vote366 views1 answer
Sql upsert
SQL
0 vote351 views1 answer
Sql server port 1434
SQL
0 vote368 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote356 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
0 vote353 views1 answer
Sql server isnull function nor working count
SQL
1 vote351 views1 answer
Check message id sql server
SQL
4 votes363 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
2 votes334 views1 answer
Convert series number to date in sql
SQL