Version 0.3.1

Added

• SQLAlchemy filter operators #130

Fixed

• Change private methods to internal #133
• Change create_all and drop_all to async #135

Full Changelog: 0.3.0...0.3.1

Version 0.3.0

Added

• Support for ON DELETE actions (#115)
• OneToOne field (#116)
• Email field (#123)
• IPAddress field (#124)
• Model class __repr__ and __str__ methods (#127)
• URL field (#128)

Fixed

• create method not working for non-integer Primary Keys (#119)

Version 0.2.1

Added

• Queryset-level delete method (#111)
• Queryset-level update method (#112)
• update_or_create convenience method (#113)

Version 0.2.0

Version 0.2.0 depends on typesystem>=0.3.0 for validation. This release changes how model fields are defined, now they are defined as a dict in the fieldsattribute of the model.

import databases
import orm


database = databases.Database("sqlite:///db.sqlite")
models = orm.ModelRegistry(database=database)


class Note(orm.Model):
    tablename = "notes"
    registry = models
    fields = {
        "id": orm.Integer(primary_key=True),
        "text": orm.String(max_length=100),
        "completed": orm.Boolean(default=False),
    }

There's no need for sync database drivers like psycopg2 for creating and destorying tables. ModelRegistry can do that now:

models.create_all()

models.drop_all()

Version 0.1.9

Added

• Add UUID field (#105)
• Add get_or_create method (#106)

Version 0.1.8

Added

• Decimal field - #104

Version 0.1.7

Added

• exclude method - #62
• order_by method - #70

Fixed

• Async tests with anyio - #101

Version 0.1.6

Added

• BigInteger column type - #91
• Enum column type - #41
• Optional depdendencies for database drivers - #100