Index

_

__add__() (BaseTable method) (SelectQuery method) __aenter__() (AsyncDatabaseMixin method) __aexit__() (AsyncDatabaseMixin method) __and__() (BaseTable method) (BigBitField method) (SelectQuery method) __call__() (Database method) __contains__() (KeyValue method) __delitem__() (BigBitField method) (KeyValue method) __enter__() (Database method) __exit__() (Database method) __getattr__() (Entity method) __getitem__() (BaseQuery method) (BigBitField method) (DataSet method) (HStoreField method) (JSONField method) (KeyValue method)

__invert__() (ColumnBase method) __iter__() (BaseQuery method) (BigBitField method) (Model method) __len__() (BaseQuery method) (BigBitField method) (KeyValue method) (Model method) __mul__() (BaseTable method) __or__() (BaseTable method) (BigBitField method) (SelectQuery method) __setitem__() (AliasManager method) (BigBitField method) (KeyValue method) __sub__() (BaseTable method) (SelectQuery method) __xor__() (BigBitField method) _WriteQuery (built-in class)

A

aclose() (AsyncDatabaseMixin method) aconnect() (AsyncDatabaseMixin method) acreate_tables() (AsyncDatabaseMixin method) add() (AliasManager method) (ManyToManyField method) add_column() (SchemaMigrator method) add_column_default() (SchemaMigrator method) add_constraint() (SchemaMigrator method) add_index() (Model class method) (SchemaMigrator method) add_not_null() (SchemaMigrator method) add_unique() (SchemaMigrator method) adrop_tables() (AsyncDatabaseMixin method) aexecute() (AsyncDatabaseMixin method) aexecute_sql() (AsyncDatabaseMixin method) aggregate() (SqliteDatabase method) Alias (built-in class) alias() (Alias method) (ColumnBase method) (Model class method) (Source method) (Window method) AliasManager (built-in class) all() (Table method) alter_column_type() (SchemaMigrator method) append() (JSONField method) aprefetch() (AsyncDatabaseMixin method) APSWDatabase (class in playhouse.apsw_ext) ArrayField (class in playhouse.postgres_ext)

as_groups() (Window method) as_json() (BinaryJSONField method) (JSONField method) as_range() (Window method) as_rowcount() (Insert method) as_rows() (Window method) Asc() built-in function asc() (ColumnBase method) AsIs() built-in function assert_query_count() (in module playhouse.test_utils) AsyncDatabaseMixin (class in playhouse.pwasyncio) AsyncMySQLDatabase (class in playhouse.pwasyncio) AsyncPostgresqlDatabase (class in playhouse.pwasyncio) AsyncSqliteDatabase (class in playhouse.pwasyncio) atomic() (AsyncDatabaseMixin method) (Database method) (MySQLDatabase method) (PostgresqlDatabase method) (SqliteDatabase method) attach() (SqliteDatabase method) attach_callback() (Proxy method) authorizer() (CySqliteDatabase method) autocommit (CySqliteDatabase attribute) AutoField (built-in class) AutoIncrementField (class in playhouse.sqlite_ext) avgrange() (in module playhouse.sqlite_udf) avgtdiff() (in module playhouse.sqlite_udf)

B

backup() (CySqliteDatabase method) backup_to_file() (CySqliteDatabase method) BareField (built-in class) BaseQuery (built-in class) BaseTable (built-in class) batch_commit() (Database method) begin() (Database method) BigAutoField (built-in class) BigBitField (built-in class) BigIntegerField (built-in class) BinaryJSONField (class in playhouse.postgres_ext) BinaryUUIDField (built-in class) bind() (BaseQuery method) (Database method) (Model class method) (Table method) bind_ctx() (Database method) (Model class method) (Table method) BitField (built-in class)

blob_open() (CySqliteDatabase method) BlobField (built-in class) bm25() (FTS5Model class method) (FTSModel class method) bm25f() (FTSModel class method) BooleanField (built-in class) built-in function Asc() AsIs() Case() Check() chunked() CommaNodeList() Default() Desc() EnclosedNodeList() fn() prefetch() bulk_create() (Model class method) bulk_update() (Model class method)

C

