internal void TestView(TableSpec spec, ViewSchema tbl) { String viewName = "v_" + spec.Name; Assert.IsNotNull(tbl); Assert.AreEqual(viewName, tbl.Name); Assert.AreEqual(spec.Columns.Length, tbl.Columns.Count); for (int idx = 0; idx < tbl.Columns.Count; idx++) { CompareColumns(spec.Columns[idx], tbl.Columns[idx]); } }
internal void TestTable(TableSpec spec, TableSchema tbl) { String tableName = spec.Name; Assert.IsNotNull(tbl); Assert.AreEqual(tableName, tbl.Name); Assert.AreEqual(spec.Columns.Length, tbl.Columns.Count); for (int idx = 0; idx < tbl.Columns.Count; idx++) { CompareColumns(spec.Columns[idx], tbl.Columns[idx]); } Assert.AreEqual(spec.Indexes.Length, tbl.Indexes.Count); for (int idx = 0; idx < tbl.Indexes.Count; idx++) { CompareIndexes(spec.Indexes[idx], tbl.Indexes[spec.Indexes[idx].Name]); } Assert.AreEqual(spec.ForeignKeys.Length, tbl.Keys.Count); for (int idx = 0; idx < tbl.Keys.Count; idx++) { CompareForeignKeys(spec.ForeignKeys[idx], tbl.Keys[idx]); } }