Class DatabaseOperations

django.db.backends.mysql.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 binary_placeholder_sql(self, value) override
inherited doc Some backends require special syntax to insert binary content (MySQL for example uses '_binary %s').
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.binary_placeholder_sql.
▷ def bulk_insert_sql(self, fields, placeholder_rows)
source link
▶ 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_datetimefield_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
inherited doc Given a lookup_type of 'year', 'month', or 'day', return the SQL that extracts a value from the given date field 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 explain_query_prefix(self, format=None, **options) override
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.explain_query_prefix.
▷ def fetch_returned_insert_rows(self, cursor)
Given a cursor object that has just performed an INSERT...RETURNING statement into a table, return the tuple of returned data.
source link
▶ def force_no_ordering(self) override
"ORDER BY NULL" prevents MySQL from implicitly ordering by grouped columns. If no ordering would otherwise be applied, we don't want any implicit sorting going on.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.force_no_ordering.
▷ def format_for_duration_arithmetic(self, sql)
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 insert_statement(self, ignore_conflicts=False) override
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.insert_statement.
▶ 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 lookup_cast(self, lookup_type, internal_type=None) override
inherited doc Return the string to use in a query when performing lookups ("contains", "like", etc.). It should contain a '%s' placeholder for the column being searched against.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.lookup_cast.
▶ def max_name_length(self) override
inherited doc Return the maximum length of table and column names, or None if there is no limit.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.max_name_length.
▶ 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 regex_lookup(self, lookup_type) override
inherited doc Return the string to use in a query when performing regular expression lookups (using "regex" or "iregex"). It should contain a '%s' placeholder for the column being searched against.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.regex_lookup.
```
If the feature is not supported (or part of it is not supported), raise
NotImplementedError.
```
▶ def return_insert_columns(self, fields) override
inherited doc For backends that support returning columns as part of an insert query, return the SQL and params to append to the INSERT query. The returned fragment should contain a format string to hold the appropriate column.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.return_insert_columns.
▶ 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_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.
```
▶ def validate_autopk_value(self, value) override
inherited doc Certain backends do not accept some values for "serial" fields (for example zero in MySQL). Raise a ValueError if the value is invalid, otherwise return the validated value.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.validate_autopk_value.

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, bulk_batch_size, cache_key_culling_sql, check_expression_support, combine_duration_expression, compiler, conditional_expression_supported_in_where_clause, convert_durationfield_value, deferrable_sql, distinct_sql, end_transaction_sql, execute_sql_flush, fetch_returned_insert_columns, field_cast_sql, for_update_sql, ignore_conflicts_suffix_sql, integer_field_range, last_insert_id, limit_offset_sql, max_in_list_size, modify_insert_params, prep_for_like_query, prepare_sql_script, process_clob, savepoint_commit_sql, savepoint_create_sql, savepoint_rollback_sql, sequence_reset_sql, set_time_zone_sql, start_transaction_sql, tablespace_sql, time_extract_sql, unification_cast_sql, 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.mysql.operations.MySQLOperations

Reexports