How to use

queryForId

method

in

mil.nga.geopackage.core.contents.ContentsDao

/**
 * {@inheritDoc}
 */
@Override
public Contents getTableContents(String table) {
  ContentsDao contentDao = getContentsDao();
  Contents contents = null;
  try {
    contents = contentDao.queryForId(table);
  } catch (SQLException e) {
    throw new GeoPackageException("Failed to retrieve table contents: "
        + table, e);
  }
  return contents;
}

/**
 * Delete a Contents by id, cascading optionally including the user table
 * 
 * @param id
 *            id
 * @param userTable
 *            true if a user table
 * @return deleted count
 * @throws SQLException
 *             upon deletion error
 */
public int deleteByIdCascade(String id, boolean userTable)
    throws SQLException {
  int count = 0;
  if (id != null) {
    Contents contents = queryForId(id);
    if (contents != null) {
      count = deleteCascade(contents, userTable);
    } else if (userTable) {
      dropTable(id);
    }
  }
  return count;
}

/**
 * Get the bounding box for the table in the provided projection
 * 
 * @param projection
 *            desired bounding box projection
 * @param table
 *            table name
 * 
 * @return bounding box
 * @since 3.1.0
 */
public BoundingBox getBoundingBox(Projection projection, String table) {
  BoundingBox boundingBox = null;
  try {
    Contents contents = queryForId(table);
    boundingBox = contents.getBoundingBox(projection);
  } catch (SQLException e) {
    throw new GeoPackageException(
        "Failed to query for contents of table: " + table, e);
  }
  return boundingBox;
}

/**
 * {@inheritDoc}
 */
@Override
public AttributesDao getAttributesDao(String tableName) {
  ContentsDao dao = getContentsDao();
  Contents contents = null;
  try {
    contents = dao.queryForId(tableName);
  } catch (SQLException e) {
    throw new GeoPackageException("Failed to retrieve "
        + Contents.class.getSimpleName() + " for table name: "
        + tableName, e);
  }
  if (contents == null) {
    throw new GeoPackageException(
        "No Contents Table exists for table name: " + tableName);
  }
  return getAttributesDao(contents);
}

/**
 * {@inheritDoc}
 */
@Override
public AttributesDao getAttributesDao(String tableName) {
  ContentsDao dao = getContentsDao();
  Contents contents = null;
  try {
    contents = dao.queryForId(tableName);
  } catch (SQLException e) {
    throw new GeoPackageException("Failed to retrieve "
        + Contents.class.getSimpleName() + " for table name: "
        + tableName, e);
  }
  if (contents == null) {
    throw new GeoPackageException(
        "No Contents Table exists for table name: " + tableName);
  }
  return getAttributesDao(contents);
}

  @Override
  public void run() {
    for (int i = 0; i < attemptsPerThread; i++) {
      try {
        ContentsDao contentsDao = geoPackage
            .getContentsDao();
        Contents contents = contentsDao
            .queryForId(tableName);
        if (contents == null) {
          throw new Exception(
              "Contents was null, table name: "
                  + tableName);
        }
        TileDao dao = geoPackage.getTileDao(tableName);
        if (dao == null) {
          throw new Exception(
              "Tile DAO was null, table name: "
                  + tableName);
        }
      } catch (Exception e) {
        threadedTileDaoError = true;
        e.printStackTrace();
        break;
      }
    }
  }
};

/**
 * Set the contents in the user related table
 * 
 * @param table
 *            user related table
 */
protected void setContents(UserRelatedTable table) {
  ContentsDao dao = geoPackage.getContentsDao();
  Contents contents = null;
  try {
    contents = dao.queryForId(table.getTableName());
  } catch (SQLException e) {
    throw new GeoPackageException("Failed to retrieve "
        + Contents.class.getSimpleName() + " for table name: "
        + table.getTableName(), e);
  }
  if (contents == null) {
    throw new GeoPackageException(
        "No Contents Table exists for table name: "
            + table.getTableName());
  }
  table.setContents(contents);
}

