Coverage for tests/test_tutorial/test_insert/test_tutorial002_py310.py: 100%

1from sqlmodel import Session, create_engine, select 10 ctx1ijklmnopqr

2 

3from ...conftest import needs_py310 10 ctx1ijklmnopqr

4 

5 

6@needs_py310 10 ctx1ijklmnopqr

7def test_tutorial(clear_sqlmodel): 10 ctx1ijklmnopqr

8 from docs_src.tutorial.insert import tutorial002_py310 as mod 8 ctx1abcdefgh

9 

10 mod.sqlite_url = "sqlite://" 8 ctx1abcdefgh

11 mod.engine = create_engine(mod.sqlite_url) 8 ctx1abcdefgh

12 mod.main() 8 ctx1abcdefgh

13 with Session(mod.engine) as session: 8 ctx1abcdefgh

14 heroes = session.exec(select(mod.Hero)).all() 8 ctx1abcdefgh

15 heroes_by_name = {hero.name: hero for hero in heroes} 8 ctx1abcdefgh

16 deadpond = heroes_by_name["Deadpond"] 8 ctx1abcdefgh

17 spider_boy = heroes_by_name["Spider-Boy"] 8 ctx1abcdefgh

18 rusty_man = heroes_by_name["Rusty-Man"] 8 ctx1abcdefgh

19 assert deadpond.name == "Deadpond" 8 ctx1abcdefgh

20 assert deadpond.age is None 8 ctx1abcdefgh

21 assert deadpond.id is not None 8 ctx1abcdefgh

22 assert deadpond.secret_name == "Dive Wilson" 8 ctx1abcdefgh

23 assert spider_boy.name == "Spider-Boy" 8 ctx1abcdefgh

24 assert spider_boy.age is None 8 ctx1abcdefgh

25 assert spider_boy.id is not None 8 ctx1abcdefgh

26 assert spider_boy.secret_name == "Pedro Parqueador" 8 ctx1abcdefgh

27 assert rusty_man.name == "Rusty-Man" 8 ctx1abcdefgh

28 assert rusty_man.age == 48 8 ctx1abcdefgh

29 assert rusty_man.id is not None 8 ctx1abcdefgh

30 assert rusty_man.secret_name == "Tommy Sharp" 8 ctx1abcdefgh