summaryrefslogtreecommitdiffstats
path: root/tags/java-M1-20060518/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/Paging.java
diff options
context:
space:
mode:
Diffstat (limited to 'tags/java-M1-20060518/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/Paging.java')
-rw-r--r--tags/java-M1-20060518/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/Paging.java108
1 files changed, 0 insertions, 108 deletions
diff --git a/tags/java-M1-20060518/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/Paging.java b/tags/java-M1-20060518/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/Paging.java
deleted file mode 100644
index 250e7673d7..0000000000
--- a/tags/java-M1-20060518/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/Paging.java
+++ /dev/null
@@ -1,108 +0,0 @@
-/**
- *
- * Copyright 2005 The Apache Software Foundation or its licensors, as applicable.
- *
- * Licensed 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.tuscany.das.rdb.test;
-
-
-import java.sql.SQLException;
-
-import org.apache.tuscany.das.rdb.Command;
-import org.apache.tuscany.das.rdb.Pager;
-import org.apache.tuscany.das.rdb.impl.PagerImpl;
-import org.apache.tuscany.das.rdb.test.data.CustomerData;
-import org.apache.tuscany.das.rdb.test.framework.DasTest;
-
-
-import commonj.sdo.DataObject;
-
-
-
-public class Paging extends DasTest {
-
- protected void setUp() throws Exception {
- super.setUp();
- new CustomerData(getAutoConnection()).refresh();
- }
-
- public void testPaging() throws SQLException {
-
- //Build command to read all customers
- Command custCommand = Command.FACTORY.createCommand("select * from CUSTOMER order by ID");
- custCommand.setConnection(getConnection());
-
- //Create a pager with the command
- Pager pager = new PagerImpl(custCommand, 2);
-
- //Get and work with first page
- DataObject root = pager.next();
- DataObject customer1 = root.getDataObject("CUSTOMER[1]");
- DataObject customer2 = root.getDataObject("CUSTOMER[2]");
- assertEquals(1, customer1.getInt("ID"));
- assertEquals(2, customer2.getInt("ID"));
-
- //Get and work with the second page
- root = pager.next();
- customer1 = root.getDataObject("CUSTOMER[1]");
- customer2 = root.getDataObject("CUSTOMER[2]");
- assertEquals(3, customer1.getInt("ID"));
- assertEquals(4, customer2.getInt("ID"));
-
- // First page again
- root = pager.previous();
- customer1 = root.getDataObject("CUSTOMER[1]");
- customer2 = root.getDataObject("CUSTOMER[2]");
- assertEquals(1, customer1.getInt("ID"));
- assertEquals(2, customer2.getInt("ID"));
-
- }
-
-
- public void testRandomPage() throws SQLException {
- //Build the select command
- Command select = Command.FACTORY
- .createCommand("select * from CUSTOMER order by ID");
-
- //Parameterize the command
- select.setConnection(getConnection());
-
- //Create a pager
- Pager pager = new PagerImpl(select, 2);
-
- //Get the first page
- DataObject root = pager.getPage(1);
- DataObject customer1 = root.getDataObject("CUSTOMER[1]");
- DataObject customer2 = root.getDataObject("CUSTOMER[2]");
- assertEquals(1, customer1.getInt("ID"));
- assertEquals(2, customer2.getInt("ID"));
-
- //Get the second page
- root = pager.getPage(2);
- customer1 = root.getDataObject("CUSTOMER[1]");
- customer2 = root.getDataObject("CUSTOMER[2]");
- assertEquals(3, customer1.getInt("ID"));
- assertEquals(4, customer2.getInt("ID"));
-
-
- // Get the first page again
- root = pager.getPage(1);
- customer1 = root.getDataObject("CUSTOMER[1]");
- customer2 = root.getDataObject("CUSTOMER[2]");
- assertEquals(1, customer1.getInt("ID"));
- assertEquals(2, customer2.getInt("ID"));
- }
-
-
-} \ No newline at end of file