class OracleOperations(BaseSpatialOperations, DatabaseOperations): (source)
Undocumented
Method | convert |
Undocumented |
Method | geo |
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 |
Undocumented |
Method | geometry |
Undocumented |
Method | get |
Undocumented |
Method | get |
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. |
Method | get |
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. |
Method | get |
Undocumented |
Method | modify |
Drop out insert parameters for NULL placeholder. Needed for Oracle Spatial backend due to #10888. |
Method | spatial |
Return the spatial aggregate SQL name. |
Method | spatial |
Undocumented |
Class Variable | disallowed |
Undocumented |
Class Variable | extent |
Undocumented |
Class Variable | from |
Undocumented |
Class Variable | function |
Undocumented |
Class Variable | gis |
Undocumented |
Class Variable | name |
Undocumented |
Class Variable | oracle |
Undocumented |
Class Variable | select |
Undocumented |
Class Variable | unionagg |
Undocumented |
Class Variable | unsupported |
Undocumented |
Inherited from BaseSpatialOperations
:
Method | check |
Undocumented |
Method | convert |
Undocumented |
Method | get |
Undocumented |
Method | get |
Undocumented |
Method | spatial |
Undocumented |
Class Variable | distance |
Undocumented |
Class Variable | geom |
Undocumented |
Class Variable | mariadb |
Undocumented |
Class Variable | mysql |
Undocumented |
Class Variable | postgis |
Undocumented |
Class Variable | spatial |
Undocumented |
Class Variable | spatialite |
Undocumented |
Property | select |
Undocumented |
Inherited from DatabaseOperations
(via BaseSpatialOperations
):
Static Method | convert |
Undocumented |
Static Method | convert |
Undocumented |
Method | adapt |
Transform a date value to an object compatible with what is expected by the backend driver for date columns. The default implementation transforms the date to text, but that is not necessary for Oracle. |
Method | adapt |
Transform a datetime value to an object compatible with what is expected by the backend driver for datetime columns. |
Method | adapt |
Transform a decimal.Decimal value to an object compatible with what is expected by the backend driver for decimal (numeric) columns. |
Method | adapt |
Transform a time value to an object compatible with what is expected by the backend driver for time columns. |
Method | bulk |
Oracle restricts the number of parameters in a query. |
Method | bulk |
Undocumented |
Method | cache |
Return an SQL query that retrieves the first cache key greater than the n smallest. |
Method | combine |
Combine a list of subexpressions into a single expression, using the provided connecting operator. This is required because operators can vary between backends (e.g., Oracle with %% and &) and between subexpression types (e... |
Method | conditional |
Oracle supports only EXISTS(...) or filters in the WHERE clause, others must be compared with True. |
Method | convert |
Undocumented |
Method | convert |
Undocumented |
Method | convert |
Undocumented |
Method | convert |
Undocumented |
Method | convert |
Undocumented |
Method | convert |
Undocumented |
Method | convert |
Undocumented |
Method | date |
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 |
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 |
Return the SQL to cast a datetime value to date value. |
Method | datetime |
Return the SQL to cast a datetime value to time value. |
Method | datetime |
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 |
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 |
Return the SQL to make a constraint "initially deferred" during a CREATE TABLE statement. |
Method | fetch |
Given a cursor object that has just performed an INSERT...RETURNING statement into a table, return the newly created data. |
Method | field |
Given a column type (e.g. 'BLOB', 'VARCHAR') and an internal type (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. |
Method | last |
Return a string of the query last executed by the given cursor, with placeholders replaced with actual values. |
Method | last |
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 |
Return LIMIT/OFFSET SQL clause. |
Method | lookup |
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 |
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 |
Return the maximum length of table and column names, or None if there is no limit. |
Method | no |
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 |
Return the value to use during an INSERT statement to specify that the field should use its default value. |
Method | prep |
Undocumented |
Method | process |
Return the value of a CLOB column, for backends that return a locator object that requires additional processing. |
Method | quote |
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 |
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 |
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 |
Return a list of the SQL statements required to reset sequences passed in `sequences`. |
Method | sequence |
Return a list of the SQL statements required to reset sequences for the given models. |
Method | sql |
Return a list of SQL statements required to remove all data from the given database tables (without actually removing the tables themselves). |
Method | start |
Return the SQL statement required to start a transaction. |
Method | subtract |
Undocumented |
Method | tablespace |
Return the SQL that will be used in a query to define the tablespace. |
Method | time |
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 | cast |
Undocumented |
Class Variable | cast |
Undocumented |
Class Variable | integer |
Undocumented |
Class Variable | set |
Undocumented |
Method | __foreign |
Undocumented |
Method | _convert |
Undocumented |
Method | _get |
Manually created sequence name to keep backward compatibility for AutoFields that aren't Oracle identity columns. |
Method | _get |
Undocumented |
Method | _prepare |
Undocumented |
Class Variable | _extract |
Undocumented |
Class Variable | _sequence |
Undocumented |
Class Variable | _tzname |
Undocumented |
Property | _foreign |
Undocumented |
Inherited from BaseDatabaseOperations
(via BaseSpatialOperations
, DatabaseOperations
):
Method | __init__ |
Undocumented |
Method | adapt |
Transform a string representation of an IP address into the expected type for the backend driver. |
Method | adapt |
Transform a value to something compatible with the backend driver. |
Method | autoinc |
Return any SQL needed to support auto-incrementing primary keys, or None if no SQL is necessary. |
Method | binary |
Some backends require special syntax to insert binary content (MySQL for example uses '_binary %s'). |
Method | combine |
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 |
Undocumented |
Method | distinct |
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 |
Return the SQL statement required to end a transaction. |
Method | execute |
Execute a list of SQL statements to flush the database. |
Method | explain |
Undocumented |
Method | for |
Return the FOR UPDATE SQL clause to lock rows for an update operation. |
Method | force |
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 | format |
Undocumented |
Method | insert |
Undocumented |
Method | integer |
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 | on |
Undocumented |
Method | prep |
Prepare a value for use in a LIKE query. |
Method | prepare |
Take an SQL script that may contain multiple lines and return a list of statements to feed to successive cursor.execute() calls. |
Method | savepoint |
Return the SQL for committing the given savepoint. |
Method | savepoint |
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 |
Return the SQL for rolling back the given savepoint. |
Method | set |
Return the SQL that will set the connection's time zone. |
Method | time |
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 |
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 |
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 |
Undocumented |
Method | window |
Undocumented |
Method | window |
Return SQL for start and end points in an OVER clause window frame. |
Method | window |
Undocumented |
Method | year |
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 |
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. |
Constant | CURRENT |
Undocumented |
Constant | FOLLOWING |
Undocumented |
Constant | PRECEDING |
Undocumented |
Constant | UNBOUNDED |
Undocumented |
Constant | UNBOUNDED |
Undocumented |
Class Variable | compiler |
Undocumented |
Class Variable | explain |
Undocumented |
Instance Variable | connection |
Undocumented |
Method | _get |
Undocumented |
Instance Variable | _cache |
Undocumented |
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.
django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.get_area_att_for_field
Undocumented
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.
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.
django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.get_geometry_converter
Undocumented
django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.spatial_aggregate_name
Return the spatial aggregate SQL name.
django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.disallowed_aggregates
Undocumented
django.contrib.gis.db.backends.base.operations.BaseSpatialOperations.unsupported_functions
Undocumented