Contents contents = contentsDao.queryForId(tableName);
if (contents != null) {
  Date lastChange = contents.getLastChange();

for (String featureTable : geoPackage.getFeatureTables()) {
  TestCase.assertTrue(geoPackage.isTable(featureTable));
  TestCase.assertNotNull(contentsDao.queryForId(featureTable));
  geoPackage.deleteTable(featureTable);
  TestCase.assertFalse(geoPackage.isTable(featureTable));
  TestCase.assertNull(contentsDao.queryForId(featureTable));
for (String tileTable : geoPackage.getTileTables()) {
  TestCase.assertTrue(geoPackage.isTable(tileTable));
  TestCase.assertNotNull(contentsDao.queryForId(tileTable));
  geoPackage.deleteTable(tileTable);
  TestCase.assertFalse(geoPackage.isTable(tileTable));
  TestCase.assertNull(contentsDao.queryForId(tileTable));
TestCase.assertNotNull(contentsDao.queryForId(attributeTable));
geoPackage.deleteTable(attributeTable);
TestCase.assertFalse(geoPackage.isTable(attributeTable));
TestCase.assertNull(contentsDao.queryForId(attributeTable));

Contents updatedContents = dao.queryForId(contents.getId());
TestCase.assertEquals(updatedLastChange,
    updatedContents.getLastChange());
  Contents reloadedContents = dao.queryForId(updatedContent
      .getId());
  TestCase.assertEquals(updatedMinimum,

Contents queryContents = dao.queryForId(contents.getTableName());
TestCase.assertNotNull(queryContents);
TestCase.assertEquals(contents.getTableName(),

Contents queryContents = dao.queryForId(tableName);
String queryContentsId = queryContents.getId();
TestCase.assertEquals(tableName, queryContents.getTableName());
Contents queryCopiedContents = dao.queryForId(copyTableName);
TestCase.assertEquals(copyTableName, queryCopiedContents.getTableName());
TestCase.assertEquals(queryContents.getDataType(),
queryContents = dao.queryForId(tableName);
TestCase.assertEquals(queryContentsId, queryContents.getId());
TestCase.assertEquals(tableName, queryContents.getTableName());

Contents queryContents = dao.queryForId(contents.getId());
TestCase.assertNull(queryContents);

Contents queryContents = contentsDao.queryForId(contentsId);
if (cascade) {
  TestCase.assertNull(queryContents);
  Contents queryContents = contentsDao.queryForId(contentsId);
  if (cascade) {
    TestCase.assertNull(queryContents);

    simpleTable.getTableName()));
validateContents(simpleTable,
    contentsDao.queryForId(simpleTable.getTableName()));
TestCase.assertEquals(SimpleAttributesTable.RELATION_TYPE.getDataType(),
    geoPackage.getTableType(simpleTable.getTableName()));
TestCase.assertNotNull(contentsDao.queryForId(simpleTable
    .getTableName()));
geoPackage.deleteTable(simpleTable.getTableName());
TestCase.assertFalse(geoPackage.isTable(simpleTable.getTableName()));
TestCase.assertNull(contentsDao.queryForId(simpleTable.getTableName()));

    mediaTable.getTableName()));
validateContents(mediaTable,
    contentsDao.queryForId(mediaTable.getTableName()));
TestCase.assertEquals(MediaTable.RELATION_TYPE.getDataType(),
    geoPackage.getTableType(mediaTable.getTableName()));
TestCase.assertNotNull(contentsDao.queryForId(mediaTable.getTableName()));
geoPackage.deleteTable(mediaTable.getTableName());
TestCase.assertFalse(geoPackage.isTable(mediaTable.getTableName()));
TestCase.assertNull(contentsDao.queryForId(mediaTable.getTableName()));

Contents contents = contentsDao.queryForId(tableName);
AttributesDao dao = geoPackage.getAttributesDao(contents);
TestCase.assertNotNull(dao);