1   /*
2    * Licensed to the Apache Software Foundation (ASF) under one or more
3    * contributor license agreements.  See the NOTICE file distributed with
4    * this work for additional information regarding copyright ownership.
5    * The ASF licenses this file to You under the Apache License, Version 2.0
6    * (the "License"); you may not use this file except in compliance with
7    * the License.  You may obtain a copy of the License at
8    *
9    *      http://www.apache.org/licenses/LICENSE-2.0
10   *
11   * Unless required by applicable law or agreed to in writing, software
12   * distributed under the License is distributed on an "AS IS" BASIS,
13   * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14   * See the License for the specific language governing permissions and
15   * limitations under the License.
16   */
17  package org.apache.commons.dbutils.handlers;
18  
19  import java.sql.SQLException;
20  import java.util.Iterator;
21  import java.util.List;
22  import java.util.Map;
23  
24  import org.apache.commons.dbutils.BaseTestCase;
25  import org.apache.commons.dbutils.ResultSetHandler;
26  
27  /**
28   * MapListHandlerTest
29   */
30  public class MapListHandlerTest extends BaseTestCase {
31  
32  	public void testHandle() throws SQLException {
33  		ResultSetHandler h = new MapListHandler();
34  		List results = (List) h.handle(this.rs);
35  
36  		assertNotNull(results);
37  		assertEquals(ROWS, results.size());
38  
39  		Iterator iter = results.iterator();
40          Map row = null;
41          assertTrue(iter.hasNext());
42          row = (Map) iter.next();
43          assertEquals(COLS, row.keySet().size());
44          assertEquals("1", row.get("one"));
45          assertEquals("2", row.get("TWO"));
46          assertEquals("3", row.get("Three"));
47              
48          assertTrue(iter.hasNext());
49          row = (Map) iter.next();
50          assertEquals(COLS, row.keySet().size());
51  
52          assertEquals("4", row.get("one"));
53          assertEquals("5", row.get("TWO"));
54          assertEquals("6", row.get("Three"));
55              
56          assertFalse(iter.hasNext());
57  	}
58  
59  	public void testEmptyResultSetHandle() throws SQLException {
60  		ResultSetHandler h = new MapListHandler();
61  		List results = (List) h.handle(this.emptyResultSet);
62  
63  		assertNotNull(results);
64  		assertTrue(results.isEmpty());
65  	}
66  
67  }