Mercurial > gemma

comparison pkg/models/sr.go @ 1572:056a86b24be2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Made bottleneck primary key an int. Attention: This may break something!
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 12 Dec 2018 19:21:02 +0100
parents 84e78d2e2d95
children 6a67cd819e93
comparison
equal deleted inserted replaced
1571:b3f2d43f43e4 1572:056a86b24be2
44 checkBottleneckSQL = ` 44 checkBottleneckSQL = `
45 SELECT true FROM waterway.bottlenecks WHERE objnam = $1` 45 SELECT true FROM waterway.bottlenecks WHERE objnam = $1`
46 46
47 checkBottleneckDateUniqueSQL = ` 47 checkBottleneckDateUniqueSQL = `
48 SELECT true FROM waterway.sounding_results sr JOIN 48 SELECT true FROM waterway.sounding_results sr JOIN
49 waterway.bottlenecks bn ON sr.bottleneck_id = bn.bottleneck_id 49 waterway.bottlenecks bn ON sr.bottleneck_id = bn.id
50 WHERE bn.objnam = $1 AND sr.date_info = $2` 50 WHERE bn.objnam = $1 AND sr.date_info = $2`
51 ) 51 )
52 52
53 func (srd SoundingResultDate) MarshalJSON() ([]byte, error) { 53 func (srd SoundingResultDate) MarshalJSON() ([]byte, error) {
54 return json.Marshal(srd.Format(SoundingResultDateFormat)) 54 return json.Marshal(srd.Format(SoundingResultDateFormat))