org.hibernate.query.NativeQuery - java examples

Here are the examples of the java api org.hibernate.query.NativeQuery taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

74 Examples 7

19 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1024")
public void testAggregateWithMatchSortAndRegexWithMaxResults() {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'$or': [ {'author': { '$regex': 'Oscar.*'}}, {'name': { '$regex': 'Po.*'} }]}}, { '$sort' : { 'name' : 1 } }])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.setMaxResults(2).list();
        replacedertThat(result).onProperty("id").containsOnly(athanasia.getId(), imperatrix.getId());
    });
}

19 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1024")
public void testAggregateWithMatchSortAndRegexWithFirstResult() {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'author': { '$regex': '.*'  } }}, { '$sort' : { 'name' : -1 } }])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.setFirstResult(1).list();
        replacedertThat(result).onProperty("id").containsExactly(imperatrix.getId(), athanasia.getId());
    });
}

19 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1024")
public void testAggregateWithMatchSortAndRegexWithFirstResultAndMaxResults() {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'$or': [ {'author': { '$regex': 'Oscar.*'}}, {'name': { '$regex': 'Po.*'} }]}}, { '$sort' : { 'name' : -1 } }])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.setMaxResults(1).setFirstResult(1).list();
        replacedertThat(result).onProperty("id").containsExactly(imperatrix.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1024")
public void testAggregateWithMatchAndSort() {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'$or': [ {'author':'Oscar Wilde'}, {'name': 'Portia' }]}}, { '$sort' : { 'name' : -1 } }])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(portia.getId(), imperatrix.getId(), athanasia.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithMin() {
    inTransaction((session) -> {
        String queryJson = "'$query': { 'author': 'Oscar Wilde' } ";
        String min = " '$min': { 'year' : 1882 } ";
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({" + queryJson + "," + min + "})";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(imperatrix.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testAggregateWithLessThan() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'year': { '$lt': 3333.3} } }, { '$sort': {'name': -1 } } ])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(portia.getId(), imperatrix.getId(), athanasia.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1024")
public void testAggregateWithMatchSortAndRegexWithOptions() {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'$and': [ {'author': { '$regex': 'oscar.*', '$options': 'i' }}, {'name': { '$regex': 'po.*', '$options': 'i'} }]}}, { '$sort' : { 'name' : -1 } }])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(portia.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithAnd() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({ '$and': [{ 'author': 'Oscar Wilde' }, { 'name': 'Portia' }]})";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsOnly(portia.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithModifiersWithEnreplacedy() {
    inTransaction((session) -> {
        StringBuilder queryWithModifiers = new StringBuilder();
        queryWithModifiers.append("'$query': { } ");
        queryWithModifiers.append(", '$max': { 'year' : 1881 } ");
        queryWithModifiers.append(", '$explain': false ");
        queryWithModifiers.append(", '$snapshot': false ");
        queryWithModifiers.append(", 'hint': { 'year' : 1881 } ");
        queryWithModifiers.append(", 'maxScan': 11234");
        queryWithModifiers.append(", '$comment': 'Testing comment' ");
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({" + queryWithModifiers.toString() + "})";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(athanasia.getId());
    });
}

18 View Complete Implementation : GenericDAOHibernateImpl.java
Copyright Apache License 2.0
Author : inspire-software
/**
 * {@inheritDoc}
 */
@Override
public List executeNativeQuery(final String nativeQuery) {
    NativeQuery sqlQuery = sessionFactory.getCurrentSession().createNativeQuery(nativeQuery);
    return sqlQuery.list();
}

