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

1from sqlmodel import Session, create_engine, select 7 ctx1hijklmn

2 

3 

4def test_tutorial(clear_sqlmodel): 7 ctx1hijklmn

5 from docs_src.tutorial.insert import tutorial003 as mod 7 ctx1abcdefg

6 

7 mod.sqlite_url = "sqlite://" 7 ctx1abcdefg

8 mod.engine = create_engine(mod.sqlite_url) 7 ctx1abcdefg

9 mod.main() 7 ctx1abcdefg

10 with Session(mod.engine) as session: 7 ctx1abcdefg

11 heroes = session.exec(select(mod.Hero)).all() 7 ctx1abcdefg

12 heroes_by_name = {hero.name: hero for hero in heroes} 7 ctx1abcdefg

13 deadpond = heroes_by_name["Deadpond"] 7 ctx1abcdefg

14 spider_boy = heroes_by_name["Spider-Boy"] 7 ctx1abcdefg

15 rusty_man = heroes_by_name["Rusty-Man"] 7 ctx1abcdefg

16 assert deadpond.name == "Deadpond" 7 ctx1abcdefg

17 assert deadpond.age is None 7 ctx1abcdefg

18 assert deadpond.id is not None 7 ctx1abcdefg

19 assert deadpond.secret_name == "Dive Wilson" 7 ctx1abcdefg

20 assert spider_boy.name == "Spider-Boy" 7 ctx1abcdefg

21 assert spider_boy.age is None 7 ctx1abcdefg

22 assert spider_boy.id is not None 7 ctx1abcdefg

23 assert spider_boy.secret_name == "Pedro Parqueador" 7 ctx1abcdefg

24 assert rusty_man.name == "Rusty-Man" 7 ctx1abcdefg

25 assert rusty_man.age == 48 7 ctx1abcdefg

26 assert rusty_man.id is not None 7 ctx1abcdefg

27 assert rusty_man.secret_name == "Tommy Sharp" 7 ctx1abcdefg