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