Examples with QueryTarget com.hazelcast.sql.impl.extract.QueryTarget used on opensource projects

Example 6 with QueryTarget

use of com.hazelcast.sql.impl.extract.QueryTarget in project hazelcast by hazelcast.

the class AvroQueryTargetTest method test_get.

@Test
public void test_get() {
    QueryTarget target = new AvroQueryTarget();
    QueryExtractor topExtractor = target.createExtractor(null, OBJECT);
    QueryExtractor nonExistingExtractor = target.createExtractor("nonExisting", OBJECT);
    QueryExtractor stringExtractor = target.createExtractor("string", VARCHAR);
    QueryExtractor booleanExtractor = target.createExtractor("boolean", BOOLEAN);
    QueryExtractor byteExtractor = target.createExtractor("byte", TINYINT);
    QueryExtractor shortExtractor = target.createExtractor("short", SMALLINT);
    QueryExtractor intExtractor = target.createExtractor("int", INT);
    QueryExtractor longExtractor = target.createExtractor("long", BIGINT);
    QueryExtractor floatExtractor = target.createExtractor("float", REAL);
    QueryExtractor doubleExtractor = target.createExtractor("double", DOUBLE);
    QueryExtractor decimalExtractor = target.createExtractor("decimal", DECIMAL);
    QueryExtractor timeExtractor = target.createExtractor("time", TIME);
    QueryExtractor dateExtractor = target.createExtractor("date", DATE);
    QueryExtractor timestampExtractor = target.createExtractor("timestamp", TIMESTAMP);
    QueryExtractor timestampTzExtractor = target.createExtractor("timestampTz", TIMESTAMP_WITH_TZ_OFFSET_DATE_TIME);
    QueryExtractor nullExtractor = target.createExtractor("null", OBJECT);
    QueryExtractor objectExtractor = target.createExtractor("object", OBJECT);
    Schema schema = SchemaBuilder.record("name").fields().name("string").type().stringType().noDefault().name("boolean").type().booleanType().noDefault().name("byte").type().intType().noDefault().name("short").type().intType().noDefault().name("int").type().intType().noDefault().name("long").type().longType().noDefault().name("float").type().floatType().noDefault().name("double").type().doubleType().noDefault().name("decimal").type().stringType().noDefault().name("time").type().stringType().noDefault().name("date").type().stringType().noDefault().name("timestamp").type().stringType().noDefault().name("timestampTz").type().stringType().noDefault().name("null").type().nullable().record("nul").fields().endRecord().noDefault().name("object").type().record("object").fields().endRecord().noDefault().endRecord();
    target.setTarget(new GenericRecordBuilder(schema).set("string", "string").set("boolean", true).set("byte", (byte) 127).set("short", (short) 32767).set("int", 2147483647).set("long", 9223372036854775807L).set("float", 1234567890.1F).set("double", 123451234567890.1D).set("decimal", "9223372036854775.123").set("time", "12:23:34").set("date", "2020-09-09").set("timestamp", "2020-09-09T12:23:34.1").set("timestampTz", "2020-09-09T12:23:34.2Z").set("null", null).set("object", new GenericRecordBuilder(SchemaBuilder.record("name").fields().endRecord()).build()).build(), null);
    assertThat(topExtractor.get()).isInstanceOf(GenericRecord.class);
    assertThat(nonExistingExtractor.get()).isNull();
    assertThat(stringExtractor.get()).isEqualTo("string");
    assertThat(booleanExtractor.get()).isEqualTo(true);
    assertThat(byteExtractor.get()).isEqualTo((byte) 127);
    assertThat(shortExtractor.get()).isEqualTo((short) 32767);
    assertThat(intExtractor.get()).isEqualTo(2147483647);
    assertThat(longExtractor.get()).isEqualTo(9223372036854775807L);
    assertThat(floatExtractor.get()).isEqualTo(1234567890.1F);
    assertThat(doubleExtractor.get()).isEqualTo(123451234567890.1D);
    assertThat(decimalExtractor.get()).isEqualTo(new BigDecimal("9223372036854775.123"));
    assertThat(timeExtractor.get()).isEqualTo(LocalTime.of(12, 23, 34));
    assertThat(dateExtractor.get()).isEqualTo(LocalDate.of(2020, 9, 9));
    assertThat(timestampExtractor.get()).isEqualTo(LocalDateTime.of(2020, 9, 9, 12, 23, 34, 100_000_000));
    assertThat(timestampTzExtractor.get()).isEqualTo(OffsetDateTime.of(2020, 9, 9, 12, 23, 34, 200_000_000, UTC));
    assertThat(nullExtractor.get()).isNull();
    assertThat(objectExtractor.get()).isNotNull();
}

