Examples with IntrinsicModel com.questdb.parser.sql.model.IntrinsicModel used on opensource projects

Example 36 with IntrinsicModel

use of com.questdb.parser.sql.model.IntrinsicModel in project questdb by bluestreak01.

the class QueryFilterAnalyserTest method testIntervalSourceMin.

@Test
public void testIntervalSourceMin() throws Exception {
    IntrinsicModel m = modelOf("timestamp = '2015-02-23T10:00:55.000Z;15s;15m;5'");
    final String expected = "[Interval{lo=2015-02-23T10:00:55.000Z, hi=2015-02-23T10:01:10.000Z}," + "Interval{lo=2015-02-23T10:15:55.000Z, hi=2015-02-23T10:16:10.000Z}," + "Interval{lo=2015-02-23T10:30:55.000Z, hi=2015-02-23T10:31:10.000Z}," + "Interval{lo=2015-02-23T10:45:55.000Z, hi=2015-02-23T10:46:10.000Z}," + "Interval{lo=2015-02-23T11:00:55.000Z, hi=2015-02-23T11:01:10.000Z}]";
    Assert.assertEquals(expected, IntervalCompiler.asIntervalStr(m.intervals));
}

Example 37 with IntrinsicModel

use of com.questdb.parser.sql.model.IntrinsicModel in project questdb by bluestreak01.

the class QueryFilterAnalyserTest method testNotEqualsDoesNotOverlapWithIn.

@Test
public void testNotEqualsDoesNotOverlapWithIn() throws Exception {
    IntrinsicModel m = modelOf("sym in ('x','y') and sym != 'z' and ex != 'blah'");
    assertFilter(m, "'blah'ex!=");
    Assert.assertEquals("[x,y]", m.keyValues.toString());
    Assert.assertEquals("[8,12]", m.keyValuePositions.toString());
}

Example 38 with IntrinsicModel

use of com.questdb.parser.sql.model.IntrinsicModel in project questdb by bluestreak01.

the class QueryFilterAnalyserTest method testListOfValuesPositiveOverlapQuoteIndifference.

@Test
public void testListOfValuesPositiveOverlapQuoteIndifference() throws Exception {
    IntrinsicModel m = modelOf("timestamp in ('2014-01-01T12:30:00.000Z', '2014-01-02T12:30:00.000Z') and sym in ('a', \"z\") and sym in ('z')");
    Assert.assertNull(m.filter);
    Assert.assertEquals(IntrinsicValue.UNDEFINED, m.intrinsicValue);
    Assert.assertEquals("[z]", m.keyValues.toString());
}

Example 39 with IntrinsicModel

use of com.questdb.parser.sql.model.IntrinsicModel in project questdb by bluestreak01.

the class QueryFilterAnalyserTest method testFilterAndInterval.

@Test
public void testFilterAndInterval() throws Exception {
    IntrinsicModel m = modelOf("bid > 100 and timestamp in (\"2014-01-01T12:30:00.000Z\", \"2014-01-02T12:30:00.000Z\")");
    Assert.assertEquals("[Interval{lo=2014-01-01T12:30:00.000Z, hi=2014-01-02T12:30:00.000Z}]", IntervalCompiler.asIntervalStr(m.intervals));
    assertFilter(m, "100bid>");
}

Example 40 with IntrinsicModel

use of com.questdb.parser.sql.model.IntrinsicModel in project questdb by bluestreak01.

the class QueryFilterAnalyserTest method testEqualsOverlapWithIn.

@Test
public void testEqualsOverlapWithIn() throws Exception {
    IntrinsicModel m = modelOf("sym in ('x','y') and sym = 'y'");
    Assert.assertNull(m.filter);
    Assert.assertEquals("[y]", m.keyValues.toString());
    Assert.assertEquals("[12]", m.keyValuePositions.toString());
}