Pony ORM

• What is Pony ORM?
  • PonyORM community
• Getting Started with Pony
  • Installing
  • Creating the database object
  • Defining entities
  • Database binding
  • Mapping entities to database tables
  • Using the debug mode
  • Creating entity instances
  • db_session
  • Writing queries
  • Getting objects
  • Updating an object
  • Writing raw SQL queries
  • Pony examples
• Connecting to the Database
  • Creating the Database object
  • Defining entities which are related to the Database object
  • Binding the database object to a specific database
  • Mapping entities to the database tables
  • Methods and attributes of the Database object
  • Using Database object for raw SQL queries
    • Using parameters in raw SQL queries
  • Customizing connection behavior
  • Database statistics
• Declaring Entities
  • Declaring an entity
  • Entity attributes
    • Required and Optional
    • PrimaryKey
    • Set
    • Composite keys
    • Composite indexes
  • Attribute data types
  • Attribute options
  • Entity inheritance
    • Multiple inheritance
    • Representing inheritance in the database
  • Adding custom methods to entities
  • Mapping customization
  • Hybrid methods and properties
• Entity Relationships
  • One-to-many relationship
  • Many-to-many relationship
  • One-to-one relationship
  • Self-references
  • Multiple relationships between two entities
• Transactions and db_session
  • Working with db_session
    • db_session and the transaction scope
    • Several transactions within the same db_session
    • Nested db_session
    • db_session cache
    • Using db_session with generator functions or coroutines
    • Parameters of db_session
  • Working with multiple databases
  • Functions for working with transactions
  • Optimistic concurrency control
  • Pessimistic locking
  • How Pony avoids lost updates
  • Transaction isolation levels and database peculiarities
  • Handling disruptions
• Working with entity instances
  • Creating an entity instance
  • Loading objects from the database
    • Getting an object by primary key
    • Getting one object by unique combination of attributes
    • Getting several objects
    • Using parameters in queries
    • Sorting query results
    • Limiting the number of selected objects
    • Traversing relationships
  • Updating an object
  • Deleting an object
    • Bulk delete
    • Cascade delete
  • Saving objects in the database
    • Order of saving objects
    • Cyclic chains during saving objects
  • Entity methods
  • Entity hooks
  • Serializing entity instances using pickle
• Queries
  • Using Python generator expressions
  • Using lambda functions
  • Pony ORM functions used to query the database
  • Pony query examples
  • Query object methods
  • Using date and time in queries
  • Automatic DISTINCT
  • Functions which can be used inside a query
    • Using getattr()
  • Using raw SQL
    • Using the raw_sql() function
    • Using the select_by_sql() and get_by_sql() methods
• Working with entity relationships
  • Establishing a relationship
  • Operations with collections
    • Attribute lifting
    • Collection attribute parameters
    • Collection attribute queries and other methods
• Aggregation
  • Query object aggregate functions
  • Several aggregate functions in one query
  • Function count
  • Conditional count
  • More sophisticated aggregate queries
  • Queries with HAVING
  • Aggregate functions in order by section
• JSON Data Type Support
  • Overview
  • Declaring a JSON attribute
  • Assigning value to the JSON attribute
  • Reading JSON attribute
  • Modifying JSON attribute
  • Querying JSON structures
  • JSON Support in Databases
• Array Data Type Support
  • Overview
  • Declaring an Array attribute
  • Operations with arrays
    • Accessing array items
• API Reference
  • Database
    • Database class
  • Supported databases
    • SQLite
    • PostgreSQL
    • MySQL
    • Oracle
    • CockroachDB
  • Transactions & db_session
    • Transaction isolation levels and database peculiarities
  • Entity definition
    • Entity attributes
    • Attribute kinds
    • Composite primary and secondary keys
    • Composite indexes
    • Attribute data types
    • Attribute options
    • Collection attribute methods
    • Entity options
    • Entity hooks
  • Entity methods
  • Queries and functions
  • Query object
  • Statistics - QueryStat
• Integration with flask
  • Flask-Login
• Integration with FastAPI
  • Setup
  • Models and Schemas
  • Async and db_session