Semaphore/db/bolt/template.go
Denis Gukov 1036af1fc6 fix(be): disable migration for mysql
fix: check refs to template before delete

fix(be): drop breaking foreign key
2022-02-05 13:30:25 +05:00

122 lines
3.0 KiB
Go

package bolt
import (
"github.com/ansible-semaphore/semaphore/db"
"go.etcd.io/bbolt"
)
func (d *BoltDb) CreateTemplate(template db.Template) (newTemplate db.Template, err error) {
err = template.Validate()
if err != nil {
return
}
template.SurveyVarsJSON = db.ObjectToJSON(template.SurveyVars)
newTpl, err := d.createObject(template.ProjectID, db.TemplateProps, template)
if err != nil {
return
}
newTemplate = newTpl.(db.Template)
err = db.FillTemplate(d, &newTemplate)
return
}
func (d *BoltDb) UpdateTemplate(template db.Template) error {
err := template.Validate()
if err != nil {
return err
}
template.SurveyVarsJSON = db.ObjectToJSON(template.SurveyVars)
return d.updateObject(template.ProjectID, db.TemplateProps, template)
}
func (d *BoltDb) GetTemplates(projectID int, filter db.TemplateFilter, params db.RetrieveQueryParams) (templates []db.Template, err error) {
var ftr = func(tpl interface{}) bool {
template := tpl.(db.Template)
var res = true
if filter.ViewID != nil {
res = res && template.ViewID != nil && *template.ViewID == *filter.ViewID
}
if filter.BuildTemplateID != nil {
res = res && template.BuildTemplateID != nil && *template.BuildTemplateID == *filter.BuildTemplateID
if filter.AutorunOnly {
res = res && template.Autorun
}
}
return res
}
err = d.getObjects(projectID, db.TemplateProps, params, ftr, &templates)
if err != nil {
return
}
err = db.FillTemplates(d, templates)
return
}
func (d *BoltDb) getRawTemplate(projectID int, templateID int) (template db.Template, err error) {
err = d.getObject(projectID, db.TemplateProps, intObjectID(templateID), &template)
return
}
func (d *BoltDb) GetTemplate(projectID int, templateID int) (template db.Template, err error) {
template, err = d.getRawTemplate(projectID, templateID)
if err != nil {
return
}
err = db.FillTemplate(d, &template)
return
}
func (d *BoltDb) deleteTemplate(projectID int, templateID int, tx *bbolt.Tx) (err error) {
inUse, err := d.isObjectInUse(projectID, db.TemplateProps, intObjectID(templateID), db.TemplateProps)
if err != nil {
return err
}
if inUse {
return db.ErrInvalidOperation
}
tasks, err := d.GetTemplateTasks(projectID, templateID, db.RetrieveQueryParams{})
if err != nil {
return
}
for _, task := range tasks {
err = d.deleteTaskWithOutputs(projectID, task.ID, tx)
if err != nil {
return
}
}
schedules, err := d.GetTemplateSchedules(projectID, templateID)
if err != nil {
return
}
for _, sch := range schedules {
err = d.deleteSchedule(projectID, sch.ID, tx)
if err != nil {
return
}
}
return d.deleteObject(projectID, db.TemplateProps, intObjectID(templateID), tx)
}
func (d *BoltDb) DeleteTemplate(projectID int, templateID int) error {
return d.db.Update(func(tx *bbolt.Tx) error {
return d.deleteTemplate(projectID, templateID, tx)
})
}
func (d *BoltDb) GetTemplateRefs(projectID int, templateID int) (db.ObjectReferrers, error) {
return d.getObjectRefs(projectID, db.TemplateProps, templateID)
}