/*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
package org.apache.openjpa.persistence.jdbc.kernel;
import org.apache.openjpa.persistence.jdbc.common.apps.*;
import javax.persistence.EntityManager;
import java.sql.*;
import java.util.*;
import org.apache.openjpa.kernel.Broker;
import org.apache.openjpa.persistence.JPAFacadeHelper;
import org.apache.openjpa.jdbc.kernel.JDBCStore;
import org.apache.openjpa.jdbc.sql.ResultSetResult;
import org.apache.openjpa.lib.rop.ResultObjectProvider;
import org.apache.openjpa.jdbc.kernel.GenericResultObjectProvider;
import org.apache.openjpa.lib.rop.ResultList;
import org.apache.openjpa.lib.rop.EagerResultList;
import org.apache.openjpa.lib.rop.ResultObjectProvider;
import org.apache.openjpa.kernel.AbstractPCResultObjectProvider;
import org.apache.openjpa.meta.ClassMetaData;
import org.apache.openjpa.kernel.OpenJPAStateManager;
import org.apache.openjpa.kernel.FetchConfiguration;
/**
*
*/
public class TestRawSQL extends BaseJDBCTest {
/** Creates a new instance of TestRawSQL */
private Object[] _oids = new Object[3];
private String[] _strings = new String[]{ "a", "b", "c" };
private int[] _ints = new int[]{ 1, 2, 3 };
public TestRawSQL(String test) {
super(test);
}
public void setUp() {
deleteAll(RawSQL.class);
EntityManager em = currentEntityManager();
Broker broker = JPAFacadeHelper.toBroker(em);
broker.begin();
RawSQL raw;
for (int i = 0; i < _oids.length; i++) {
raw = new RawSQL(_strings[i], _ints[i]);
broker.persist(raw, null);
_oids[i] = broker.getUserObject(raw);
}
broker.commit();
broker.close();
em.close();
}
public void testLoadWithResult()
throws Exception {
EntityManager em = currentEntityManager();
Broker broker = JPAFacadeHelper.toBroker(em);
JDBCStore store = (JDBCStore)broker.getStoreManager();
Connection conn = store.getConnection();
Statement stmnt = conn.createStatement();
ResultSet rs = stmnt.executeQuery("SELECT * FROM RAWSQL "
+ "ORDER BY INTFIELD");
ResultSetResult res = new ResultSetResult(rs,
store.getConfiguration().getDBDictionaryInstance());
ResultObjectProvider rop = new GenericResultObjectProvider
(RawSQL.class, store, null, res);
ResultList rl = new EagerResultList(rop);
check(rl, broker);
rl.close();
broker.close();
em.close();
}
public void testLoadWithPCROP()
throws Exception {
EntityManager em = currentEntityManager();
Broker broker = JPAFacadeHelper.toBroker(em);
ResultObjectProvider rop = new AbstractPCResultObjectProvider(broker) {
private int _row = -1;
public boolean supportsRandomAccess() {
return true;
}
public boolean next() {
return ++_row < _oids.length;
}
public boolean absolute(int pos) {
_row = pos;
return _row < _oids.length;
}
public int size() {
return _oids.length;
}
public void close() {
}
public void handleCheckedException(Exception e) {
throw new RuntimeException(e.toString());
}
protected Object getObjectId(ClassMetaData meta) {
return _oids[_row];
}
protected Class getPCType() {
return RawSQL.class;
}
protected void load(OpenJPAStateManager sm,
FetchConfiguration fetch) {
ClassMetaData meta = sm.getMetaData();
sm.storeStringField(meta.getField("stringField").getIndex(),
_strings[_row]);
sm.storeIntField(meta.getField("intField").getIndex(),
_ints[_row]);
// note that we're not loading version info here, so the system
// will go out and get it after this intial load; kinda neat
}
};
ResultList rl = new EagerResultList(rop);
check(rl, broker);
rl.close();
broker.close();
}
private void check(ResultList rl, Broker broker) {
RawSQL raw;
int i = 0;
for (Iterator itr = rl.iterator(); itr.hasNext(); i++) {
raw = (RawSQL) itr.next();
assertTrue(broker.getStateManager(raw).getLoaded().get(0));
assertTrue(broker.getStateManager(raw).getLoaded().get(1));
if (i < _oids.length) {
assertEquals(_strings[i], raw.getStringField());
assertEquals(_ints[i], raw.getIntField());
}
}
assertEquals(_oids.length, i);
assertEquals(_oids.length, rl.size());
}
}