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

List of usage examples for com.badlogic.gdx.sql SQLiteGdxDatabaseCursor getString

  1. HOME
  2. Java
  3. com.badlogic.gdx
  4. com.badlogic.gdx.sql.*
  5. SQLiteGdxDatabaseCursor
  6. getString

Introduction

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

Prototype

public String getString(int columnIndex);

Source Link

Document

Returns the value of the requested column as a string.

Usage

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

License:Open Source License

public static String GetShortDescription(Cache cache) {
    String description = "";
    SQLiteGdxDatabaseCursor reader = Database.Data.rawQuery("select ShortDescription from Caches where Id=?",
            new String[] { Long.toString(cache.Id) });
    if (reader == null)
        return "";
    reader.moveToFirst();/*from  ww  w.  j  av a2s .  c om*/
    while (!reader.isAfterLast()) {
        if (reader.getString(0) != null)
            description = reader.getString(0);
        reader.moveToNext();
    }
    reader.close();
    return description;
}

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

License:Open Source License

public static String GetDescription(Cache cache) {
    String description = "";
    SQLiteGdxDatabaseCursor reader = Database.Data.rawQuery("select Description from Caches where Id=?",
            new String[] { Long.toString(cache.Id) });
    if (reader == null)
        return "";
    reader.moveToFirst();/*from  ww  w.  j  a  v a  2 s. co m*/
    while (!reader.isAfterLast()) {
        if (reader.getString(0) != null)
            description = reader.getString(0);
        reader.moveToNext();
    }
    reader.close();
    return description;
}

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

License:Open Source License

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

    try {// ww w .j a v  a2 s . c  o  m
        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/*  w w  w .j  a va 2 s.  co  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 ArrayList<String> getGcCodesFromMustLoadImages() {

    ArrayList<String> GcCodes = new ArrayList<String>();

    SQLiteGdxDatabaseCursor reader = Database.Data.rawQuery(
            "select GcCode from Caches where Type<>4 and (ImagesUpdated=0 or DescriptionImagesUpdated=0)",
            null);//  ww  w. ja  va2  s . c  o m

    if (reader.getCount() > 0) {
        reader.moveToFirst();
        while (!reader.isAfterLast()) {
            String GcCode = reader.getString(0);
            GcCodes.add(GcCode);
            reader.moveToNext();
        }
    }
    reader.close();
    return GcCodes;
}

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);//from  w w w  . j a  va2 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  ww.ja  va  2 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 ArrayList<String> getImageURLsForCache(String GcCode) {
    ArrayList<String> images = new ArrayList<String>();

    SQLiteGdxDatabaseCursor reader = Database.Data.rawQuery("select ImageUrl from Images where GcCode=?",
            new String[] { GcCode });

    if (reader == null)
        return images;
    reader.moveToFirst();/* w w  w.  j  ava 2 s .  c  om*/
    while (!reader.isAfterLast()) {
        images.add(reader.getString(0));
        reader.moveToNext();
    }
    reader.close();

    return images;
}

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

License:Open Source License

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

License:Open Source License

private int GetDatabaseSchemeVersion() {
    int result = -1;
    SQLiteGdxDatabaseCursor c = null;
    try {//w w  w .jav  a 2s.  c o  m
        c = rawQuery("select Value from Config where [Key] like ?",
                new String[] { "DatabaseSchemeVersionWin" });
    } catch (Exception exc) {
        return -1;
    }
    try {
        c.moveToFirst();
        while (!c.isAfterLast()) {
            String databaseSchemeVersion = c.getString(0);
            result = Integer.parseInt(databaseSchemeVersion);
            c.moveToNext();
        }
    } catch (Exception exc) {
        result = -1;
    }
    if (c != null) {
        c.close();
    }

    return result;
}