MySQL 5.6.14 Source Code Document
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Friends Macros Groups Pages
QueryTimeAsUtilDateTypesTest.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.TimeAsUtilDateTypes;
22 import java.util.Date;
23 
24 import testsuite.clusterj.model.IdBase;
25 
26 public class QueryTimeAsUtilDateTypesTest extends AbstractQueryTest {
27 
28  @Override
29  public Class<TimeAsUtilDateTypes> getInstanceType() {
30  return TimeAsUtilDateTypes.class;
31  }
32 
33  @Override
34  void createInstances(int number) {
35  createAllTimeAsUtilDateTypesInstances(number);
36  }
37 
65  public void test() {
66  btreeIndexScanTime();
67  hashIndexScanTime();
68  bothIndexScanTime();
69  noneIndexScanTime();
70  failOnError();
71  }
72 
73  public void btreeIndexScanTime() {
74  equalQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(8), 8);
75  greaterEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(7), 7, 8, 9);
76  greaterThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(6), 7, 8, 9);
77  lessEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), 4, 3, 2, 1, 0);
78  lessThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), 3, 2, 1, 0);
79  betweenQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 4, 5, 6);
80  greaterEqualAndLessEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 4, 5, 6);
81  greaterThanAndLessEqualQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 5, 6);
82  greaterEqualAndLessThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 4, 5);
83  greaterThanAndLessThanQuery("time_not_null_btree", "idx_time_not_null_btree", getTimeFor(4), getTimeFor(6), 5);
84  }
85 
86  public void hashIndexScanTime() {
87  equalQuery("time_not_null_hash", "idx_time_not_null_hash", getTimeFor(8), 8);
88  greaterEqualQuery("time_not_null_hash", "none", getTimeFor(7), 7, 8, 9);
89  greaterThanQuery("time_not_null_hash", "none", getTimeFor(6), 7, 8, 9);
90  lessEqualQuery("time_not_null_hash", "none", getTimeFor(4), 4, 3, 2, 1, 0);
91  lessThanQuery("time_not_null_hash", "none", getTimeFor(4), 3, 2, 1, 0);
92  betweenQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
93  greaterEqualAndLessEqualQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
94  greaterThanAndLessEqualQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 5, 6);
95  greaterEqualAndLessThanQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 4, 5);
96  greaterThanAndLessThanQuery("time_not_null_hash", "none", getTimeFor(4), getTimeFor(6), 5);
97  }
98 
99  public void bothIndexScanTime() {
100  equalQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(8), 8);
101  greaterEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(7), 7, 8, 9);
102  greaterThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(6), 7, 8, 9);
103  lessEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), 4, 3, 2, 1, 0);
104  lessThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), 3, 2, 1, 0);
105  betweenQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 4, 5, 6);
106  greaterEqualAndLessEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 4, 5, 6);
107  greaterThanAndLessEqualQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 5, 6);
108  greaterEqualAndLessThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 4, 5);
109  greaterThanAndLessThanQuery("time_not_null_both", "idx_time_not_null_both", getTimeFor(4), getTimeFor(6), 5);
110  }
111 
112  public void noneIndexScanTime() {
113  equalQuery("time_not_null_none", "none", getTimeFor(8), 8);
114  greaterEqualQuery("time_not_null_none", "none", getTimeFor(7), 7, 8, 9);
115  greaterThanQuery("time_not_null_none", "none", getTimeFor(6), 7, 8, 9);
116  lessEqualQuery("time_not_null_none", "none", getTimeFor(4), 4, 3, 2, 1, 0);
117  lessThanQuery("time_not_null_none", "none", getTimeFor(4), 3, 2, 1, 0);
118  betweenQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
119  greaterEqualAndLessEqualQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 4, 5, 6);
120  greaterThanAndLessEqualQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 5, 6);
121  greaterEqualAndLessThanQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 4, 5);
122  greaterThanAndLessThanQuery("time_not_null_none", "none", getTimeFor(4), getTimeFor(6), 5);
123  }
124 
125 
126  private void createAllTimeAsUtilDateTypesInstances(int number) {
127  for (int i = 0; i < number; ++i) {
128  TimeAsUtilDateTypes instance = session.newInstance(TimeAsUtilDateTypes.class);
129  instance.setId(i);
130  instance.setTime_not_null_hash(getTimeFor(i));
131  instance.setTime_not_null_btree(getTimeFor(i));
132  instance.setTime_not_null_both(getTimeFor(i));
133  instance.setTime_not_null_none(getTimeFor(i));
134  instances.add(instance);
135  }
136  }
137 
138  protected Date getTimeFor(int i) {
139  return new Date(getMillisFor(0, 0, i, 0));
140  }
141 
142  public static String toString(IdBase instance) {
143  TimeAsUtilDateTypes timetype = (TimeAsUtilDateTypes)instance;
144  StringBuffer buffer = new StringBuffer("TimeTypes id: ");
145  buffer.append(timetype.getId());
146  buffer.append("; time_not_null_both: ");
147  buffer.append(timetype.getTime_not_null_both().toString());
148  buffer.append("; time_not_null_btree: ");
149  buffer.append(timetype.getTime_not_null_btree().toString());
150  buffer.append("; time_not_null_hash: ");
151  buffer.append(timetype.getTime_not_null_hash().toString());
152  buffer.append("; time_not_null_none: ");
153  buffer.append(timetype.getTime_not_null_none().toString());
154  return buffer.toString();
155  }
156 }