diff options
| author |  Miika Turkia <miika.turkia@gmail.com> | 2014-12-20 18:19:47 +0200 |
|---|---|---|
| committer |  Dirk Hohndel <dirk@hohndel.org> | 2014-12-20 11:29:37 -0800 |
| commit | 61002381e9b13b43f63b84f132876691a102d266 (patch) | |
| tree | 77aae179993097ebcca8cfd80d50562eea2c9551 /parse-xml.c | |
| parent | 82dea858eb6d9a5156331c8264c11af4aaf3e1b0 (diff) | |
| download | subsurface-61002381e9b13b43f63b84f132876691a102d266.tar.gz | |
Stub for collecting visibility on Cobalt DB import
Signed-off-by: Miika Turkia <miika.turkia@gmail.com>
Signed-off-by: Dirk Hohndel <dirk@hohndel.org>
Diffstat (limited to 'parse-xml.c')
| -rw-r--r-- | parse-xml.c | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/parse-xml.c b/parse-xml.c index d5496aa05..f6afe9391 100644 --- a/parse-xml.c +++ b/parse-xml.c @@ -2366,6 +2366,16 @@ extern int cobalt_buddies(void *handle, int columns, char **data, char **column) return 0; } +/* + * We still need to figure out how to map free text visibility to + * Subsurface star rating. + */ + +extern int cobalt_visibility(void *handle, int columns, char **data, char **column) +{ + return 0; +} + extern int cobalt_dive(void *param, int columns, char **data, char **column) { @@ -2375,6 +2385,7 @@ extern int cobalt_dive(void *param, int columns, char **data, char **column) char get_profile_template[] = "select runtime*60,(DepthPressure*10000/SurfacePressure)-10000,p.Temperature from Dive AS d JOIN TrackPoints AS p ON d.Id=p.DiveId where d.Id=%d"; char get_cylinder_template[] = "select FO2,FHe,StartingPressure,EndingPressure,TankSize,TankPressure,TotalConsumption from GasMixes where DiveID=%d and StartingPressure>0 group by FO2,FHe"; char get_buddy_template[] = "select l.Data from Items AS i, List AS l ON i.Value1=l.Id where i.DiveId=%d and l.Type=4"; + char get_visibility_template[] = "select l.Data from Items AS i, List AS l ON i.Value1=l.Id where i.DiveId=%d and l.Type=3"; char get_buffer[1024]; dive_start(); @@ -2432,6 +2443,13 @@ extern int cobalt_dive(void *param, int columns, char **data, char **column) return 1; } + snprintf(get_buffer, sizeof(get_buffer) - 1, get_visibility_template, cur_dive->number); + retval = sqlite3_exec(handle, get_buffer, &cobalt_visibility, 0, &err); + if (retval != SQLITE_OK) { + fprintf(stderr, "%s", translate("gettextFromC", "Database query get_cylinders failed.\n")); + return 1; + } + snprintf(get_buffer, sizeof(get_buffer) - 1, get_profile_template, cur_dive->number); retval = sqlite3_exec(handle, get_buffer, &cobalt_profile_sample, 0, &err); if (retval != SQLITE_OK) { |