Index

_ | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y

_

__and__() (SelectQuery method)
__getitem__() (DataSet method)
(SelectQuery method)
__invert__() (Node method)
__iter__() (SelectQuery method)
__len__() (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)
AESEncryptedField (built-in class)
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

BareField (built-in class)
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() (FTSModel class method)
BooleanField (built-in class)

C

case() (built-in function)
cast() (built-in function)
CharField (built-in class)
check_libsqlite() (BerkeleyDatabase class method)
check_pysqlite() (BerkeleyDatabase class method)
children() (JSONField method)
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)
CompressedField (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_or_get() (Model class 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)
DeferredRelation (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() (DeleteQuery method)
(InsertQuery method)
(RawQuery method)
(SelectQuery method)
(UpdateQuery method)
dirty_fields (Model attribute)
disconnect() (Signal method)
distinct() (SelectQuery method)
DocIDField (built-in class)
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() (Database method)
(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)
expression() (hybrid_method method)
extend() (Node class method)
extract() (JSONField 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)
fts5_installed() (FTS5Model class method)
FTS5Model (built-in class)
FTSModel (built-in class)
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)
hybrid_method (built-in class)
hybrid_property (built-in class)

I

id (BaseClosureTable attribute)
IndexMetadata (built-in class)
init() (Database method)
initialize() (Proxy method)
initialize_connection() (Database method)
insert() (JSONField method)
(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)
json_type() (JSONField method)
JSONField (built-in class), [1]
JSONKeyStore (built-in class)

K

keys() (HStoreField method)
KeyStore (built-in class)

L

last_insert_id() (Database method)
length() (JSONField method)
limit() (SelectQuery method)
load_csv() (built-in function)
load_extension() (SqliteExtDatabase method)

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)
on_conflict() (InsertQuery method)
(UpdateQuery method)
optimize() (FTSModel class method)
order_by() (SelectQuery method)
over() (fn method)

P

paginate() (SelectQuery method)
PaginatedQuery (built-in class)
parse() (built-in function)
PasswordField (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)
PrimaryKeyAutoIncrementField (built-in class)
PrimaryKeyField (built-in class)
Proxy (built-in class)
python_value()

Q

Query (built-in class)
query() (DataSet method)

R

rank() (FTSModel class method)
raw() (Model class method)
RawQuery (built-in class)
ReadSlaveModel (built-in class)
rebuild() (FTSModel class method)
regexp() (Node method)
register_database() (built-in function)
register_fields() (Database class method)
register_module() (APSWDatabase method)
register_ops() (Database class method)
remove() (JSONField method)
(ManyToManyField method)
rename_column() (SchemaMigrator method)
rename_table() (SchemaMigrator method)
replace() (JSONField method)
RetryOperationalError (built-in class)
return_id_list() (InsertQuery method)
returning() (DeleteQuery method)
(InsertQuery method)
(UpdateQuery method)
ReverseGFK (built-in class)
rollback() (Database method)
(savepoint method)
(transaction method)
root (BaseClosureTable attribute)
RowIDField (built-in class)
rows_affected() (Database method)

S

save() (Model method)
savepoint (built-in class)
savepoint() (Database method)
scalar() (Query method)
SchemaMigrator (built-in class)
search() (FTS5Model class method)
(FTSModel class method)
search_bm25() (FTS5Model class method)
(FTSModel class method)
SearchField (built-in class)
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() (JSONField method)
set_autocommit() (Database method)
set_model() (DeferredRelation method)
siblings() (BaseClosureTable method)
Signal (built-in class)
slice() (HStoreField method)
SQL (built-in class)
sql (IndexMetadata attribute)
sql() (Query 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)
tree() (JSONField method)
truncate_date() (Database method)
TSVectorField (built-in class)
tuples() (DeleteQuery method)
(InsertQuery method)
(RawQuery method)
(SelectQuery method)
(UpdateQuery 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)
VocabModel() (FTS5Model class method)

W

where() (Query method)
Window (built-in class)
window() (SelectQuery method)
wrapped_count() (SelectQuery method)

Y

year (DateField attribute)
(DateTimeField attribute)