cache_size (SqliteDatabase attribute) Case() built-in function Cast (built-in class) cast() (ColumnBase method) CharField (built-in class) Check() built-in function children() (JSONField method) chunked() built-in function clear() (BigBitField method) (KeyValue method) (ManyToManyField method) clear_bit() (BigBitField method) clear_settings() (in module playhouse.sqlite_udf) clear_toggles() (in module playhouse.sqlite_udf) close() (Database method) (DataSet method) close_all() (PooledDatabase method) close_idle() (PooledDatabase method) close_pool() (AsyncDatabaseMixin method) close_stale() (PooledDatabase method) CockroachDatabase (class in playhouse.cockroachdb) coerce() (Field method) (Function method) collate() (Ordering method) collation() (SqliteDatabase method) Column (built-in class) column (Field attribute) ColumnBase (built-in class) ColumnMetadata (built-in class) ColumnMetadata.data_type (built-in variable) ColumnMetadata.default (built-in variable) ColumnMetadata.name (built-in variable) ColumnMetadata.null (built-in variable) ColumnMetadata.primary_key (built-in variable) ColumnMetadata.table (built-in variable) columns (Table attribute) columns() (Select method) (ValuesList method) CommaNodeList() built-in function

commit() (Database method) CompositeKey (built-in class) CompoundSelectQuery (built-in class) CompressedField (class in playhouse.fields) concat() (BinaryJSONField method) (JSONField method) conflict_constraint() (OnConflict method) conflict_target() (OnConflict method) conflict_where() (OnConflict method) connect() (Database method) (DataSet method) (in module playhouse.db_url) (Signal method) connection() (Database method) connection_context() (Database method) contained_by() (BinaryJSONField method) contains() (ArrayField method) (BinaryJSONField method) (HStoreField method) contains_all() (BinaryJSONField method) contains_any() (ArrayField method) (BinaryJSONField method) (HStoreField method) Context (built-in class) copy() (Node static method) count (count_queries attribute) count() (AsyncDatabaseMixin method) (ModelSelect method) (SelectBase method) count_queries (class in playhouse.test_utils) create() (Model class method) create_all() (SchemaManager method) create_foreign_key() (SchemaManager method) create_index() (Table method) create_indexes() (SchemaManager method) create_sequence() (SchemaManager method) create_table() (Model class method) (SchemaManager method) create_tables() (Database method) CTE (built-in class) cte() (Query method) CURRENT_ROW (Window attribute) cursor() (Database method) CySqliteDatabase (class in playhouse.cysqlite_ext)

D

damerau_levenshtein_dist() (in module playhouse.sqlite_udf) Database (built-in class) database (FlaskDB attribute) DatabaseError (built-in class) DatabaseProxy (built-in class) DataError (built-in class) DataSet (class in playhouse.dataset) date_series() (in module playhouse.sqlite_udf) DateField (built-in class) DateTimeField (built-in class) DateTimeTZField (class in playhouse.postgres_ext) day (DateField attribute) (DateTimeField attribute) db_value() (Field method) DecimalField (built-in class) Default() built-in function DeferredForeignKey (built-in class) DeferredThroughModel (built-in class) defined() (HStoreField method) Delete (built-in class) delete() (HStoreField method) (Model class method) (Table method), [1] delete_by_id() (Model class method) delete_instance() (Model method)

dependencies() (Model method) Desc() built-in function desc() (ColumnBase method) detach() (SqliteDatabase method) dict_to_model() (in module playhouse.shortcuts) dicts() (BaseQuery method) (ModelSelect method) dirty_field_names (Model attribute) dirty_fields (Model attribute) disconnect() (Signal method) distinct() (Select method) DoesNotExist (built-in class) DoubleField (built-in class) DQ (built-in class) drop_all() (SchemaManager method) drop_column() (SchemaMigrator method) drop_column_default() (SchemaMigrator method) drop_constraint() (SchemaMigrator method) drop_index() (SchemaMigrator method) drop_indexes() (SchemaManager method) drop_not_null() (SchemaMigrator method) drop_sequence() (SchemaManager method) drop_table() (Model class method) (SchemaManager method) drop_tables() (Database method) duration() (in module playhouse.sqlite_udf)

E

