gemma: pkg/controllers/printtemplates.go annotate

annotate pkg/controllers/printtemplates.go @ 5591:0011f50cf216 surveysperbottleneckid

Removed no longer used alternative api for surveys/ endpoint. As bottlenecks in the summary for SR imports are now identified by their id and no longer by the (not guarantied to be unique!) name, there is no longer the need to request survey data by the name+date tuple (which isn't reliable anyway). So the workaround was now reversed.

author	Sascha Wilde <wilde@sha-bang.de>
date	Wed, 06 Apr 2022 13:30:29 +0200
parents	4394daeea96a
children	6270951dda28

rev	line source
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	1 // This is Free Software under GNU Affero General Public License v >= 3.0
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	2 // without warranty, see README.md and license for details.
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	3 //
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	4 // SPDX-License-Identifier: AGPL-3.0-or-later
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	5 // License-Filename: LICENSES/AGPL-3.0.txt
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	6 //
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	7 // Copyright (C) 2018 by via donau
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	8 // – Österreichische Wasserstraßen-Gesellschaft mbH
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	9 // Software engineering by Intevation GmbH
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	10 //
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	11 // Author(s):
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	12 // * Sascha L. Teichmann <sascha.teichmann@intevation.de>
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	13
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	14 package controllers
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	15
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	16 import (
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	17 "bytes"
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	18 "database/sql"
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	19 "encoding/json"
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	20 "net/http"
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	21 "strings"
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	22 "time"
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	23
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	24 "github.com/gorilla/mux"
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	25 "github.com/jackc/pgx/pgtype"
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	26
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	27 "gemma.intevation.de/gemma/pkg/models"
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	28
4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	29 mw "gemma.intevation.de/gemma/pkg/middleware"
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	30 )
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	31
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	32 const maxPrintTemplateSize = 5 * 1024 * 1024
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	33
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	34 const (
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	35 listPrintTemplatesSQL = `
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	36 SELECT
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	37 template_name,
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	38 template_type::varchar,
2270 1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	39 date_info,
1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	40 country
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	41 FROM users.templates
3223 9e087a495f41 Fixed SQL statements. Got broken when migrated to new filter builder. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3217 diff changeset	42 WHERE
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	43 `
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	44
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	45 hasPrintTemplateSQL = `
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	46 SELECT true FROM users.templates
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	47 WHERE template_name = $1 AND template_type = $2::template_types`
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	48
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	49 deletePrintTemplateSQL = `
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	50 DELETE FROM users.templates
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	51 WHERE template_name = $1 AND template_type = $2::template_types`
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	52
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	53 selectPrintTemplateSQL = `
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	54 SELECT template_data FROM users.templates
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	55 WHERE template_name = $1 AND template_type = $2::template_types`
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	56
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	57 insertPrintTemplateSQL = `
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	58 INSERT INTO users.templates (template_name, template_type, template_data, country)
2267 37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	59 SELECT
37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	60 $1,
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	61 $2::template_types,
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	62 $3,
2267 37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	63 CASE WHEN pg_has_role('sys_admin', 'MEMBER') THEN NULL
4158 5466562cca60 Remove utility function with possibly bad performance impact Tom Gottfried <tom@intevation.de> parents: 3228 diff changeset	64 ELSE (SELECT country FROM users.list_users
5466562cca60 Remove utility function with possibly bad performance impact Tom Gottfried <tom@intevation.de> parents: 3228 diff changeset	65 WHERE username = current_user)
2267 37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	66 END`
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	67
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	68 updatePrintTemplateSQL = `
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	69 UPDATE user.templates template_data = $2
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	70 WHERE template_name = $1 AND template_type = $2::template_types`
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	71 )
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	72
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	73 var templateTypes = []string{"map", "diagram", "report"}
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	74
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	75 func listPrintTemplates(req *http.Request) (jr mw.JSONResult, err error) {
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	76
3228 607a158fe8f5 Print templates: Fixed accessing templates by type. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3226 diff changeset	77 ts := mux.Vars(req)["type"]
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	78 if ts == "" {
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	79 if ts = req.FormValue("types"); ts == "" {
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	80 ts = strings.Join(templateTypes, ",")
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	81 }
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	82 }
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	83
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	84 types := toTextArray(ts, templateTypes)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	85 filter := buildFilterTerm("template_type = ANY($%d) ", types)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	86
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	87 var stmt strings.Builder
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	88 var args []interface{}
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	89
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	90 stmt.WriteString(listPrintTemplatesSQL)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	91 filter.serialize(&stmt, &args)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	92 stmt.WriteString(" ORDER BY date_info DESC")
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	93
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	94 var rows *sql.Rows
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	95 if rows, err = mw.JSONConn(req).QueryContext(req.Context(), stmt.String(), args...); err != nil {
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	96 return
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	97 }
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	98 defer rows.Close()
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	99
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	100 type template struct {
2270 1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	101 Name string `json:"name"`
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	102 Type string `json:"type"`
2270 1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	103 Time models.Time `json:"time"`
1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	104 Country *string `json:"country,omitempty"`
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	105 }
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	106
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	107 templates := []*template{}
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	108
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	109 for rows.Next() {
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	110 var tmpl template
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	111 var w time.Time
2270 1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	112 var country sql.NullString
3226 d84c64c0f510 Print templates: Forget to scan the type from the result set when listing available templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3223 diff changeset	113 if err = rows.Scan(
d84c64c0f510 Print templates: Forget to scan the type from the result set when listing available templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3223 diff changeset	114 &tmpl.Name,
d84c64c0f510 Print templates: Forget to scan the type from the result set when listing available templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3223 diff changeset	115 &tmpl.Type,
d84c64c0f510 Print templates: Forget to scan the type from the result set when listing available templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3223 diff changeset	116 &w,
d84c64c0f510 Print templates: Forget to scan the type from the result set when listing available templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3223 diff changeset	117 &country,
d84c64c0f510 Print templates: Forget to scan the type from the result set when listing available templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3223 diff changeset	118 ); err != nil {
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	119 return
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	120 }
3089 813309225e35 Made 'go vet' happy again. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2270 diff changeset	121 tmpl.Time = models.Time{Time: w}
2270 1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	122 if country.Valid {
1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	123 tmpl.Country = &country.String
1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	124 }
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	125 templates = append(templates, &tmpl)
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	126 }
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	127
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	128 jr = mw.JSONResult{Result: templates}
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	129 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	130 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	132 func fetchPrintTemplate(req *http.Request) (jr mw.JSONResult, err error) {
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	133
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	134 vars := mux.Vars(req)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	135 name, typ := vars["name"], vars["type"]
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	136
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	137 ctx := req.Context()
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	138 var data pgtype.Bytea
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	139 err = mw.JSONConn(req).QueryRowContext(ctx, selectPrintTemplateSQL, name, typ).Scan(&data)
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	140
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	141 switch {
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	142 case err == sql.ErrNoRows:
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	143 err = mw.JSONError{
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	144 Code: http.StatusNotFound,
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	145 Message: "No such template found",
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	146 }
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	147 return
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	148 case err != nil:
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	149 return
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	150 case data.Status != pgtype.Present:
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	151 err = mw.JSONError{
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	152 Code: http.StatusInternalServerError,
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	153 Message: "Unexpected return value from database query",
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	154 }
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	155 return
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	156 }
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	157 jr = mw.JSONResult{Result: bytes.NewReader(data.Bytes)}
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	158 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	159 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	160
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	161 func createPrintTemplate(req *http.Request) (jr mw.JSONResult, err error) {
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	162
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	163 vars := mux.Vars(req)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	164 name, typ := vars["name"], vars["type"]
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	165
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	166 in := mw.JSONInput(req).(*json.RawMessage)
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	167
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	168 if name == "" {
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	169 err = mw.JSONError{
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	170 Code: http.StatusBadRequest,
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	171 Message: "Template must have a none empty name",
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	172 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	173 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	174 }
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	175 if len(*in) == 0 {
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	176 err = mw.JSONError{
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	177 Code: http.StatusBadRequest,
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	178 Message: "Template must have a none empty template",
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	179 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	180 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	181 }
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	182
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	183 ctx := req.Context()
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	184 var tx *sql.Tx
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	185 if tx, err = mw.JSONConn(req).BeginTx(ctx, nil); err != nil {
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	186 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	187 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	188 defer tx.Rollback()
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	189
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	190 var dummy bool
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	191 err = tx.QueryRowContext(ctx, hasPrintTemplateSQL, name, typ).Scan(&dummy)
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	192
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	193 switch {
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	194 case err == sql.ErrNoRows:
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	195 // This is fine.
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	196 case err != nil:
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	197 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	198 default:
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	199 err = mw.JSONError{
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	200 Code: http.StatusBadRequest,
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	201 Message: "A template with this name already exists",
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	202 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	203 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	204 }
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	205 data := pgtype.Bytea{Bytes: *in, Status: pgtype.Present}
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	206
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	207 if _, err = tx.ExecContext(ctx, insertPrintTemplateSQL, name, typ, &data); err != nil {
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	208 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	209 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	210
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	211 if err = tx.Commit(); err != nil {
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	212 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	213 }
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	214 jr = mw.JSONResult{
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	215 Code: http.StatusCreated,
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	216 Result: map[string]string{
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	217 "created": name,
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	218 },
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	219 }
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	220 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	221 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	222
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	223 func deletePrintTemplate(req *http.Request) (jr mw.JSONResult, err error) {
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	224
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	225 vars := mux.Vars(req)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	226 name, typ := vars["name"], vars["type"]
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	227
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	228 ctx := req.Context()
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	229 var tx *sql.Tx
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	230 if tx, err = mw.JSONConn(req).BeginTx(ctx, nil); err != nil {
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	231 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	232 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	233 defer tx.Rollback()
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	234
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	235 var dummy bool
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	236 err = tx.QueryRowContext(ctx, hasPrintTemplateSQL, name, typ).Scan(&dummy)
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	237
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	238 switch {
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	239 case err == sql.ErrNoRows:
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	240 err = mw.JSONError{
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	241 Code: http.StatusNotFound,
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	242 Message: "No such template found",
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	243 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	244 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	245 case err != nil:
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	246 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	247 case !dummy:
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	248 err = mw.JSONError{
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	249 Code: http.StatusInternalServerError,
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	250 Message: "Unexpected return value from database query",
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	251 }
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	252 return
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	253 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	254
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	255 if _, err = tx.ExecContext(ctx, deletePrintTemplateSQL, name, typ); err != nil {
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	256 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	257 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	258
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	259 if err = tx.Commit(); err != nil {
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	260 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	261 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	262
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	263 jr = mw.JSONResult{
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	264 Result: map[string]string{
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	265 "deleted": name,
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	266 },
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	267 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	268
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	269 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	270 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	271
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	272 func updatePrintTemplate(req *http.Request) (jr mw.JSONResult, err error) {
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	273
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	274 vars := mux.Vars(req)
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	275 name, typ := vars["name"], vars["type"]
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	276
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	277 in := mw.JSONInput(req).(*json.RawMessage)
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	278
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	279 if name == "" {
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	280 err = mw.JSONError{
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	281 Code: http.StatusBadRequest,
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	282 Message: "Template must have a none empty name",
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	283 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	284 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	285 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	286 if len(*in) == 0 {
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	287 err = mw.JSONError{
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	288 Code: http.StatusBadRequest,
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	289 Message: "Template must have a none empty template",
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	290 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	291 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	292 }
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	293
4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	294 ctx := req.Context()
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	295 var tx *sql.Tx
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	296 if tx, err = mw.JSONConn(req).BeginTx(ctx, nil); err != nil {
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	297 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	298 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	299 defer tx.Rollback()
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	300
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	301 var dummy bool
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	302 err = tx.QueryRowContext(ctx, hasPrintTemplateSQL, name, typ).Scan(&dummy)
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	303
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	304 switch {
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	305 case err == sql.ErrNoRows:
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	306 err = mw.JSONError{
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	307 Code: http.StatusNotFound,
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	308 Message: "No such template found",
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	309 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	310 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	311 case err != nil:
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	312 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	313 case !dummy:
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	314 err = mw.JSONError{
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	315 Code: http.StatusInternalServerError,
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	316 Message: "Unexpected return value from database query",
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	317 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	318 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	319 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	320 data := pgtype.Bytea{Bytes: *in, Status: pgtype.Present}
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	321
3217 4c254651d80b Added template types "map", "diagram", "report". Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 3089 diff changeset	322 if _, err = tx.ExecContext(ctx, updatePrintTemplateSQL, name, typ, &data); err != nil {
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	323 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	324 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	325
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	326 if err = tx.Commit(); err != nil {
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	327 return
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	328 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	329
4244 4394daeea96a Moved JSONHandler into middleware package. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 4243 diff changeset	330 jr = mw.JSONResult{
2162 0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	331 Code: http.StatusOK,
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	332 Result: map[string]string{
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	333 "updated": name,
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	334 },
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	335 }
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	336 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	337 }

Mercurial > gemma

annotate pkg/controllers/printtemplates.go @ 5591:0011f50cf216 surveysperbottleneckid