/*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.facebook.presto.raptor.storage;
import com.facebook.presto.Session;
import com.facebook.presto.raptor.RaptorColumnHandle;
import com.facebook.presto.raptor.RaptorPageSource;
import com.facebook.presto.spi.Page;
import com.facebook.presto.spi.type.Type;
import com.facebook.presto.testing.MaterializedResult;
import com.google.common.collect.ImmutableList;
import com.google.common.collect.Iterables;
import com.google.common.io.Files;
import io.airlift.testing.FileUtils;
import org.skife.jdbi.v2.DBI;
import org.skife.jdbi.v2.Handle;
import org.skife.jdbi.v2.IDBI;
import org.testng.annotations.AfterMethod;
import org.testng.annotations.BeforeMethod;
import org.testng.annotations.Test;
import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.UUID;
import static com.facebook.presto.operator.OperatorAssertion.toMaterializedResult;
import static com.facebook.presto.operator.RowPagesBuilder.rowPagesBuilder;
import static com.facebook.presto.raptor.storage.DatabaseLocalStorageManager.getShardPath;
import static com.facebook.presto.spi.type.BigintType.BIGINT;
import static com.facebook.presto.spi.type.TimeZoneKey.UTC_KEY;
import static com.facebook.presto.spi.type.VarcharType.VARCHAR;
import static com.facebook.presto.testing.TestingBlockEncodingManager.createTestingBlockEncodingManager;
import static java.util.Locale.ENGLISH;
import static org.testng.Assert.assertEquals;
import static org.testng.Assert.assertFalse;
import static org.testng.Assert.assertTrue;
@Test(singleThreaded = true)
public class TestDatabaseLocalStorageManager
{
private Handle dummyHandle;
private File dataDir;
private LocalStorageManager storageManager;
@BeforeMethod
public void setup()
throws IOException
{
IDBI dbi = new DBI("jdbc:h2:mem:test" + System.nanoTime());
dummyHandle = dbi.open();
dataDir = Files.createTempDir();
DatabaseLocalStorageManagerConfig config = new DatabaseLocalStorageManagerConfig().setDataDirectory(dataDir);
storageManager = new DatabaseLocalStorageManager(dbi, createTestingBlockEncodingManager(), config);
}
@AfterMethod
public void tearDown()
{
dummyHandle.close();
FileUtils.deleteRecursively(dataDir);
}
@Test
public void testImportFlow()
throws IOException
{
Session session = Session.builder()
.setUser("user")
.setSource("source")
.setCatalog("catalog")
.setSchema("schema")
.setTimeZoneKey(UTC_KEY)
.setLocale(ENGLISH)
.build();
ImmutableList<Type> types = ImmutableList.<Type>of(VARCHAR, BIGINT);
UUID shardUuid = UUID.randomUUID();
assertFalse(storageManager.shardExists(shardUuid));
List<RaptorColumnHandle> columnHandles = ImmutableList.of(
new RaptorColumnHandle("test", "column_7", 7L, VARCHAR),
new RaptorColumnHandle("test", "column_11", 11L, BIGINT));
List<Page> pages = rowPagesBuilder(types)
.row("alice", 0)
.row("bob", 1)
.row("charlie", 2)
.row("dave", 3)
.pageBreak()
.row("alice", 4)
.row("bob", 5)
.row("charlie", 6)
.row("dave", 7)
.pageBreak()
.row("alice", 8)
.row("bob", 9)
.row("charlie", 10)
.row("dave", 11)
.build();
MaterializedResult expected = toMaterializedResult(session, types, pages);
ColumnFileHandle fileHandles = storageManager.createStagingFileHandles(shardUuid, columnHandles);
for (Page page : pages) {
fileHandles.append(page);
}
storageManager.commit(fileHandles);
assertTrue(storageManager.shardExists(shardUuid));
RaptorPageSource raptorPageSource = new RaptorPageSource(ImmutableList.of(
storageManager.getBlocks(shardUuid, columnHandles.get(0)),
storageManager.getBlocks(shardUuid, columnHandles.get(1))));
List<Page> actualPages = new ArrayList<>();
while (!raptorPageSource.isFinished()) {
Page page = raptorPageSource.getNextPage();
if (page != null) {
actualPages.add(page);
}
}
MaterializedResult actual = toMaterializedResult(session, types, actualPages);
assertEquals(actual, expected);
}
@Test
public void testImportEmptySource()
throws IOException
{
UUID shardUuid = UUID.randomUUID();
List<RaptorColumnHandle> columnHandles = ImmutableList.of(new RaptorColumnHandle("test", "column_13", 13L, BIGINT));
ColumnFileHandle fileHandles = storageManager.createStagingFileHandles(shardUuid, columnHandles);
storageManager.commit(fileHandles);
assertTrue(storageManager.shardExists(shardUuid));
assertTrue(Iterables.isEmpty(storageManager.getBlocks(shardUuid, columnHandles.get(0))));
}
@Test
public void testShardPath()
{
UUID uuid = UUID.fromString("db298a0c-e968-4d5a-8e58-b1021c7eab2c");
File expected = getShardPath(new File("/data/test"), uuid);
File actual = new File("/data/test/db/29/8a/db298a0c-e968-4d5a-8e58-b1021c7eab2c");
assertEquals(expected, actual);
}
}