EnclosedNodeList() built-in function Entity (built-in class) except_() (SelectQuery method) exclude() (Window method) EXCLUDED (built-in class) execute() (BaseQuery method) (Database method) execute_sql() (Database method) exists() (AsyncDatabaseMixin method) (HStoreField method) (ModelSelect method) (SelectBase method)

Expression (built-in class) extends() (Window method) extract() (BinaryJSONField method) (JSONField method), [1], [2] extract_date() (Database method) extract_json() (JSONField method) extract_text() (JSONField method)

F

Field (built-in class) file_ext() (in module playhouse.sqlite_udf) file_read() (in module playhouse.sqlite_udf) filter() (Function method) (Model class method) (ModelSelect method) find() (Table method) find_one() (Table method) first() (ModelSelect method) (SelectBase method) FixedCharField (built-in class) flag() (BitField method) FlaskDB (class in playhouse.flask_utils) FloatField (built-in class) fn() built-in function following() (Window static method) for_update() (Select method)

foreign_keys (SqliteDatabase attribute) ForeignKeyField (built-in class) ForeignKeyMetadata (built-in class) ForeignKeyMetadata.column (built-in variable) ForeignKeyMetadata.dest_column (built-in variable) ForeignKeyMetadata.dest_table (built-in variable) ForeignKeyMetadata.table (built-in variable) ForUpdate (built-in class) freeze() (DataSet method) (Table method) from_() (Select method) (Update method) from_database() (Introspector class method) (SchemaMigrator class method) fts5_installed() (FTS5Model class method) FTS5Model (class in playhouse.sqlite_ext) FTSModel (class in playhouse.sqlite_ext) func() (SqliteDatabase method) Function (built-in class)

G

gauss_distribution() (in module playhouse.sqlite_udf) generate_models() (in module playhouse.reflection) (Introspector method) get() (AliasManager method) (AsyncDatabaseMixin method) (KeyValue method) (Model class method) (ModelSelect method) (SelectBase method) get_by_id() (Model class method) get_columns() (Database method) get_foreign_keys() (Database method) get_id() (Model method) get_indexes() (Database method) get_object_list() (PaginatedQuery method)

get_object_or_404() (in module playhouse.flask_utils) get_or_create() (Model class method) get_or_none() (Model class method) get_page() (PaginatedQuery method) get_page_count() (PaginatedQuery method) get_primary_keys() (Database method) get_queries() (count_queries method) get_tables() (Database method) get_through_model() (ManyToManyField method) get_views() (Database method) GROUP (Window attribute) group_by() (Select method) group_by_extend() (Select method) GROUPS (Window attribute) gunzip() (in module playhouse.sqlite_udf) gzip() (in module playhouse.sqlite_udf)

H

has_key() (BinaryJSONField method) having() (Select method) highlight() (SearchField method) hostname() (in module playhouse.sqlite_udf) hour (DateTimeField attribute) (TimeField attribute)

HStoreField (class in playhouse.postgres_ext) humandelta() (in module playhouse.sqlite_udf) hybrid_method (class in playhouse.hybrid) hybrid_property (class in playhouse.hybrid)

I

IdentityField (built-in class) if_then_else() (in module playhouse.sqlite_udf) ImproperlyConfigured (built-in class) in_transaction() (Database method) Index (built-in class) index() (Model class method) IndexMetadata (built-in class) IndexMetadata.columns (built-in variable) IndexMetadata.name (built-in variable) IndexMetadata.sql (built-in variable) IndexMetadata.table (built-in variable) IndexMetadata.unique (built-in variable) init() (Database method) init_app() (FlaskDB method) initialize() (Proxy method) Insert (built-in class) insert() (JSONField method) (Model class method) (Table method), [1] insert_from() (Model class method)

insert_many() (Model class method) IntegerField (built-in class) IntegrityError (built-in class) InterfaceError (built-in class) InternalError (built-in class) intersect() (SelectQuery method) interval() (PostgresqlDatabase method) IntervalField (class in playhouse.postgres_ext) Introspector (class in playhouse.reflection) IPField (built-in class) is_alias() (Node method) is_closed() (Database method) is_dirty() (Model method) is_set() (BigBitField method) is_stopped() (SqliteQueueDatabase method) ISODateTimeField (class in playhouse.sqlite_ext) items() (HStoreField method) (KeyValue method) iterate() (AsyncDatabaseMixin method) iterator() (BaseQuery method)

