django.db.backends.oracle.schema.DatabaseSchemaEditor

class documentation

class DatabaseSchemaEditor(BaseDatabaseSchemaEditor):

Known subclasses: django.contrib.gis.db.backends.oracle.schema.OracleGISSchemaEditor

Undocumented

Method	`_alter_column_collation_sql`	Undocumented
Method	`_alter_column_type_sql`	Hook to specialize column type alteration for different backends, for cases when a creation type is different to an alteration type (e.g. SERIAL in PostgreSQL, PostGIS fields).
Method	`_alter_field_type_workaround`	No summary
Method	`_drop_identity`	Undocumented
Method	`_field_should_be_indexed`	Undocumented
Method	`_generate_temp_name`	Generate temporary names for workarounds that need temp columns.
Method	`_get_default_collation`	Undocumented
Method	`_is_identity_column`	Undocumented
Method	`_unique_should_be_added`	Undocumented
Method	`alter_field`	No summary
Method	`delete_model`	Delete a model from the database.
Method	`normalize_name`	Get the properly shortened and uppercased identifier as returned by quote_name() but without the quotes.
Method	`prepare_default`	Only used for backends which have requires_literal_defaults feature
Method	`quote_value`	No summary
Method	`remove_field`	Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table.
Class Variable	`sql_alter_column_collate`	Undocumented
Class Variable	`sql_alter_column_default`	Undocumented
Class Variable	`sql_alter_column_no_default`	Undocumented
Class Variable	`sql_alter_column_not_null`	Undocumented
Class Variable	`sql_alter_column_null`	Undocumented
Class Variable	`sql_alter_column_type`	Undocumented
Class Variable	`sql_create_column`	Undocumented
Class Variable	`sql_create_column_inline_fk`	Undocumented
Class Variable	`sql_create_index`	Undocumented
Class Variable	`sql_delete_column`	Undocumented
Class Variable	`sql_delete_table`	Undocumented

Inherited from BaseDatabaseSchemaEditor:

Method	`add_constraint`	Add a constraint to a model.
Method	`add_field`	Create a field on a model. Usually involves adding a column, but may involve adding a table instead (for M2M fields).
Method	`add_index`	Add an index on a model.
Method	`alter_db_table`	Rename the table a model points to.
Method	`alter_db_tablespace`	Move a model's table between tablespaces.
Method	`alter_index_together`	Deal with a model changing its index_together. The input index_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format.
Method	`alter_unique_together`	Deal with a model changing its unique_together. The input unique_togethers must be doubly-nested, not the single-nested ["foo", "bar"] format.
Method	`create_model`	Create a table and any accompanying indexes or unique constraints for the given `model`.
Method	`execute`	Execute the given SQL statement, with optional parameters.
Method	`remove_constraint`	Remove a constraint from a model.
Method	`remove_index`	Remove an index from a model.
Static Method	`_effective_default`	Undocumented
Method	`__enter__`	Undocumented
Method	`__exit__`	Undocumented
Method	`__init__`	Undocumented
Method	`_alter_column_default_sql`	Hook to specialize column default alteration.
Method	`_alter_column_null_sql`	Hook to specialize column null alteration.
Method	`_alter_field`	Perform a "physical" (non-ManyToMany) field update.
Method	`_alter_many_to_many`	Alter M2Ms to repoint their to= endpoints.
Method	`_check_sql`	Undocumented
Method	`_collate_sql`	Undocumented
Method	`_column_default_sql`	Return the SQL to use in a DEFAULT clause. The resulting string should contain a '%s' placeholder for a default value.
Method	`_constraint_names`	Return all constraint names matching the columns and conditions.
Method	`_create_check_sql`	Undocumented
Method	`_create_fk_sql`	Undocumented
Method	`_create_index_name`	Generate a unique name for an index/unique constraint.
Method	`_create_index_sql`	Return the SQL statement to create the index for one or several fields or expressions. `sql` can be specified if the syntax differs from the standard (GIS indexes, ...).
Method	`_create_primary_key_sql`	Undocumented
Method	`_create_unique_sql`	Undocumented
Method	`_deferrable_constraint_sql`	Undocumented
Method	`_delete_check_sql`	Undocumented
Method	`_delete_composed_index`	Undocumented
Method	`_delete_constraint_sql`	Undocumented
Method	`_delete_fk_sql`	Undocumented
Method	`_delete_index_sql`	Undocumented
Method	`_delete_primary_key`	Undocumented
Method	`_delete_primary_key_sql`	Undocumented
Method	`_delete_unique_sql`	Undocumented
Method	`_field_became_primary_key`	Undocumented
Method	`_field_indexes_sql`	Return a list of all index SQL statements for the specified field.
Method	`_field_should_be_altered`	Undocumented
Method	`_fk_constraint_name`	Undocumented
Method	`_get_index_tablespace_sql`	Undocumented
Method	`_index_columns`	Undocumented
Method	`_index_condition_sql`	Undocumented
Method	`_index_include_sql`	Undocumented
Method	`_iter_column_sql`	Undocumented
Method	`_model_indexes_sql`	Return a list of all index SQL statements (field indexes, index_together, Meta.indexes) for the specified model.
Method	`_rename_field_sql`	Undocumented
Method	`_unique_sql`	Undocumented
Method	`column_sql`	Return the column definition for a field. The field must already have had set_attributes_from_name() called.
Method	`effective_default`	Return a field's effective database default value.
Method	`quote_name`	Undocumented
Method	`remove_procedure`	Undocumented
Method	`skip_default`	Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob).
Method	`skip_default_on_alter`	Some backends don't accept default values for certain columns types (i.e. MySQL longtext and longblob) in the ALTER COLUMN statement.
Method	`table_sql`	Take a model and return its table definition.
Class Variable	`sql_alter_column`	Undocumented
Class Variable	`sql_check_constraint`	Undocumented
Class Variable	`sql_constraint`	Undocumented
Class Variable	`sql_create_check`	Undocumented
Class Variable	`sql_create_fk`	Undocumented
Class Variable	`sql_create_inline_fk`	Undocumented
Class Variable	`sql_create_pk`	Undocumented
Class Variable	`sql_create_table`	Undocumented
Class Variable	`sql_create_unique`	Undocumented
Class Variable	`sql_create_unique_index`	Undocumented
Class Variable	`sql_delete_constraint`	Undocumented
Class Variable	`sql_delete_index`	Undocumented
Class Variable	`sql_delete_procedure`	Undocumented
Class Variable	`sql_rename_column`	Undocumented
Class Variable	`sql_rename_table`	Undocumented
Class Variable	`sql_retablespace_table`	Undocumented
Class Variable	`sql_unique_constraint`	Undocumented
Class Variable	`sql_update_with_default`	Undocumented
Instance Variable	`atomic`	Undocumented
Instance Variable	`atomic_migration`	Undocumented
Instance Variable	`collect_sql`	Undocumented
Instance Variable	`collected_sql`	Undocumented
Instance Variable	`connection`	Undocumented
Instance Variable	`deferred_sql`	Undocumented

