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

1from sqlmodel import Session, create_engine, select 6 ctx1efghij

2 

3from ...conftest import needs_py310 6 ctx1efghij

4 

5 

6@needs_py310 6 ctx1efghij

7def test_tutorial(clear_sqlmodel): 6 ctx1efghij

8 from docs_src.tutorial.insert import tutorial003_py310 as mod 4 ctx1abcd

9 

10 mod.sqlite_url = "sqlite://" 4 ctx1abcd

11 mod.engine = create_engine(mod.sqlite_url) 4 ctx1abcd

12 mod.main() 4 ctx1abcd

13 with Session(mod.engine) as session: 4 ctx1abcd

14 heroes = session.exec(select(mod.Hero)).all() 4 ctx1abcd

15 heroes_by_name = {hero.name: hero for hero in heroes} 4 ctx1abcd

16 deadpond = heroes_by_name["Deadpond"] 4 ctx1abcd

17 spider_boy = heroes_by_name["Spider-Boy"] 4 ctx1abcd

18 rusty_man = heroes_by_name["Rusty-Man"] 4 ctx1abcd

19 assert deadpond.name == "Deadpond" 4 ctx1abcd

20 assert deadpond.age is None 4 ctx1abcd

21 assert deadpond.id is not None 4 ctx1abcd

22 assert deadpond.secret_name == "Dive Wilson" 4 ctx1abcd

23 assert spider_boy.name == "Spider-Boy" 4 ctx1abcd

24 assert spider_boy.age is None 4 ctx1abcd

25 assert spider_boy.id is not None 4 ctx1abcd

26 assert spider_boy.secret_name == "Pedro Parqueador" 4 ctx1abcd

27 assert rusty_man.name == "Rusty-Man" 4 ctx1abcd

28 assert rusty_man.age == 48 4 ctx1abcd

29 assert rusty_man.id is not None 4 ctx1abcd

30 assert rusty_man.secret_name == "Tommy Sharp" 4 ctx1abcd