18 View Complete Implementation : FreemarkerTemplateQuery.java
Copyright Apache License 2.0
Author : slyak
private Query bind(Query query, Object[] values) {
    // get proxy target if exist.
    // must be hibernate QueryImpl
    NativeQuery targetQuery = AopTargetUtils.getTarget(query);
    Map<String, Object> params = getParams(values);
    if (!CollectionUtils.isEmpty(params)) {
        QueryBuilder.setParams(targetQuery, params);
    }
    return query;
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindOneWithPair() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ 'author' : 'Oscar Wilde' })";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1024")
public void testAggregateWithMatchSortAndRegex() {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'$or': [ {'author': { '$regex': 'Oscar.*', '$options': 'i'}}, {'name': { '$regex': 'Po.*'} }]}}, { '$sort' : { 'name' : -1 } }])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(portia.getId(), imperatrix.getId(), athanasia.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithMax() {
    inTransaction((session) -> {
        String queryJson = "'$query': { 'author': 'Oscar Wilde' } ";
        String max = " '$max': { 'year' : 1881 } ";
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({" + queryJson + "," + max + "})";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(athanasia.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testAggregateGreaterThan() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'year': { '$gt': 0.3} } }, { '$sort': {'name': -1 } } ])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(portia.getId(), imperatrix.getId(), athanasia.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithNor() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find( { '$nor' : [ { 'name' : 'Athanasia'}, { 'name' : 'Portia' }]})";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsOnly(imperatrix.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithExplain() {
    inTransaction((session) -> {
        StringBuilder queryWithModifiers = new StringBuilder();
        queryWithModifiers.append("'$query': { 'author': 'Oscar Wilde' } ");
        queryWithModifiers.append(", '$max': { 'year' : 1881 } ");
        queryWithModifiers.append(", '$explain': true ");
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({" + queryWithModifiers.toString() + "})";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        @SuppressWarnings("unchecked")
        List<Object[]> result = query.list();
        // I'm not sure we can test the content because this is the result of the explain command
        // and I believe it might change among versions
        replacedertThat(result.get(0)).isNotEmpty();
    });
}

18 View Complete Implementation : GenericDAOHibernateImpl.java
Copyright Apache License 2.0
Author : inspire-software
/**
 * {@inheritDoc}
 */
@Override
public int executeNativeUpdate(final String nativeQuery) {
    NativeQuery sqlQuery = sessionFactory.getCurrentSession().createNativeQuery(nativeQuery);
    return sqlQuery.executeUpdate();
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindAndModify() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findAndModify({ 'query': {'_id': 1}, 'update': { '$set': { 'author': 'Oscar Wilder' } }, 'new': true })";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Oscar Wilder");
    });
}

18 View Complete Implementation : GenericDAOHibernateImpl.java
Copyright Apache License 2.0
Author : inspire-software
/**
 * {@inheritDoc}
 */
@Override
public int executeNativeUpdate(final String nativeQuery, final Object... parameters) {
    NativeQuery sqlQuery = sessionFactory.getCurrentSession().createNativeQuery(nativeQuery);
    setQueryParameters(sqlQuery, parameters);
    return sqlQuery.executeUpdate();
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindAndModifyNoMatch() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findAndModify({ 'query': {'_id': 11}, 'update': { '$set': { 'author': 'Oscar Wilder' } }, 'new': true })";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testAggregate() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([{ '$match': {'author': 'Oscar Wilde' } }, { '$sort': {'name': -1 } } ])";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsExactly(portia.getId(), imperatrix.getId(), athanasia.getId());
    });
}

18 View Complete Implementation : QueryResultBuilder.java
Copyright Apache License 2.0
Author : blinkfox
/**
 * 根据是否是原生 SQL 查询来构造自定义类型的查询结果 {@code Query} 实例.
 *
 * @param isNative 是否原生 SQL
 * @return 额外改造后的 {@code Query} 实例.
 */
@SuppressWarnings({ "deprecation", "rawtypes" })
Query build(boolean isNative) {
    ResultTransformer resultTransformer = new FenixResultTransformer<>(this.getResultTypeClreplaced());
    if (isNative) {
        // 获取该查询对应的 NativeQuery,设置转换类型.
        NativeQuery<?> nativeQuery = ProxyHelper.getTarget(query);
        nativeQuery.setResultTransformer(resultTransformer);
        return nativeQuery;
    } else {
        org.hibernate.query.Query hibernateQuery = ProxyHelper.getTarget(query);
        hibernateQuery.setResultTransformer(resultTransformer);
        return hibernateQuery;
    }
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithNot() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find( { 'name' :  { '$not' : { '$eq' : 'Athanasia' }}})";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsOnly(portia.getId(), imperatrix.getId());
    });
}

