Package com.mysema.query.jpa

Examples of com.mysema.query.jpa.JPQLQuery.singleResult()

1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
    public void Substring2() {
        QCompany company = QCompany.company;
        StringExpression name = company.name;
        Integer companyId = query().from(company).singleResult(company.id);
        JPQLQuery query = query().from(company).where(company.id.eq(companyId));
        String str = query.singleResult(company.name);

        assertEquals(Integer.valueOf(29),
                query.singleResult(name.length().subtract(11)));

        assertEquals(str.substring(0, 7),
View Full Code Here
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
        Integer companyId = query().from(company).singleResult(company.id);
        JPQLQuery query = query().from(company).where(company.id.eq(companyId));
        String str = query.singleResult(company.name);

        assertEquals(Integer.valueOf(29),
                query.singleResult(name.length().subtract(11)));

        assertEquals(str.substring(0, 7),
                query.singleResult(name.substring(0, 7)));

        assertEquals(str.substring(15),
View Full Code Here
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
        assertEquals(Integer.valueOf(29),
                query.singleResult(name.length().subtract(11)));

        assertEquals(str.substring(0, 7),
                query.singleResult(name.substring(0, 7)));

        assertEquals(str.substring(15),
                query.singleResult(name.substring(15)));

        assertEquals(str.substring(str.length()),
View Full Code Here
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
        assertEquals(str.substring(0, 7),
                query.singleResult(name.substring(0, 7)));

        assertEquals(str.substring(15),
                query.singleResult(name.substring(15)));

        assertEquals(str.substring(str.length()),
                query.singleResult(name.substring(name.length())));

        assertEquals(str.substring(str.length() - 11),
View Full Code Here
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
        assertEquals(str.substring(15),
                query.singleResult(name.substring(15)));

        assertEquals(str.substring(str.length()),
                query.singleResult(name.substring(name.length())));

        assertEquals(str.substring(str.length() - 11),
                query.singleResult(name.substring(name.length().subtract(11))));
    }
View Full Code Here
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
        assertEquals(str.substring(str.length()),
                query.singleResult(name.substring(name.length())));

        assertEquals(str.substring(str.length() - 11),
                query.singleResult(name.substring(name.length().subtract(11))));
    }

    @Test
    @ExcludeIn(DERBY)
    public void Substring_From_Right() {
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.