J

Join (built-in class) join() (ModelSelect method) (Select method) (Source method) join_from() (ModelSelect method) journal_mode (SqliteDatabase attribute) journal_size_limit (SqliteDatabase attribute)

json() (JSONBField method) json_type() (JSONField method) JSONBField (class in playhouse.sqlite_ext) JSONField (class in playhouse.mysql_ext:) (class in playhouse.postgres_ext) (class in playhouse.sqlite_ext) JSONPath (class in playhouse.sqlite_ext)

K

keys() (HStoreField method) (KeyValue method)

KeyValue (class in playhouse.kv)

L

last_insert_id() (Database method) left_outer_join() (Source method) length() (BinaryJSONField method) (JSONField method), [1] levenshtein_dist() (in module playhouse.sqlite_udf)

limit() (Query method) list() (AsyncDatabaseMixin method) literal() (Context method) load_extension() (SqliteDatabase method) lucene() (FTSModel class method)

M

manual_close() (PooledDatabase method) manual_commit() (Database method) ManyToManyField (built-in class) map_models() (SubclassAwareMetadata method) MariaDBConnectorDatabase (class in playhouse.mysql_ext) match() (FTS5Model class method) (FTSModel class method) Match() (in module playhouse.mysql_ext:) (in module playhouse.postgres_ext) match() (SearchField method) (TSVectorField method) median() (in module playhouse.sqlite_udf) Metadata (built-in class) migrate() (in module playhouse.migrate) minrange() (in module playhouse.sqlite_udf) mintdiff() (in module playhouse.sqlite_udf) minute (DateTimeField attribute) (TimeField attribute) MissingGreenletBridge (class in playhouse.pwasyncio) mmap_size (SqliteDatabase attribute) mode() (in module playhouse.sqlite_udf) Model (built-in class) model (Field attribute) Model (FlaskDB attribute) model_class (Table attribute) model_graph() (Metadata method) model_to_dict() (in module playhouse.shortcuts) ModelAlias (built-in class) ModelIndex (built-in class) models() (ModelSelect method) ModelSelect (built-in class)

module playhouse.apsw_ext playhouse.cockroachdb playhouse.cysqlite_ext playhouse.dataset playhouse.db_url playhouse.fields playhouse.flask_utils playhouse.hybrid playhouse.kv playhouse.migrate playhouse.mysql_ext playhouse.mysql_ext: playhouse.pool playhouse.postgres_ext playhouse.pwasyncio playhouse.pydantic_utils playhouse.reflection playhouse.shortcuts playhouse.signals playhouse.sqlcipher_ext playhouse.sqlite_ext playhouse.sqlite_udf playhouse.sqliteq playhouse.test_utils pwiz month (DateField attribute) (DateTimeField attribute) MySQLConnectorDatabase (class in playhouse.mysql_ext) MySQLDatabase (built-in class) MySQLMigrator (class in playhouse.migrate)

N

name (Field attribute) namedtuples() (BaseQuery method) (ModelSelect method) Negated (built-in class)

NO_OTHERS (Window attribute) Node (built-in class) NodeList (built-in class) NotSupportedError (built-in class) nulls_distinct() (Index method)

O

object_list() (in module playhouse.flask_utils) objects() (BaseQuery method) (ModelSelect method) offset() (Query method) on() (Join method) on_commit() (CySqliteDatabase method) on_conflict() (Insert method) on_conflict_ignore() (Insert method) on_conflict_replace() (Insert method) on_rollback() (CySqliteDatabase method)

on_update() (CySqliteDatabase method) OnConflict (built-in class) OperationalError (built-in class) optimize() (FTS5Model class method) (FTSModel class method) order_by() (Query method) order_by_extend() (Query method) Ordering (built-in class) orwhere() (Query method) over() (Function method)

P

