mangomango 0.1.2

A simple MongoDB client that works with Pydantic models.

MangoMango

Basics

Usage

Connecting to MongoDB

To connect to a MongoDB instance, create a MangoMango client:

from mangomango import MangoMango

client = MangoMango(host="localhost", port=27017)

Creating a Database

To create or get a database, use the get_database method:

db = client.get_database("mydatabase")

Defining a Table

To define a table, use the table decorator on a Pydantic model. The type will not change, it will just register a table with this Model. To get the table, use get_table:

@db.table(collection="users", primary_key="id")
class User(BaseModel):
    id: int
    username: str
    email: str

UserTable = db.get_table("users")

Inserting Data

To insert data into a table:

user = User(id=0, username="john_doe", email="[e-mail]")
UserTable.insert(user)

Querying Data

To query data from a table:

user = UserTable.find({"username": "john_doe"})
print(user.username, user.email)

Updating Data

To update data in a table, use the update() method. The first argument is the primary key of the object, it can also be the object itself.

UserTable.update(john.id, {"$set": {"email": "[e-mail]"}})

You can also edit the object and re-push it with the same primary key. use push() method that insert if there is no object with the same primary key, else it remove and then insert

john.email = "[e-mail]"
UserTable.push(john)

Deleting Data

To delete one data from a table, use remove() method. Can take either primary key or object as first argument:

UserTable.remove(john.id)

Bulk Insert

To insert multiple objects:

users = [
    User(id=1, username="alice", email="[e-mail]"),
    User(id=2, username="bob", email="[e-mail]")
]
UserTable.insert_many_iter(users)

Bulk Update

To update multiple objects:

UserTable.update_many({"username": {"$in": ["alice", "bob"]}}, {"$set": {"active": True}})

Bulk Delete

To delete multiple objects:

UserTable.remove_many({"username": {"$in": ["alice", "bob"]}})

the doc is not finished