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

Introduction

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

Prototype

public int getInt(int columnIndex);

Source Link

Document

Returns the value of the requested column as a int.

Usage

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

License:Open Source License

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

    try {//from   w w  w.  ja v  a 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.CacheDAO.java

License:Open Source License

private boolean readDetailFromCursor(SQLiteGdxDatabaseCursor reader, CacheDetail detail,
        boolean withReaderOffset, boolean withDescription) {
    // Reader includes Compleate Cache or Details only
    int readerOffset = withReaderOffset ? 20 : 0;

    detail.PlacedBy = reader.getString(readerOffset + 0).trim();

    if (reader.isNull(readerOffset + 5))
        detail.ApiStatus = Cache.NOTLIVE;
    else/*from ww w. ja  v a  2  s . c o  m*/
        detail.ApiStatus = (byte) reader.getInt(readerOffset + 5);

    String sDate = reader.getString(readerOffset + 1);
    DateFormat iso8601Format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    try {
        detail.DateHidden = iso8601Format.parse(sDate);
    } catch (ParseException e) {
        e.printStackTrace();
    }

    detail.Url = reader.getString(readerOffset + 2).trim();
    if (reader.getString(readerOffset + 3) != null)
        detail.TourName = reader.getString(readerOffset + 3).trim();
    else
        detail.TourName = "";
    if (reader.getString(readerOffset + 4) != "")
        detail.GPXFilename_ID = reader.getLong(readerOffset + 4);
    else
        detail.GPXFilename_ID = -1;
    detail.setAttributesPositive(new DLong(reader.getLong(readerOffset + 7), reader.getLong(readerOffset + 6)));
    detail.setAttributesNegative(new DLong(reader.getLong(readerOffset + 9), reader.getLong(readerOffset + 8)));

    if (reader.getString(readerOffset + 10) != null)
        detail.setHint(reader.getString(readerOffset + 10).trim());
    else
        detail.setHint("");

    if (withDescription) {
        detail.longDescription = reader.getString(readerOffset + 11);
        detail.tmpSolver = reader.getString(readerOffset + 12);
        detail.tmpNote = reader.getString(readerOffset + 13);
        detail.shortDescription = reader.getString(readerOffset + 14);
    }
    return true;
}

---

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

License:Open Source License

public Boolean loadBooleanValue(String gcCode, String key) {
    SQLiteGdxDatabaseCursor reader = Database.Data
            .rawQuery("select " + key + " from Caches where GcCode = \"" + gcCode + "\"", null);
    try {//from  w  w  w  .  ja v a  2  s  .  co m
        reader.moveToFirst();
        while (!reader.isAfterLast()) {
            if (reader.getInt(0) != 0) { // gefunden. Suche abbrechen
                return true;
            }
            reader.moveToNext();
        }
    } catch (Exception ex) {
        return false;
    } finally {
        reader.close();
    }

    return false;
}

---

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

License:Open Source License

public Category ReadFromCursor(SQLiteGdxDatabaseCursor reader) {
    Category result = new Category();

    result.Id = reader.getLong(0);//w  w  w .j ava 2  s  .  c  o  m
    result.GpxFilename = reader.getString(1);
    result.pinned = reader.getInt(2) != 0;

    // alle GpxFilenames einlesen
    SQLiteGdxDatabaseCursor reader2 = Database.Data.rawQuery(
            "select ID, GPXFilename, Imported, CacheCount from GpxFilenames where CategoryId=?",
            new String[] { String.valueOf(result.Id) });
    reader2.moveToFirst();
    while (reader2.isAfterLast() == false) {
        GpxFilenameDAO gpxFilenameDAO = new GpxFilenameDAO();
        GpxFilename gpx = gpxFilenameDAO.ReadFromCursor(reader2);
        result.add(gpx);
        reader2.moveToNext();
    }
    reader2.close();

    return result;
}

---

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

License:Open Source License

public GpxFilename ReadFromCursor(SQLiteGdxDatabaseCursor reader) {
    long id;/*from w  w  w .  ja  v  a2  s.c o  m*/
    String gpxFileName;
    long categoryId = -1;

    id = reader.getLong(0);
    gpxFileName = reader.getString(1);

    GpxFilename result = new GpxFilename(id, gpxFileName, categoryId);

    if (reader.isNull(2))
        result.Imported = new Date();
    else {
        String sDate = reader.getString(2);
        DateFormat iso8601Format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        try {
            result.Imported = iso8601Format.parse(sDate);
        } catch (ParseException e) {
            result.Imported = new Date();
        }
    }

    if (reader.isNull(3))
        result.CacheCount = 0;
    else
        result.CacheCount = reader.getInt(3);

    return result;
}

---

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

License:Open Source License

public int getImageCount(String whereClause) {
    int count = 0;

    SQLiteGdxDatabaseCursor reader = Database.Data
            .rawQuery("select count(id) from Images where GcCode in (select GcCode from Caches "
                    + ((whereClause.length() > 0) ? "where " + whereClause : whereClause) + ")", null);

    if (reader == null)
        return 0;
    reader.moveToFirst();/*  ww  w .jav a  2  s  .c  o m*/

    if (!reader.isAfterLast()) {
        count = reader.getInt(0);
    }
    reader.close();

    return count;
}

---

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

License:Open Source License

/**
 * Create Waypoint Object from Reader./* w  w  w . java2  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.Database.java

License:Open Source License

public static int getCacheCountInDB(String absolutePath) {
    try {//from w  ww.j  a v a  2s.c o  m
        SQLiteGdxDatabase tempDB = SQLiteGdxDatabaseFactory.getNewDatabase(Gdx.files.absolute(absolutePath));
        tempDB.openOrCreateDatabase();
        SQLiteGdxDatabaseCursor result = tempDB.rawQuery("SELECT COUNT(*) FROM caches", null);
        result.moveToFirst();
        int count = result.getInt(1);
        result.close();
        tempDB.closeDatabase();
        return count;
    } catch (Exception exc) {
        return -1;
    }
}

---

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.
 *//*from   w ww .ja  v a2 s.  c  o  m*/
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();

}

---

From source file:de.longri.cachebox3.types.ImageEntry.java

License:Open Source License

/**
 * @param reader//from  www.  jav  a 2 s . c om
  */
public ImageEntry(SQLiteGdxDatabaseCursor reader) {
    CacheId = reader.getLong(0);
    GcCode = reader.getString(1).trim();
    Name = reader.getString(2);
    Description = reader.getString(3);
    ImageUrl = reader.getString(4);
    IsCacheImage = reader.getInt(5) == 1 ? true : false;

    LocalPath = DescriptionImageGrabber.BuildImageFilename(GcCode, URI.create(ImageUrl));
}

---

• «
• 1
• 2
• »