Function dropCollectionIndexes

core/collection_record_table_sync.go:300–323

(app App, collection *Collection)

}

func dropCollectionIndexes(app App, collection *Collection) error {
	if collection.IsView() {
		return nil // views don't have indexes
	}

	return app.RunInTransaction(func(txApp App) error {
		for _, raw := range collection.Indexes {
			parsed := dbutils.ParseIndex(raw)

			// note: don't check IsValid because the index table name may not be populated
			// (https://github.com/pocketbase/pocketbase/issues/7689)
			if parsed.IndexName == "" {
				return fmt.Errorf("failed to dop index - missing index name: %s", raw)
			}

			_, err := txApp.DB().NewQuery(fmt.Sprintf("DROP INDEX IF EXISTS [[%s]]", parsed.IndexName)).Execute()
			if err != nil {
				return err
			}
		}

		return nil
	})
}

func createCollectionIndexes(app App, collection *Collection) error {
	if collection.IsView() {