SQLAlchemy-Utils

SQLAlchemy-Utils provides custom data types and various utility functions for SQLAlchemy.

• Installation
  • Supported platforms
  • Installing an official release
  • Installing the development version
  • Checking the installation
• Listeners
  • Automatic data coercion
  • Instant defaults
  • Many-to-many orphan deletion
• Data types
  • ArrowType
  • ChoiceType
  • ColorType
  • CompositeType
  • CountryType
  • CurrencyType
  • EmailType
  • EncryptedType
  • JSONType
  • LocaleType
  • LtreeType
  • IPAddressType
  • PasswordType
  • PhoneNumberType
  • ScalarListType
  • StringEncryptedType
  • TimezoneType
  • TSVectorType
  • URLType
  • UUIDType
  • WeekDaysType
• Range data types
  • Range type initialization
  • Range type operators
  • DateRangeType
  • DateTimeRangeType
  • IntRangeType
  • NumericRangeType
  • RangeComparator
• Aggregated attributes
  • Why?
  • Features
  • Simple aggregates
  • Custom aggregate expressions
  • Multiple aggregates per class
  • Many-to-Many aggregates
  • Multi-level aggregates
  • Examples
  • TODO
• Observers
  • Simple observers
  • Observes vs aggregated
  • Deeply nested observing
  • Observing multiple columns
• Internationalization
  • TranslationHybrid vs SQLAlchemy-i18n
  • Quickstart
  • Dynamic locales
• Generic relationships
  • Inheritance
  • Abstract base classes
  • Composite keys
• Database helpers
  • database_exists
  • create_database
  • drop_database
  • has_index
  • has_unique_index
  • json_sql
  • render_expression
  • render_statement
• Foreign key helpers
  • dependent_objects
  • get_referencing_foreign_keys
  • group_foreign_keys
  • is_indexed_foreign_key
  • merge_references
  • non_indexed_foreign_keys
• ORM helpers
  • cast_if
  • escape_like
  • get_bind
  • get_class_by_table
  • get_column_key
  • get_columns
  • get_declarative_base
  • get_hybrid_properties
  • get_mapper
  • get_query_entities
  • get_primary_keys
  • get_tables
  • get_type
  • has_changes
  • identity
  • is_loaded
  • make_order_by_deterministic
  • naturally_equivalent
  • quote
  • sort_query
• Utility classes
  • QueryChain
  • API
• Model mixins
  • Timestamp
  • generic_repr
• View utilities
  • create_view
  • create_materialized_view
  • refresh_materialized_view
• Testing
  • assert_min_value
  • assert_max_length
  • assert_max_value
  • assert_nullable
  • assert_non_nullable
• License