Index

_

__and__() (SelectQuery method) __getitem__() (DataSet method) (SelectQuery method) __invert__() (Node method) __iter__() (SelectQuery method) __or__() (SelectQuery method)

__sub__() (SelectQuery method) __xor__() (SelectQuery method) _close() (PooledDatabase method) _connect() (PooledDatabase method) _is_bound

A

add() (ManyToManyField method) add_column() (SchemaMigrator method) add_index() (SchemaMigrator method) add_not_null() (SchemaMigrator method) aggregate() (SelectQuery method) (SqliteExtDatabase method) aggregate_rows() (SelectQuery method) alias() (Model class method) (Node method) (Query method) all() (Table method)

ancestors() (BaseClosureTable method) annotate() (SelectQuery method) APSWDatabase (built-in class) ArrayField (built-in class) asc() (Node method) assert_query_count() (built-in function) atomic() (Database method)

B

BaseClosureTable (built-in class) begin() (Database method) BerkeleyDatabase (built-in class) between() (Node method) BigIntegerField (built-in class) BinaryJSONField (built-in class)

bind_to() (Node method) BlobField (built-in class) BM25() (built-in function) bm25() (FTSModel class method) BooleanField (built-in class)

C

case() (built-in function) cast() (built-in function) CharField (built-in class) clear() (ManyToManyField method) close() (Database method) (DataSet method) ClosureTable() (built-in function) coerce() collation() (SqliteExtDatabase method) column (ForeignKeyMetadata attribute) ColumnMetadata (built-in class) columns (IndexMetadata attribute) (Table attribute) commit() (Database method) (savepoint method) (transaction method) commit_on_success() (Database method) compiler() (Database method) CompositeKey (built-in class) CompoundSelect (built-in class)

concat() (Node method) connect() (built-in function) (DataSet method) (Database method) (Signal method) contained_by() (BinaryJSONField method) contains() (ArrayField method) (BinaryJSONField method) (HStoreField method) (Node method) contains_all() (BinaryJSONField method) contains_any() (ArrayField method) (BinaryJSONField method) (HStoreField method) count (count_queries attribute) count() (SelectQuery method) count_queries (built-in class) create() (Model class method) create_foreign_key() (Database method) create_index() (Database method) (Table method) create_sequence() (Database method) create_table() (Database method) (FTSModel class method) (Model class method) create_tables() (Database method)

D

data_type (ColumnMetadata attribute) Database (built-in class) DataSet (built-in class) DateField (built-in class) DateTimeField (built-in class) DateTimeTZField (built-in class) day (DateField attribute) (DateTimeField attribute) db_value() DecimalField (built-in class) defined() (HStoreField method) delete() (HStoreField method) (Model class method) (Table method) delete_instance() (Model method) DeleteQuery (built-in class) dependencies() (Model method) depth (BaseClosureTable attribute) desc() (Node method)

descendants() (BaseClosureTable method) dest_column (ForeignKeyMetadata attribute) dest_table (ForeignKeyMetadata attribute) dict_to_model() (built-in function) dicts() (RawQuery method) (SelectQuery method) dirty_fields (Model attribute) disconnect() (Signal method) distinct() (SelectQuery method) DoubleField (built-in class) drop_column() (SchemaMigrator method) drop_index() (SchemaMigrator method) drop_not_null() (SchemaMigrator method) drop_sequence() (Database method) drop_table() (Database method) (Model class method) drop_tables() (Database method) dump_csv() (built-in function)

E

endswith() (Node method) execute() (DeleteQuery method) (InsertQuery method) (Query method) (RawQuery method) (SelectQuery method) (UpdateQuery method) execute_sql() (Database method) execution_context() (Database method)

ExecutionContext (built-in class) exists() (HStoreField method) (SelectQuery method) extend() (Node class method) extract_date() (Database method)

F

find() (Table method) find_one() (Table method) first() (SelectQuery method) FloatField (built-in class) fn (built-in class) for_update() (SelectQuery method) ForeignKeyField (built-in class)

ForeignKeyMetadata (built-in class) freeze() (DataSet method) (Table method) from_() (SelectQuery method) from_database() (Introspector class method) FTSModel (built-in class), [1] func() (SqliteExtDatabase method)

G

generate_models() (Introspector method) get() (Model class method) (SelectQuery method) get_autocommit() (Database method) get_columns() (Database method) get_conn() (Database method) get_cursor() (Database method) get_foreign_keys() (Database method) get_indexes() (Database method) get_object_list() (PaginatedQuery method) get_object_or_404() (built-in function)

get_or_create() (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) GFKField (built-in class) granular_transaction() (SqliteExtDatabase method) group_by() (SelectQuery method)

