Class DatabaseOperations

django.db.backends.sqlite3.operations.DatabaseOperations

Declaration

class DatabaseOperations(BaseDatabaseOperations)

Methods

▶ def adapt_datetimefield_value(self, value) override
inherited doc Transform a datetime value to an object compatible with what is expected by the backend driver for datetime columns.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.adapt_datetimefield_value.
▶ def adapt_timefield_value(self, value) override
inherited doc Transform a time value to an object compatible with what is expected by the backend driver for time columns.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.adapt_timefield_value.
▶ def bulk_batch_size(self, fields, objs) override
SQLite has a compile-time default (SQLITE_LIMIT_VARIABLE_NUMBER) of 999 variables per query.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.bulk_batch_size.
```
If there's only a single field to insert, the limit is 500
(SQLITE_MAX_COMPOUND_SELECT).
```
▷ def bulk_insert_sql(self, fields, placeholder_rows)
source link
▶ def check_expression_support(self, expression) override
inherited doc Check that the backend supports the provided expression.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.check_expression_support.
```
This is used on specific backends to rule out known expressions
that have problematic or nonexistent implementations. If the
expression has a known problem, the backend should raise
NotSupportedError.
```
▶ def combine_duration_expression(self, connector, sub_expressions) override
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.combine_duration_expression.
▶ def combine_expression(self, connector, sub_expressions) override
inherited doc Combine a list of subexpressions into a single expression, using
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.combine_expression.
```
the provided connecting operator. This is required because operators
can vary between backends (e.g., Oracle with %% and &) and between
subexpression types (e.g., date expressions).
```
▷ def convert_booleanfield_value(self, value, expression, connection)
source link
▷ def convert_datefield_value(self, value, expression, connection)
source link
▷ def convert_datetimefield_value(self, value, expression, connection)
source link
▷ def convert_timefield_value(self, value, expression, connection)
source link
▷ def convert_uuidfield_value(self, value, expression, connection)
source link
▶ def date_extract_sql(self, lookup_type, field_name) override
Support EXTRACT with a user-defined function django_date_extract() that's registered in connect(). Use single quotes because this is a string and could otherwise cause a collision with a field name.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.date_extract_sql.
▶ def date_trunc_sql(self, lookup_type, field_name, tzname=None) override
inherited doc Given a lookup_type of 'year', 'month', or 'day', return the SQL that truncates the given date or datetime field field_name to a date object with only the given specificity.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.date_trunc_sql.
```
If `tzname` is provided, the given value is truncated in a specific
timezone.
```
▶ def datetime_cast_date_sql(self, field_name, tzname) override
inherited doc Return the SQL to cast a datetime value to date value.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.datetime_cast_date_sql.
▶ def datetime_cast_time_sql(self, field_name, tzname) override
inherited doc Return the SQL to cast a datetime value to time value.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.datetime_cast_time_sql.
▶ def datetime_extract_sql(self, lookup_type, field_name, tzname) override
inherited doc Given a lookup_type of 'year', 'month', 'day', 'hour', 'minute', or 'second', return the SQL that extracts a value from the given datetime field field_name.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.datetime_extract_sql.
▶ def datetime_trunc_sql(self, lookup_type, field_name, tzname) override
inherited doc Given a lookup_type of 'year', 'month', 'day', 'hour', 'minute', or 'second', return the SQL that truncates the given datetime field field_name to a datetime object with only the given specificity.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.datetime_trunc_sql.
▷ def format_for_duration_arithmetic(self, sql)
Do nothing since formatting is handled in the custom function.
source link
▶ def get_db_converters(self, expression) override
inherited doc Return a list of functions needed to convert field data.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.get_db_converters.
```
Some field types on some backends do not provide data in the correct
format, this is the hook for converter functions.
```
▷ def get_decimalfield_converter(self, expression)
source link
▶ def insert_statement(self, ignore_conflicts=False) override
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.insert_statement.
▶ def integer_field_range(self, internal_type) override
inherited doc Given an integer field internal type (e.g. 'PositiveIntegerField'), return a tuple of the (min_value, max_value) form representing the range of the column type bound to the field.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.integer_field_range.
▶ def last_executed_query(self, cursor, sql, params) override
inherited doc Return a string of the query last executed by the given cursor, with placeholders replaced with actual values.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.last_executed_query.
```
`sql` is the raw query containing placeholders and `params` is the
sequence of parameters. These are used by default, but this method
exists for database backends to provide a better implementation
according to their own quoting schemes.
```
▶ def no_limit_value(self) override
inherited doc Return the value to use for the LIMIT when we are wanting "LIMIT infinity". Return None if the limit clause can be omitted in this case.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.no_limit_value.
▶ def pk_default_value(self) override
inherited doc Return the value to use during an INSERT statement to specify that the field should use its default value.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.pk_default_value.
▶ def quote_name(self, name) override
inherited doc Return a quoted version of the given table, index, or column name. Do not quote the given name if it's already been quoted.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.quote_name.
▶ def sequence_reset_by_name_sql(self, style, sequences) override
inherited doc Return a list of the SQL statements required to reset sequences passed in `sequences`.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.sequence_reset_by_name_sql.
```
The `style` argument is a Style object as returned by either
color_style() or no_style() in django.core.management.color.
```

