Examples with Index org.folio.dbschema.Index used on opensource projects

Example 6 with Index

use of org.folio.dbschema.Index in project raml-module-builder by folio-org.

the class IndexTest method indexStringTypeFalse.

@Test
void indexStringTypeFalse() {
    Index idx = new Index();
    idx.setFieldName("testField");
    idx.setStringType(false);
    idx.setupIndex();
    assertEquals("(jsonb->'testField')", idx.getFinalTruncatedSqlExpression("test_table"));
}

Example 7 with Index

use of org.folio.dbschema.Index in project raml-module-builder by folio-org.

the class IndexTest method sqlExpressionQuery.

@Test
void sqlExpressionQuery() {
    Index index = index("testIdx", "testIdx");
    assertNull(index.getSqlExpressionQuery());
    index.setSqlExpressionQuery("foo($)");
    assertEquals("foo($)", index.getSqlExpressionQuery());
}

Example 8 with Index

use of org.folio.dbschema.Index in project raml-module-builder by folio-org.

the class IndexTest method arrayMultiFieldNames.

@Test
void arrayMultiFieldNames() {
    Index idx = index("testIdx", "testIdx");
    idx.setMultiFieldNames("field1[*].test,field2[*].name,field3.blah.blah2[*].foo");
    assertEquals("concat_space_sql(concat_array_object_values(test_table.jsonb->'field1','test') ," + " concat_array_object_values(test_table.jsonb->'field2','name') , concat_array_object_values(test_table.jsonb->'field3'->'blah'->'blah2','foo'))", idx.getFinalSqlExpression("test_table"));
}

Example 9 with Index

use of org.folio.dbschema.Index in project raml-module-builder by folio-org.

the class IndexTest method fieldNameWithMultipleNames.

@Test
void fieldNameWithMultipleNames() {
    Index idx = index("name1, name2", "name1, name2");
    assertThrows(UnsupportedOperationException.class, () -> idx.getFinalTruncatedSqlExpression("test_table"));
}

Example 10 with Index

use of org.folio.dbschema.Index in project raml-module-builder by folio-org.

the class IndexTest method sqlsetMultiFieldNamesWrapSetRemoveAccents.

@Test
void sqlsetMultiFieldNamesWrapSetRemoveAccents() {
    Index idx = index("testIdx", "testIdx");
    idx.setCaseSensitive(false);
    idx.setRemoveAccents(true);
    idx.setMultiFieldNames("test1,test2.test3");
    assertEquals("lower(f_unaccent(concat_space_sql(test_table.jsonb->>'test1' , test_table.jsonb->'test2'->>'test3')))", idx.getFinalSqlExpression("test_table"));
}