Skip to content

Commit 75e8314

Browse files
committed
start on orm
1 parent 7c4e23e commit 75e8314

2 files changed

Lines changed: 46 additions & 0 deletions

File tree

‎orm.py‎

Lines changed: 19 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,19 @@
1+
from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey
2+
from sqlalchemy.orm import mapper, relationship
3+
4+
metadata = MetaData()
5+
6+
7+
order = Table(
8+
'order', metadata,
9+
Column('id', Integer, primary_key=True, autoincrement=True),
10+
)
11+
12+
order_lines = Table(
13+
'order_lines', metadata,
14+
Column('order_id', ForeignKey('order.id'), primary_key=True),
15+
Column('sku', String(255), primary_key=True),
16+
Column('quantity', Integer),
17+
# order=relationship(order, back_populates="lines")
18+
)
19+

‎test_orm.py‎

Lines changed: 27 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,27 @@
1+
import pytest
2+
from sqlalchemy import create_engine
3+
from sqlalchemy.orm import sessionmaker
4+
5+
from orm import metadata
6+
7+
8+
@pytest.fixture
9+
def db():
10+
engine = create_engine('sqlite:///:memory:', echo=True)
11+
metadata.create_all(engine)
12+
return engine
13+
14+
@pytest.fixture
15+
def session(db):
16+
return sessionmaker(bind=db)()
17+
18+
def test_smoke(session):
19+
session.execute('INSERT INTO "order" VALUES (1)')
20+
session.execute('INSERT INTO "order_lines" VALUES (1, "sku1", 12)')
21+
session.execute('INSERT INTO "order_lines" VALUES (1, "sku2", 13)')
22+
r = session.execute('SELECT * from "order" JOIN "order_lines"')
23+
assert list(r) == [
24+
(1, 1, "sku1", 12),
25+
(1, 1, "sku2", 13),
26+
]
27+

0 commit comments

Comments
 (0)