def _alter_column_collation_sql(self, model, new_field, new_type, new_collation):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor._alter_column_collation_sql

Undocumented

def _alter_column_type_sql(self, model, old_field, new_field, new_type):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor._alter_column_type_sql

Hook to specialize column type alteration for different backends, for cases when a creation type is different to an alteration type (e.g. SERIAL in PostgreSQL, PostGIS fields).

Return a two-tuple of: an SQL fragment of (sql, params) to insert into an ALTER TABLE statement and a list of extra (sql, params) tuples to run once the field is altered.

def _alter_field_type_workaround(self, model, old_field, new_field):

Oracle refuses to change from some type to other type. What we need to do instead is: - Add a nullable version of the desired field with a temporary name. If

the new column is an auto field, then the temporary column can't be nullable.

Update the table to transfer values from old to new
Drop old column
Rename the new column and possibly drop the nullable property

def _drop_identity(self, table_name, column_name):

Undocumented

def _field_should_be_indexed(self, model, field):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor._field_should_be_indexed

Undocumented

def _generate_temp_name(self, for_name):

Generate temporary names for workarounds that need temp columns.

def _get_default_collation(self, table_name):

Undocumented

def _is_identity_column(self, table_name, column_name):

Undocumented

def _unique_should_be_added(self, old_field, new_field):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor._unique_should_be_added

Undocumented

def alter_field(self, model, old_field, new_field, strict=False):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.alter_field

Allow a field's type, uniqueness, nullability, default, column, constraints, etc. to be modified. old_field is required to compute the necessary changes. If strict is True, raise errors if the old column does not match old_field precisely.

def delete_model(self, model):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.delete_model

overridden in django.contrib.gis.db.backends.oracle.schema.OracleGISSchemaEditor

Delete a model from the database.

def normalize_name(self, name):

Get the properly shortened and uppercased identifier as returned by quote_name() but without the quotes.

def prepare_default(self, value):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.prepare_default

Only used for backends which have requires_literal_defaults feature

def quote_value(self, value):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.quote_value

Return a quoted version of the value so it's safe to use in an SQL string. This is not safe against injection from user code; it is intended only for use in making SQL scripts or preparing default values for particularly tricky backends (defaults are not user-defined, though, so this is safe).

def remove_field(self, model, field):

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.remove_field

overridden in django.contrib.gis.db.backends.oracle.schema.OracleGISSchemaEditor

Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table.

sql_alter_column_collate: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_alter_column_collate

Undocumented

sql_alter_column_default: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_alter_column_default

Undocumented

sql_alter_column_no_default: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_alter_column_no_default

Undocumented

sql_alter_column_not_null: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_alter_column_not_null

Undocumented

sql_alter_column_null: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_alter_column_null

Undocumented

sql_alter_column_type: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_alter_column_type

Undocumented

sql_create_column: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_create_column

Undocumented

sql_create_column_inline_fk: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_create_column_inline_fk

Undocumented

sql_create_index: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_create_index

Undocumented

sql_delete_column: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_delete_column

Undocumented

sql_delete_table: str =

overrides django.db.backends.base.schema.BaseDatabaseSchemaEditor.sql_delete_table

Undocumented