/*
* Licensed to CRATE Technology GmbH ("Crate") under one or more contributor
* license agreements. See the NOTICE file distributed with this work for
* additional information regarding copyright ownership. Crate licenses
* this file to you 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.
*
* However, if you have executed another commercial license agreement
* with Crate these terms will supersede the license and you may use the
* software solely pursuant to the terms of the relevant commercial agreement.
*/
package io.crate.analyze;
import io.crate.blob.v2.BlobIndicesService;
import io.crate.exceptions.InvalidTableNameException;
import io.crate.exceptions.TableAlreadyExistsException;
import io.crate.exceptions.TableUnknownException;
import io.crate.metadata.TableIdent;
import io.crate.metadata.blob.BlobSchemaInfo;
import io.crate.test.integration.CrateDummyClusterServiceUnitTest;
import io.crate.testing.SQLExecutor;
import org.elasticsearch.cluster.metadata.IndexMetaData;
import org.junit.Before;
import org.junit.Test;
import static org.hamcrest.Matchers.is;
public class BlobTableAnalyzerTest extends CrateDummyClusterServiceUnitTest {
private SQLExecutor e;
@Before
public void prepare() {
TableIdent myBlobsIdent = new TableIdent(BlobSchemaInfo.NAME, "blobs");
TestingBlobTableInfo myBlobsTableInfo = TableDefinitions.createBlobTable(myBlobsIdent, clusterService);
e = SQLExecutor.builder(clusterService).addBlobTable(myBlobsTableInfo).build();
}
@Test(expected = IllegalArgumentException.class)
public void testWithInvalidProperty() {
e.analyze("create blob table screenshots with (foobar=1)");
}
@Test(expected = IllegalArgumentException.class)
public void testWithMultipleArgsToProperty() {
e.analyze("create blob table screenshots with (number_of_replicas=[1, 2])");
}
@Test
public void testCreateBlobTableAutoExpand() {
CreateBlobTableAnalyzedStatement analysis = e.analyze(
"create blob table screenshots clustered into 10 shards with (number_of_replicas='0-all')");
assertThat(analysis.tableIdent().name(), is("screenshots"));
assertThat(analysis.tableIdent().schema(), is(BlobSchemaInfo.NAME));
assertThat(analysis.tableParameter().settings().getAsInt(IndexMetaData.SETTING_NUMBER_OF_SHARDS, 0), is(10));
assertThat(analysis.tableParameter().settings().get(IndexMetaData.SETTING_AUTO_EXPAND_REPLICAS), is("0-all"));
}
@Test
public void testCreateBlobTableDefaultNumberOfShards() {
CreateBlobTableAnalyzedStatement analysis = e.analyze("create blob table screenshots");
assertThat(analysis.tableIdent().name(), is("screenshots"));
assertThat(analysis.tableIdent().schema(), is(BlobSchemaInfo.NAME));
assertThat(analysis.tableParameter().settings().getAsInt(IndexMetaData.SETTING_NUMBER_OF_SHARDS, 0), is(4));
}
@Test
public void testCreateBlobTableRaisesErrorIfAlreadyExists() throws Exception {
expectedException.expect(TableAlreadyExistsException.class);
e.analyze("create blob table blobs");
}
@Test
public void testCreateBlobTable() {
CreateBlobTableAnalyzedStatement analysis = e.analyze(
"create blob table screenshots clustered into 10 shards with (number_of_replicas='0-all')");
assertThat(analysis.tableIdent().name(), is("screenshots"));
assertThat(analysis.tableParameter().settings().getAsInt(IndexMetaData.SETTING_NUMBER_OF_SHARDS, 0), is(10));
assertThat(analysis.tableParameter().settings().get(IndexMetaData.SETTING_AUTO_EXPAND_REPLICAS), is("0-all"));
}
@Test
public void testCreateBlobTableWithPath() {
CreateBlobTableAnalyzedStatement analysis = e.analyze(
"create blob table screenshots with (blobs_path='/tmp/crate_blob_data')");
assertThat(analysis.tableIdent().name(), is("screenshots"));
assertThat(analysis.tableParameter().settings().get(BlobIndicesService.SETTING_INDEX_BLOBS_PATH.getKey()),
is("/tmp/crate_blob_data"));
}
@Test
public void testCreateBlobTableWithPathParameter() {
CreateBlobTableAnalyzedStatement analysis = e.analyze(
"create blob table screenshots with (blobs_path=?)", new Object[]{"/tmp/crate_blob_data"});
assertThat(analysis.tableIdent().name(), is("screenshots"));
assertThat(analysis.tableParameter().settings().get(BlobIndicesService.SETTING_INDEX_BLOBS_PATH.getKey()),
is("/tmp/crate_blob_data"));
}
@Test
public void testCreateBlobTableWithPathInvalidType() {
expectedException.expect(IllegalArgumentException.class);
expectedException.expectMessage("Invalid value for argument 'blobs_path'");
e.analyze("create blob table screenshots with (blobs_path=1)");
}
@Test
public void testCreateBlobTableWithPathInvalidParameter() {
expectedException.expect(IllegalArgumentException.class);
expectedException.expectMessage("Invalid value for argument 'blobs_path'");
e.analyze("create blob table screenshots with (blobs_path=?)", new Object[]{1});
}
@Test(expected = InvalidTableNameException.class)
public void testCreateBlobTableIllegalTableName() throws Exception {
e.analyze("create blob table \"blob.s\"");
}
@Test
public void testDropBlobTable() {
DropBlobTableAnalyzedStatement analysis = e.analyze("drop blob table blobs");
assertThat(analysis.tableIdent().name(), is("blobs"));
assertThat(analysis.tableIdent().schema(), is(BlobSchemaInfo.NAME));
}
@Test(expected = IllegalArgumentException.class)
public void testDropBlobTableWithInvalidSchema() {
e.analyze("drop blob table doc.users");
}
@Test
public void testDropBlobTableWithValidSchema() {
DropBlobTableAnalyzedStatement analysis = e.analyze("drop blob table \"blob\".blobs");
assertThat(analysis.tableIdent().name(), is("blobs"));
}
@Test(expected = TableUnknownException.class)
public void testDropBlobTableThatDoesNotExist() {
e.analyze("drop blob table unknown");
}
@Test
public void testDropBlobTableIfExists() throws Exception {
DropBlobTableAnalyzedStatement analysis = e.analyze("drop blob table if exists blobs");
assertThat(analysis.dropIfExists(), is(true));
assertThat(analysis.tableIdent().name(), is("blobs"));
assertThat(analysis.tableIdent().schema(), is(BlobSchemaInfo.NAME));
}
@Test
public void testDropNonExistentBlobTableIfExists() throws Exception {
DropBlobTableAnalyzedStatement analysis = e.analyze("drop blob table if exists unknown");
assertThat(analysis.dropIfExists(), is(true));
}
@Test(expected = IllegalArgumentException.class)
public void testAlterBlobTableWithInvalidProperty() throws Exception {
e.analyze("alter blob table blobs set (foobar='2')");
}
@Test
public void testAlterBlobTableWithReplicas() throws Exception {
AlterBlobTableAnalyzedStatement analysis = e.analyze("alter blob table blobs set (number_of_replicas=2)");
assertThat(analysis.table().ident().name(), is("blobs"));
assertThat(analysis.tableParameter().settings().getAsInt(IndexMetaData.SETTING_NUMBER_OF_REPLICAS, 0), is(2));
}
@Test
public void testAlterBlobTableWithPath() {
expectedException.expect(IllegalArgumentException.class);
expectedException.expectMessage("Invalid property \"blobs_path\" passed to [ALTER | CREATE] TABLE statement");
e.analyze("alter blob table blobs set (blobs_path=1)");
}
@Test
public void testCreateBlobTableWithParams() throws Exception {
CreateBlobTableAnalyzedStatement analysis = e.analyze(
"create blob table screenshots clustered into ? shards with (number_of_replicas= ?)",
new Object[]{2, "0-all"});
assertThat(analysis.tableIdent().name(), is("screenshots"));
assertThat(analysis.tableIdent().schema(), is(BlobSchemaInfo.NAME));
assertThat(analysis.tableParameter().settings().getAsInt(IndexMetaData.SETTING_NUMBER_OF_SHARDS, 0), is(2));
assertThat(analysis.tableParameter().settings().get(IndexMetaData.SETTING_AUTO_EXPAND_REPLICAS), is("0-all"));
}
@Test
public void testCreateBlobTableWithInvalidShardsParam() throws Exception {
expectedException.expect(IllegalArgumentException.class);
expectedException.expectMessage("invalid number 'foo'");
e.analyze("create blob table screenshots clustered into ? shards", new Object[]{"foo"});
}
}