protected boolean metaDataExistsFor(String pyramidId) { String metadata = null; try { metadata = readMetaData(pyramidId); } catch (IOException e) { metadata = null; } return metadata != null; }
@Override public <T> List<TileData<T>> readTiles (String pyramidId, TileSerializer<T> serializer, Iterable<TileIndex> tiles, JSONObject properties ) throws IOException { return readTiles( pyramidId, serializer, tiles ); }
Statement stmt = null; try { if (!tableExists(TABLE_METADATA)) { return null; sb.append(COL_PYRAMID_ID); sb.append(" = '"); sb.append(toTableName(pyramidId)); sb.append("'");
@Test public void testMetadata() { try { sqlitePyramidIO.initializeForWrite(PYRAMID_ID); String metadata = "Some metadata."; sqlitePyramidIO.writeMetaData(PYRAMID_ID, metadata); Assert.assertTrue(sqlitePyramidIO.readMetaData(PYRAMID_ID).equals(metadata)); } catch (Exception e) { fail(e.getMessage()); } }
@Test public void testSingleTile() { try { sqlitePyramidIO.initializeForWrite(PYRAMID_ID); tileToWrite.setBin(0, 0, binVals); sqlitePyramidIO.writeTiles(PYRAMID_ID, serializer, Collections.singletonList(tileToWrite)); sqlitePyramidIO.readTiles(PYRAMID_ID, serializer, Collections.singletonList(tileDef)); Assert.assertTrue(readResult.size()==1);
@Test public void testInitializeForWrite() { try { sqlitePyramidIO.initializeForWrite(PYRAMID_ID); if (!sqlitePyramidIO.tableExists(PYRAMID_ID)) fail("Tile pyramid table wasn't created."); if (!sqlitePyramidIO.tableExists("metadata")) fail("Metadata table wasn't created."); } catch (Exception e) { fail(e.getMessage()); } }
try { StringBuilder sb = new StringBuilder(); if (metaDataExistsFor(pyramidId)) { sb.append("UPDATE "); sb.append(TABLE_METADATA); sb.append(COL_PYRAMID_ID); sb.append(" = '"); sb.append(toTableName(pyramidId)); sb.append("';"); sb.append(COL_METADATA); sb.append(") VALUES('"); sb.append(toTableName(pyramidId)); sb.append("','"); sb.append(metaData);
protected boolean tableExists(String pyramidId) throws SQLException { StringBuilder sb = new StringBuilder(); sb.append("SELECT name FROM 'sqlite_master' WHERE type='table' AND name="); sb.append(toTableName(pyramidId)); Statement stmt = null; boolean exists = false; try { stmt = _connection.createStatement(); stmt.execute(sb.toString()); exists = stmt.getResultSet().next(); } finally { if (stmt != null) { stmt.close(); } } return exists; }
@Override protected PyramidIO create() throws ConfigurationException { try { String driver = getPropertyValue(JDBC_DRIVER); String rootPath = getPropertyValue(ROOT_PATH); return new JDBCPyramidIO(driver, rootPath); } catch (ClassNotFoundException | SQLException e) { throw new ConfigurationException("Error creating JDBCPyramidIO", e); } } }
@After public void tearDown() throws Exception { try { sqlitePyramidIO.shutdown(); File dbFile = new File("test.db"); if (!dbFile.delete()) fail("Failed to delete test database."); } catch (Exception e) { fail(e.getMessage()); } }
sb.append(toTableName(pyramidId)); sb.append(" ("); sb.append(COL_ZOOM_LVL);
if (!tableExists(pyramidId)) { StringBuilder sb = new StringBuilder(); sb.append("CREATE TABLE "); sb.append(toTableName(pyramidId)); sb.append(" ("); sb.append(COL_ZOOM_LVL); if (!tableExists(TABLE_METADATA)) { StringBuilder sb = new StringBuilder(); sb.append("CREATE TABLE ");
PreparedStatement ps = null; try { if (!tableExists(pyramidId)) { sb.append(COL_TILE_DATA); sb.append(" FROM "); sb.append(toTableName(pyramidId)); sb.append(" WHERE "); sb.append(COL_ZOOM_LVL);
PreparedStatement ps = null; try { if (!tableExists(pyramidId)) { sb.append(COL_TILE_DATA); sb.append(" FROM "); sb.append(toTableName(pyramidId)); sb.append(" WHERE "); sb.append(COL_ZOOM_LVL);