Mercurial > gemma

comparison pkg/models/intservices.go @ 1288:9f7dc950ffd2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Accept only well-formed XML documents as style in database
author Tom Gottfried <tom@intevation.de>
date Thu, 22 Nov 2018 12:25:01 +0100
parents a244b18cb916
children cabf4789e02b
comparison
equal deleted inserted replaced
1287:54b7d8e2b224 1288:9f7dc950ffd2
42 SELECT relname, style IS NOT NULL, as_wms, as_wfs 42 SELECT relname, style IS NOT NULL, as_wms, as_wfs
43 FROM sys_admin.published_services 43 FROM sys_admin.published_services
44 JOIN pg_class ON name = oid ORDER by relname` 44 JOIN pg_class ON name = oid ORDER by relname`
45 45
46 selectStyleSQL = ` 46 selectStyleSQL = `
47 SELECT style 47 SELECT XMLSERIALIZE(DOCUMENT style AS text)
48 FROM sys_admin.published_services 48 FROM sys_admin.published_services
49 JOIN pg_class ON name = oid 49 JOIN pg_class ON name = oid
50 WHERE relname = $1` 50 WHERE relname = $1`
51 51
52 updateStyleSQL = ` 52 updateStyleSQL = `
53 UPDATE sys_admin.published_services 53 UPDATE sys_admin.published_services
54 SET style = $1::bytea 54 SET style = XMLPARSE(DOCUMENT $1)
55 WHERE name IN (SELECT oid FROM pg_class WHERE relname = $2)` 55 WHERE name IN (SELECT oid FROM pg_class WHERE relname = $2)`
56 ) 56 )
57 57
58 var InternalServices = &IntServices{} 58 var InternalServices = &IntServices{}
59 59