querytyper 0.1.0

A Python package to queryy databases using a fully typed syntax.

Querytyper

Querytyper is a Python package to query MongoDB using a fully typed syntax. It leverages the Pydantic library for defining and validating data models, providing a seamless and type-safe experience.

Features

• Construct MongoDB queries using Python's native syntax with type hints.
• Leverage Pydantic models to define your MongoDB document structure and query filters efficiently.
• Build complex queries using logical operators and comparisons in a natural and expressive way.

Using

To add and install this package as a dependency of your project, run poetry add querytyper.

A simple example:

from pydantic import BaseModel, EmailStr
from querytyper import MongoFilterMeta, MongoQuery

class User(BaseModel):
    """User database model."""
    id: int
    name: str
    age: int
    email: EmailStr

class UserFilter(User, metaclass=MongoFilterMeta):
    """User query filter."""

query = MongoQuery(
        (UserFilter.name == "John")
        & (UserFilter.age >= 10)
        & (
            UserFilter.email
            in [
                "[e-mail]",
                "[e-mail]",
            ]
        )
    )
print(query)

{
    "name": "John",
    "age": {"$gte": 10},
    "email": [
        "[e-mail]",
        "[e-mail]",
    ],
}

Contributing

Prerequisites

1. Set up Git to use SSH

1. Generate an SSH key and add the SSH key to your GitHub account.
2. Configure SSH to automatically load your SSH keys:

   cat << EOF >> ~/.ssh/config
   Host *
     AddKeysToAgent yes
     IgnoreUnknown UseKeychain
     UseKeychain yes
   EOF
   

2. Install Docker

1. Install Docker Desktop.
   • Enable Use Docker Compose V2 in Docker Desktop's preferences window.
   • Linux only:
     • Export your user's user id and group id so that files created in the Dev Container are owned by your user:

       cat << EOF >> ~/.bashrc
       export UID=$(id --user)
       export GID=$(id --group)
       EOF
       

3. Install VS Code or PyCharm

1. Install VS Code and VS Code's Dev Containers extension. Alternatively, install PyCharm.
2. Optional: install a Nerd Font such as FiraCode Nerd Font and configure VS Code or configure PyCharm to use it.

Development environments

The following development environments are supported:

1. ⭐️ GitHub Codespaces: click on Code and select Create codespace to start a Dev Container with GitHub Codespaces.
2. ⭐️ Dev Container (with container volume): click on Open in Dev Containers to clone this repository in a container volume and create a Dev Container with VS Code.
3. Dev Container: clone this repository, open it with VS Code, and run Ctrl/⌘ + ⇧ + P → Dev Containers: Reopen in Container.
4. PyCharm: clone this repository, open it with PyCharm, and configure Docker Compose as a remote interpreter with the dev service.
5. Terminal: clone this repository, open it with your terminal, and run docker compose up --detach dev to start a Dev Container in the background, and then run docker compose exec dev zsh to open a shell prompt in the Dev Container.

Developing

• This project follows the Conventional Commits standard to automate Semantic Versioning and Keep A Changelog with Commitizen.
• Run poe from within the development environment to print a list of Poe the Poet tasks available to run on this project.
• Run poetry add {package} from within the development environment to install a run time dependency and add it to pyproject.toml and poetry.lock. Add --group test or --group dev to install a CI or development dependency, respectively.
• Run poetry update from within the development environment to upgrade all dependencies to the latest versions allowed by pyproject.toml.
• Run cz bump to bump the package's version, update the CHANGELOG.md, and create a git tag.