📄 orderbytests.java
字号:
package test.org.mandarax.util.resultsetfilters;
/*
* Copyright (C) 1999-2004 <A href="http://www-ist.massey.ac.nz/JBDietrich" target="_top">Jens Dietrich</a>
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
import org.mandarax.util.resultsetfilters.*;
import junit.framework.TestSuite;
/**
* Test suite to test the order by filter.
* @author <A href="http://www-ist.massey.ac.nz/JBDietrich" target="_top">Jens Dietrich</A>
* @version 3.4 <7 March 05>
* @since 3.0
*/
public class OrderByTests extends AbstractTestSuite {
/**
* Launch the test suite. See TestRunner for interpretation
* of command line parameters.
* @see test.org.mandarax.testsupport.TestRunner
* @param args parameters
*/
public static void main(String[] args) {
test.org.mandarax.testsupport.TestRunner.run (OrderByTests.class, args);
}
public static TestSuite suite() throws Exception {
/* test kb:
"Tom", "Meier", "01/01/1960", 80, 1.80;
"John", "Meier", "01/01/1960", 90, 1.90;
"Jim", "Smith", "01/01/1970", 100, 1.90;
"Jack", "Smith", "01/01/1970", 60, 1.60;
"Tom", "Taylor", "01/01/1980", 70, 1.70;
"John", "Meijer", "01/01/1980", 80, 1.80;
"Jim", "Mejer", "01/01/1990", 50, 1.50;
*/
TestSuite suite = new TestSuite("Test cases for the Order By result set filter");
suite.addTest(new OrderByTestCase(
"Order By filter test case 1",
new OrderByCondition[]{new ASC(NAME),new ASC(FNAME)},
new Object[][] {
convert("John", "Meier", "01/01/1960", 90, 1.90),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("Jim", "Mejer", "01/01/1990", 50, 1.50),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Jim", "Smith", "01/01/1970", 100, 1.90),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 2",
new OrderByCondition[]{new ASC(NAME),new DESC(FNAME)},
new Object[][] {
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("John", "Meier", "01/01/1960", 90, 1.90),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("Jim", "Mejer", "01/01/1990", 50, 1.50),
convert("Jim", "Smith", "01/01/1970", 100, 1.90),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 3",
new OrderByCondition[]{new DESC(NAME),new DESC(FNAME)},
new Object[][] {
convert("Tom", "Taylor", "01/01/1980", 70, 1.70),
convert("Jim", "Smith", "01/01/1970", 100, 1.90),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Jim", "Mejer", "01/01/1990", 50, 1.50),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("John", "Meier", "01/01/1960", 90, 1.90)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 4",
new OrderByCondition[]{new DESC(DOB),new DESC(NAME),new DESC(FNAME)},
new Object[][] {
convert("Jim", "Mejer", "01/01/1990", 50, 1.50),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("Jim", "Smith", "01/01/1970", 100, 1.90),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("John", "Meier", "01/01/1960", 90, 1.90)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 5",
new OrderByCondition[]{new ASC(DOB),new ASC(NAME),new ASC(FNAME)},
new Object[][] {
convert("John", "Meier", "01/01/1960", 90, 1.90),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Jim", "Smith", "01/01/1970", 100, 1.90),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70),
convert("Jim", "Mejer", "01/01/1990", 50, 1.50)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 6",
new OrderByCondition[]{new DESC(WEIGHT),new DESC(NAME),new DESC(FNAME)},
new Object[][] {
convert("Jim", "Smith", "01/01/1970", 100, 1.90),
convert("John", "Meier", "01/01/1960", 90, 1.90),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Jim", "Mejer", "01/01/1990", 50, 1.50)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 7",
new OrderByCondition[]{new ASC(WEIGHT),new ASC(NAME),new ASC(FNAME)},
new Object[][] {
convert("Jim", "Mejer", "01/01/1990", 50, 1.50),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("John", "Meier", "01/01/1960", 90, 1.90),
convert("Jim", "Smith", "01/01/1970", 100, 1.90)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 8",
new OrderByCondition[]{new DESC(SIZE),new DESC(NAME),new DESC(FNAME)},
new Object[][] {
convert("Jim", "Smith", "01/01/1970", 100, 1.90),
convert("John", "Meier", "01/01/1960", 90, 1.90),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Jim", "Mejer", "01/01/1990", 50, 1.50)
}
));
suite.addTest(new OrderByTestCase(
"Order By filter test case 9",
new OrderByCondition[]{new ASC(SIZE),new ASC(NAME),new ASC(FNAME)},
new Object[][] {
convert("Jim", "Mejer", "01/01/1990", 50, 1.50),
convert("Jack", "Smith", "01/01/1970", 60, 1.60),
convert("Tom", "Taylor", "01/01/1980", 70, 1.70),
convert("Tom", "Meier", "01/01/1960", 80, 1.80),
convert("John", "Meijer", "01/01/1980", 80, 1.80),
convert("John", "Meier", "01/01/1960", 90, 1.90),
convert("Jim", "Smith", "01/01/1970", 100, 1.90)
}
));
return suite;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -