Example usage for com.badlogic.gdx.sql SQLiteGdxDatabaseCursor getDouble

Introduction

In this page you can find the example usage for com.badlogic.gdx.sql SQLiteGdxDatabaseCursor getDouble.

Prototype

public double getDouble(int columnIndex);

Source Link

Document

Returns the value of the requested column as a double.

Usage

From source file:de.longri.cachebox3.sqlite.dao.CacheDAO.java

License:Open Source License

Cache ReadFromCursor(SQLiteGdxDatabaseCursor reader, boolean fullDetails, boolean withDescription) {

    try {/*w  ww. j  a  va  2s  .c  om*/
        Cache cache = new Cache(reader.getDouble(2), reader.getDouble(3), fullDetails);

        cache.Id = reader.getLong(0);
        cache.setGcCode(reader.getString(1).trim());
        cache.setName(reader.getString(4).trim());
        cache.Size = CacheSizes.parseInt(reader.getInt(5));
        cache.setDifficulty(((float) reader.getShort(6)) / 2);
        cache.setTerrain(((float) reader.getShort(7)) / 2);
        cache.setArchived(reader.getInt(8) != 0);
        cache.setAvailable(reader.getInt(9) != 0);
        cache.setFound(reader.getInt(10) != 0);
        cache.Type = CacheTypes.values()[reader.getShort(11)];
        cache.setOwner(reader.getString(12).trim());

        cache.NumTravelbugs = reader.getInt(13);
        cache.setGcId(reader.getString(14));
        cache.Rating = (reader.getShort(15)) / 100.0f;
        if (reader.getInt(16) > 0)
            cache.setFavorite(true);
        else
            cache.setFavorite(false);

        if (reader.getInt(17) > 0)
            cache.setHasUserData(true);
        else
            cache.setHasUserData(false);

        if (reader.getInt(18) > 0)
            cache.setListingChanged(true);
        else
            cache.setListingChanged(false);

        if (reader.getInt(19) > 0)
            cache.setCorrectedCoordinates(true);
        else
            cache.setCorrectedCoordinates(false);

        if (fullDetails) {
            readDetailFromCursor(reader, cache.detail, fullDetails, withDescription);
        }

        return cache;
    } catch (Exception exc) {
        log.error("Read Cache", exc);
        return null;
    }
}

---

From source file:de.longri.cachebox3.sqlite.dao.WaypointDAO.java

License:Open Source License

/**
 * Create Waypoint Object from Reader./*from   ww w. j  a v  a  2 s. c o m*/
 *
 * @param reader
 * @param full   Waypoints as FullWaypoints (true) or Waypoint (false)
 * @return
 */
public Waypoint getWaypoint(SQLiteGdxDatabaseCursor reader, boolean full) {
    Waypoint WP = null;

    WP = new Waypoint(reader.getDouble(2), reader.getDouble(3), full);

    WP.setGcCode(reader.getString(0));
    WP.CacheId = reader.getLong(1);
    WP.Type = CacheTypes.values()[reader.getShort(4)];
    WP.IsSyncExcluded = reader.getInt(5) == 1;
    WP.IsUserWaypoint = reader.getInt(6) == 1;
    WP.setTitle(reader.getString(7).trim());
    WP.IsStart = reader.getInt(8) == 1;

    if (full) {
        WP.setClue(reader.getString(10));
        WP.setDescription(reader.getString(9));
        WP.setCheckSum(createCheckSum(WP));
    }
    return WP;
}

---

From source file:de.longri.cachebox3.sqlite.Import.CacheInfoList.java

License:Open Source License

/**
 * Mit dieser Methode wird die DB indexiert und die Klasse enthlt dann eine Statiche Liste mit den Cache Informationen. Wenn die Liste
 * nicht mehr bentigt wird, sollte sie mit dispose() gelscht werden.
 *//*  ww  w  .j a  v a  2  s  .com*/
public static void IndexDB() {
    mCacheInfoList = new HashMap<String, CacheInfo>();

    SQLiteGdxDatabaseCursor reader = Database.Data.rawQuery(
            "select GcCode, Id, ListingCheckSum, ImagesUpdated, DescriptionImagesUpdated, ListingChanged, Found, CorrectedCoordinates, Latitude, Longitude, GpxFilename_Id, Favorit from Caches",
            null);

    reader.moveToFirst();

    while (!reader.isAfterLast()) {
        CacheInfo cacheInfo = new CacheInfo();

        cacheInfo.id = reader.getLong(1);

        if (reader.isNull(2)) {
            cacheInfo.ListingCheckSum = 0;
        } else {
            cacheInfo.ListingCheckSum = reader.getInt(2);
        }

        if (reader.isNull(3)) {
            cacheInfo.ImagesUpdated = false;
        } else {
            cacheInfo.ImagesUpdated = reader.getInt(3) != 0;
        }

        if (reader.isNull(4)) {
            cacheInfo.DescriptionImagesUpdated = false;
        } else {
            cacheInfo.DescriptionImagesUpdated = reader.getInt(4) != 0;
        }

        if (reader.isNull(5)) {
            cacheInfo.ListingChanged = false;
        } else {
            cacheInfo.ListingChanged = reader.getInt(5) != 0;
        }

        if (reader.isNull(6)) {
            cacheInfo.Found = false;
        } else {
            cacheInfo.Found = reader.getInt(6) != 0;
        }

        if (reader.isNull(7)) {
            cacheInfo.CorrectedCoordinates = false;
        } else {
            cacheInfo.CorrectedCoordinates = reader.getInt(7) != 0;
        }

        if (reader.isNull(8)) {
            cacheInfo.Latitude = 361;
        } else {
            cacheInfo.Latitude = reader.getDouble(8);
        }
        if (reader.isNull(9)) {
            cacheInfo.Longitude = 361;
        } else {
            cacheInfo.Longitude = reader.getDouble(9);
        }

        cacheInfo.GpxFilename_Id = reader.getInt(10);

        if (reader.isNull(11)) {
            cacheInfo.favorite = false;
        } else {
            cacheInfo.favorite = reader.getInt(11) != 0;
        }

        mCacheInfoList.put(reader.getString(0), cacheInfo);
        reader.moveToNext();
    }
    reader.close();

}

---