class documentation

class SpatialiteSchemaEditor(DatabaseSchemaEditor): (source)

View In Hierarchy

Undocumented

Method __init__ Undocumented
Method add_field Create a field on a model.
Method alter_db_table Rename the table a model points to.
Method column_sql Return the column definition for a field. The field must already have had set_attributes_from_name() called.
Method create_model Create a table and any accompanying indexes or unique constraints for the given `model`.
Method delete_model Delete a model from the database.
Method geo_quote_name Undocumented
Method remove_field Remove a field from a model. Usually involves deleting a column, but for M2Ms may involve deleting a table.
Method remove_geometry_metadata Undocumented
Class Variable geometry_tables Undocumented
Class Variable sql_add_geometry_column Undocumented
Class Variable sql_add_spatial_index Undocumented
Class Variable sql_discard_geometry_columns Undocumented
Class Variable sql_drop_spatial_index Undocumented
Class Variable sql_recover_geometry_metadata Undocumented
Class Variable sql_remove_geometry_metadata Undocumented
Class Variable sql_update_geometry_columns Undocumented
Instance Variable geometry_sql Undocumented

Inherited from DatabaseSchemaEditor:

Method __enter__ Undocumented
Method __exit__ Undocumented
Method add_constraint Add a constraint to a model.
Method 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.
Method prepare_default Only used for backends which have requires_literal_defaults feature
Method 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).
Method remove_constraint Remove a constraint from a model.
Class Variable sql_create_fk Undocumented
Class Variable sql_create_inline_fk Undocumented
Class Variable sql_create_unique Undocumented
Class Variable sql_delete_column Undocumented
Class Variable sql_delete_table Undocumented
Class Variable sql_delete_unique Undocumented
Instance Variable deferred_sql Undocumented
Method _alter_field Perform a "physical" (non-ManyToMany) field update.
Method _alter_many_to_many Alter M2Ms to repoint their to= endpoints.
Method _collate_sql Undocumented
Method _is_referenced_by_fk_constraint Return whether or not the provided table name is referenced by another one. If `column_name` is specified, only references pointing to that column are considered. If `ignore_self` is True, self-referential constraints are ignored.
Method _remake_table Shortcut to transform a model from old_model into new_model

Inherited from BaseDatabaseSchemaEditor (via DatabaseSchemaEditor):

Method add_index Add an index on a model.
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 effective_default Return a field's effective database default value.
Method execute Execute the given SQL statement, with optional parameters.
Method quote_name Undocumented
Method remove_index Remove an index from a model.
Method remove_procedure Undocumented
Method rename_index 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_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_check_constraint Undocumented
Class Variable sql_constraint Undocumented
Class Variable sql_create_check Undocumented
Class Variable sql_create_column Undocumented
Class Variable sql_create_column_inline_fk Undocumented
Class Variable sql_create_index Undocumented
Class Variable sql_create_pk Undocumented
Class Variable sql_create_table 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_index 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
Static Method _effective_default Undocumented
Method _alter_column_collation_sql 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_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 _check_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 _field_should_be_indexed 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 _rename_index_sql Undocumented
Method _unique_constraint_name Undocumented
Method _unique_should_be_added Undocumented
Method _unique_sql Undocumented
def __init__(self, *args, **kwargs): (source)
def add_field(self, model, field): (source)
def alter_db_table(self, model, old_db_table, new_db_table, disable_constraints=True): (source)

Rename the table a model points to.

def column_sql(self, model, field, include_default=False): (source)

Return the column definition for a field. The field must already have had set_attributes_from_name() called.

def create_model(self, model): (source)

Create a table and any accompanying indexes or unique constraints for the given `model`.

def delete_model(self, model, **kwargs): (source)

Delete a model from the database.

def geo_quote_name(self, name): (source)

Undocumented

def remove_field(self, model, field): (source)

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

def remove_geometry_metadata(self, model, field): (source)

Undocumented

geometry_tables: list[str] = (source)

Undocumented

sql_add_geometry_column: str = (source)

Undocumented

sql_add_spatial_index: str = (source)

Undocumented

sql_discard_geometry_columns: str = (source)

Undocumented

sql_drop_spatial_index: str = (source)

Undocumented

sql_recover_geometry_metadata: str = (source)

Undocumented

sql_remove_geometry_metadata: str = (source)

Undocumented

sql_update_geometry_columns: str = (source)

Undocumented

geometry_sql: list = (source)

Undocumented