django.contrib.gis.db.backends.oracle.operations.OracleOperations

class documentation

class OracleOperations(BaseSpatialOperations, DatabaseOperations):

View In Hierarchy

Undocumented

Method convert​_extent Undocumented
Method geo​_db​_type Return the geometry database type for Oracle. Unlike other spatial backends, no stored procedure is necessary and it's the same for all geometry types.
Method geo​_quote​_name Undocumented
Method geometry​_columns Undocumented
Method get​_area​_att​_for​_field Undocumented
Method get​_distance No summary
Method get​_geom​_placeholder No summary
Method get​_geometry​_converter Undocumented
Method modify​_insert​_params Drop out insert parameters for NULL placeholder. Needed for Oracle Spatial backend due to #10888.
Method spatial​_aggregate​_name Return the spatial aggregate SQL name.
Method spatial​_ref​_sys Undocumented
Class Variable disallowed​_aggregates Undocumented
Class Variable extent Undocumented
Class Variable from​_text Undocumented
Class Variable function​_names Undocumented
Class Variable gis​_operators Undocumented
Class Variable name Undocumented
Class Variable oracle Undocumented
Class Variable select Undocumented
Class Variable unionagg Undocumented
Class Variable unsupported​_functions Undocumented

Inherited from BaseSpatialOperations:

Method check​_expression​_support Undocumented
Method convert​_extent3d Undocumented
Method get​_db​_converters Undocumented
Method get​_distance​_att​_for​_field Undocumented
Method spatial​_function​_name Undocumented
Class Variable distance​_expr​_for​_lookup Undocumented
Class Variable geom​_func​_prefix Undocumented
Class Variable mariadb Undocumented
Class Variable mysql Undocumented
Class Variable postgis Undocumented
Class Variable spatial​_version Undocumented
Class Variable spatialite Undocumented
Property select​_extent Undocumented

Inherited from DatabaseOperations:

Static Method convert​_empty​_bytes Undocumented
Static Method convert​_empty​_string Undocumented
Method __foreign​_key​_constraints Undocumented
Method ​_convert​_field​_to​_tz Undocumented
Method ​_get​_no​_autofield​_sequence​_name Manually created sequence name to keep backward compatibility for AutoFields that aren't Oracle identity columns.
Method ​_get​_sequence​_name Undocumented
Method ​_prepare​_tzname​_delta Undocumented
Method adapt​_datefield​_value No summary
Method adapt​_datetimefield​_value Transform a datetime value to an object compatible with what is expected by the backend driver for datetime columns.
Method adapt​_decimalfield​_value Transform a decimal.Decimal value to an object compatible with what is expected by the backend driver for decimal (numeric) columns.
Method adapt​_timefield​_value Transform a time value to an object compatible with what is expected by the backend driver for time columns.
Method bulk​_batch​_size Oracle restricts the number of parameters in a query.
Method bulk​_insert​_sql Undocumented
Method cache​_key​_culling​_sql Return an SQL query that retrieves the first cache key greater than the n smallest.
Method combine​_expression No summary
Method conditional​_expression​_supported​_in​_where​_clause Oracle supports only EXISTS(...) or filters in the WHERE clause, others must be compared with True.
Method convert​_binaryfield​_value Undocumented
Method convert​_booleanfield​_value Undocumented
Method convert​_datefield​_value Undocumented
Method convert​_datetimefield​_value Undocumented
Method convert​_textfield​_value Undocumented
Method convert​_timefield​_value Undocumented
Method convert​_uuidfield​_value Undocumented
Method date​_extract​_sql Given a lookup_type of 'year', 'month', or 'day', return the SQL that extracts a value from the given date field field_name.
Method date​_trunc​_sql 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.
Method datetime​_cast​_date​_sql Return the SQL to cast a datetime value to date value.
Method datetime​_cast​_time​_sql Return the SQL to cast a datetime value to time value.
Method datetime​_extract​_sql 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.
Method datetime​_trunc​_sql 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.
Method deferrable​_sql Return the SQL to make a constraint "initially deferred" during a CREATE TABLE statement.
Method fetch​_returned​_insert​_columns Given a cursor object that has just performed an INSERT...RETURNING statement into a table, return the newly created data.
Method field​_cast​_sql No summary
Method get​_db​_converters Return a list of functions needed to convert field data.
Method last​_executed​_query Return a string of the query last executed by the given cursor, with placeholders replaced with actual values.
Method last​_insert​_id 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.
Method limit​_offset​_sql Return LIMIT/OFFSET SQL clause.
Method lookup​_cast 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.
Method max​_in​_list​_size 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.
Method max​_name​_length Return the maximum length of table and column names, or None if there is no limit.
Method no​_limit​_value 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.
Method pk​_default​_value Return the value to use during an INSERT statement to specify that the field should use its default value.
Method prep​_for​_iexact​_query Undocumented
Method process​_clob Return the value of a CLOB column, for backends that return a locator object that requires additional processing.
Method quote​_name Return a quoted version of the given table, index, or column name. Do not quote the given name if it's already been quoted.
Method regex​_lookup 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.
Method return​_insert​_columns 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.
Method sequence​_reset​_by​_name​_sql Return a list of the SQL statements required to reset sequences passed in sequences.
Method sequence​_reset​_sql Return a list of the SQL statements required to reset sequences for the given models.
Method sql​_flush Return a list of SQL statements required to remove all data from the given database tables (without actually removing the tables themselves).
Method start​_transaction​_sql Return the SQL statement required to start a transaction.
Method subtract​_temporals Undocumented
Method tablespace​_sql Return the SQL that will be used in a query to define the tablespace.
Method time​_trunc​_sql 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.
Class Variable ​_sequence​_reset​_sql Undocumented
Class Variable ​_tzname​_re Undocumented
Class Variable cast​_char​_field​_without​_max​_length Undocumented
Class Variable cast​_data​_types Undocumented
Class Variable integer​_field​_ranges Undocumented
Class Variable set​_operators Undocumented
Property ​_foreign​_key​_constraints Undocumented

