MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
QueryTimeAsSqlTimeTypesTest.java
1 /*
2  Copyright 2010 Sun Microsystems, Inc.
3  All rights reserved. Use is subject to license terms.
4 
5  This program is free software; you can redistribute it and/or modify
6  it under the terms of the GNU General Public License as published by
7  the Free Software Foundation; version 2 of the License.
8 
9  This program is distributed in the hope that it will be useful,
10  but WITHOUT ANY WARRANTY; without even the implied warranty of
11  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12  GNU General Public License for more details.
13 
14  You should have received a copy of the GNU General Public License
15  along with this program; if not, write to the Free Software
16  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
17 */
18 
19 package testsuite.clusterj;
20 
21 import testsuite.clusterj.model.TimeAsSqlTimeTypes;
22 import java.sql.Time;
23 import testsuite.clusterj.model.IdBase;
24 
25 public class QueryTimeAsSqlTimeTypesTest extends AbstractQueryTest {
26 
27  @Override
28  public Class<TimeAsSqlTimeTypes> getInstanceType() {
29  return TimeAsSqlTimeTypes.class;
30  }
31 
32  @Override
33  void createInstances(int number) {
34  createAllTimeAsSqlTimeTypesInstances(number);
35  }
36 
64  public void test() {
65  btreeIndexScanTime();
66  hashIndexScanTime();
67  bothIndexScanTime();
68  noneIndexScanTime();
69  failOnError();
70  }
71 
72  public void btreeIndexScanTime() {
73  equalQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(8), 8);
74  greaterEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(7), 7, 8, 9);
75  greaterThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(6), 7, 8, 9);
76  lessEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), 4, 3, 2, 1, 0);
77  lessThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), 3, 2, 1, 0);
78  betweenQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 4, 5, 6);
79  greaterEqualAndLessEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 4, 5, 6);
80  greaterThanAndLessEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 5, 6);
81  greaterEqualAndLessThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 4, 5);
82  greaterThanAndLessThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 5);
83  }
84 
85  public void hashIndexScanTime() {
86  equalQuery("time_not_null_hash", "idx_time_not_null_hash", getTimeFor(8), 8);
87  greaterEqualQuery("time_not_null_hash", "none", getTimeFor(7), 7, 8, 9);
88  greaterThanQuery("time_not_null_hash", "none", getTimeFor(6), 7, 8, 9);
89  lessEqualQuery("time_not_null_hash", "none", getTimeFor(4), 4, 3, 2, 1, 0);
90  lessThanQuery("time_not_null_hash", "none", getTimeFor(4), 3, 2, 1, 0);
91  betweenQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
92  greaterEqualAndLessEqualQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
93  greaterThanAndLessEqualQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 5, 6);
94  greaterEqualAndLessThanQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 4, 5);
95  greaterThanAndLessThanQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 5);
96  }
97 
98  public void bothIndexScanTime() {
99  equalQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(8), 8);
100  greaterEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(7), 7, 8, 9);
101  greaterThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(6), 7, 8, 9);
102  lessEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), 4, 3, 2, 1, 0);
103  lessThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), 3, 2, 1, 0);
104  betweenQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 4, 5, 6);
105  greaterEqualAndLessEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 4, 5, 6);
106  greaterThanAndLessEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 5, 6);
107  greaterEqualAndLessThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 4, 5);
108  greaterThanAndLessThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 5);
109  }
110 
111  public void noneIndexScanTime() {
112  equalQuery("time_not_null_none", "none", getTimeFor(8), 8);
113  greaterEqualQuery("time_not_null_none", "none", getTimeFor(7), 7, 8, 9);
114  greaterThanQuery("time_not_null_none", "none", getTimeFor(6), 7, 8, 9);
115  lessEqualQuery("time_not_null_none", "none", getTimeFor(4), 4, 3, 2, 1, 0);
116  lessThanQuery("time_not_null_none", "none", getTimeFor(4), 3, 2, 1, 0);
117  betweenQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
118  greaterEqualAndLessEqualQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
119  greaterThanAndLessEqualQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 5, 6);
120  greaterEqualAndLessThanQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 4, 5);
121  greaterThanAndLessThanQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 5);
122  }
123 
124 
125  private void createAllTimeAsSqlTimeTypesInstances(int number) {
126  for (int i = 0; i < number; ++i) {
127  TimeAsSqlTimeTypes instance = session.newInstance(TimeAsSqlTimeTypes.class);
128  instance.setId(i);
129  instance.setTime_not_null_hash(getTimeFor(i));
130  instance.setTime_not_null_btree(getTimeFor(i));
131  instance.setTime_not_null_both(getTimeFor(i));
132  instance.setTime_not_null_none(getTimeFor(i));
133  instances.add(instance);
134  }
135  }
136 
137  protected Time getTimeFor(int i) {
138  return new Time(getMillisFor(0, 0, i, 0));
139  }
140 
141  public static String toString(IdBase instance) {
142  TimeAsSqlTimeTypes timetype = (TimeAsSqlTimeTypes)instance;
143  StringBuffer buffer = new StringBuffer("TimeTypes id: ");
144  buffer.append(timetype.getId());
145  buffer.append("; time_not_null_both: ");
146  buffer.append(timetype.getTime_not_null_both().toString());
147  buffer.append("; time_not_null_btree: ");
148  buffer.append(timetype.getTime_not_null_btree().toString());
149  buffer.append("; time_not_null_hash: ");
150  buffer.append(timetype.getTime_not_null_hash().toString());
151  buffer.append("; time_not_null_none: ");
152  buffer.append(timetype.getTime_not_null_none().toString());
153  return buffer.toString();
154  }
155 }