protected QueryObjectModel createQuery(Ordering[] orderings) throws RepositoryException { JoinCondition c = qf.equiJoinCondition( LEFT, propertyName1, RIGHT, propertyName2); QueryObjectModel qom = createQuery( QueryObjectModelConstants.JCR_JOIN_TYPE_INNER, c); return qf.createQuery(qom.getSource(), qom.getConstraint(), orderings, qom.getColumns()); } }
private String format() throws RepositoryException { append("SELECT "); append(qom.getColumns()); append(" FROM "); append(qom.getSource()); Constraint c = qom.getConstraint(); if (c != null) { append(" WHERE "); append(c); } Ordering[] orderings = qom.getOrderings(); if (orderings.length > 0) { append(" ORDER BY "); append(orderings); } return sb.toString(); }
private String format() throws RepositoryException { append("SELECT "); append(qom.getColumns()); append(" FROM "); append(qom.getSource()); Constraint c = qom.getConstraint(); if (c != null) { append(" WHERE "); append(c); } Ordering[] orderings = qom.getOrderings(); if (orderings.length > 0) { append(" ORDER BY "); append(orderings); } return sb.toString(); }
public void testCreateQueryFromSource() throws RepositoryException { Source selector = qf.selector(testNodeType, SELECTOR_NAME1); QueryObjectModel qom = qf.createQuery(selector, null, null, null); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertNull("Constraint must be null", qom.getConstraint()); assertEquals("Wrong size of orderings", 0, qom.getOrderings().length); assertEquals("Wrong size of columns", 0, qom.getColumns().length); }
public void testCreateQuery() throws RepositoryException { Selector selector = qf.selector(testNodeType, SELECTOR_NAME1); QueryObjectModel qom = qf.createQuery(selector, null, null, null); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertNull("Constraint must be null", qom.getConstraint()); assertEquals("Wrong size of orderings", 0, qom.getOrderings().length); assertEquals("Wrong size of columns", 0, qom.getColumns().length); }
private String format() throws RepositoryException { append("SELECT "); append(qom.getColumns()); append(" FROM "); append(qom.getSource()); Constraint c = qom.getConstraint(); if (c != null) { append(" WHERE "); append(c); } Ordering[] orderings = qom.getOrderings(); if (orderings.length > 0) { append(" ORDER BY "); append(orderings); } return sb.toString(); }
public void testCreateQueryFromSourceWithConstraint() throws RepositoryException { Source selector = qf.selector(testNodeType, SELECTOR_NAME1); PropertyExistence propExist = qf.propertyExistence(SELECTOR_NAME1, propertyName1); QueryObjectModel qom = qf.createQuery( selector, propExist, null, null); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertTrue("Not a property existence constraint", qom.getConstraint() instanceof PropertyExistence); assertEquals("Wrong size of orderings", 0, qom.getOrderings().length); assertEquals("Wrong size of columns", 0, qom.getColumns().length); }
public void testCreateQueryWithConstraint() throws RepositoryException { Selector selector = qf.selector(testNodeType, SELECTOR_NAME1); PropertyExistence propExist = qf.propertyExistence(SELECTOR_NAME1, propertyName1); QueryObjectModel qom = qf.createQuery( selector, propExist, null, null); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertTrue("Not a property existence constraint", qom.getConstraint() instanceof PropertyExistence); assertEquals("Wrong size of orderings", 0, qom.getOrderings().length); assertEquals("Wrong size of columns", 0, qom.getColumns().length); }
public void testCreateQueryFromSourceWithConstraintAndOrdering() throws RepositoryException { Source selector = qf.selector(testNodeType, SELECTOR_NAME1); PropertyExistence propExist = qf.propertyExistence(SELECTOR_NAME1, propertyName1); PropertyValue propValue = qf.propertyValue(SELECTOR_NAME1, propertyName1); Ordering ordering = qf.ascending(propValue); QueryObjectModel qom = qf.createQuery(selector, propExist, new Ordering[]{ordering}, null); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertTrue("Not a property existence constraint", qom.getConstraint() instanceof PropertyExistence); assertEquals("Wrong size of orderings", 1, qom.getOrderings().length); assertEquals("Wrong size of columns", 0, qom.getColumns().length); }
public void testCreateQueryWithConstraintAndOrdering() throws RepositoryException { Selector selector = qf.selector(testNodeType, SELECTOR_NAME1); PropertyExistence propExist = qf.propertyExistence(SELECTOR_NAME1, propertyName1); PropertyValue propValue = qf.propertyValue(SELECTOR_NAME1, propertyName1); Ordering ordering = qf.ascending(propValue); QueryObjectModel qom = qf.createQuery(selector, propExist, new Ordering[]{ordering}, null); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertTrue("Not a property existence constraint", qom.getConstraint() instanceof PropertyExistence); assertEquals("Wrong size of orderings", 1, qom.getOrderings().length); assertEquals("Wrong size of columns", 0, qom.getColumns().length); }
public void testCreateQueryFromSourceWithConstraintOrderingAndColumn() throws RepositoryException { Source selector = qf.selector(testNodeType, SELECTOR_NAME1); PropertyExistence propExist = qf.propertyExistence(SELECTOR_NAME1, propertyName1); PropertyValue propValue = qf.propertyValue(SELECTOR_NAME1, propertyName1); Ordering ordering = qf.ascending(propValue); Column column = qf.column(SELECTOR_NAME1, propertyName1, propertyName1); QueryObjectModel qom = qf.createQuery(selector, propExist, new Ordering[]{ordering}, new Column[]{column}); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertTrue("Not a property existence constraint", qom.getConstraint() instanceof PropertyExistence); assertEquals("Wrong size of orderings", 1, qom.getOrderings().length); assertEquals("Wrong size of columns", 1, qom.getColumns().length); }
public void testCreateQueryWithConstraintOrderingAndColumn() throws RepositoryException { Selector selector = qf.selector(testNodeType, SELECTOR_NAME1); PropertyExistence propExist = qf.propertyExistence(SELECTOR_NAME1, propertyName1); PropertyValue propValue = qf.propertyValue(SELECTOR_NAME1, propertyName1); Ordering ordering = qf.ascending(propValue); Column column = qf.column(SELECTOR_NAME1, propertyName1, propertyName1); QueryObjectModel qom = qf.createQuery(selector, propExist, new Ordering[]{ordering}, new Column[]{column}); assertTrue("Not a selector source", qom.getSource() instanceof Selector); assertTrue("Not a property existence constraint", qom.getConstraint() instanceof PropertyExistence); assertEquals("Wrong size of orderings", 1, qom.getOrderings().length); assertEquals("Wrong size of columns", 1, qom.getColumns().length); }
@Test public void createQuery() throws RepositoryException { Selector s = f.selector("nt:file", "x"); BindVariableValue b = f.bindVariable("var"); Constraint c = f.propertyExistence("x", "c"); PropertyValue p = f.propertyValue("x", "propertyName"); c = f.and(f.comparison(p, QueryObjectModelConstants.JCR_OPERATOR_EQUAL_TO, b), c); Ordering o = f.ascending(p); Column col = f.column("x", "propertyName", "columnName"); Ordering[] ords = new Ordering[]{o}; Column[] cols = new Column[]{col}; QueryObjectModel q = f.createQuery(s, c, ords, cols); assertEquals(Query.JCR_JQOM, q.getLanguage()); String[] bv = q.getBindVariableNames(); assertEquals(1, bv.length); assertEquals("var", bv[0]); assertEquals(s, q.getSource()); assertEquals(c, q.getConstraint()); assertEquals(o, q.getOrderings()[0]); assertEquals(col, q.getColumns()[0]); }