Mercurial > gemma
comparison pkg/octree/cache.go @ 1135:19a04b150b6c
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{}, |