H

having() (SelectQuery method) hour (DateTimeField attribute) (TimeField attribute)

HStoreField (built-in class)

I

id (BaseClosureTable attribute) IndexMetadata (built-in class) init() (Database method) initialize() (Proxy method) initialize_connection() (Database method) insert() (Model class method) (Table method) insert_from() (Model class method) insert_many() (Model method)

InsertQuery (built-in class) IntegerField (built-in class) Introspector (built-in class) is_dirty() (Model method) is_null() (Node method) items() (HStoreField method) iterator() (SelectQuery method)

J

join() (Query method)

JSONField (built-in class)

K

keys() (HStoreField method)

KeyStore (built-in class)

L

last_insert_id() (Database method) limit() (SelectQuery method)

load_csv() (built-in function)

M

manual_close() (PooledDatabase method) ManyToManyField (built-in class) Match() (built-in function) match() (built-in function) (FTSModel class method) migrate() (built-in function) minute (DateTimeField attribute) (TimeField attribute)

Model (built-in class) model_class (Table attribute) model_to_dict() (built-in function) month (DateField attribute) (DateTimeField attribute) MySQLDatabase (built-in class) MySQLMigrator (built-in class)

N

naive() (SelectQuery method) name (ColumnMetadata attribute) (IndexMetadata attribute)

Node (built-in class) null (ColumnMetadata attribute)

O

object_list() (built-in function) offset() (SelectQuery method) optimize() (FTSModel class method)

order_by() (SelectQuery method) over() (fn method)

P

paginate() (SelectQuery method) PaginatedQuery (built-in class) PickledKeyStore (built-in class) PooledDatabase (built-in class) PooledMySQLDatabase (built-in class) PooledPostgresqlDatabase (built-in class) PooledPostgresqlExtDatabase (built-in class) PostgresqlDatabase (built-in class)

PostgresqlExtDatabase (built-in class) PostgresqlMigrator (built-in class) prefetch() (built-in function) prepared() (Model method) primary_key (ColumnMetadata attribute) PrimaryKeyField (built-in class) Proxy (built-in class) python_value()

Q

Query (built-in class)

query() (DataSet method)

R

Rank() (built-in function) rank() (FTSModel class method) raw() (Model class method) RawQuery (built-in class) ReadSlaveModel (built-in class) rebuild() (FTSModel class method) regexp() (Node method) register_fields() (Database class method) register_module() (APSWDatabase method)

register_ops() (Database class method) remove() (ManyToManyField method) rename_column() (SchemaMigrator method) rename_table() (SchemaMigrator method) return_id_list() (InsertQuery method) ReverseGFK (built-in class) rollback() (Database method) (savepoint method) (transaction method) root (BaseClosureTable attribute) rows_affected() (Database method)

S

save() (Model method) savepoint (built-in class) savepoint() (Database method) scalar() (Query method) SchemaMigrator (built-in class) search() (FTSModel class method) search_bm25() (FTSModel class method) second (DateTimeField attribute) (TimeField attribute) select() (Model class method) (SelectQuery method) SelectQuery (built-in class) send() (Signal method) sequence_exists() (Database method) ServerSide() (built-in function) set_autocommit() (Database method)

siblings() (BaseClosureTable method) Signal (built-in class) slice() (HStoreField method) SQL (built-in class) sql (IndexMetadata attribute) sql() (Query method) sql_error_handler() (Database method) sqlall() (Model class method) SqlCipherDatabase (built-in class) SqliteDatabase (built-in class) SqliteExtDatabase (built-in class) SqliteMigrator (built-in class) startswith() (Node method) switch() (Query method)

T

Table (built-in class) table (ColumnMetadata attribute) (ForeignKeyMetadata attribute) (IndexMetadata attribute) table_exists() (Model class method) tables (DataSet attribute) test_database (built-in class) TextField (built-in class) thaw() (DataSet method) (Table method)

TimeField (built-in class) transaction (built-in class) transaction() (APSWDatabase method) (DataSet method) (Database method) translate() (built-in function) TSVectorField (built-in class) tuples() (RawQuery method) (SelectQuery method)

U

unique (IndexMetadata attribute) unregister_module() (APSWDatabase method) update() (HStoreField method) (Model class method) (Table method) UpdateQuery (built-in class)

upsert() (InsertQuery method) Using (built-in class) UUIDField (built-in class)

V

values() (HStoreField method)

VirtualModel (built-in class)

W

where() (Query method) Window (built-in class)

window() (SelectQuery method) wrapped_count() (SelectQuery method)

Y

year (DateField attribute) (DateTimeField attribute)