Database
Database.init()
Database.__enter__()
Database.connection_context()
Database.connect()
Database.close()
Database.is_closed()
Database.connection()
Database.cursor()
Database.execute_sql()
Database.execute()
Database.last_insert_id()
Database.rows_affected()
Database.in_transaction()
Database.atomic()
Database.manual_commit()
Database.session_start()
Database.session_commit()
Database.session_rollback()
Database.transaction()
Database.savepoint()
Database.begin()
Database.commit()
Database.rollback()
Database.batch_commit()
Database.table_exists()
Database.get_tables()
Database.get_indexes()
Database.get_columns()
Database.get_primary_keys()
Database.get_foreign_keys()
Database.get_views()
Database.sequence_exists()
Database.create_tables()
Database.drop_tables()
Database.bind()
Database.bind_ctx()
Database.extract_date()
Database.truncate_date()
Database.random()
SqliteDatabase
SqliteDatabase.pragma()
SqliteDatabase.cache_size
SqliteDatabase.foreign_keys
SqliteDatabase.journal_mode
SqliteDatabase.journal_size_limit
SqliteDatabase.mmap_size
SqliteDatabase.page_size
SqliteDatabase.read_uncommitted
SqliteDatabase.synchronous
SqliteDatabase.wal_autocheckpoint
SqliteDatabase.timeout
SqliteDatabase.register_aggregate()
SqliteDatabase.aggregate()
SqliteDatabase.register_collation()
SqliteDatabase.collation()
SqliteDatabase.register_function()
SqliteDatabase.func()
SqliteDatabase.register_window_function()
SqliteDatabase.window_function()
SqliteDatabase.table_function()
SqliteDatabase.unregister_aggregate()
SqliteDatabase.unregister_collation()
SqliteDatabase.unregister_function()
SqliteDatabase.unregister_table_function()
SqliteDatabase.load_extension()
SqliteDatabase.attach()
SqliteDatabase.detach()
SqliteDatabase.transaction()
PostgresqlDatabase
PostgresqlDatabase.set_time_zone()
MySQLDatabase
Node
Node.copy()
Node.unwrap()
Node.is_alias()
Source
Source.alias()
Source.select()
Source.join()
Source.left_outer_join()
BaseTable
BaseTable.__and__()
BaseTable.__add__()
BaseTable.__sub__()
BaseTable.__or__()
BaseTable.__mul__()
Table
Table.bind()
Table.bind_ctx()
Table.select()
Table.insert()
Table.replace()
Table.update()
Table.delete()
Join
Join.on()
ValuesList
ValuesList.columns()
CTE
CTE.select_from()
CTE.union_all()
ColumnBase
ColumnBase.alias()
ColumnBase.cast()
ColumnBase.asc()
ColumnBase.desc()
ColumnBase.__invert__()
Column
Alias
Alias.alias()
Negated
Value
AsIs()
Cast
Ordering
Ordering.collate()
Asc()
Desc()
Expression
Entity
Entity.__getattr__()
SQL
Check()
Function
Function.over()
Function.filter()
Function.coerce()
Function.python_value()
fn()
Window
Window.RANGE
Window.ROWS
Window.GROUPS
Window.CURRENT_ROW
Window.NO_OTHERS
Window.GROUP
Window.TIES
Window.preceding()
Window.following()
Window.as_rows()
Window.as_range()
Window.as_groups()
Window.extends()
Window.exclude()
Window.alias()
Case()
NodeList
CommaNodeList()
EnclosedNodeList()
DQ
Tuple
OnConflict
OnConflict.preserve()
OnConflict.update()
OnConflict.where()
OnConflict.conflict_target()
OnConflict.conflict_where()
OnConflict.conflict_constraint()
EXCLUDED
BaseQuery
BaseQuery.bind()
BaseQuery.dicts()
BaseQuery.tuples()
BaseQuery.namedtuples()
BaseQuery.objects()
BaseQuery.sql()
BaseQuery.execute()
BaseQuery.iterator()
BaseQuery.__iter__()
BaseQuery.__getitem__()
BaseQuery.__len__()
RawQuery
Query
Query.with_cte()
Query.where()
Query.orwhere()
Query.order_by()
Query.order_by_extend()
Query.limit()
Query.offset()
Query.paginate()
SelectQuery
SelectQuery.cte()
SelectQuery.select_from()
SelectQuery.union_all()
SelectQuery.__add__()
SelectQuery.union()
SelectQuery.__or__()
SelectQuery.intersect()
SelectQuery.__and__()
SelectQuery.except_()
SelectQuery.__sub__()
SelectBase
SelectBase.peek()
SelectBase.first()
SelectBase.scalar()
SelectBase.count()
SelectBase.exists()
SelectBase.get()
CompoundSelectQuery
Select
Select.columns()
Select.select()
Select.select_extend()
Select.from_()
Select.join()
Select.group_by()
Select.group_by_extend()
Select.having()
Select.distinct()
Select.window()
Select.for_update()
_WriteQuery
_WriteQuery.returning()
Update
Update.from_()
Insert
Insert.on_conflict_ignore()
Insert.on_conflict_replace()
Insert.on_conflict()
Delete
Index
Index.safe()
Index.where()
Index.using()
ModelIndex
Field
Field.column
Field.model
Field.name
Field.db_value()
Field.python_value()
Field.coerce()
IntegerField
BigIntegerField
SmallIntegerField
AutoField
BigAutoField
IdentityField
FloatField
DoubleField
DecimalField
CharField
FixedCharField
TextField
BlobField
BitField
BitField.flag()
BigBitField
BigBitField.set_bit()
BigBitField.clear_bit()
BigBitField.toggle_bit()
BigBitField.is_set()
UUIDField
BinaryUUIDField
DateTimeField
DateTimeField.year
DateTimeField.month
DateTimeField.day
DateTimeField.hour
DateTimeField.minute
DateTimeField.second
DateTimeField.to_timestamp()
DateTimeField.truncate()
DateField
DateField.year
DateField.month
DateField.day
DateField.to_timestamp()
DateField.truncate()
TimeField
TimeField.hour
TimeField.minute
TimeField.second
TimestampField
IPField
BooleanField
BareField
ForeignKeyField
DeferredForeignKey
ManyToManyField
ManyToManyField.through_model
ManyToManyField.add()
ManyToManyField.remove()
ManyToManyField.clear()
ManyToManyField.get_through_model()
DeferredThroughModel
CompositeKey
SchemaManager
SchemaManager.create_table()
SchemaManager.drop_table()
SchemaManager.truncate_table()
SchemaManager.create_indexes()
SchemaManager.drop_indexes()
SchemaManager.create_sequence()
SchemaManager.drop_sequence()
SchemaManager.create_foreign_key()
SchemaManager.create_all()
SchemaManager.drop_all()
Metadata
Metadata.table
Metadata.model_graph()
Metadata.set_database()
Metadata.set_table_name()
SubclassAwareMetadata
SubclassAwareMetadata.map_models()
Model
Model.alias()
Model.select()
Model.update()
Model.insert()
Model.insert_many()
Model.insert_from()
Model.replace()
Model.replace_many()
Model.raw()
Model.delete()
Model.create()
Model.bulk_create()
Model.bulk_update()
Model.get()
Model.get_or_none()
Model.get_by_id()
Model.set_by_id()
Model.delete_by_id()
Model.get_or_create()
Model.filter()
Model.get_id()
Model.save()
Model.dirty_fields
Model.is_dirty()
Model.delete_instance()
Model.bind()
Model.bind_ctx()
Model.table_exists()
Model.create_table()
Model.drop_table()
Model.truncate_table()
Model.index()
Model.add_index()
Model.dependencies()
Model.__iter__()
Model.__len__()
ModelAlias
ModelSelect
ModelSelect.switch()
ModelSelect.objects()
ModelSelect.join()
ModelSelect.join_from()
ModelSelect.filter()
ModelSelect.prefetch()
prefetch()
AliasManager
AliasManager.add()
AliasManager.get()
AliasManager.__setitem__()
AliasManager.push()
AliasManager.pop()
State
Context
Context.scope
Context.parentheses
Context.subquery
Context.scope_normal()
Context.scope_source()
Context.scope_values()
Context.scope_cte()
Context.scope_column()
Context.sql()
Context.literal()
Context.parse()
Context.query()
Proxy
Proxy.initialize()
Proxy.attach_callback()
DatabaseProxy
chunked()
SqliteExtDatabase
CSqliteExtDatabase
CSqliteExtDatabase.on_commit()
CSqliteExtDatabase.on_rollback()
CSqliteExtDatabase.on_update()
CSqliteExtDatabase.changes()
CSqliteExtDatabase.autocommit
CSqliteExtDatabase.backup()
CSqliteExtDatabase.backup_to_file()
CSqliteExtDatabase.blob_open()
RowIDField
DocIDField
AutoIncrementField
JSONField
JSONField.__getitem__()
JSONField.set()
JSONField.update()
JSONField.remove()
JSONField.json_type()
JSONField.length()
JSONField.children()
JSONField.tree()
JSONPath
JSONPath.__getitem__()
JSONPath.set()
JSONPath.update()
JSONPath.remove()
JSONPath.json_type()
JSONPath.length()
JSONPath.children()
JSONPath.tree()
SearchField
SearchField.match()
VirtualModel
FTSModel
FTSModel.match()
FTSModel.search()
FTSModel.search_bm25()
FTSModel.search_bm25f()
FTSModel.search_lucene()
FTSModel.rank()
FTSModel.bm25()
FTSModel.bm25f()
FTSModel.lucene()
FTSModel.rebuild()
FTSModel.optimize()
FTS5Model
FTS5Model.fts5_installed()
FTS5Model.search()
FTS5Model.search_bm25()
FTS5Model.rank()
FTS5Model.bm25()
FTS5Model.VocabModel()
TableFunction
TableFunction.columns
TableFunction.params
TableFunction.name
TableFunction.initialize()
TableFunction.iterate()
TableFunction.register()
ClosureTable()
BaseClosureTable
BaseClosureTable.id
BaseClosureTable.depth
BaseClosureTable.root
BaseClosureTable.descendants()
BaseClosureTable.ancestors()
BaseClosureTable.siblings()
LSMTable
ZeroBlob
Blob
Blob.read()
Blob.seek()
Blob.tell()
Blob.write()
Blob.close()
Blob.reopen()
if_then_else()
strip_tz()
humandelta()
mintdiff()
avgtdiff()
duration()
date_series()
file_ext()
file_read()
gzip()
gunzip()
hostname()
toggle()
setting()
clear_toggles()
clear_settings()
randomrange()
gauss_distribution()
sqrt()
tonumber()
mode()
minrange()
avgrange()
range()
median()
substr_count()
strip_chars()
damerau_levenshtein_dist()
levenshtein_dist()
str_dist()
regex_search()
APSWDatabase
APSWDatabase.register_module()
APSWDatabase.unregister_module()
SqlCipherDatabase
SqlCipherDatabase.rekey()
IntervalField
PostgresqlExtDatabase
ServerSide()
ArrayField
ArrayField.contains()
ArrayField.contains_any()
DateTimeTZField
HStoreField
HStoreField.keys()
HStoreField.values()
HStoreField.items()
HStoreField.slice()
HStoreField.exists()
HStoreField.defined()
HStoreField.update()
HStoreField.delete()
HStoreField.contains()
HStoreField.contains_any()
BinaryJSONField
BinaryJSONField.contains()
BinaryJSONField.contains_any()
BinaryJSONField.contains_all()
BinaryJSONField.contained_by()
BinaryJSONField.concat()
BinaryJSONField.has_key()
BinaryJSONField.remove()
Match()
TSVectorField
TSVectorField.match()
CockroachDatabase
CockroachDatabase.run_transaction()
PooledCockroachDatabase
run_transaction()
UUIDKeyField
DataSet
DataSet.tables
DataSet.__getitem__()
DataSet.query()
DataSet.transaction()
DataSet.freeze()
DataSet.thaw()
DataSet.connect()
DataSet.close()
Table.columns
Table.model_class
Table.create_index()
Table.find()
Table.find_one()
Table.all()
Table.freeze()
Table.thaw()
CompressedField
PickleField
hybrid_method
hybrid_method.expression()
hybrid_property
KeyValue
KeyValue.__contains__()
KeyValue.__len__()
KeyValue.__getitem__()
KeyValue.__setitem__()
KeyValue.__delitem__()
KeyValue.keys()
KeyValue.values()
KeyValue.items()
KeyValue.update()
KeyValue.get()
KeyValue.pop()
KeyValue.clear()
model_to_dict()
dict_to_model()
update_model_from_dict()
Signal
Signal.connect()
Signal.disconnect()
Signal.send()
migrate()
SchemaMigrator
SchemaMigrator.add_column()
SchemaMigrator.drop_column()
SchemaMigrator.rename_column()
SchemaMigrator.add_not_null()
SchemaMigrator.drop_not_null()
SchemaMigrator.alter_column_type()
SchemaMigrator.rename_table()
SchemaMigrator.add_index()
SchemaMigrator.drop_index()
SchemaMigrator.add_constraint()
SchemaMigrator.drop_constraint()
SchemaMigrator.add_unique()
PostgresqlMigrator
PostgresqlMigrator.set_search_path()
SqliteMigrator
MySQLMigrator
generate_models()
print_model()
print_table_sql()
Introspector
Introspector.from_database()
Introspector.generate_models()
connect()
parse()
register_database()
PooledDatabase
PooledDatabase.manual_close()
PooledDatabase.close_idle()
PooledDatabase.close_stale()
PooledDatabase.close_all()
PooledPostgresqlDatabase
PooledPostgresqlExtDatabase
PooledMySQLDatabase
PooledSqliteDatabase
PooledSqliteExtDatabase
count_queries
count_queries.count
count_queries.get_queries()
assert_query_count()
get_object_or_404()
object_list()
PaginatedQuery
PaginatedQuery.get_page()
PaginatedQuery.get_page_count()
PaginatedQuery.get_object_list()