gemma: pkg/controllers/printtemplates.go annotate

annotate pkg/controllers/printtemplates.go @ 2549:9bf6b767a56a

client: refactored and improved splitscreen for diagrams To make different diagrams possible, the splitscreen view needed to be decoupled from the cross profiles. Also the style has changed to make it more consistent with the rest of the app. The standard box header is now used and there are collapse and expand animations.

author	Markus Kottlaender <markus@intevation.de>
date	Fri, 08 Mar 2019 08:50:47 +0100
parents	1c8b8a4476af
children	813309225e35

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"
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	21 "time"
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	22
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	23 "github.com/gorilla/mux"
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	24 "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	25
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	26 "gemma.intevation.de/gemma/pkg/models"
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	27 )
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	28
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	29 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	30
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	31 const (
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	32 listPrintTemplatesSQL = `
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	33 SELECT
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	34 template_name,
2270 1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	35 date_info,
1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	36 country
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	37 FROM
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	38 users.templates
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	39 ORDER BY date_info DESC`
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	40
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	41 hasPrintTemplateSQL = `
2247 e6fba449aa3c merged pdf-export in default Markus Kottlaender <markus@intevation.de> parents: 2162 diff changeset	42 SELECT true FROM users.templates WHERE template_name = $1`
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	43
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	44 deletePrintTemplateSQL = `
2247 e6fba449aa3c merged pdf-export in default Markus Kottlaender <markus@intevation.de> parents: 2162 diff changeset	45 DELETE FROM users.templates WHERE template_name = $1`
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	46
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	47 selectPrintTemplateSQL = `
2247 e6fba449aa3c merged pdf-export in default Markus Kottlaender <markus@intevation.de> parents: 2162 diff changeset	48 SELECT template_data FROM users.templates WHERE template_name = $1`
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	49
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	50 insertPrintTemplateSQL = `
2267 37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	51 INSERT INTO users.templates (template_name, template_data, country)
37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	52 SELECT
37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	53 $1,
37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	54 $2,
37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	55 CASE WHEN pg_has_role('sys_admin', 'MEMBER') THEN NULL
37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	56 ELSE users.current_user_country()
37ae1bee3e4a Ajjusted RLS for user templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2247 diff changeset	57 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	58
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	59 updatePrintTemplateSQL = `
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	60 UPDATE user.templates template_data = $2 WHERE template_name = $1`
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	61 )
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	62
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	63 func listPrintTemplates(
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	64 _ interface{},
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	65 req *http.Request,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	66 conn *sql.Conn,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	67 ) (jr JSONResult, err error) {
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	68
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	69 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	70 Name string `json:"name"`
1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	71 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	72 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	73 }
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	74
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	75 var rows *sql.Rows
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	76 if rows, err = conn.QueryContext(req.Context(), listPrintTemplatesSQL); err != nil {
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	77 return
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	78 }
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	79 defer rows.Close()
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	80
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	81 templates := []*template{}
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	82
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	83 for rows.Next() {
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	84 var tmpl template
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	85 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	86 var country sql.NullString
1c8b8a4476af Print templates: Add country to listing if template has one. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2267 diff changeset	87 if err = rows.Scan(&tmpl.Name, &w, &country); err != nil {
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	88 return
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	89 }
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	90 tmpl.Time = models.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	91 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	92 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	93 }
2150 2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	94 templates = append(templates, &tmpl)
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	95 }
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	96
2c67c51d57ad Print templates: Implemented GET of all templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2148 diff changeset	97 jr = JSONResult{Result: templates}
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	98 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	99 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	100
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	101 func fetchPrintTemplate(
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	102 _ interface{},
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	103 req *http.Request,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	104 conn *sql.Conn,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	105 ) (jr JSONResult, err error) {
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	106
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	107 ctx := req.Context()
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	108 name := mux.Vars(req)["name"]
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	109
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	110 var data pgtype.Bytea
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	111 err = conn.QueryRowContext(ctx, selectPrintTemplateSQL, name).Scan(&data)
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	112
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	113 switch {
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	114 case err == sql.ErrNoRows:
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	115 err = JSONError{
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	116 Code: http.StatusNotFound,
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	117 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	118 }
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	119 return
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	120 case err != nil:
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	121 return
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	122 case data.Status != pgtype.Present:
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	123 err = JSONError{
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	124 Code: http.StatusInternalServerError,
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	125 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	126 }
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	127 return
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	128 }
51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	129 jr = 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	130 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	131 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	132
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	133 func createPrintTemplate(
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	134 input interface{},
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	135 req *http.Request,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	136 conn *sql.Conn,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	137 ) (jr 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	138
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	139 ctx := req.Context()
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	140 name := mux.Vars(req)["name"]
7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	141 in := input.(*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	142
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	143 if 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	144 err = JSONError{
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	145 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	146 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	147 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	148 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	149 }
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	150 if len(*in) == 0 {
2158 7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	151 err = JSONError{
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	152 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	153 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	154 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	155 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	156 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	157 var tx *sql.Tx
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	158 if tx, err = conn.BeginTx(ctx, nil); 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	159 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	160 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	161 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	162
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	163 var dummy bool
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	164 err = tx.QueryRowContext(ctx, hasPrintTemplateSQL, name).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	165
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	166 switch {
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	167 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	168 // 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	169 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	170 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	171 default:
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	172 err = JSONError{
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	173 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	174 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	175 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	176 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	177 }
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	178 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	179
2161 7444b75d5497 Print templates endpoints: Get rid of useless models.PrintTemplateIn model. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2158 diff changeset	180 if _, err = tx.ExecContext(ctx, insertPrintTemplateSQL, name, &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	181 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	182 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	183
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	184 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	185 return
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	186 }
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	187 jr = JSONResult{
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	188 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	189 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	190 "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	191 },
7bd485bf85e8 Print templates: Implemented /api/templates/print POST to create new templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2155 diff changeset	192 }
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	193 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	194 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	195
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	196 func deletePrintTemplate(
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	197 _ interface{},
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	198 req *http.Request,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	199 conn *sql.Conn,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	200 ) (jr JSONResult, err error) {
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	201
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	202 ctx := req.Context()
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	203 name := mux.Vars(req)["name"]
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	204
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	205 var tx *sql.Tx
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	206 if tx, err = conn.BeginTx(ctx, nil); err != nil {
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	207 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	208 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	209 defer tx.Rollback()
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	210
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	211 var dummy bool
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	212 err = tx.QueryRowContext(ctx, hasPrintTemplateSQL, name).Scan(&dummy)
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	213
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	214 switch {
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	215 case err == sql.ErrNoRows:
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	216 err = JSONError{
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	217 Code: http.StatusNotFound,
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	218 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	219 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	220 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	221 case err != nil:
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	222 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	223 case !dummy:
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	224 err = JSONError{
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	225 Code: http.StatusInternalServerError,
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	226 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	227 }
2155 51c5aead78c0 Print templates: Implemented /api/templates/print/{name} GET. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2153 diff changeset	228 return
2153 cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	229 }
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	230
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	231 if _, err = tx.ExecContext(ctx, deletePrintTemplateSQL, name); err != nil {
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	232 return
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	233 }
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 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	236 return
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
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	239 jr = JSONResult{
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	240 Result: map[string]string{
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	241 "deleted": name,
cdd68f555ad7 Print templates: Implemented /api/templates/print/{name} DELETE. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2150 diff changeset	242 },
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
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	245 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	246 }
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	247
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	248 func updatePrintTemplate(
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	249 input interface{},
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	250 req *http.Request,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	251 conn *sql.Conn,
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	252 ) (jr 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	253
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	254 ctx := req.Context()
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	255 name := mux.Vars(req)["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	256 in := input.(*json.RawMessage)
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	257
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	258 if 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	259 err = JSONError{
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	260 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	261 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	262 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	263 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	264 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	265 if len(*in) == 0 {
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	266 err = JSONError{
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	267 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	268 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	269 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	270 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	271 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	272 var tx *sql.Tx
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 if tx, err = conn.BeginTx(ctx, nil); 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	274 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	275 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	276 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	277
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 var dummy bool
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 err = tx.QueryRowContext(ctx, hasPrintTemplateSQL, name).Scan(&dummy)
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	280
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 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	282 case err == sql.ErrNoRows:
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 err = JSONError{
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 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	285 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	286 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	287 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	288 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	289 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	290 case !dummy:
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 err = JSONError{
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 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	293 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	294 }
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 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	296 }
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 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	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 if _, err = tx.ExecContext(ctx, updatePrintTemplateSQL, name, &data); 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	300 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	301 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	302
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 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	304 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	305 }
0627565fb4d2 Print templates: Implemented /api/templates/print/{name} PATCH to update print templates. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: 2161 diff changeset	306
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 jr = JSONResult{
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 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	309 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	310 "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	311 },
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 }
2148 4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	313 return
4057a1f15174 Print templates: Forget to add controller file. Sascha L. Teichmann <sascha.teichmann@intevation.de> parents: diff changeset	314 }

Mercurial > gemma

annotate pkg/controllers/printtemplates.go @ 2549:9bf6b767a56a