1 #region MIT license 2 // 3 // MIT license 4 // 5 // Copyright (c) 2007-2008 Jiri Moudry, Pascal Craponne 6 // 7 // Permission is hereby granted, free of charge, to any person obtaining a copy 8 // of this software and associated documentation files (the "Software"), to deal 9 // in the Software without restriction, including without limitation the rights 10 // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell 11 // copies of the Software, and to permit persons to whom the Software is 12 // furnished to do so, subject to the following conditions: 13 // 14 // The above copyright notice and this permission notice shall be included in 15 // all copies or substantial portions of the Software. 16 // 17 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 18 // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 19 // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 20 // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 21 // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, 22 // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN 23 // THE SOFTWARE. 24 // 25 #endregion 26 using System.Collections.Generic; 27 using System.Data; 28 using DbLinq.Util; 29 using DbLinq.Vendor; 30 31 namespace DbLinq.Ingres 32 { 33 #if !MONO_STRICT 34 public 35 #endif 36 partial class IngresSchemaLoader 37 { ReadDataNameAndSchema(IDataRecord dataRecord)38 protected override IDataName ReadDataNameAndSchema(IDataRecord dataRecord) 39 { 40 var dataName = new DataName { Name = dataRecord.GetAsString(0).TrimEnd(), Schema = dataRecord.GetAsString(1).TrimEnd() }; 41 return dataName; 42 } 43 ReadTables(IDbConnection connectionString, string databaseName)44 public override IList<IDataName> ReadTables(IDbConnection connectionString, string databaseName) 45 { 46 // note: the ReadDataNameAndSchema relies on information order 47 const string sql = @"SELECT table_name, table_owner FROM iitables " + 48 "WHERE table_owner <> '$ingres' " + 49 "AND table_type in ('T', 'V') " + 50 "AND table_name NOT LIKE 'ii%'"; 51 52 return DataCommand.Find<IDataName>(connectionString, sql, ReadDataNameAndSchema); 53 } 54 } 55 } 56