2 * Firebird ADO.NET Data provider for .NET and Mono
4 * The contents of this file are subject to the Initial
5 * Developer's Public License Version 1.0 (the "License");
6 * you may not use this file except in compliance with the
7 * License. You may obtain a copy of the License at
8 * http://www.firebirdsql.org/index.php?op=doc&id=idpl
10 * Software distributed under the License is distributed on
11 * an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
12 * express or implied. See the License for the specific
13 * language governing rights and limitations under the License.
15 * Copyright (c) 2002, 2004 Carlos Guzman Alvarez
16 * All Rights Reserved.
21 using System.Collections;
22 using FirebirdSql.Data.Firebird;
23 using FirebirdSql.Data.Firebird.Isql;
24 using NUnit.Framework;
26 namespace FirebirdSql.Data.Firebird.Tests
29 public class FbDatabaseSchemaTest : BaseTest
31 public FbDatabaseSchemaTest() : base(false)
36 public void CharacterSets()
38 Connection.GetSchema("CharacterSets");
42 public void CheckConstraints()
44 Connection.GetSchema("CheckConstraints");
48 public void CheckConstraintsByTable()
50 Connection.GetSchema("CheckConstraintsByTable");
54 public void Collations()
56 Connection.GetSchema("Collations");
62 DataTable columns = Connection.GetSchema("Columns");
64 columns = Connection.GetSchema(
66 new string[] { null, null, "TEST", "INT_FIELD" });
68 Assert.AreEqual(1, columns.Rows.Count);
72 public void ColumnPrivileges()
74 Connection.GetSchema("ColumnPrivileges");
80 Connection.GetSchema("Domains");
84 public void ForeignKeys()
86 Connection.GetSchema("ForeignKeys");
90 public void Functions()
92 Connection.GetSchema("Functions");
96 public void Generators()
98 Connection.GetSchema("Generators");
102 public void Indexes()
104 Connection.GetSchema("Indexes");
108 public void PrimaryKeys()
110 DataTable primaryKeys = Connection.GetSchema("PrimaryKeys");
112 primaryKeys = Connection.GetSchema(
114 new string[] { null, null, "TEST" });
116 Assert.AreEqual(1, primaryKeys.Rows.Count);
120 public void ProcedureParameters()
122 Connection.GetSchema("ProcedureParameters");
124 DataTable procedureParameters = Connection.GetSchema(
125 "ProcedureParameters",
126 new string[] { null, null, "SELECT_DATA" });
128 Assert.AreEqual(3, procedureParameters.Rows.Count);
132 public void ProcedurePrivileges()
134 Connection.GetSchema("ProcedurePrivileges");
138 public void Procedures()
140 DataTable procedures = Connection.GetSchema("Procedures");
142 procedures = Connection.GetSchema(
144 new string[] { null, null, "SELECT_DATA" });
146 Assert.AreEqual(1, procedures.Rows.Count);
150 public void DataTypes()
152 Connection.GetSchema("DataTypes");
158 Connection.GetSchema("Roles");
164 DataTable tables = Connection.GetSchema("Tables");
166 tables = Connection.GetSchema(
168 new string[] { null, null, "TEST" });
170 Assert.AreEqual(tables.Rows.Count, 1);
172 tables = Connection.GetSchema(
174 new string[] { null, null, null, "TABLE" });
176 Assert.AreEqual(tables.Rows.Count, 1);
180 public void TableConstraints()
182 Connection.GetSchema("TableConstraints");
186 public void TablePrivileges()
188 Connection.GetSchema("TablePrivileges");
192 public void Triggers()
194 Connection.GetSchema("Triggers");
198 public void UniqueKeys()
200 Connection.GetSchema("UniqueKeys");
204 public void ViewColumnUsage()
206 Connection.GetSchema("ViewColumnUsage");
212 Connection.GetSchema("Views");
216 public void ViewPrivileges()
218 Connection.GetSchema("ViewPrivileges");