Class DatabaseOperations

Declaration

Methods

• ▶ def adapt_datefield_value(self, value) override

  inherited doc Transform a date value to an object compatible with what is expected by the backend driver for date columns.

  source link

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

• ▶ 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_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_ipaddressfield_value(self, value) override

  inherited doc Transform a string representation of an IP address into the expected type for the backend driver.

  source link

  This method overrides django.db.backends.base.operations.BaseDatabaseOperations.adapt_ipaddressfield_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_insert_sql(self, fields, placeholder_rows)

  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 distinct_sql(self, fields, params) override

  inherited doc Return an SQL DISTINCT clause which removes duplicate rows from the result set. If any fields are given, only check the given fields for duplicates.

  source link

  This method overrides django.db.backends.base.operations.BaseDatabaseOperations.distinct_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 ignore_conflicts_suffix_sql(self, ignore_conflicts=None) override

  source link

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

• ▶ 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

  Return the maximum length of an identifier.

  source link

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

  The maximum length of an identifier is 63 by default, but can be
  changed by recompiling PostgreSQL after editing the NAMEDATALEN
  macro in src/include/pg_config_manual.h.
  
  This implementation returns 63, but can be overridden by a custom
  database backend that inherits most of its behavior from this one.

• ▶ 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 prep_for_iexact_query(self, x)

  source link
• ▶ def prepare_sql_script(self, sql) override

  inherited doc Take an SQL script that may contain multiple lines and return a list of statements to feed to successive cursor.execute() calls.

  source link

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

  Since few databases are able to process raw SQL scripts in a single
  cursor.execute() call and PEP 249 doesn't talk about this use case,
  the default implementation is conservative.

• ▶ 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 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 set_time_zone_sql(self) override

  inherited doc Return the SQL that will set the connection's time zone.

  source link

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

  Return '' if the backend doesn't support time zones.

• ▶ 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 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.

• ▶ def unification_cast_sql(self, output_field) override

  inherited doc Given a field instance, return the SQL that casts the result of a union to that type. The resulting string should contain a '%s' placeholder for the expression being cast.

  source link

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

Inherited methods

• Methods inherited from django.db.backends.base.operations.BaseDatabaseOperations:
  __init__, adapt_unknown_value, autoinc_sql, binary_placeholder_sql, bulk_batch_size, cache_key_culling_sql, check_expression_support, combine_duration_expression, combine_expression, compiler, conditional_expression_supported_in_where_clause, convert_durationfield_value, end_transaction_sql, execute_sql_flush, fetch_returned_insert_columns, field_cast_sql, for_update_sql, force_no_ordering, get_db_converters, insert_statement, integer_field_range, last_insert_id, limit_offset_sql, max_in_list_size, modify_insert_params, pk_default_value, prep_for_like_query, process_clob, regex_lookup, savepoint_commit_sql, savepoint_create_sql, savepoint_rollback_sql, start_transaction_sql, time_extract_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.postgis.operations.PostGISOperations

Reexports

• Imported in django.contrib.gis.db.backends.postgis.operations.
• Imported in django.db.backends.postgresql.base.

Generated by nedoc v0.9 at 2020-12-29 14:04