page_size (SqliteDatabase attribute) paginate() (Query method) PaginatedQuery (class in playhouse.flask_utils) parentheses (Context attribute) parse() (Context method) (in module playhouse.db_url) pause() (SqliteQueueDatabase method) peek() (ModelSelect method) (SelectBase method) PeeweeException (built-in class) PickleField (class in playhouse.fields) playhouse.apsw_ext module playhouse.cockroachdb module playhouse.cysqlite_ext module playhouse.dataset module playhouse.db_url module playhouse.fields module playhouse.flask_utils module playhouse.hybrid module playhouse.kv module playhouse.migrate module playhouse.mysql_ext module playhouse.mysql_ext: module playhouse.pool module playhouse.postgres_ext module playhouse.pwasyncio module playhouse.pydantic_utils module playhouse.reflection module

playhouse.shortcuts module playhouse.signals module playhouse.sqlcipher_ext module playhouse.sqlite_ext module playhouse.sqlite_udf module playhouse.sqliteq module playhouse.test_utils module PooledCockroachDatabase (class in playhouse.cockroachdb) PooledCySqliteDatabase (class in playhouse.cysqlite_ext) PooledDatabase (class in playhouse.pool) PooledMariaDBConnectorDatabase (class in playhouse.mysql_ext) PooledMySQLConnectorDatabase (class in playhouse.mysql_ext) PooledMySQLDatabase (class in playhouse.pool) PooledPostgresqlDatabase (class in playhouse.pool) PooledPostgresqlExtDatabase (class in playhouse.postgres_ext) PooledPsycopg3Database (class in playhouse.postgres_ext) PooledSqliteDatabase (class in playhouse.pool) pop() (AliasManager method) (KeyValue method) PostgresqlDatabase (built-in class) PostgresqlExtDatabase (class in playhouse.postgres_ext) PostgresqlMigrator (class in playhouse.migrate) pragma() (SqliteDatabase method) preceding() (Window static method) prefetch() built-in function prefetch() (ModelSelect method) preserve() (OnConflict method) print_model() (in module playhouse.reflection) print_table_sql() (in module playhouse.reflection) ProgrammingError (built-in class) progress() (CySqliteDatabase method) Proxy (built-in class) Psycopg3Database (class in playhouse.postgres_ext) push() (AliasManager method) pwiz module python_value() (Field method) (Function method)

Q

Query (built-in class)

query() (Context method) (DataSet method)

R

random() (Database method) randomrange() (in module playhouse.sqlite_udf) RANGE (Window attribute) range() (in module playhouse.sqlite_udf) rank() (FTS5Model class method) (FTSModel class method) raw() (Model class method) RawQuery (built-in class) read_uncommitted (SqliteDatabase attribute) rebuild() (FTS5Model class method) (FTSModel class method) regex_search() (in module playhouse.sqlite_udf) register_aggregate() (SqliteDatabase method) register_collation() (SqliteDatabase method) register_database() (in module playhouse.db_url) register_function() (SqliteDatabase method) register_module() (APSWDatabase method) register_table_function() (CySqliteDatabase method) register_window_function() (SqliteDatabase method)

rekey() (SqlCipherDatabase method) remove() (BinaryJSONField method) (JSONField method) (ManyToManyField method) rename_column() (SchemaMigrator method) rename_table() (SchemaMigrator method) replace() (JSONField method) (Model class method) (Table method) replace_many() (Model class method) resolve_multimodel_query() (in module playhouse.shortcuts) returning() (_WriteQuery method) rollback() (Database method) RowIDField (class in playhouse.sqlite_ext) ROWS (Window attribute) rows_affected() (Database method) run() (AsyncDatabaseMixin method) run_transaction() (CockroachDatabase method) (in module playhouse.cockroachdb)

S

safe() (Index method) save() (Model method) savepoint() (Database method) scalar() (AsyncDatabaseMixin method) (ModelSelect method) (SelectBase method) SchemaManager (built-in class) SchemaMigrator (class in playhouse.migrate) scope (Context attribute) scope_column() (Context method) scope_cte() (Context method) scope_normal() (Context method) scope_source() (Context method) scope_values() (Context method) search() (FTS5Model class method) (FTSModel class method) search_bm25() (FTS5Model class method) (FTSModel class method) search_bm25f() (FTSModel class method) search_lucene() (FTSModel class method) SearchField (class in playhouse.sqlite_ext) second (DateTimeField attribute) (TimeField attribute) Select (built-in class) select() (Model class method) (Select method) (Source method) (Table method) select_extend() (Select method) select_from() (CTE method) (SelectQuery method) SelectBase (built-in class) SelectQuery (built-in class) send() (Signal method) sequence_exists() (Database method) ServerSide() (in module playhouse.postgres_ext)

