异步orm+pydantic=ormantic
ormantic的Python项目详细描述
正常
ormantic
包是python的异步orm,支持postgres,
mysql和sqlite。ormatic是来自^{
- SQLAlchemy core用于查询生成。
- ^{
} 用于跨数据库异步支持。 - ^{
} 用于数据验证。
因为orm是基于sqlalchemy核心构建的,所以可以使用alembic提供 数据库迁移。
note:使用ipython
从控制台尝试此操作,因为它支持await
。
importdatabasesimportsqlalchemyimportormanticasormdatabase=databases.Database("sqlite:///db.sqlite")metadata=sqlalchemy.MetaData()classNote(orm.Model):id:orm.Integer(primary_key=True)=Nonetext:orm.String(max_length=100)completed:orm.Boolean()=FalseclassMapping:table_name="notes"database=databasemetadata=metadata# Create the databaseengine=sqlalchemy.create_engine(str(database.url))metadata.create_all(engine)# .create()awaitNote.objects.create(text="Buy the groceries.",completed=False)awaitNote.objects.create(text="Call Mum.",completed=True)awaitNote.objects.create(text="Send invoices.",completed=True)# .all()notes=awaitNote.objects.all()# .filter()notes=awaitNote.objects.filter(completed=True).all()# exact, iexact, contains, icontains, lt, lte, gt, gte, innotes=awaitNote.objects.filter(text__icontains="mum").all()# .get()note=awaitNote.objects.get(id=1)# .update()awaitnote.update(completed=True)# .delete()awaitnote.delete()note=awaitNote.objects.get(id=2)assertnote.pk==note.id==2
ormantic支持在外键之间加载和筛选…
importdatabasesimportsqlalchemyimportormanticasormdatabase=databases.Database("sqlite:///db.sqlite")metadata=sqlalchemy.MetaData()classAlbum(orm.Model):id:orm.Integer(primary_key=True)=Nonename:orm.String(max_length=100)classMapping:table_name="album"metadata=metadatadatabase=databaseclassTrack(orm.Model):id:orm.Integer(primary_key=True)=Nonealbum:orm.ForeignKey(Album)title:orm.String(max_length=100)position:orm.Integer()classMapping:table_name="track"metadata=metadatadatabase=database# Create the databaseengine=sqlalchemy.create_engine(str(database.url))metadata.create_all(engine)# Create some records to work with.malibu=awaitAlbum.objects.create(name="Malibu")awaitTrack.objects.create(album=malibu,title="The Bird",position=1)awaitTrack.objects.create(album=malibu,title="Heart don't stand a chance",position=2)awaitTrack.objects.create(album=malibu,title="The Waters",position=3)fantasies=awaitAlbum.objects.create(name="Fantasies")awaitTrack.objects.create(album=fantasies,title="Help I'm Alive",position=1)awaitTrack.objects.create(album=fantasies,title="Sick Muse",position=2)# Fetch an instance, without loading a foreign key relationship on it.track=awaitTrack.objects.get(title="The Bird")# We have an album instance, but it only has the primary key populatedprint(track.album)# Album(id=1) [sparse]print(track.album.pk)# 1print(track.album.name)# Raises AttributeError# Load the relationship from the databaseawaittrack.album.load()asserttrack.album.name=="Malibu"# This time, fetch an instance, loading the foreign key relationship.track=awaitTrack.objects.select_related("album").get(title="The Bird")asserttrack.album.name=="Malibu"# Fetch instances, with a filter across an FK relationship.tracks=Track.objects.filter(album__name="Fantasies")assertlen(tracks)==2# Fetch instances, with a filter and operator across an FK relationship.assertTrack.objects.filter(album__name__iexact="fantasies").count()==2
数据类型
所有字段类型都支持以下关键字参数。
primary_key
allow_null
index
unique
支持以下列类型:
orm.Boolean()
orm.Date()
orm.DateTime()
orm.Enum()
orm.Float()
orm.Integer()
orm.JSON()
orm.String(max_length)
orm.StringArray()
orm.Text()
orm.Time()