Changeset e355037 in subsurface


Ignore:
Timestamp:
Apr 11, 2017, 5:26:31 PM (3 months ago)
Author:
Dirk Hohndel <dirk@…>
Branches:
master
Children:
360cd85
Parents:
4ea4e8f
git-author:
Miika Turkia <miika.turkia@…> (04/11/17 11:06:37)
git-committer:
Dirk Hohndel <dirk@…> (04/11/17 17:26:31)
Message:

Ignore empty cylinders on Cobalt import

It appears that Cobalt might include additional gas mixes, and only way
to determine what is used appears to be to ensure that start and end
pressures are greater than 0. One would assume there to be something
else available in the database, but I was not able to spot it.

Fixes #297

Signed-off-by: Miika Turkia <miika.turkia@…>

File:
1 edited

Legend:

Unmodified
Added
Removed
  • core/parse-xml.c

    rbcad5dd re355037  
    28702870        char *err = NULL;
    28712871        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";
    2872         char get_cylinder_template[] = "select FO2,FHe,StartingPressure,EndingPressure,TankSize,TankPressure,TotalConsumption from GasMixes where DiveID=%d and StartingPressure>0 group by FO2,FHe";
     2872        char get_cylinder_template[] = "select FO2,FHe,StartingPressure,EndingPressure,TankSize,TankPressure,TotalConsumption from GasMixes where DiveID=%d and StartingPressure>0 and EndingPressure > 0 group by FO2,FHe";
    28732873        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";
    28742874        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";
Note: See TracChangeset for help on using the changeset viewer.