delete.go 745 B

1234567891011121314151617
  1. package sqltemplate
  2. var Delete = `
  3. func (m *{{.upperObject}}Model) Delete({{.lowerPrimaryKey}} {{.dataType}}) error {
  4. {{if .containsCache}}{{if .isNotPrimaryKey}}data,err:=m.FindOne({{.lowerPrimaryKey}})
  5. if err!=nil{
  6. return err
  7. }{{end}}
  8. {{.keys}}
  9. _, err {{if .isNotPrimaryKey}}={{else}}:={{end}} m.Exec(func(conn sqlx.SqlConn) (result sql.Result, err error) {
  10. query := ` + "`" + `delete from ` + "` +" + ` m.table + ` + " `" + ` where {{.snakePrimaryKey}} = ?` + "`" + `
  11. return conn.Exec(query, {{.lowerPrimaryKey}})
  12. }, {{.keyValues}}){{else}}query := ` + "`" + `delete from ` + "` +" + ` m.table + ` + " `" + ` where {{.snakePrimaryKey}} = ?` + "`" + `
  13. _,err:=m.ExecNoCache(query, {{.lowerPrimaryKey}}){{end}}
  14. return err
  15. }
  16. `