Example of using Pymongo to access MongoDB Atlas databases and collections using Pydantic models.
- Warning: as of August 1, 2024, dependency package Cryptography issues a warning message if you install a version greater than or equal to 43. See the requirements.txt file for more information.
| Tool | Version |
|---|---|
| Python | 3.13.5 |
| cryptography | 45.0.5 |
| Loguru | 0.7.3 |
| MongoDB Atlas | 8.0.11 |
| Pydantic | 2.11.7 |
| Pymongo | 4.13.2 |
| python-dot-env | 1.1.1 |
| VSCode | 1.101.2 |
| PyCharm | 2025.1.3.1 |
| Date | Description |
|---|---|
| 2024-05-20 | Initial creation |
| 2024-07-30 | verify execution against latest version of software tools |
| 2024-08-01 | add requirements.txt file and warning about cryptography package level restriction |
| 2024-09-17 | Verify program works with python 3.12.6 and other new levels of related packages |
| 2024-10-01 | Verify program works with python 3.12.7 |
| 2025-01-16 | Verify program works with python 3.13.1 and latest package releases |
| 2025-01-30 | Upgrade packages |
| 2025-02-18 | Upgrade to python 3.13.2 and latest packages |
| 2025-02-21 | Stop using PyODMongo and use Pydantic instead |
| 2025-02-22 | rename remote repo and switch from GitLab to GitHub |
| 2025-02-24 | add extract_customer_schema method |
| 2025-02-25 | add static find_by_unique_id method to base model class |
| 2025-02-27 | start moving MongoDb methods and logging setup to base class |
| 2025-04-14 | verify code runs with python 3.13.3 and related packages |
| 2025-04-15 | move models into their own directory |
| 2025-04-17 | move logging into a separate LoggingUtility class |
| 2025-04-18 | use updated ProgramSettings class |
| 2025-05-17 | update MongoDB connection information |
| 2025-06-09 | update to use revised LoggingUtility |
| 2025-07-13 | use requirements.txt to display version information about required packages. |
- Following information is expected to be available and accurate in a file named .env with values different than the ones shown:
MONGODB_CONNECTION_TEMPLATE='fmorrison-learning.vemxm.mongodb.net/?retryWrites=true&w=majority&appName=FMORRISON-LEARNING&authSource=admin'
MONGODB_UID='' <--- fill in your super user ID
MONGODB_PWD='' <--- fill in your super user password
DB_USER=<db_password>@fmorrison-learning.vemxm.mongodb.net/?retryWrites=true&w=majority&appName=FMORRISON-LEARNING
MONGODB_DATABASE_NAME='sample_analytics' <--- This program expects you have pulled in the free MongoDB sample databases
MONGODB_COLLECTION_NAME='customers' <--- This program expects you have pulled in the free MongoDB sample collections
- since many MongoDB collections have an _id field, I created a parent class named
MongoDbBaseModelto make it easier to handle working with that field, especially when creating new records by copying existing ones that will need a different unique id from the one they were copied from.