Inherited from BaseDatabaseOperations (via DatabaseOperations):

Constant CURRENT​_ROW Undocumented
Constant FOLLOWING Undocumented
Constant PRECEDING Undocumented
Constant UNBOUNDED​_FOLLOWING Undocumented
Constant UNBOUNDED​_PRECEDING Undocumented
Method __init__ Undocumented
Method ​_get​_limit​_offset​_params Undocumented
Method adapt​_ipaddressfield​_value Transform a string representation of an IP address into the expected type for the backend driver.
Method adapt​_unknown​_value Transform a value to something compatible with the backend driver.
Method autoinc​_sql Return any SQL needed to support auto-incrementing primary keys, or None if no SQL is necessary.
Method binary​_placeholder​_sql Some backends require special syntax to insert binary content (MySQL for example uses '_binary %s').
Method check​_expression​_support Check that the backend supports the provided expression.
Method combine​_duration​_expression Undocumented
Method compiler Return the SQLCompiler class corresponding to the given name, in the namespace corresponding to the compiler_module attribute on this backend.
Method convert​_durationfield​_value Undocumented
Method distinct​_sql 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.
Method end​_transaction​_sql Return the SQL statement required to end a transaction.
Method execute​_sql​_flush Execute a list of SQL statements to flush the database.
Method explain​_query​_prefix Undocumented
Method for​_update​_sql Return the FOR UPDATE SQL clause to lock rows for an update operation.
Method force​_no​_ordering Return a list used in the "ORDER BY" clause to force no ordering at all. Return an empty list to include nothing in the ordering.
Method ignore​_conflicts​_suffix​_sql Undocumented
Method insert​_statement Undocumented
Method integer​_field​_range 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.
Method prep​_for​_like​_query Prepare a value for use in a LIKE query.
Method prepare​_sql​_script Take an SQL script that may contain multiple lines and return a list of statements to feed to successive cursor.execute() calls.
Method savepoint​_commit​_sql Return the SQL for committing the given savepoint.
Method savepoint​_create​_sql Return the SQL for starting a new savepoint. Only required if the "uses_savepoints" feature is True. The "sid" parameter is a string for the savepoint id.
Method savepoint​_rollback​_sql Return the SQL for rolling back the given savepoint.
Method set​_time​_zone​_sql Return the SQL that will set the connection's time zone.
Method time​_extract​_sql Given a lookup_type of 'hour', 'minute', or 'second', return the SQL that extracts a value from the given time field field_name.
Method unification​_cast​_sql 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.
Method validate​_autopk​_value 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.
Method window​_frame​_end Undocumented
Method window​_frame​_range​_start​_end Undocumented
Method window​_frame​_rows​_start​_end Return SQL for start and end points in an OVER clause window frame.
Method window​_frame​_start Undocumented
Method year​_lookup​_bounds​_for​_date​_field Return a two-elements list with the lower and upper bound to be used with a BETWEEN operator to query a DateField value using a year lookup.
Method year​_lookup​_bounds​_for​_datetime​_field Return a two-elements list with the lower and upper bound to be used with a BETWEEN operator to query a DateTimeField value using a year lookup.
Class Variable compiler​_module Undocumented
Class Variable explain​_prefix Undocumented
Instance Variable ​_cache Undocumented
Instance Variable connection Undocumented
def convert_extent(self, clob):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.convert_extent

Undocumented

def geo_db_type(self, f):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.geo_db_type
Return the geometry database type for Oracle. Unlike other spatial backends, no stored procedure is necessary and it's the same for all geometry types.
def geo_quote_name(self, name):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.geo_quote_name

Undocumented

def geometry_columns(self):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.geometry_columns

Undocumented

def get_area_att_for_field(self, field):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.get_area_att_for_field

Undocumented

def get_distance(self, f, value, lookup_type):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.get_distance
Return the distance parameters given the value and the lookup type. On Oracle, geometry columns with a geodetic coordinate system behave implicitly like a geography column, and thus meters will be used as the distance parameter on them.
def get_geom_placeholder(self, f, value, compiler):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.get_geom_placeholder
Return the placeholder for the given geometry field with the given value. Depending on the spatial backend, the placeholder may contain a stored procedure call to the transformation function of the spatial backend.
def get_geometry_converter(self, expression):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.get_geometry_converter

Undocumented

def modify_insert_params(self, placeholder, params):
overrides django.db.backends.base.operations.BaseDatabaseOperations.modify_insert_params
Drop out insert parameters for NULL placeholder. Needed for Oracle Spatial backend due to #10888.
def spatial_aggregate_name(self, agg_name):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.spatial_aggregate_name
Return the spatial aggregate SQL name.
def spatial_ref_sys(self):
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.spatial_ref_sys

Undocumented

disallowed_aggregates =
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.disallowed_aggregates

Undocumented

extent: str =

Undocumented

from_text: str =
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.from_text

Undocumented

function_names: dict[str, str] =
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.function_names

Undocumented

gis_operators =

Undocumented

name: str =

Undocumented

oracle: bool =
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.oracle

Undocumented

select: str =
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.select

Undocumented

unionagg: str =

Undocumented

unsupported_functions: set[str] =
overrides django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.unsupported_functions

Undocumented