Class DatabaseOperations

django.db.backends.oracle.operations.DatabaseOperations

Declaration

class DatabaseOperations(BaseDatabaseOperations)

Methods

▶ def adapt_datefield_value(self, value) override
Transform a date value to an object compatible with what is expected
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.adapt_datefield_value.
```
by the backend driver for date columns.
The default implementation transforms the date to text, but that is not
necessary for Oracle.
```
▶ def adapt_datetimefield_value(self, value) override
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.
```
If naive datetime is passed assumes that is in UTC. Normally Django
models.DateTimeField makes sure that if USE_TZ is True passed datetime
is timezone aware.
```
▶ def adapt_decimalfield_value(self, value, max_digits=None, decimal_places=None) override
inherited doc Transform a decimal.Decimal value to an object compatible with what is expected by the backend driver for decimal (numeric) columns.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.adapt_decimalfield_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
Oracle restricts the number of parameters in a query.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.bulk_batch_size.
▷ def bulk_insert_sql(self, fields, placeholder_rows)
source link
▶ def cache_key_culling_sql(self) override
inherited doc Return an SQL query that retrieves the first cache key greater than the n smallest.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.cache_key_culling_sql.
```
This is used by the 'db' cache backend to determine where to start
culling.
```
▶ 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 conditional_expression_supported_in_where_clause(self, expression) override
Oracle supports only EXISTS(...) or filters in the WHERE clause, others must be compared with True.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.conditional_expression_supported_in_where_clause.
▷ def convert_binaryfield_value(self, value, expression, connection)
source link
▷ 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_textfield_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
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 deferrable_sql(self) override
inherited doc Return the SQL to make a constraint "initially deferred" during a CREATE TABLE statement.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.deferrable_sql.
▶ def fetch_returned_insert_columns(self, cursor, returning_params) override
inherited doc Given a cursor object that has just performed an INSERT...RETURNING statement into a table, return the newly created data.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.fetch_returned_insert_columns.
▶ def field_cast_sql(self, db_type, internal_type) override
inherited doc Given a column type (e.g. 'BLOB', 'VARCHAR') and an internal type
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.field_cast_sql.
```
(e.g. 'GenericIPAddressField'), return the SQL to cast it before using
it in a WHERE statement. The resulting string should contain a '%s'
placeholder for the column being searched against.
```
▶ 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 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 last_insert_id(self, cursor, table_name, pk_name) override
inherited doc Given a cursor object that has just performed an INSERT statement into a table that has an auto-incrementing ID, return the newly created ID.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.last_insert_id.
```
`pk_name` is the name of the primary-key column.
```
▶ def limit_offset_sql(self, low_mark, high_mark) override
inherited doc Return LIMIT/OFFSET SQL clause.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.limit_offset_sql.
▶ 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_in_list_size(self) override
inherited doc Return the maximum number of items that can be passed in a single 'IN' list condition, or None if the backend does not impose a limit.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.max_in_list_size.
▶ 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 prep_for_iexact_query(self, x)
source link
▶ def process_clob(self, value) override
inherited doc Return the value of a CLOB column, for backends that return a locator object that requires additional processing.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.process_clob.
▶ 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 sequence_reset_sql(self, style, model_list) override
inherited doc Return a list of the SQL statements required to reset sequences for the given models.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.sequence_reset_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 start_transaction_sql(self) override
inherited doc Return the SQL statement required to start a transaction.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.start_transaction_sql.
▶ def subtract_temporals(self, internal_type, lhs, rhs) override
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.subtract_temporals.
▶ def tablespace_sql(self, tablespace, inline=False) override
inherited doc Return the SQL that will be used in a query to define the tablespace.
source link
This method overrides django.db.backends.base.operations.BaseDatabaseOperations.tablespace_sql.
```
Return '' if the backend doesn't support tablespaces.

If `inline` is True, append the SQL to a row; otherwise append it to
the entire CREATE TABLE or CREATE INDEX statement.
```
▶ 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.
```

Class methods

▷ def convert_empty_bytes(value, expression, connection) @staticmethod
@staticmethod
def convert_empty_bytes(
value,
expression,
connection,
)
source link
▷ def convert_empty_string(value, expression, connection) @staticmethod
@staticmethod
def convert_empty_string(
value,
expression,
connection,
)
source link

Django

Class DatabaseOperations

Declaration

Methods

Class methods

Inherited methods

Subclasses

Reexports