Sometimes you may want to create or edit a collection programmatically (eg. as part of a DB migration). You could find all available Collection related db methods in the daos godoc, but here are some commonly used ones:

    Fetch collections

    Fetch collection by name or id
    collection, err := app.Dao().FindCollectionByNameOrId("example")
    Fetch collections by type
    baseCollections, err := app.Dao().FindCollectionsByType(models.CollectionTypeBase) authCollections, err := app.Dao().FindCollectionsByType(models.CollectionTypeAuth)

    Create new collection

    Create new collection WITHOUT data validations
    import ( "github.com/pocketbase/pocketbase/models" "github.com/pocketbase/pocketbase/models/schema" "github.com/pocketbase/pocketbase/tools/types" ) ... collection := &models.Collection{ Name: "example", Type: models.CollectionTypeBase, ListRule: nil, ViewRule: types.Pointer("@request.auth.id != ''"), CreateRule: types.Pointer(""), UpdateRule: types.Pointer("@request.auth.id != ''"), DeleteRule: nil, Schema: schema.NewSchema( &schema.SchemaField{ Name: "title", Type: schema.FieldTypeText, Required: true, Unique: true, Options: &schema.TextOptions{ Max: types.Pointer(10), }, }, &schema.SchemaField{ Name: "user", Type: schema.FieldTypeRelation, Required: true, Options: &schema.RelationOptions{ MaxSelect: types.Pointer(1), CollectionId: "ae40239d2bc4477", CascadeDelete: true, }, }, ), } // the id is autogenerated, but you can set a specific one if you want to: // collection.SetId("...") if err := app.Dao().SaveCollection(collection); err != nil { return err }
    Create new collection WITH data validations
    import ( "github.com/pocketbase/pocketbase/forms" "github.com/pocketbase/pocketbase/models" "github.com/pocketbase/pocketbase/models/schema" "github.com/pocketbase/pocketbase/tools/types" ) ... collection := &models.Collection{} form := forms.NewCollectionUpsert(app, collection) form.Name = "example" form.Type = models.CollectionTypeBase form.ListRule = nil form.ViewRule = types.Pointer("@request.auth.id != ''") form.CreateRule = types.Pointer("") form.UpdateRule = types.Pointer("@request.auth.id != ''") form.DeleteRule = nil form.Schema.AddField(&schema.SchemaField{ Name: "title", Type: schema.FieldTypeText, Required: true, Unique: true, Options: &schema.TextOptions{ Max: types.Pointer(10), }, }) form.Schema.AddField(&schema.SchemaField{ Name: "user", Type: schema.FieldTypeRelation, Required: true, Options: &schema.RelationOptions{ MaxSelect: types.Pointer(1), CollectionId: "ae40239d2bc4477", CascadeDelete: true, }, }) // validate and submit (internally it calls app.Dao().SaveCollection(collection) in a transaction) if err := form.Submit(); err != nil { return err }

    Update existing collection

    Update collection WITHOUT data validations
    import ( "github.com/pocketbase/pocketbase/models/schema" ) ... collection, err := app.Dao().FindCollectionByNameOrId("example") if err != nil { return err } collection.Name = "example_update" collection.Schema.AddField(&schema.SchemaField{ Name: "description", Type: schema.FieldTypeText, }) if err := app.Dao().SaveCollection(collection); err != nil { return err }
    Update collection WITH data validations
    import ( "github.com/pocketbase/pocketbase/forms" "github.com/pocketbase/pocketbase/models/schema" ) ... collection, err := app.Dao().FindCollectionByNameOrId("example") if err != nil { return err } form := forms.NewCollectionUpsert(app, collection) form.Name = "example_update" form.Schema.AddField(&schema.SchemaField{ Name: "description", Type: schema.FieldTypeText, }) // validate and submit (internally it calls app.Dao().SaveCollection(collection) in a transaction) if err := form.Submit(); err != nil { return err }

    Delete collection

    collection, err := app.Dao().FindCollectionByNameOrId("example") if err != nil { return err } if err := app.Dao().DeleteCollection(collection); err != nil { return err }