18 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testFindWithPair() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({ 'author' : 'Oscar Wilde' })";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).onProperty("id").containsOnly(portia.getId(), imperatrix.getId(), athanasia.getId());
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1310")
public void testInsertOneThenRemove() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".insertOne({ '_id': { '$numberLong': '11' }, 'author': 'Oscar Wilder', 'name': 'The one and wildest', 'rating': '1' } )";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // Try again.
        try {
            n = query.executeUpdate();
            Fail.fail("Unique key constraint violation exception expected.");
        } catch (Exception e) {
        /* Expected */
        }
        // Check that it was inserted.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'The one and wildest' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(11);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Oscar Wilder");
        replacedertThat(result.get(0).getName()).isEqualTo("The one and wildest");
        // Need to remove here because subsequent tests replacedume the initial dataset.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that it is gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1313")
public void testInsertMultipleThenDeleteOne() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".insert( [ { '_id': { '$numberLong': '11' }, 'author': 'Oscar Wilde', 'name': 'Collection', 'rating': '1' }, { '_id': { '$numberLong': '12' }, 'author': 'Oscar Wilde', 'name': 'Collection', 'rating': '2' } ], { 'ordered': false } )";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(2);
        // Check that all were inserted.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".count({ 'name' : 'Collection' })";
        Object foundCount = session.createNativeQuery(nativeQuery).uniqueResult();
        replacedertThat(foundCount).isEqualTo(2L);
        // Try to delete first
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".deleteOne({ 'name': 'Collection' })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that it is gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ 'name': 'Collection' })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        // Try to delete second
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".deleteOne({ 'name': 'Collection' })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that it is gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ 'name': 'Collection' })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1313")
public void testInsertThenDeleteOneWithOptions() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".insertOne({ '_id': { '$numberLong': '11' }, 'author': 'Oscar Wilder', 'name': 'The one and wildest', 'rating': '1' } )";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".deleteOne({ '_id': { '$numberLong': '11' } }, { 'w': 'majority', 'wtimeout' : 100 })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // Check that it is gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@SuppressWarnings("unchecked")
public void testInsertMultipleThenRemove() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".insert( [ { '_id': { '$numberLong': '11' }, 'author': 'Oscar Wilder', 'name': 'The one and wildest', 'rating': '1' }, { '_id': { '$numberLong': '12' }, 'author': 'Friedrich Schiller', 'name': 'An die Freude', 'rating': '1' } ], { 'ordered': false } )";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(2);
        // Try again.
        try {
            n = query.executeUpdate();
            Fail.fail("Unique key constraint violation exception expected.");
        } catch (Exception e) {
        /* Expected */
        }
        // Check that all were inserted.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'The one and wildest' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(11);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Oscar Wilder");
        replacedertThat(result.get(0).getName()).isEqualTo("The one and wildest");
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'An die Freude' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(12);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Friedrich Schiller");
        replacedertThat(result.get(0).getName()).isEqualTo("An die Freude");
        // Need to remove here because subsequent tests replacedume the initial dataset.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': { '$numberLong': '12' } })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that they are gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '12' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@SuppressWarnings("unchecked")
@TestForIssue(jiraKey = "OGM-1027")
public void testInsertMultipleWithNumberLongThenRemove() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".insert( [ { '_id': NumberLong(11), 'author': 'Oscar Wilder', 'name': 'The one and wildest', 'rating': '1' }, { '_id': NumberLong(12), 'author': 'Friedrich Schiller', 'name': 'An die Freude', 'rating': '1' } ], { 'ordered': false } )";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(2);
        // Check that all were inserted.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'The one and wildest' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(11);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Oscar Wilder");
        replacedertThat(result.get(0).getName()).isEqualTo("The one and wildest");
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'An die Freude' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(12);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Friedrich Schiller");
        replacedertThat(result.get(0).getName()).isEqualTo("An die Freude");
        // Need to remove here because subsequent tests replacedume the initial dataset.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': NumberLong(11) })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': NumberLong(12) })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that they are gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': NumberLong(11) })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': NumberLong(12) })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1314")
