miniSql

创建
zgc123@gmail.com authored at 11/19/2023 1:40:15 AM
6136600
Tree
0 Parent(s)
Summary: 3 changed files with 135 additions and 0 deletions.
Added +40 -0
Added +29 -0
Added +66 -0
Added +40 -0
diff --git a/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/Commands/RunTextGeneratorCommand.cs b/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/Commands/RunTextGeneratorCommand.cs
new file mode 100644
index 0000000..7b672a8
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/Commands/RunTextGeneratorCommand.cs
@@ -0,0 +1,40 @@
+#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 MiniSqlQuery.Core.Commands;
+
+namespace MiniSqlQuery.PlugIns.TextGenerator.Commands
+{
+    public class RunTextGeneratorCommand : CommandBase
+    {
+        public RunTextGeneratorCommand()
+            : base("Run the (experimental) text to C# class generator")
+        {
+        }
+
+        public override void Execute()
+        {
+            var editor = ActiveFormAsEditor;
+
+            if (editor != null)
+            {
+                var text = editor.SelectedText;
+                if (string.IsNullOrEmpty(text))
+                {
+                    text = editor.AllText;
+                }
+
+                var textGeneratorService = new TextGeneratorService();
+                var generatedText = textGeneratorService.Process(text);
+
+                // update editor, just put in the code for now...
+                editor.InsertText(generatedText);
+            }
+        }
+    }
+}
\ No newline at end of file
Added +29 -0
diff --git a/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/TextGeneratorLoader.cs b/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/TextGeneratorLoader.cs
new file mode 100644
index 0000000..64291ea
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/TextGeneratorLoader.cs
@@ -0,0 +1,29 @@
+#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 MiniSqlQuery.Core;
+using MiniSqlQuery.PlugIns.TextGenerator.Commands;
+
+namespace MiniSqlQuery.PlugIns.TextGenerator
+{
+    public class TextGeneratorLoader : PluginLoaderBase
+    {
+        public TextGeneratorLoader()
+            : base(
+                "Text Generator Tools",
+                "A Mini SQL Query Plugin for generating test from... text :-)",
+                21)
+        {
+        }
+
+        public override void InitializePlugIn()
+        {
+            IHostWindow hostWindow = Services.HostWindow;
+            hostWindow.AddPluginCommand<RunTextGeneratorCommand>();
+        }
+    }
+}
\ No newline at end of file
Added +66 -0
diff --git a/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/TextGeneratorService.cs b/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/TextGeneratorService.cs
new file mode 100644
index 0000000..634c234
--- /dev/null
+++ b/minisqlquery-master/src/MiniSqlQuery/PlugIns/TextGenerator/TextGeneratorService.cs
@@ -0,0 +1,66 @@
+using System;
+using System.Globalization;
+using System.Text;
+
+namespace MiniSqlQuery.PlugIns.TextGenerator
+{
+    public class TextGeneratorService
+    {
+        private const string SpaceString = " ";
+
+        public string Process(string text)
+        {
+            if (string.IsNullOrEmpty(text))
+            {
+                return text;
+            }
+
+            // convert to a class, line 1 is name, rest are props
+
+            var lines = text.Split(Environment.NewLine.ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
+
+            var sb = new StringBuilder();
+
+            // class name
+            sb.Append("public class ");
+            sb.AppendLine(ToPascalCase(lines[0]));
+            sb.AppendLine("{");
+
+            // properties
+            if (lines.Length > 1)
+            {
+                for (int i = 1; i < lines.Length; i++)
+                {
+                    string typeName = "string";
+                    var propertyName = ToPascalCase(lines[i]);
+
+                    // is it an "id"
+                    if (propertyName.EndsWith("id", StringComparison.CurrentCultureIgnoreCase))
+                    {
+                        typeName = "int";
+                    }
+
+                    sb.Append("public virtual ");
+                    sb.Append(typeName);
+                    sb.Append(" ");
+                    sb.Append(propertyName);
+                    sb.AppendLine(" { get; set; }");
+                }
+            }
+
+            sb.AppendLine("}");
+
+            return sb.ToString();
+        }
+
+        public string ToPascalCase(string text)
+        {
+            // if it has spaces, e.g "first name", or maybe its lower, e.g. "foo". Still allow for "MyID" etc
+            if (text.Contains(SpaceString) || !char.IsUpper(text[0]))
+            {
+                return CultureInfo.CurrentCulture.TextInfo.ToTitleCase(text).Replace(SpaceString, string.Empty).Trim();
+            }
+            return text.Trim();
+        }
+    }
+}
\ No newline at end of file