diff options
| author |  Miika Turkia <miika.turkia@gmail.com> | 2019-01-01 15:32:27 +0200 |
|---|---|---|
| committer | Miika Turkia <miika.turkia@gmail.com> | 2019-01-01 15:32:27 +0200 |
| commit | 9c4234549408d58918d9718fd9ed06b966e25b2e (patch) | |
| tree | c9676d49929dbe72aebc312d724ee4fab12da850 /core/import-shearwater.c | |
| parent | 5930cb52de2331523c05be26f50cf576be9b2335 (diff) | |
| download | subsurface-9c4234549408d58918d9718fd9ed06b966e25b2e.tar.gz | |
Use correct value for PO2
averagePPO2 appears to be correct value instead of currentPPO2SetPoint.
Signed-off-by: Miika Turkia <miika.turkia@gmail.com>
Diffstat (limited to 'core/import-shearwater.c')
| -rw-r--r-- | core/import-shearwater.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/core/import-shearwater.c b/core/import-shearwater.c index 67078e875..1a96c3e64 100644 --- a/core/import-shearwater.c +++ b/core/import-shearwater.c @@ -324,8 +324,8 @@ static int shearwater_cloud_dive(void *param, int columns, char **data, char **c struct parser_state *state = (struct parser_state *)param; sqlite3 *handle = state->sql_handle; char *err = NULL; - char get_profile_template[] = "select currentTime,currentDepth,waterTemp,currentPPO2SetPoint,currentNdl,CNSPercent,decoCeiling,firstStopDepth,firstStopTime from dive_log_records where diveLogId=%ld"; - char get_profile_template_ai[] = "select currentTime,currentDepth,waterTemp,currentPPO2SetPoint,currentNdl,CNSPercent,decoCeiling,aiSensor0_PressurePSI,aiSensor1_PressurePSI,firstStopDepth,firstStopTime from dive_log_records where diveLogId = %ld"; + char get_profile_template[] = "select currentTime,currentDepth,waterTemp,averagePPO2,currentNdl,CNSPercent,decoCeiling,firstStopDepth,firstStopTime from dive_log_records where diveLogId=%ld"; + char get_profile_template_ai[] = "select currentTime,currentDepth,waterTemp,averagePPO2,currentNdl,CNSPercent,decoCeiling,aiSensor0_PressurePSI,aiSensor1_PressurePSI,firstStopDepth,firstStopTime from dive_log_records where diveLogId = %ld"; char get_cylinder_template[] = "select fractionO2 / 100,fractionHe / 100 from dive_log_records where diveLogId = %ld group by fractionO2,fractionHe"; char get_changes_template[] = "select a.currentTime,a.fractionO2 / 100,a.fractionHe /100 from dive_log_records as a,dive_log_records as b where (a.id - 1) = b.id and (a.fractionO2 != b.fractionO2 or a.fractionHe != b.fractionHe) and a.diveLogId=b.divelogId and a.diveLogId = %ld"; char get_mode_template[] = "select distinct currentCircuitSetting from dive_log_records where diveLogId = %ld"; |