public void testInsertManyThenDeleteManyWithOptions() {
    inTransaction((session) -> {
        String nativeQueryForInsertMany = "db." + OscarWildePoem.TABLE_NAME + ".insert( " + "[ { '_id': { '$numberLong': '11' }, 'author': 'Oscar Wilde', 'name': 'First name', 'rating': '8' }, " + "{ '_id': { '$numberLong': '12' }, 'author': 'Oscar Wilde', 'name': 'Second name','rating': '8' }, " + "{ '_id': { '$numberLong': '13' }, 'author': 'Oscar Wilde', 'name': 'Third name','rating': '8' } ], " + "{ 'ordered': false } )";
        NativeQuery queryInsertMany = session.createNativeQuery(nativeQueryForInsertMany);
        int countOfInserted = queryInsertMany.executeUpdate();
        replacedertThat(countOfInserted).isEqualTo(3);
        String nativeQueryForDeleteManyWithOptions = "db." + OscarWildePoem.TABLE_NAME + ".deleteMany( {'rating': '8'}, { 'w': 'majority', 'wtimeout' : 100 } )";
        NativeQuery queryDeleteManyWithOptions = session.createNativeQuery(nativeQueryForDeleteManyWithOptions);
        int countOfDeleted = queryDeleteManyWithOptions.executeUpdate();
        replacedertThat(countOfDeleted).isEqualTo(3);
        String nativeQueryForFindDeletedEnreplacedy = "db." + OscarWildePoem.TABLE_NAME + ".find( {'rating': '8'} )";
        NativeQuery queryFindDeletedEnreplacedy = session.createNativeQuery(nativeQueryForFindDeletedEnreplacedy).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> listOfFoundEnreplacedy = queryFindDeletedEnreplacedy.list();
        replacedertThat(listOfFoundEnreplacedy.size()).isEqualTo(0);
    });
}

17 View Complete Implementation : FreemarkerTemplateQuery.java
Copyright Apache License 2.0
Author : slyak
private Query createJpaQuery(String queryString) {
    Clreplaced<?> objectType = getQueryMethod().getReturnedObjectType();
    // get original proxy query.
    Query oriProxyQuery;
    // must be hibernate QueryImpl
    NativeQuery query;
    if (useJpaSpec && getQueryMethod().isQueryForEnreplacedy()) {
        oriProxyQuery = getEnreplacedyManager().createNativeQuery(queryString, objectType);
    } else {
        oriProxyQuery = getEnreplacedyManager().createNativeQuery(queryString);
        query = AopTargetUtils.getTarget(oriProxyQuery);
        Clreplaced<?> genericType;
        // find generic type
        if (objectType.isreplacedignableFrom(Map.clreplaced)) {
            genericType = objectType;
        } else {
            ClreplacedTypeInformation<?> ctif = ClreplacedTypeInformation.from(objectType);
            TypeInformation<?> actualType = ctif.getActualType();
            genericType = actualType.getType();
        }
        if (genericType != Void.clreplaced) {
            QueryBuilder.transform(query, genericType);
        }
    }
    // return the original proxy query, for a series of JPA actions, e.g.:close em.
    return oriProxyQuery;
}

17 View Complete Implementation : HibernateStore.java
Copyright GNU Lesser General Public License v2.1
Author : xwiki
private <T, E> T executeNative(String sqlString, Function<NativeQuery<E>, T> function) {
    try (Session session = getSessionFactory().openSession()) {
        NativeQuery<E> query = session.createNativeQuery(sqlString);
        return function.apply(query);
    }
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@SuppressWarnings("unchecked")
public void testInsertThenRemove() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".insert({ '_id': { '$numberLong': '11' }, 'author': 'Oscar Wilder', 'name': 'The one and wildest', 'rating': '1' } )";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // Try again.
        try {
            n = query.executeUpdate();
            Fail.fail("Unique key constraint violation exception expected.");
        } catch (Exception e) {
        /* Expected */
        }
        // Check that it was inserted.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'The one and wildest' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(11);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Oscar Wilder");
        replacedertThat(result.get(0).getName()).isEqualTo("The one and wildest");
        // Need to remove here because subsequent tests replacedume the initial dataset.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that it is gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : HibernatePotentialDuplicateStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public boolean exists(PotentialDuplicate potentialDuplicate) {
    NativeQuery<BigInteger> query;
    if (potentialDuplicate.getTeiA() == null) {
        return false;
    }
    if (potentialDuplicate.getTeiB() == null) {
        query = getSession().createNativeQuery("select count(potentialduplicateid) from potentialduplicate pd " + "where pd.teiA = :teia limit 1");
        query.setParameter("teia", potentialDuplicate.getTeiA());
    } else {
        query = getSession().createNativeQuery("select count(potentialduplicateid) from potentialduplicate pd " + "where (pd.teiA = :teia and pd.teiB = :teib) or (pd.teiA = :teib and pd.teiB = :teia) limit 1");
        query.setParameter("teia", potentialDuplicate.getTeiA());
        query.setParameter("teib", potentialDuplicate.getTeiB());
    }
    return query.getSingleResult().intValue() != 0;
}