session_commit() (Database method) session_rollback() (Database method) session_start() (Database method) set() (JSONField method) set_bit() (BigBitField method) set_by_id() (Model class method) set_database() (Metadata method) set_isolation_level() (PostgresqlDatabase method) set_search_path() (PostgresqlMigrator method) set_table_name() (Metadata method) set_time_zone() (PostgresqlDatabase method) setting() (in module playhouse.sqlite_udf) Signal (class in playhouse.signals) slice() (HStoreField method) slow_query_log() (CySqliteDatabase method) SmallIntegerField (built-in class) snippet() (SearchField method) Source (built-in class) SQL (built-in class) sql() (BaseQuery method) (Context method) SqlCipherDatabase (class in playhouse.sqlcipher_ext) SqliteDatabase (built-in class) SqliteMigrator (class in playhouse.migrate) SqliteQueueDatabase (class in playhouse.sqliteq) sqrt() (in module playhouse.sqlite_udf) start() (SqliteQueueDatabase method) State (built-in class) stop() (SqliteQueueDatabase method) str_dist() (in module playhouse.sqlite_udf) strip_chars() (in module playhouse.sqlite_udf) strip_tz() (in module playhouse.sqlite_udf) SubclassAwareMetadata (built-in class) subquery (Context attribute) substr_count() (in module playhouse.sqlite_udf) switch() (ModelSelect method) synchronous (SqliteDatabase attribute)

T

Table (built-in class) (class in playhouse.dataset) table (Metadata attribute) table_exists() (Database method) (Model class method) table_function() (CySqliteDatabase method) tables (DataSet attribute) TDecimalField (class in playhouse.sqlite_ext) TextField (built-in class) thaw() (DataSet method) (Table method) ThreadSafeDatabaseMetadata (class in playhouse.shortcuts) through_model (ManyToManyField attribute) TIES (Window attribute) TimeField (built-in class) timeout (SqliteDatabase attribute) TimestampField (built-in class) to_pydantic() (in module playhouse.pydantic_utils) to_timestamp() (DateField method) (DateTimeField method)

toggle() (in module playhouse.sqlite_udf) toggle_bit() (BigBitField method) tonumber() (in module playhouse.sqlite_udf) transaction() (Database method) (DataSet method) (MySQLDatabase method) (PostgresqlDatabase method) (SqliteDatabase method) tree() (JSONField method) truncate() (DateField method) (DateTimeField method) truncate_date() (Database method) truncate_table() (Model method) (SchemaManager method) TSVectorField (class in playhouse.postgres_ext) Tuple (built-in class) tuples() (BaseQuery method) (ModelSelect method)

U

union() (SelectQuery method) union_all() (CTE method) (SelectQuery method) unload_extension() (SqliteDatabase method) unpause() (SqliteQueueDatabase method) unregister_aggregate() (SqliteDatabase method) unregister_collation() (SqliteDatabase method) unregister_function() (SqliteDatabase method) unregister_module() (APSWDatabase method) unregister_table_function() (CySqliteDatabase method) unregister_window_function() (SqliteDatabase method)

unwrap() (Node method) Update (built-in class) update() (HStoreField method) (JSONField method) (KeyValue method) (Model class method) (OnConflict method) (Table method), [1] update_model_from_dict() (in module playhouse.shortcuts) using() (Index method) UUIDField (built-in class)

V

Value (built-in class) values() (HStoreField method) (KeyValue method) ValuesList (built-in class)

ViewMetadata (built-in class) ViewMetadata.name (built-in variable) ViewMetadata.sql (built-in variable) VocabModel() (FTS5Model class method)

W

wal_autocheckpoint (SqliteDatabase attribute) where() (Index method) (OnConflict method) (Query method)

Window (built-in class) window() (Select method) window_function() (SqliteDatabase method) with_cte() (Query method)

Y

year (DateField attribute) (DateTimeField attribute)