[PATCH 1/2] Ignore deleted dives on Cobalt import
Miika Turkia
miika.turkia at gmail.com
Sun Feb 22 09:57:33 PST 2015
Signed-off-by: Miika Turkia <miika.turkia at gmail.com>
---
parse-xml.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/parse-xml.c b/parse-xml.c
index 1d9ce97..16988cd 100644
--- a/parse-xml.c
+++ b/parse-xml.c
@@ -2746,7 +2746,7 @@ int parse_cobalt_buffer(sqlite3 *handle, const char *url, const char *buffer, in
char *err = NULL;
target_table = table;
- char get_dives[] = "select Id,strftime('%s',DiveStartTime),LocationId,'buddy','notes',Units,(MaxDepthPressure*10000/SurfacePressure)-10000,DiveMinutes,SurfacePressure,SerialNumber,'model' from Dive";
+ char get_dives[] = "select Id,strftime('%s',DiveStartTime),LocationId,'buddy','notes',Units,(MaxDepthPressure*10000/SurfacePressure)-10000,DiveMinutes,SurfacePressure,SerialNumber,'model' from Dive where IsViewDeleted = 0";
retval = sqlite3_exec(handle, get_dives, &cobalt_dive, handle, &err);
--
2.1.0
More information about the subsurface
mailing list