Coverage for docs_src / tutorial / aggregate / tutorial000.py: 100%

1import os 6 ctx1abcdef

2from typing import Optional 6 ctx1abcdef

3 

4from mongodb_odm import ASCENDING, Document, IndexModel, apply_indexes, connect 6 ctx1abcdef

5 

6 

7class Player(Document): 6 ctx1abcdef

8 name: str 6 ctx1abcdef

9 country_code: str 6 ctx1abcdef

10 rating: Optional[int] = None 6 ctx1abcdef

11 

12 class ODMConfig(Document.ODMConfig): 6 ctx1abcdef

13 indexes = [ 6 ctx1abcdef

14 IndexModel([("rating", ASCENDING)]), 

15 ] 

16 

17 

18def configuration(): 6 ctx1abcdef

19 connect(os.environ.get("MONGO_URL", "mongodb://localhost:27017/testdb")) 6 ctx1abcdef

20 apply_indexes() 6 ctx1abcdef

21 

22 

23def create_players(): 6 ctx1abcdef

24 Player(name="Pelé", country_code="BRA", rating=98).create() 6 ctx1abcdef

25 Player(name="Diego Maradona", country_code="ARG", rating=97).create() 6 ctx1abcdef

26 Player(name="Zinedine Zidane", country_code="FRA", rating=94).create() 6 ctx1abcdef

27 Player(name="Ronaldo", country_code="BRA", rating=94).create() 6 ctx1abcdef

28 Player(name="Neymar", country_code="BRA", rating=89).create() 6 ctx1abcdef

29 Player(name="Lionel Messi", country_code="ARG", rating=91).create() 6 ctx1abcdef

30 Player(name="Ángel Di María", country_code="ARG", rating=84).create() 6 ctx1abcdef

31 Player(name="Karim Benzema", country_code="FRA", rating=89).create() 6 ctx1abcdef

32 Player(name="Antoine Griezmann", country_code="FRA", rating=85).create() 6 ctx1abcdef

33 Player(name="Kylian Mbappé", country_code="FRA", rating=91).create() 6 ctx1abcdef

34 Player(name="Gerd Müller", country_code="GER").create() 6 ctx1abcdef

35 Player(name="Miroslav Klose", country_code="GER", rating=91).create() 6 ctx1abcdef

36 Player(name="Thomas Müller", country_code="GER", rating=87).create() 6 ctx1abcdef

37 Player(name="Cristiano Ronaldo", country_code="POR", rating=87).create() 6 ctx1abcdef

38 Player(name="Eusébio", country_code="POR", rating=93).create() 6 ctx1abcdef

39 Player(name="Diogo Jota", country_code="POR", rating=85).create() 6 ctx1abcdef

40 Player(name="David Beckham", country_code="ENG", rating=89).create() 6 ctx1abcdef

41 Player(name="Wayne Rooney", country_code="ENG", rating=80).create() 6 ctx1abcdef

42 Player(name="Harry Kane", country_code="ENG", rating=89).create() 6 ctx1abcdef

43 

44 

45def number_of_player_by_country(): 6 ctx1abcdef

46 pipeline = [ 6 ctx1abcdef

47 {"$group": {"_id": "$country_code", "total_player": {"$sum": 1}}}, 

48 {"$sort": {"_id": 1}}, 

49 ] 

50 player_count = Player.aggregate(pipeline=pipeline) 6 ctx1abcdef

51 for obj in player_count: 6 ctx1abcdef

52 print(obj) 6 ctx1abcdef

53 print() 6 ctx1abcdef

54 

55 

56def main(): 6 ctx1abcdef

57 configuration() 6 ctx1abcdef

58 create_players() 6 ctx1abcdef

59 

60 number_of_player_by_country() 6 ctx1abcdef

61 

62 

63if __name__ == "__main__": 6 ctx1abcdef

64 main()