// Path: moneta-core/src/test/java/org/moneta/HSqlTestBase.java
// public class HSqlTestBase {
// 	
// 	protected Connection nativeConnection;
// 
// 	@Before
// 	public void setUp() throws Exception {
// 		org.hsqldb.jdbcDriver nativeDriver = new org.hsqldb.jdbcDriver();
//         nativeConnection = nativeDriver.connect("jdbc:hsqldb:mem:TestDb", new Properties());
// 	}
// 
// 
// }
// 
// Path: moneta-core/src/main/java/org/moneta/types/Record.java
// public class Record extends BaseType {
// 	
// 	@JsonProperty("record")
// 	private Value[] values;
// 
// 	public Value[] getValues() {
// 		return values;
// 	}
// 
// 	public void setValues(Value[] values) {
// 		this.values = values;
// 	}
// 
// }
// 
// Path: moneta-core/src/main/java/org/moneta/types/Value.java
// public class Value extends BaseType {
// 	
// 	private String name;
// 	private Object value;
// 	
// 	public Value()   {}
// 	public Value(String name, Object value)   {
// 		this.setName(name);
// 		this.setValue(value);
// 	}
// 	
// 	public String getName() {
// 		return name;
// 	}
// 	
// 	public void setName(String name) {
// 		this.name = name;
// 	}
// 	
// 	public Object getValue() {
// 		return value;
// 	}
// 	
// 	public void setValue(Object value) {
// 		this.value = value;
// 	}
// 
// }


import org.apache.commons.dbutils.QueryRunner;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.moneta.HSqlTestBase;
import org.moneta.types.Record;
import org.moneta.types.Value;

/*
 * This software is licensed under the Apache License, Version 2.0
 * (the "License") agreement; 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.moneta.dao;


public class RecordResultSetHandlerTest extends HSqlTestBase {
	
	RecordResultSetHandler handler;
	
	@Before
	public void setUp() throws Exception {
		super.setUp();
		handler = new RecordResultSetHandler();
		handler.getAliasMap().put("TABLE_CAT", "Catalog");
	}
	
	@Test
	public void testBasicHappyPath() throws Exception {
		QueryRunner runner = new QueryRunner();

// Path: moneta-core/src/test/java/org/moneta/HSqlTestBase.java
// public class HSqlTestBase {
// 	
// 	protected Connection nativeConnection;
// 
// 	@Before
// 	public void setUp() throws Exception {
// 		org.hsqldb.jdbcDriver nativeDriver = new org.hsqldb.jdbcDriver();
//         nativeConnection = nativeDriver.connect("jdbc:hsqldb:mem:TestDb", new Properties());
// 	}
// 
// 
// }
// 
// Path: moneta-core/src/main/java/org/moneta/types/Record.java
// public class Record extends BaseType {
// 	
// 	@JsonProperty("record")
// 	private Value[] values;
// 
// 	public Value[] getValues() {
// 		return values;
// 	}
// 
// 	public void setValues(Value[] values) {
// 		this.values = values;
// 	}
// 
// }
// 
// Path: moneta-core/src/main/java/org/moneta/types/Value.java
// public class Value extends BaseType {
// 	
// 	private String name;
// 	private Object value;
// 	
// 	public Value()   {}
// 	public Value(String name, Object value)   {
// 		this.setName(name);
// 		this.setValue(value);
// 	}
// 	
// 	public String getName() {
// 		return name;
// 	}
// 	
// 	public void setName(String name) {
// 		this.name = name;
// 	}
// 	
// 	public Object getValue() {
// 		return value;
// 	}
// 	
// 	public void setValue(Object value) {
// 		this.value = value;
// 	}
// 
// }


// Path: moneta-core/src/test/java/org/moneta/dao/RecordResultSetHandlerTest.java
import org.apache.commons.dbutils.QueryRunner;
import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.moneta.HSqlTestBase;
import org.moneta.types.Record;
import org.moneta.types.Value;

/*
 * This software is licensed under the Apache License, Version 2.0
 * (the "License") agreement; 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.moneta.dao;


public class RecordResultSetHandlerTest extends HSqlTestBase {
	
	RecordResultSetHandler handler;
	
	@Before
	public void setUp() throws Exception {
		super.setUp();
		handler = new RecordResultSetHandler();
		handler.getAliasMap().put("TABLE_CAT", "Catalog");
	}
	
	@Test
	public void testBasicHappyPath() throws Exception {
		QueryRunner runner = new QueryRunner();

		Record[] recArray = runner.query(nativeConnection, 