17 View Complete Implementation : InfinispanRemoteSessionNativeQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testEnreplacediesInsertedInCurrentSessionAreFoundByNativeQuery() {
    Employee mike = new Employee(5l, "Mike", getDate(2020, Month.NOVEMBER, 21), 1);
    String query = "from HibernateOGMGenerated.Registry where name = 'Mike'";
    inTransaction(session -> {
        NativeQuery nativeQuery = session.createNativeQuery(query).addEnreplacedy(Employee.clreplaced);
        List result = nativeQuery.list();
        replacedertThat(result).isEmpty();
        session.persist(mike);
    });
    inTransaction(session -> {
        NativeQuery nativeQuery = session.createNativeQuery(query).addEnreplacedy(Employee.clreplaced);
        List result = nativeQuery.list();
        replacedertThat(result).containsExactly(mike);
    });
    inTransaction(session -> {
        session.delete(mike);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1311")
public void testInsertManyThenRemove() {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".insertMany( [ { '_id': { '$numberLong': '11' }, 'author': 'Oscar Wilder', 'name': 'The one and wildest', 'rating': '1' }, { '_id': { '$numberLong': '12' }, 'author': 'Friedrich Schiller', 'name': 'An die Freude', 'rating': '1' } ], { 'ordered': false } )";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(2);
        // Try again.
        try {
            n = query.executeUpdate();
            Fail.fail("Unique key constraint violation exception expected.");
        } catch (Exception e) {
        /* Expected */
        }
        // Check that all were inserted.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'The one and wildest' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(11);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Oscar Wilder");
        replacedertThat(result.get(0).getName()).isEqualTo("The one and wildest");
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne( { 'name': 'An die Freude' } )";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(12);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Friedrich Schiller");
        replacedertThat(result.get(0).getName()).isEqualTo("An die Freude");
        // Need to remove here because subsequent tests replacedume the initial dataset.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': { '$numberLong': '12' } })";
        query = session.createNativeQuery(nativeQuery);
        n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that they are gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '12' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@SuppressWarnings("unchecked")
public void testFindAndModifyNoMatchUpsertThenRemoveThenFindOne() throws Exception {
    inTransaction((session) -> {
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findAndModify({ 'query': {'_id': { '$numberLong': '11' } }, 'update': { '$set': { 'author': 'Oscar Wilder', 'name': 'The one and wildest', 'rating': '1' } }, 'new': true, 'upsert': true })";
        NativeQuery query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(result.get(0).getId()).isEqualTo(11);
        replacedertThat(result.get(0).getAuthor()).isEqualTo("Oscar Wilder");
        replacedertThat(result.get(0).getName()).isEqualTo("The one and wildest");
        // Need to remove here because subsequent tests replacedume the initial dataset.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".remove({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery);
        int n = query.executeUpdate();
        replacedertThat(n).isEqualTo(1);
        // And check that it is gone.
        nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".findOne({ '_id': { '$numberLong': '11' } })";
        query = session.createNativeQuery(nativeQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(0);
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1024")
public void testAggregateWithUnwindGroupAndSort() {
    inTransaction((session) -> {
        String match = "{ '$match': { 'author':{'$regex':'o.*', '$options': 'i'}}}";
        String unwind = "{'$unwind': '$mediums'}";
        String group = "{ '$group': {'_id' : '$_id' ,'clicks' : {'$push':'$mediums'} } }";
        String sort = "{ '$sort': { '_id' : -1 } }";
        String nativeQuery = "db." + OscarWildePoem.TABLE_NAME + ".aggregate([" + match + "," + unwind + "," + group + "," + sort + "])";
        NativeQuery query = session.createNativeQuery(nativeQuery);
        @SuppressWarnings("unchecked")
        List<Object[]> result = query.list();
        replacedertThat(result).hreplacedize(2);
        BasicDBList expectedImperatrix = new BasicDBList();
        expectedImperatrix.addAll(imperatrix.getMediums());
        replacedertThat(result.get(0)).isEqualTo(new Object[] { imperatrix.getId(), expectedImperatrix });
        BasicDBList expectedAthanasia = new BasicDBList();
        expectedAthanasia.addAll(athanasia.getMediums());
        replacedertThat(result.get(1)).isEqualTo(new Object[] { athanasia.getId(), expectedAthanasia });
    });
}

17 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "OGM-1314")
public void testInsertManyThenDeleteMany() {
    inTransaction((session) -> {
        String nativeQueryForDeleteMany = "db." + OscarWildePoem.TABLE_NAME + ".deleteMany( {'author': 'Oscar Wilde'} )";
        NativeQuery queryDeleteMany = session.createNativeQuery(nativeQueryForDeleteMany);
        int countOfDeleted = queryDeleteMany.executeUpdate();
        replacedertThat(countOfDeleted).isEqualTo(3);
        String nativeQueryForFindDeletedEnreplacedy = "db." + OscarWildePoem.TABLE_NAME + ".find( {'author': 'Oscar Wilde'} )";
        NativeQuery queryFindDeletedEnreplacedy = session.createNativeQuery(nativeQueryForFindDeletedEnreplacedy).addEnreplacedy(OscarWildePoem.clreplaced);
        List<OscarWildePoem> listOfFoundEnreplacedy = queryFindDeletedEnreplacedy.list();
        replacedertThat(listOfFoundEnreplacedy.size()).isEqualTo(0);
    });
}

16 View Complete Implementation : AdminDaoImpl.java
Copyright MIT License
Author : anselleeyy
@Override
public boolean setSelect(int value) {
    // TODO Auto-generated method stub
    String sql = "update syscontrol set ifSelect = " + value;
    try {
        NativeQuery<?> query = sessionFactory.getCurrentSession().createNativeQuery(sql);
        query.executeUpdate();
        return true;
    } catch (Exception e) {
        // TODO: handle exception
        System.err.println("系统表更新失败!");
        return false;
    }
}

16 View Complete Implementation : QueueHealthTest.java
Copyright Creative Commons Zero v1.0 Universal
Author : CMSgov
@SuppressWarnings("rawtypes")
@ExtendWith(BufferedLoggerHandler.clreplaced)
public clreplaced QueueHealthTest {

    private Session session = mock(Session.clreplaced);

    private final SessionFactory factory = mock(SessionFactory.clreplaced);

    private DPCQueueManagedSessionFactory managedSessionFactory = new DPCQueueManagedSessionFactory(factory);

    private NativeQuery query = mock(NativeQuery.clreplaced);

    private MetricRegistry metrics = new MetricRegistry();

    @BeforeEach
    void setupQueueDependencies() {
        reset(factory, session, query);
        when(factory.openSession()).thenReturn(session);
        when(session.createSQLQuery(Mockito.anyString())).thenReturn(query);
    }

    @Test
    void testHealthyQueue() {
        when(query.getFirstResult()).thenReturn(0);
        final DistributedBatchQueue queue = new DistributedBatchQueue(managedSessionFactory, 100, metrics);
        replacedertDoesNotThrow(() -> queue.replacedertHealthy(UUID.randomUUID()), "Queue should be healthy");
        // Healthcheck should preplaced
        final JobQueueHealthCheck jobQueueHealthCheck = new JobQueueHealthCheck(queue, UUID.randomUUID());
        replacedertTrue(jobQueueHealthCheck.check().isHealthy(), "Should be healthy");
    }

    @Test
    void testUnhealthyQueue() {
        when(query.getFirstResult()).thenReturn(2);
        final DistributedBatchQueue queue = new DistributedBatchQueue(managedSessionFactory, 100, metrics);
        replacedertThrows(JobQueueUnhealthy.clreplaced, () -> queue.replacedertHealthy(UUID.randomUUID()), "Queue should be unhealthy");
        // Healthcheck should preplaced
        final JobQueueHealthCheck jobQueueHealthCheck = new JobQueueHealthCheck(queue, UUID.randomUUID());
        replacedertFalse(jobQueueHealthCheck.check().isHealthy(), "Should be unhealthy");
    }
}

16 View Complete Implementation : NativeQueryMethodInterceptorImpl.java
Copyright MIT License
Author : gasparbarancelli
private Long getTotalRecords(NativeQueryInfo info, Session session) {
    NativeQuery<?> query = session.createNativeQuery(info.getSqlTotalRecord());
    query.unwrap(NativeQuery.clreplaced).addScalar("totalRecords", LongType.INSTANCE);
    addParameterJpa(query, info);
    return (Long) query.getSingleResult();
}

16 View Complete Implementation : ObjectIdTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
private void replacedertCountQueryResult(OgmSession session, String queryString, long expectedCount) {
    NativeQuery query = session.createNativeQuery(queryString);
    query.addScalar("n");
    long actualCount = (Long) query.list().iterator().next();
    replacedertThat(actualCount).describedAs("Count query didn't yield expected result").isEqualTo(expectedCount);
}

16 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@TestForIssue(jiraKey = "OGM-1315")
public void testUpdateOne() throws Exception {
    inTransaction((session) -> {
        String nativeUpdateOneQuery = "db." + OscarWildePoem.TABLE_NAME + ".updateOne(" + "  { 'author' : 'Oscar Wilde' }, " + "  { '$inc': { 'copiesSold' : 1 } } " + ")";
        NativeQuery query = session.createNativeQuery(nativeUpdateOneQuery);
        int modifiedCount = query.executeUpdate();
        replacedertThat(modifiedCount).isEqualTo(1);
        // Find updated one and check that it was updated.
        String nativeFindQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({ 'author' : 'Oscar Wilde' })";
        query = session.createNativeQuery(nativeFindQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        int modifiedElementIndex = 0;
        List<Integer> initialCopiesSoldList = Arrays.asList(portia.getCopiesSold(), athanasia.getCopiesSold(), imperatrix.getCopiesSold());
        for (int i = 0; i < result.size(); i++) {
            Integer currentCopiesSold = result.get(i).getCopiesSold();
            if (!initialCopiesSoldList.contains(currentCopiesSold)) {
                modifiedElementIndex = i;
                break;
            }
        }
        OscarWildePoem modifiedPoem = result.get(modifiedElementIndex);
        // Need to update back to original state because subsequent tests replacedume the initial dataset.
        session.clear();
        nativeUpdateOneQuery = "db." + OscarWildePoem.TABLE_NAME + ".updateOne(" + "  { 'name' : '" + modifiedPoem.getName() + "' }, " + "  { '$inc': { 'copiesSold' : -1 } } " + ")";
        query = session.createNativeQuery(nativeUpdateOneQuery);
        modifiedCount = query.executeUpdate();
        replacedertThat(modifiedCount).isEqualTo(1);
        // And check that it same as was.
        nativeFindQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({ 'name' : '" + modifiedPoem.getName() + "' })";
        query = session.createNativeQuery(nativeFindQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(1);
        replacedertThat(initialCopiesSoldList).contains(result.get(0).getCopiesSold());
    });
}

16 View Complete Implementation : MongoDBSessionCLIQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
@TestForIssue(jiraKey = "1316")
public void testUpdateMany() throws Exception {
    inTransaction((session) -> {
        String nativeUpdateManyQuery = "db." + OscarWildePoem.TABLE_NAME + ".updateMany(" + "  { 'author' : 'Oscar Wilde' }, " + "  { '$inc': { 'copiesSold' : 1 } } " + ")";
        NativeQuery query = session.createNativeQuery(nativeUpdateManyQuery);
        int modifiedCount = query.executeUpdate();
        replacedertThat(modifiedCount).isEqualTo(3);
        // Check that it was updated.
        String nativeFindQuery = "db." + OscarWildePoem.TABLE_NAME + ".find({ 'author' : 'Oscar Wilde' })";
        query = session.createNativeQuery(nativeFindQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        @SuppressWarnings("unchecked")
        List<OscarWildePoem> result = query.list();
        List<Integer> initialRatingsList = Arrays.asList(portia.getCopiesSold(), athanasia.getCopiesSold(), imperatrix.getCopiesSold());
        replacedertThat(result).hreplacedize(initialRatingsList.size());
        replacedertThat(result).onProperty("copiesSold").containsOnly(initialRatingsList.get(0) + 1, initialRatingsList.get(1) + 1, initialRatingsList.get(2) + 1);
        // Need to update back to original state because subsequent tests replacedume the initial dataset.
        session.clear();
        nativeUpdateManyQuery = "db." + OscarWildePoem.TABLE_NAME + ".updateMany(" + "  { 'author' : 'Oscar Wilde' }, " + "  { '$inc': { 'copiesSold' : -1 } }, " + "  { 'upsert': true, 'writeConcern': {'w': 'majority', 'wtimeout' : 100 } } " + ")";
        query = session.createNativeQuery(nativeUpdateManyQuery);
        modifiedCount = query.executeUpdate();
        replacedertThat(modifiedCount).isEqualTo(3);
        // And check that it same as was.
        query = session.createNativeQuery(nativeFindQuery).addEnreplacedy(OscarWildePoem.clreplaced);
        result = query.list();
        replacedertThat(result).hreplacedize(3);
        replacedertThat(result).onProperty("copiesSold").containsOnly(initialRatingsList.toArray());
    });
}

16 View Complete Implementation : DefaultJpaRepository.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : ueboot
public List findBySql(StringQuery stringQuery, ResultTransformer transformer) {
    replacedert.notNull(stringQuery, "StringQuery must not be null!");
    String sql = stringQuery.getQuery();
    NamedParams params = stringQuery.getParams();
    replacedert.notNull(params, "NamedParams must not be null!");
    Query query = em.createNativeQuery(sql);
    setQueryParams(query, params);
    NativeQuery sqlQuery = query.unwrap(NativeQuery.clreplaced);
    stringQuery.getScalars().forEach((s, type) -> {
        sqlQuery.addScalar(s, type);
    });
    return sqlQuery.setResultTransformer(transformer).list();
}

16 View Complete Implementation : DefaultJpaRepository.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : ueboot
public <S> List<S> findBySql(StringQuery stringQuery, Clreplaced<S> transformer) {
    replacedert.notNull(stringQuery, "StringQuery must not be null!");
    String sql = stringQuery.getQuery();
    NamedParams params = stringQuery.getParams();
    replacedert.notNull(params, "NamedParams must not be null!");
    Query query = em.createNativeQuery(sql);
    setQueryParams(query, params);
    NativeQuery sqlQuery = query.unwrap(NativeQuery.clreplaced);
    stringQuery.getScalars().forEach((s, type) -> {
        sqlQuery.addScalar(s, type);
    });
    return sqlQuery.setResultTransformer(Transformers.aliasToBean(transformer)).list();
}

15 View Complete Implementation : JobDaoImpl.java
Copyright Apache License 2.0
Author : FlowCI
@Override
public Job get(BigInteger key) {
    return execute((Session session) -> {
        String where = "job.id=:id";
        Builder builder = JOB_LIST_QUERY_BUILDER.clone().where(where).parameter("id", key);
        NativeQuery nativeQuery = builder.createNativeQuery(session).setResultSetMapping("MappingJobResult");
        Object[] objects = (Object[]) nativeQuery.uniqueResult();
        return JobConvertUtil.convert(objects);
    });
}

15 View Complete Implementation : Neo4jSessionNativeQueryTest.java
Copyright GNU Lesser General Public License v2.1
Author : hibernate
@Test
public void testNativeQueryExecuteUpdate() throws Exception {
    OgmSession session = (OgmSession) openSession();
    Transaction transaction = session.beginTransaction();
    String findQueryString = "MATCH (n:" + UPDATE_LABEL + ") RETURN n";
    NativeQuery findQuery = session.createNativeQuery(findQueryString);
    String createQuery = "CREATE (n:" + UPDATE_LABEL + " { author:'Giorgio Faletti' })";
    int updates = session.createNativeQuery(createQuery).executeUpdate();
    if (TestHelper.getCurrentDatastoreProviderType() != DatastoreProviderType.NEO4J_HTTP) {
        // 1 node + 1 label + 1 property set
        replacedertThat(updates).isEqualTo(3);
    }
    Object createdNode = findQuery.uniqueResult();
    replacedertThat(createdNode).isNotNull();
    String deleteQuery = "MATCH (n:" + UPDATE_LABEL + ") DELETE n ";
    int deletes = session.createNativeQuery(deleteQuery).executeUpdate();
    if (TestHelper.getCurrentDatastoreProviderType() != DatastoreProviderType.NEO4J_HTTP) {
        // 1 node
        replacedertThat(deletes).isEqualTo(1);
    }
    Object uniqueResult = findQuery.uniqueResult();
    replacedertThat(uniqueResult).isNull();
    transaction.commit();
    session.clear();
    session.close();
}