Mercurial > gemma

comparison pkg/octree/cache.go @ 1135:19a04b150b6c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed SQL syntax errors introduced with 1153:2e6b47cdb2ca.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 07 Nov 2018 23:03:59 +0100
parents 2e6b47cdb2ca
children d753ce6cf588
comparison
equal deleted inserted replaced
1134:0420761c1c3f 1135:19a04b150b6c
46 const ( 46 const (
47 fetchOctreeSQL = ` 47 fetchOctreeSQL = `
48 SELECT octree_checksum, octree_index 48 SELECT octree_checksum, octree_index
49 FROM waterway.sounding_results 49 FROM waterway.sounding_results
50 WHERE bottleneck_id = $1 AND date_info = $2::date 50 WHERE bottleneck_id = $1 AND date_info = $2::date
51 AND octree_checksum NOT NULL AND octree_index NOT NULL 51 AND octree_checksum IS NOT NULL AND octree_index IS NOT NULL
52 ` 52 `
53 checkOctreeSQL = ` 53 checkOctreeSQL = `
54 SELECT CASE 54 SELECT CASE
55 WHEN octree_checksum = $3 THEN NULL 55 WHEN octree_checksum = $3 THEN NULL
56 ELSE octree_index 56 ELSE octree_index
57 END 57 END
58 FROM waterway.sounding_results 58 FROM waterway.sounding_results
59 WHERE bottleneck_id = $1 AND date_info = $2::date 59 WHERE bottleneck_id = $1 AND date_info = $2::date
60 AND octree_checksum NOT NULL AND octree_index NOT NULL 60 AND octree_checksum IS NOT NULL AND octree_index IS NOT NULL
61 ` 61 `
62 ) 62 )
63 63
64 var Cache = OctreeCache{ 64 var Cache = OctreeCache{
65 entries: map[cacheKey]*cacheEntry{}, 65 entries: map[cacheKey]*cacheEntry{},