quazydb 1.1.6

Powerful yet simple Python ORM

Powerful yet simple Python ORM

Let’s combine all modern ORMs with business essence into something intuitive and simple.

Example:

import random

from quazy import DBFactory, DBTable


class Product(DBTable):
    name: str
    price: float
    description: str = None


if __name__ == "__main__":
    db = DBFactory.postgres(conninfo="postgresql://quazy:quazy@127.0.0.1/quazy")
    db._debug_mode = True
    db.use_module()

    db.clear()
    db.create()

    for i in range(100):
        db.insert(Product(name=f'Product #{i + 1}', price=random.randint(1, 1000) / 100))

    q = Product.query().filter(lambda x: x.price >= 5)
    print("Total amount:", q.fetch_count())
    print("Average price:", q.fetch_avg("price"))
    print("Products:")
    for x in q:
        print(x.name, "->", x.price)

Documentation

https://quazydb.readthedocs.io/en/latest/