Skip to content

Commit 37bebea

Browse files
committed
first tests of orm [orm_tests]
1 parent 2f4f530 commit 37bebea

2 files changed

Lines changed: 45 additions & 0 deletions

File tree

‎conftest.py‎

Lines changed: 20 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,20 @@
1+
import pytest
2+
from sqlalchemy import create_engine
3+
from sqlalchemy.orm import sessionmaker, clear_mappers
4+
5+
from orm import metadata, start_mappers
6+
7+
8+
@pytest.fixture
9+
def in_memory_db():
10+
engine = create_engine('sqlite:///:memory:')
11+
metadata.create_all(engine)
12+
return engine
13+
14+
15+
@pytest.fixture
16+
def session(in_memory_db):
17+
start_mappers()
18+
yield sessionmaker(bind=in_memory_db)()
19+
clear_mappers()
20+

‎test_orm.py‎

Lines changed: 25 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,25 @@
1+
import model
2+
3+
def test_orderline_mapper_can_load_lines(session):
4+
session.execute(
5+
'INSERT INTO order_lines (orderid, sku, qty) VALUES '
6+
'("order1", "RED-CHAIR", 12),'
7+
'("order1", "RED-TABLE", 13),'
8+
'("order2", "BLUE-LIPSTICK", 14)'
9+
)
10+
expected = [
11+
model.OrderLine("order1", "RED-CHAIR", 12),
12+
model.OrderLine("order1", "RED-TABLE", 13),
13+
model.OrderLine("order2", "BLUE-LIPSTICK", 14),
14+
]
15+
assert session.query(model.OrderLine).all() == expected
16+
17+
18+
def test_orderline_mapper_can_save_lines(session):
19+
new_line = model.OrderLine("order1", "DECORATIVE-WIDGET", 12)
20+
session.add(new_line)
21+
session.commit()
22+
23+
rows = list(session.execute('SELECT orderid, sku, qty FROM "order_lines"'))
24+
assert rows == [("order1", "DECORATIVE-WIDGET", 12)]
25+

0 commit comments

Comments
 (0)