creation.py 855 B

123456789101112131415161718
  1. from django.db.backends.mysql.creation import DatabaseCreation
  2. class MySQLCreation(DatabaseCreation):
  3. def sql_indexes_for_field(self, model, f, style):
  4. from django.contrib.gis.db.models.fields import GeometryField
  5. output = super(MySQLCreation, self).sql_indexes_for_field(model, f, style)
  6. if isinstance(f, GeometryField) and f.spatial_index:
  7. qn = self.connection.ops.quote_name
  8. db_table = model._meta.db_table
  9. idx_name = '%s_%s_id' % (db_table, f.column)
  10. output.append(style.SQL_KEYWORD('CREATE SPATIAL INDEX ') +
  11. style.SQL_TABLE(qn(idx_name)) +
  12. style.SQL_KEYWORD(' ON ') +
  13. style.SQL_TABLE(qn(db_table)) + '(' +
  14. style.SQL_FIELD(qn(f.column)) + ');')
  15. return output