SQLAlchemy 实用程序
SQLAlchemy-Utils 为 SQLAlchemy 提供自定义数据类型和各种实用函数。
SQLAlchemy-Utils官方文档
一、安装
pip install sqlalchemy-utils
二、Data types
class User(Base):
TYPES = [
('admin', 'Admin'),
('regular-user', 'Regular user')
]
__tablename__ = 'user'
id = sa.Column(sa.Integer, primary_key=True)
name = sa.Column(sa.Unicode(255))
type = sa.Column(ChoiceType(TYPES))
user = User(type='admin')
user.type # Choice(code='admin', value='Admin')
from sqlalchemy_utils import JSONType
class Product(Base):
__tablename__ = 'product'
id = sa.Column(sa.Integer, autoincrement=True)
name = sa.Column(sa.Unicode(50))
details = sa.Column(JSONType)
product = Product()
product.details = {
'color': 'red',
'type': 'car',
'max-speed': '400 mph'
}
session.commit()
- LocaleType
- LtreeType
- IPAddressType
- PasswordType
- PhoneNumberType
- ScalarListType
- StringEncryptedType
- TimezoneType
- TSVectorType
- URLType
- UUIDType
- WeekDaysType
三、Database helpers
database_exists('postgresql://postgres@localhost/name') #=> False
create_database('postgresql://postgres@localhost/name')
database_exists('postgresql://postgres@localhost/name') #=> True
create_database('postgresql://postgres@localhost/name')
create_database(engine.url)
drop_database('postgresql://postgres@localhost/name')
drop_database(engine.url)
网友评论