FilesExpand file tree

 master

/

mongodb.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

86 lines (74 loc) · 2.28 KB

 master

/

mongodb.py

Copy path

Top

File metadata and controls

• Code
• Blame

86 lines (74 loc) · 2.28 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

from pymongo import MongoClient

from pprint import pprint

# connect to the MongoDB server

client = MongoClient()

# or explicitly

# client = MongoClient("localhost", 27017)

# list all database names

print("Available databases:", client.list_database_names())

# access the database "python", this will create the actual database

# if it doesn't exist

database = client["python"]

# or this:

# database = client.python

# list all collections

print("Available collections:", database.list_collection_names())

# get books collection (or create one)

books = database["books"]

# insert a single book

result = books.insert_one({

"name": "Invent Your Own Computer Games with Python, 4E",

"author": "Al Sweigart",

"price": 17.99,

"url": "https://amzn.to/2zxN2W2"

})

print("One book inserted:", result.inserted_id)

# insert many books

books_data = [

{

"name": "Automate the Boring Stuff with Python: Practical Programming for Total Beginners",

"author": "Al Sweigart",

"price": 17.76,

"url": "https://amzn.to/2YAncdY"

},

{

"name": "Python Crash Course: A Hands-On, Project-Based Introduction to Programming",

"author": "Eric Matthes",

"price": 22.97,

"url": "https://amzn.to/2yQfQZl"

},

{

"name": "MySQL for Python",

"author": "Albert Lukaszewski",

"price": 49.99,

}

]

result = books.insert_many(books_data)

print("Many books inserted, Ids:", result.inserted_ids)

# get a single book by a specific author

eric_book = books.find_one({"author": "Eric Matthes"})

pprint(eric_book)

# get all books by a specific author

sweigart_books = books.find({"author": "Al Sweigart"})

print("Al Sweigart's books:")

pprint(list(sweigart_books))

# get all documents in books collection

all_books = books.find({})

print("All books:")

pprint(list(all_books))

# delete a specific document by a JSON query

result = books.delete_one({"author": "Albert Lukaszewski"})

# delete all books by Al Sweigart

result = books.delete_many({"author": "Al Sweigart"})

# printing all documents

all_books = books.find({})

print("All books:")

pprint(list(all_books))

# drop this collection

database.drop_collection("books")

# or this:

# books.drop()

# drop this entire database

client.drop_database("python")

# close the connection

client.close()