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/Commands/DisplayDbModelDependenciesCommand.cs b/minisqlquery-master/src/MiniSqlQuery.Core/Commands/DisplayDbModelDependenciesCommand.cs
new file mode 100644
index 0000000..10ec35c
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery.Core/Commands/DisplayDbModelDependenciesCommand.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.Text;
+using MiniSqlQuery.Core.DbModel;
+using WeifenLuo.WinFormsUI.Docking;
+
+namespace MiniSqlQuery.Core.Commands
+{
+    /// <summary>
+    /// 	The display db model dependencies command.
+    /// </summary>
+    public class DisplayDbModelDependenciesCommand
+        : CommandBase
+    {
+        /// <summary>
+        /// 	Initializes a new instance of the <see cref = "DisplayDbModelDependenciesCommand" /> class.
+        /// </summary>
+        public DisplayDbModelDependenciesCommand()
+            : base("Order Tables by FK Dependencies")
+        {
+            SmallImage = ImageResource.table_link;
+        }
+
+        /// <summary>
+        /// 	Execute the command.
+        /// </summary>
+        public override void Execute()
+        {
+            var editor = Services.Resolve<IEditor>("txt-editor");
+            editor.FileName = null;
+            HostWindow.DisplayDockedForm(editor as DockContent);
+
+            if (HostWindow.DatabaseInspector.DbSchema == null)
+            {
+                HostWindow.DatabaseInspector.LoadDatabaseDetails();
+            }
+
+            var dependencyWalker = new DbModelDependencyWalker(HostWindow.DatabaseInspector.DbSchema);
+            var tables = dependencyWalker.SortTablesByForeignKeyReferences();
+
+            var sb = new StringBuilder();
+            foreach (DbModelTable table in tables)
+            {
+                sb.AppendLine(table.FullName);
+            }
+
+            editor.AllText = sb.ToString();
+        }
+
+        /// <summary>
+        /// Gets a value indicating that the command can be executed (requires a connection).
+        /// </summary>
+        public override bool Enabled
+        {
+            get
+            {
+                return Services.Settings.ConnectionDefinition != null;
+            }
+        }
+    }
+}
\ No newline at end of file