Java Code Examples for com.j256.ormlite.dao.Dao#queryRaw()
The following examples show how to use
com.j256.ormlite.dao.Dao#queryRaw() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
| Source File: JdbcRawResultsImplTest.java From ormlite-jdbc with ISC License | 6 votes |
|
@Test
public void testCustomColumnNames() throws Exception {
Dao<Foo, Integer> dao = createDao(Foo.class, true);
Foo foo = new Foo();
foo.val = 1213213;
assertEquals(1, dao.create(foo));
final String idName = "SOME_ID";
final String valName = "SOME_VAL";
final AtomicBoolean gotResult = new AtomicBoolean(false);
GenericRawResults<Object> results = dao.queryRaw("select id as " + idName + ", val as " + valName + " from foo",
new RawRowMapper<Object>() {
@Override
public Object mapRow(String[] columnNames, String[] resultColumns) {
assertEquals(idName, columnNames[0]);
assertEquals(valName, columnNames[1]);
gotResult.set(true);
return new Object();
}
});
List<Object> list = results.getResults();
assertNotNull(list);
assertEquals(1, list.size());
assertTrue(gotResult.get());
}
Example 2
| Source File: SelectIteratorTest.java From ormlite-core with ISC License | 6 votes |
|
@Test(expected = IllegalStateException.class)
public void testIteratorRawResults() throws Exception {
Dao<Foo, Integer> dao = createDao(Foo.class, true);
Foo foo1 = new Foo();
assertEquals(1, dao.create(foo1));
GenericRawResults<String[]> rawResults = dao.queryRaw("SELECT " + Foo.ID_COLUMN_NAME + " FROM FOO");
CloseableIterator<String[]> iterator = rawResults.closeableIterator();
try {
assertTrue(iterator.hasNext());
iterator.next();
iterator.remove();
} finally {
iterator.close();
}
}
Example 3
| Source File: RawResultsImplTest.java From ormlite-core with ISC License | 6 votes |
|
@Test
public void testQueryRaw() throws Exception {
Dao<Foo, Integer> dao = createDao(Foo.class, true);
Foo foo = new Foo();
foo.val = 1;
foo.equal = 10;
assertEquals(1, dao.create(foo));
QueryBuilder<Foo, Integer> qb = dao.queryBuilder();
qb.where().eq(Foo.VAL_COLUMN_NAME, new SelectArg());
GenericRawResults<String[]> rawResults = dao.queryRaw(qb.prepareStatementString(), Integer.toString(foo.val));
List<String[]> results = rawResults.getResults();
assertEquals(1, results.size());
boolean found = false;
String[] columnNames = rawResults.getColumnNames();
for (int i = 0; i < rawResults.getNumberColumns(); i++) {
if (columnNames[i].equalsIgnoreCase(Foo.ID_COLUMN_NAME)) {
assertEquals(Integer.toString(foo.id), results.get(0)[0]);
found = true;
}
}
assertTrue(found);
}
Example 4
| Source File: RawResultsImplTest.java From ormlite-core with ISC License | 6 votes |
|
@Test
public void testGetFirstResult() throws Exception {
Dao<Foo, Integer> dao = createDao(Foo.class, true);
Foo foo1 = new Foo();
foo1.val = 342;
assertEquals(1, dao.create(foo1));
Foo foo2 = new Foo();
foo2.val = 9045342;
assertEquals(1, dao.create(foo2));
QueryBuilder<Foo, Integer> qb = dao.queryBuilder();
qb.selectRaw("MAX(" + Foo.VAL_COLUMN_NAME + ")");
GenericRawResults<String[]> results = dao.queryRaw(qb.prepareStatementString());
String[] result = results.getFirstResult();
int max = Integer.parseInt(result[0]);
if (foo1.val > foo2.val) {
assertEquals(foo1.val, max);
} else {
assertEquals(foo2.val, max);
}
}
Example 5
| Source File: RawResultsImplTest.java From ormlite-core with ISC License | 6 votes |
|
@Test
public void testCustomColumnNames() throws Exception {
Dao<Foo, Integer> dao = createDao(Foo.class, true);
Foo foo = new Foo();
foo.val = 1213213;
assertEquals(1, dao.create(foo));
final String idName = "SOME_ID";
final String valName = "SOME_VAL";
final AtomicBoolean gotResult = new AtomicBoolean(false);
GenericRawResults<Object> results =
dao.queryRaw("select id as " + idName + ", val as " + valName + " from foo",
new RawRowMapper<Object>() {
@Override
public Object mapRow(String[] columnNames, String[] resultColumns) {
assertEquals(idName, columnNames[0]);
assertEquals(valName, columnNames[1]);
gotResult.set(true);
return new Object();
}
});
assertEquals(1, results.getResults().size());
results.close();
assertTrue(gotResult.get());
}
Example 6
| Source File: EnumToStringTypeTest.java From ormlite-core with ISC License | 6 votes |
|
@Test
public void testEnumToStringValue() throws Exception {
Class<LocalEnumToString> clazz = LocalEnumToString.class;
Dao<LocalEnumToString, Object> dao = createDao(clazz, true);
LocalEnumToString foo = new LocalEnumToString();
foo.ourEnum = OurEnum.SECOND;
assertEquals(1, dao.create(foo));
GenericRawResults<String[]> results = dao.queryRaw("select * from " + TABLE_NAME);
CloseableIterator<String[]> iterator = results.closeableIterator();
try {
assertTrue(iterator.hasNext());
String[] result = iterator.next();
assertNotNull(result);
assertEquals(1, result.length);
assertFalse(OurEnum.SECOND.name().equals(result[0]));
assertTrue(OurEnum.SECOND.toString().equals(result[0]));
} finally {
IOUtils.closeQuietly(iterator);
}
}
Example 7
| Source File: SqliteDatabaseTypeTest.java From ormlite-jdbc with ISC License | 5 votes |
|
@Test
public void testDateFormat() throws Exception {
Dao<AllTypes, Object> dao = createDao(AllTypes.class, true);
AllTypes all = new AllTypes();
all.dateField = new Date();
assertEquals(1, dao.create(all));
GenericRawResults<String[]> results = dao.queryRaw("select * from alltypes");
List<String[]> stringslist = results.getResults();
String[] names = results.getColumnNames();
for (String[] strings : stringslist) {
for (int i = 0; i < strings.length; i++) {
System.out.println(names[i] + "=" + strings[i]);
}
}
}
Example 8
| Source File: QueryBuilderTest.java From ormlite-core with ISC License | 5 votes |
|
@Test
public void testQueryRawMax() throws Exception {
Dao<Foo, Object> dao = createDao(Foo.class, true);
Foo foo1 = new Foo();
foo1.stringField = "1";
foo1.val = 10;
assertEquals(1, dao.create(foo1));
Foo foo2 = new Foo();
foo2.stringField = "1";
foo2.val = 20;
assertEquals(1, dao.create(foo2));
Foo foo3 = new Foo();
foo3.stringField = "2";
foo3.val = 30;
assertEquals(1, dao.create(foo3));
Foo foo4 = new Foo();
foo4.stringField = "2";
foo4.val = 40;
assertEquals(1, dao.create(foo4));
QueryBuilder<Foo, Object> qb = dao.queryBuilder();
qb.selectRaw("string, max(val) as val");
qb.groupBy(Foo.STRING_COLUMN_NAME);
GenericRawResults<Foo> results = dao.queryRaw(qb.prepareStatementString(), dao.getRawRowMapper());
assertNotNull(results);
CloseableIterator<Foo> iterator = results.closeableIterator();
try {
assertTrue(iterator.hasNext());
assertEquals(foo2.val, iterator.next().val);
assertTrue(iterator.hasNext());
assertEquals(foo4.val, iterator.next().val);
assertFalse(iterator.hasNext());
} finally {
iterator.close();
}
}
Example 9
| Source File: RawResultsImplTest.java From ormlite-core with ISC License | 5 votes |
|
@Test
public void testQueryRawColumns() throws Exception {
Dao<Foo, Integer> dao = createDao(Foo.class, true);
Foo foo1 = new Foo();
foo1.val = 1;
foo1.equal = 10;
assertEquals(1, dao.create(foo1));
Foo foo2 = new Foo();
foo2.val = 10;
foo2.equal = 5;
assertEquals(1, dao.create(foo2));
QueryBuilder<Foo, Integer> qb = dao.queryBuilder();
qb.selectRaw("COUNT(*)");
GenericRawResults<String[]> rawResults = dao.queryRaw(qb.prepareStatementString());
List<String[]> results = rawResults.getResults();
assertEquals(1, results.size());
// 2 rows inserted
assertEquals("2", results.get(0)[0]);
qb = dao.queryBuilder();
qb.selectRaw("MIN(val)", "MAX(val)");
rawResults = dao.queryRaw(qb.prepareStatementString());
results = rawResults.getResults();
assertEquals(1, results.size());
String[] result = results.get(0);
assertEquals(2, result.length);
// foo1 has the maximum value
assertEquals(Integer.toString(foo1.val), result[0]);
// foo2 has the maximum value
assertEquals(Integer.toString(foo2.val), result[1]);
}
Example 10
| Source File: RawResultsImplTest.java From ormlite-core with ISC License | 5 votes |
|
@Test
public void testHaving() throws Exception {
Dao<Foo, Integer> dao = createDao(Foo.class, true);
Foo foo = new Foo();
int val1 = 243342;
foo.val = val1;
assertEquals(1, dao.create(foo));
foo = new Foo();
foo.val = val1;
assertEquals(1, dao.create(foo));
foo = new Foo();
// only one of these
int val2 = 6543;
foo.val = val2;
assertEquals(1, dao.create(foo));
QueryBuilder<Foo, Integer> qb = dao.queryBuilder();
qb.selectColumns(Foo.VAL_COLUMN_NAME);
qb.groupBy(Foo.VAL_COLUMN_NAME);
qb.having("COUNT(VAL) > 1");
GenericRawResults<String[]> results = dao.queryRaw(qb.prepareStatementString());
List<String[]> list = results.getResults();
// only val2 has 2 of them
assertEquals(1, list.size());
assertEquals(String.valueOf(val1), list.get(0)[0]);
qb.having("COUNT(VAL) > 2");
results = dao.queryRaw(qb.prepareStatementString());
list = results.getResults();
assertEquals(0, list.size());
}
Example 11
| Source File: QueryBuilderTest.java From ormlite-core with ISC License | 4 votes |
|
@Test
public void testQueryColumnsPlusQueryRawMax() throws Exception {
Dao<Foo, Object> dao = createDao(Foo.class, true);
Foo foo1 = new Foo();
foo1.stringField = "1";
foo1.val = 10;
assertEquals(1, dao.create(foo1));
Foo foo2 = new Foo();
foo2.stringField = "1";
foo2.val = 20;
assertEquals(1, dao.create(foo2));
Foo foo3 = new Foo();
foo3.stringField = "2";
foo3.val = 40;
assertEquals(1, dao.create(foo3));
Foo foo4 = new Foo();
foo4.stringField = "2";
foo4.val = 30;
assertEquals(1, dao.create(foo4));
QueryBuilder<Foo, Object> qb = dao.queryBuilder();
qb.selectColumns(Foo.STRING_COLUMN_NAME);
qb.selectRaw("MAX(val) AS val");
qb.groupBy(Foo.STRING_COLUMN_NAME);
GenericRawResults<Foo> results = dao.queryRaw(qb.prepareStatementString(), dao.getRawRowMapper());
assertNotNull(results);
CloseableIterator<Foo> iterator = results.closeableIterator();
try {
assertTrue(iterator.hasNext());
Foo result = iterator.next();
assertEquals(foo2.val, result.val);
assertEquals(foo2.stringField, result.stringField);
assertTrue(iterator.hasNext());
result = iterator.next();
assertEquals(foo3.val, result.val);
assertEquals(foo3.stringField, result.stringField);
assertFalse(iterator.hasNext());
} finally {
iterator.close();
}
}
