Examples with Schema org.hisp.dhis.schema.Schema used on opensource projects

Example 11 with Schema

use of org.hisp.dhis.schema.Schema in project dhis2-core by dhis2.

the class InMemoryQueryEngineTest method sortCreatedAsc.

@Test
public void sortCreatedAsc() {
    Schema schema = schemaService.getDynamicSchema(DataElement.class);
    Query query = Query.from(schema);
    query.setObjects(dataElements);
    query.addOrder(new Order(schema.getProperty("created"), Direction.ASCENDING));
    List<? extends IdentifiableObject> objects = queryEngine.query(query);
    assertEquals(6, objects.size());
    assertEquals("deabcdefghA", objects.get(0).getUid());
    assertEquals("deabcdefghB", objects.get(1).getUid());
    assertEquals("deabcdefghC", objects.get(2).getUid());
    assertEquals("deabcdefghD", objects.get(3).getUid());
    assertEquals("deabcdefghE", objects.get(4).getUid());
    assertEquals("deabcdefghF", objects.get(5).getUid());
}

Example 12 with Schema

use of org.hisp.dhis.schema.Schema in project dhis2-core by dhis2.

the class InMemoryQueryEngineTest method sortNameDesc.

@Test
public void sortNameDesc() {
    Schema schema = schemaService.getDynamicSchema(DataElement.class);
    Query query = Query.from(schema);
    query.setObjects(dataElements);
    query.addOrder(new Order(schema.getProperty("name"), Direction.DESCENDING));
    List<? extends IdentifiableObject> objects = queryEngine.query(query);
    assertEquals(6, objects.size());
    assertEquals("deabcdefghF", objects.get(0).getUid());
    assertEquals("deabcdefghE", objects.get(1).getUid());
    assertEquals("deabcdefghD", objects.get(2).getUid());
    assertEquals("deabcdefghC", objects.get(3).getUid());
    assertEquals("deabcdefghB", objects.get(4).getUid());
    assertEquals("deabcdefghA", objects.get(5).getUid());
}

Example 13 with Schema

use of org.hisp.dhis.schema.Schema in project dhis2-core by dhis2.

the class CriteriaQueryEngineTest method sortNameDesc.

@Test
public void sortNameDesc() {
    Schema schema = schemaService.getDynamicSchema(DataElement.class);
    Query query = Query.from(schema);
    query.addOrder(new Order(schema.getProperty("name"), Direction.DESCENDING));
    List<? extends IdentifiableObject> objects = queryEngine.query(query);
    assertEquals(6, objects.size());
    assertEquals("deabcdefghF", objects.get(0).getUid());
    assertEquals("deabcdefghE", objects.get(1).getUid());
    assertEquals("deabcdefghD", objects.get(2).getUid());
    assertEquals("deabcdefghC", objects.get(3).getUid());
    assertEquals("deabcdefghB", objects.get(4).getUid());
    assertEquals("deabcdefghA", objects.get(5).getUid());
}

Example 14 with Schema

use of org.hisp.dhis.schema.Schema in project dhis2-core by dhis2.

the class HibernateGenericStore method getByAttribute.

@Override
@SuppressWarnings("unchecked")
public T getByAttribute(Attribute attribute) {
    Schema schema = schemaService.getDynamicSchema(getClazz());
    if (schema == null || !schema.havePersistedProperty("attributeValues")) {
        return null;
    }
    Criteria criteria = getCriteria();
    criteria.createAlias("attributeValues", "av");
    criteria.add(Restrictions.eq("av.attribute", attribute));
    return (T) criteria.uniqueResult();
}

Example 15 with Schema

use of org.hisp.dhis.schema.Schema in project dhis2-core by dhis2.

the class HibernateGenericStore method getAttributeValueByAttributeAndValue.

@Override
@SuppressWarnings("unchecked")
public List<AttributeValue> getAttributeValueByAttributeAndValue(Attribute attribute, String value) {
    Schema schema = schemaService.getDynamicSchema(getClazz());
    if (schema == null || !schema.havePersistedProperty("attributeValues")) {
        return null;
    }
    String hql = "select av from " + getClazz().getSimpleName() + "  as e " + "inner join e.attributeValues av inner join av.attribute at where at = :attribute and av.value = :value)";
    return getQuery(hql).setEntity("attribute", attribute).setString("value", value).list();
}