miniSql

创建
zgc123@gmail.com authored at 11/19/2023 1:40:15 AM
6136600
Tree
0 Parent(s)
Summary: 1 changed files with 66 additions and 0 deletions.
Added +66 -0
Added +66 -0
diff --git a/minisqlquery-master/src/MiniSqlQuery.Core/DbModel/DbModelTable.cs b/minisqlquery-master/src/MiniSqlQuery.Core/DbModel/DbModelTable.cs
new file mode 100644
index 0000000..c5e7820
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery.Core/DbModel/DbModelTable.cs
@@ -0,0 +1,66 @@
+#region License
+
+// Copyright 2005-2019 Paul Kohler (https://github.com/paulkohler/minisqlquery). All rights reserved.
+// This source code is made available under the terms of the GNU Lesser General Public License v3.0
+// https://github.com/paulkohler/minisqlquery/blob/master/LICENSE
+#endregion
+
+using System.Collections.Generic;
+using System.Diagnostics;
+
+namespace MiniSqlQuery.Core.DbModel
+{
+    /// <summary>The db model table.</summary>
+    [DebuggerDisplay("DbModelTable: {FullName} (Columns: {Columns.Count}, PKs: {PrimaryKeyColumns.Count}, FKs: {ForeignKeyColumns.Count})")]
+    public class DbModelTable : DbModelObjectBase
+    {
+        /// <summary>Initializes a new instance of the <see cref="DbModelTable"/> class.</summary>
+        public DbModelTable()
+        {
+            Columns = new List<DbModelColumn>();
+            Constraints = new List<DbModelConstraint>();
+            ObjectType = ObjectTypes.Table;
+        }
+
+        /// <summary>Gets the Columns for this table.</summary>
+        /// <value>The columns.</value>
+        public virtual List<DbModelColumn> Columns { get; internal set; }
+
+        /// <summary>Gets Constraints.</summary>
+        /// <value>The constraints.</value>
+        public virtual List<DbModelConstraint> Constraints { get; private set; }
+
+        /// <summary>Gets ForeignKeyColumns.</summary>
+        /// <value>The foreign key columns.</value>
+        public virtual List<DbModelColumn> ForeignKeyColumns
+        {
+            get { return Columns.FindAll(c => c.ForeignKeyReference != null); }
+        }
+
+        /// <summary>Gets NonKeyColumns.</summary>
+        /// <value>The non key columns.</value>
+        public virtual List<DbModelColumn> NonKeyColumns
+        {
+            get { return Columns.FindAll(c => !c.IsKey && c.ForeignKeyReference == null); }
+        }
+
+        /// <summary>Gets a reference to the parent database instance.</summary>
+        /// <value>The parent model instance object.</value>
+        public virtual DbModelInstance ParentDb { get; internal set; }
+
+        /// <summary>Gets PrimaryKeyColumns.</summary>
+        /// <value>The primary key columns.</value>
+        public virtual List<DbModelColumn> PrimaryKeyColumns
+        {
+            get { return Columns.FindAll(c => c.IsKey); }
+        }
+
+        /// <summary>Adds the <paramref name="column"/> to the list of <see cref="Columns"/> assigning the <see cref="DbModelColumn.ParentTable"/>.</summary>
+        /// <param name="column">The new column.</param>
+        public virtual void Add(DbModelColumn column)
+        {
+            column.ParentTable = this;
+            Columns.Add(column);
+        }
+    }
+}
\ No newline at end of file