1561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes/*
2561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * Licensed to the Apache Software Foundation (ASF) under one or more
3561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * contributor license agreements.  See the NOTICE file distributed with
4561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * this work for additional information regarding copyright ownership.
5561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * The ASF licenses this file to You under the Apache License, Version 2.0
6561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * (the "License"); you may not use this file except in compliance with
7561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * the License.  You may obtain a copy of the License at
8561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes *
9561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes *     http://www.apache.org/licenses/LICENSE-2.0
10561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes *
11561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * Unless required by applicable law or agreed to in writing, software
12561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * distributed under the License is distributed on an "AS IS" BASIS,
13561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
14561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * See the License for the specific language governing permissions and
15561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes * limitations under the License.
16561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes */
17561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes
18561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughespackage org.apache.harmony.sql.tests.java.sql;
19561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes
20561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughesimport static java.sql.DatabaseMetaData.*;
21561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes
22561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughesimport junit.framework.TestCase;
23561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes
24561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughespublic class DatabaseMetaDataTest extends TestCase {
25561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes
26561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes    /*
27561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes     * Public statics test
28561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes     */
29561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes    public void testPublicStatics() {
30561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(attributeNoNulls, 0);
31561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(attributeNullable, 1);
32561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(attributeNullableUnknown, 2);
33561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(bestRowNotPseudo, 1);
34561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(bestRowPseudo, 2);
35561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(bestRowSession, 2);
36561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(bestRowTemporary, 0);
37561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(bestRowTransaction, 1);
38561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(bestRowUnknown, 0);
39561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(columnNoNulls, 0);
40561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(columnNullable, 1);
41561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(columnNullableUnknown, 2);
42561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionColumnIn, 1);
43561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionColumnInOut, 2);
44561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionColumnOut, 3);
45561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionColumnResult, 5);
46561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionColumnUnknown, 0);
47561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionNoNulls, 0);
48561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionNoTable, 1);
49561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionNullable, 1);
50561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionNullableUnknown, 2);
51561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionResultUnknown, 0);
52561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionReturn, 4);
53561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(functionReturnsTable, 2);
54561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeyCascade, 0);
55561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeyInitiallyDeferred, 5);
56561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeyInitiallyImmediate, 6);
57561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeyNoAction, 3);
58561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeyNotDeferrable, 7);
59561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeyRestrict, 1);
60561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeySetDefault, 4);
61561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(importedKeySetNull, 2);
62561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureColumnIn, 1);
63561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureColumnInOut, 2);
64561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureColumnOut, 4);
65561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureColumnResult, 3);
66561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureColumnReturn, 5);
67561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureColumnUnknown, 0);
68561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureNoNulls, 0);
69561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureNoResult, 1);
70561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureNullable, 1);
71561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureNullableUnknown, 2);
72561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureResultUnknown, 0);
73561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(procedureReturnsResult, 2);
74561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(sqlStateSQL, 2);
75561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(sqlStateSQL99, 2);
76561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(sqlStateXOpen, 1);
77561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(tableIndexClustered, 1);
78561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(tableIndexHashed, 2);
79561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(tableIndexOther, 3);
80561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(tableIndexStatistic, 0);
81561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(typeNoNulls, 0);
82561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(typeNullable, 1);
83561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(typeNullableUnknown, 2);
84561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(typePredBasic, 2);
85561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(typePredChar, 1);
86561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(typePredNone, 0);
87561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(typeSearchable, 3);
88561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(versionColumnNotPseudo, 1);
89561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(versionColumnPseudo, 2);
90561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes        assertEquals(versionColumnUnknown, 0);
91561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes    }
92561ee011997c6c2f1befbfaa9d5f0a99771c1d63Elliott Hughes}
93