SmartSQL/SmartSQL.DocUtils/JS.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SmartSQL.DocUtils;
using Jint;

namespace SmartSQL.DocUtils
{
    public class JS
    {
        private static Engine jt = null;
        static JS()
        {
            jt = new Engine(cfg =>
            {
                //cfg.LimitRecursion();
                cfg.Strict();
            });
            jt.SetValue("log", new Action<object>(Console.WriteLine)); 
            
            var text = string.Empty;
            var names = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceNames();
            foreach (var name in names)
            {
                if (Path.GetExtension(name) == ".js")
                {
                    text = System.Reflection.Assembly.GetExecutingAssembly().GetResourceContent(name);
                    try
                    {
                        jt.Execute(text);
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex);
                    }
                }
            }
        }

        /// summary>
        /// https://zeroturnaround.github.io/sql-formatter/
        /// 格式化SQL语句
        /// </summary>
        /// <param name="sql">SQL语句</param>
        /// <param name="dbtype">数据库类型</param>
        /// <returns>格式化后的SQL语句</returns>
        public static string RunFmtSql(string sql, string dbtype)
        {
            var supportLang = new List<string>()
            {
                "sql",
                "redshift",
                "db2",
                "mariadb",
                "mysql",
                "n1ql",
                "plsql",