▶ def sql_flush(self, style, tables, *, reset_sequences=False, allow_cascade=False) override

inherited doc Return a list of SQL statements required to remove all data from the given database tables (without actually removing the tables themselves).

source link

This method overrides django.db.backends.base.operations.BaseDatabaseOperations.sql_flush.

The `style` argument is a Style object as returned by either
color_style() or no_style() in django.core.management.color.

If `reset_sequences` is True, the list includes SQL statements required
to reset the sequences.

The `allow_cascade` argument determines whether truncation may cascade
to tables with foreign keys pointing the tables being truncated.
PostgreSQL requires a cascade even if these tables are empty.

▶ def subtract_temporals(self, internal_type, lhs, rhs) override
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.subtract_temporals.
▶ def time_extract_sql(self, lookup_type, field_name) override
inherited doc Given a lookup_type of 'hour', 'minute', or 'second', return the SQL that extracts a value from the given time field field_name.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.time_extract_sql.
▶ def time_trunc_sql(self, lookup_type, field_name, tzname=None) override
inherited doc Given a lookup_type of 'hour', 'minute' or 'second', return the SQL that truncates the given time or datetime field field_name to a time object with only the given specificity.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.time_trunc_sql.
```
If `tzname` is provided, the given value is truncated in a specific
timezone.
```

Inherited methods

Methods inherited from django.db.backends.base.operations.BaseDatabaseOperations:
__init__, adapt_datefield_value, adapt_decimalfield_value, adapt_ipaddressfield_value, adapt_unknown_value, autoinc_sql, binary_placeholder_sql, cache_key_culling_sql, compiler, conditional_expression_supported_in_where_clause, convert_durationfield_value, deferrable_sql, distinct_sql, end_transaction_sql, execute_sql_flush, explain_query_prefix, fetch_returned_insert_columns, field_cast_sql, for_update_sql, force_no_ordering, ignore_conflicts_suffix_sql, last_insert_id, limit_offset_sql, lookup_cast, max_in_list_size, max_name_length, modify_insert_params, prep_for_like_query, prepare_sql_script, process_clob, regex_lookup, return_insert_columns, savepoint_commit_sql, savepoint_create_sql, savepoint_rollback_sql, sequence_reset_sql, set_time_zone_sql, start_transaction_sql, tablespace_sql, unification_cast_sql, validate_autopk_value, window_frame_end, window_frame_range_start_end, window_frame_rows_start_end, window_frame_start, year_lookup_bounds_for_date_field, year_lookup_bounds_for_datetime_field

Subclasses

django.contrib.gis.db.backends.spatialite.operations.SpatiaLiteOperations

Reexports