Example 7 with QueryTarget

use of com.hazelcast.sql.impl.extract.QueryTarget in project hazelcast by hazelcast.

the class JsonQueryTargetTest method test_get.

@Test
@Parameters(method = "values")
public void test_get(Object value) {
    QueryTarget target = new JsonQueryTarget();
    QueryExtractor topExtractor = target.createExtractor(null, OBJECT);
    QueryExtractor nonExistingExtractor = target.createExtractor("nonExisting", OBJECT);
    QueryExtractor stringExtractor = target.createExtractor("string", VARCHAR);
    QueryExtractor booleanExtractor = target.createExtractor("boolean", BOOLEAN);
    QueryExtractor byteExtractor = target.createExtractor("byte", TINYINT);
    QueryExtractor shortExtractor = target.createExtractor("short", SMALLINT);
    QueryExtractor intExtractor = target.createExtractor("int", INT);
    QueryExtractor longExtractor = target.createExtractor("long", BIGINT);
    QueryExtractor floatExtractor = target.createExtractor("float", REAL);
    QueryExtractor doubleExtractor = target.createExtractor("double", DOUBLE);
    QueryExtractor decimalExtractor = target.createExtractor("decimal", DECIMAL);
    QueryExtractor timeExtractor = target.createExtractor("time", TIME);
    QueryExtractor dateExtractor = target.createExtractor("date", DATE);
    QueryExtractor timestampExtractor = target.createExtractor("timestamp", TIMESTAMP);
    QueryExtractor timestampTzExtractor = target.createExtractor("timestampTz", TIMESTAMP_WITH_TZ_OFFSET_DATE_TIME);
    QueryExtractor nullExtractor = target.createExtractor("null", OBJECT);
    QueryExtractor objectExtractor = target.createExtractor("object", OBJECT);
    target.setTarget(value, null);
    assertThat(topExtractor.get()).isInstanceOf(Map.class);
    assertThat(nonExistingExtractor.get()).isNull();
    assertThat(stringExtractor.get()).isEqualTo("string");
    assertThat(booleanExtractor.get()).isEqualTo(true);
    assertThat(byteExtractor.get()).isEqualTo((byte) 127);
    assertThat(shortExtractor.get()).isEqualTo((short) 32767);
    assertThat(intExtractor.get()).isEqualTo(2147483647);
    assertThat(longExtractor.get()).isEqualTo(9223372036854775807L);
    assertThat(floatExtractor.get()).isEqualTo(1234567890.1F);
    assertThat(doubleExtractor.get()).isEqualTo(123451234567890.1D);
    assertThat(decimalExtractor.get()).isEqualTo(new BigDecimal("9223372036854775.123"));
    assertThat(timeExtractor.get()).isEqualTo(LocalTime.of(12, 23, 34));
    assertThat(dateExtractor.get()).isEqualTo(LocalDate.of(2020, 9, 9));
    assertThat(timestampExtractor.get()).isEqualTo(LocalDateTime.of(2020, 9, 9, 12, 23, 34, 100_000_000));
    assertThat(timestampTzExtractor.get()).isEqualTo(OffsetDateTime.of(2020, 9, 9, 12, 23, 34, 200_000_000, UTC));
    assertThat(nullExtractor.get()).isNull();
    assertThat(objectExtractor.get()).isNotNull();
}

Example 8 with QueryTarget

use of com.hazelcast.sql.impl.extract.QueryTarget in project hazelcast by hazelcast.

the class AvroQueryTargetDescriptorTest method test_create.

@Test
@Parameters({ "true", "false" })
public void test_create(boolean key) {
    Extractors extractors = Extractors.newBuilder(SERIALIZATION_SERVICE).build();
    AvroQueryTargetDescriptor descriptor = AvroQueryTargetDescriptor.INSTANCE;
    // when
    QueryTarget target = descriptor.create(SERIALIZATION_SERVICE, extractors, key);
    // then
    assertThat(target).isInstanceOf(AvroQueryTarget.class);
}