异步orm。
orm的Python项目详细描述
orm
orm
包是python的异步orm,支持postgres,
mysql和sqlite。ORM使用:
- SQLAlchemy core用于查询生成。
- ^{
} 用于跨数据库异步支持。 - ^{
} 用于数据验证。
因为orm是基于sqlalchemy核心构建的,所以可以使用alembic提供 数据库迁移。
orm仍在开发中:我们建议用orm~=0.1
note:使用ipython
从控制台尝试此操作,因为它支持await
。
importdatabasesimportormimportsqlalchemydatabase=databases.Database("sqlite:///db.sqlite")metadata=sqlalchemy.MetaData()classNote(orm.Model):__tablename__="notes"__database__=database__metadata__=metadataid=orm.Integer(primary_key=True)text=orm.String(max_length=100)completed=orm.Boolean(default=False)# 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()# 'pk' always refers to the primary keynote=awaitNote.objects.get(pk=2)note.pk# 2
ORM支持在外键之间加载和筛选…
importdatabasesimportormimportsqlalchemydatabase=databases.Database("sqlite:///db.sqlite")metadata=sqlalchemy.MetaData()classAlbum(orm.Model):__tablename__="album"__metadata__=metadata__database__=databaseid=orm.Integer(primary_key=True)name=orm.String(max_length=100)classTrack(orm.Model):__tablename__="track"__metadata__=metadata__database__=databaseid=orm.Integer(primary_key=True)album=orm.ForeignKey(Album)title=orm.String(max_length=100)position=orm.Integer()# 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.tracks=Track.objects.filter(album__name__iexact="fantasies")assertlen(tracks)==2# Limit a querytracks=awaitTrack.objects.limit(1).all()assertlen(tracks)==1
数据类型
所有字段类型都支持以下关键字参数。
primary_key
allow_null
default
index
unique
除非设置了以下任一项,否则所有字段都是必需的:
allow_null
-创建可为空的列。将默认值设置为None
。allow_blank
-允许空字符串进行验证。将默认值设置为""
。default
-设置字段的默认值。
支持以下列类型。 请参阅type-specific validation keyword arguments的字体系统。
orm.String(max_length)
orm.Text()
orm.Boolean()
orm.Integer()
orm.Float()
orm.Date()
orm.Time()
orm.DateTime()
orm.JSON()