Package javax.jcr.query

Examples of javax.jcr.query.Query.bindValue()

693
694
695
696
697
698
699
700
701
702
703
        try
        {
            Query query = getJcrSession().getWorkspace().getQueryManager().createQuery( q, Query.JCR_SQL2 );
            ValueFactory valueFactory = getJcrSession().getValueFactory();
            query.bindValue( "checksum", valueFactory.createValue( checksum ) );
            QueryResult result = query.execute();

            artifacts = new ArrayList<>();
            for ( Node n : JcrUtils.getNodes( result ) )
            {
View Full Code Here
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
        query.setOffset(offset);
        if (values != null && !values.isEmpty()) {
            for (Iterator<String> it = values.keySet().iterator(); it.hasNext();) {
                String varName = it.next();
                Value value = ValueFormat.getJCRValue(values.get(varName), sInfo.getNamePathResolver(), sInfo.getSession().getValueFactory());
                query.bindValue(varName, value);
            }
        }
        return new QueryInfoImpl(query.execute(), idFactory,
                sInfo.getNamePathResolver(), getQValueFactory());
    }
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
            ValueFactory vf = session.getValueFactory();

            QueryManager qm = session.getWorkspace().getQueryManager();
            Query q = qm.createQuery("select text from [nt:base] where id = $id", Query.JCR_SQL2);
            q.bindValue("id", vf.createValue("1"));
            QueryResult r = q.execute();
            RowIterator it = r.getRows();
            assertTrue(it.hasNext());
            Row row = it.nextRow();
            assertEquals("hello world", row.getValue("text").getString());
View Full Code Here
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
            query.setOffset(offset);
        }
        if (values != null && !values.isEmpty()) {
            for (Map.Entry<String, QValue> entry : values.entrySet()) {
                Value value = ValueFormat.getJCRValue(entry.getValue(), sInfo.getNamePathResolver(), sInfo.getSession().getValueFactory());
                query.bindValue(entry.getKey(), value);
            }
        }
        return new QueryInfoImpl(query.execute(), idFactory,
                sInfo.getNamePathResolver(), getQValueFactory());
    }
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
            QueryManager qm = session.getWorkspace().getQueryManager();

            // SQL-2

            Query q = qm.createQuery("select text from [nt:base] where id = $id", Query.JCR_SQL2);
            q.bindValue("id", vf.createValue("1"));
            QueryResult r = q.execute();
            RowIterator it = r.getRows();
            assertTrue(it.hasNext());
            Row row = it.nextRow();
            assertEquals("hello world", row.getValue("text").getString());
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
            + " AND CONTAINS(mytext, $searchExpression)";
        Query q = superuser.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
        assertEquals("Expected exactly 1 bind variable", 1, q.getBindVariableNames().length);
        assertEquals("searchExpression", q.getBindVariableNames()[0]);

        q.bindValue("searchExpression", superuser.getValueFactory().createValue("fox"));
        QueryResult result = q.execute();
        checkResult(result, 1);
    }

}
View Full Code Here
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
            query.setOffset(offset);
        }
        if (values != null && !values.isEmpty()) {
            for (Map.Entry<String, QValue> entry : values.entrySet()) {
                Value value = ValueFormat.getJCRValue(entry.getValue(), sInfo.getNamePathResolver(), sInfo.getSession().getValueFactory());
                query.bindValue(entry.getKey(), value);
            }
        }
        return new QueryInfoImpl(query.execute(), idFactory,
                sInfo.getNamePathResolver(), getQValueFactory());
    }
View Full Code Here
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
            query.setOffset(offset);
        }
        if (values != null && !values.isEmpty()) {
            for (Map.Entry<String, QValue> entry : values.entrySet()) {
                Value value = ValueFormat.getJCRValue(entry.getValue(), sInfo.getNamePathResolver(), sInfo.getSession().getValueFactory());
                query.bindValue(entry.getKey(), value);
            }
        }
        return new QueryInfoImpl(query.execute(), idFactory,
                sInfo.getNamePathResolver(), getQValueFactory());
    }
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
        QueryManager qm = session.getWorkspace().getQueryManager();

        // SQL-2

        Query q = qm.createQuery("select text from [nt:base] where id = $id", Query.JCR_SQL2);
        q.bindValue("id", vf.createValue("1"));
        QueryResult r = q.execute();
        RowIterator it = r.getRows();
        assertTrue(it.hasNext());
        Row row = it.nextRow();
        assertEquals("hello_world", row.getValue("text").getString());
View Full Code Here
191
192
193
194
195
196
197
198
199
200
201
        hello2.setProperty("data",  "y");
        session.save();
        ValueFactory vf = session.getValueFactory();
        QueryManager qm = session.getWorkspace().getQueryManager();
        Query q = qm.createQuery("select id from [nt:base] where data >= $data order by id", Query.JCR_SQL2);
        q.bindValue("data", vf.createValue("x"));
        for (int i = -1; i < 5; i++) {
            QueryResult r = q.execute();
            RowIterator it = r.getRows();
            assertEquals(3, r.getRows().getSize());
            assertEquals(3, r.getNodes().getSize());
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.