LINQPad.QueryPlanVisualizer/src/QueryPlanVisualizer.LinqPad6/PlanConvertor.cs at 9d667267a6150ba7723bc4db7b0cf866aed7aebb · Giorgi/LINQPad.QueryPlanVisualizer · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
using ExecutionPlanVisualizer.Helpers;
using System;
using System.IO;
using System.Net.Http;
using System.Text.Encodings.Web;
using System.Text.Json;
using System.Threading.Tasks;

namespace ExecutionPlanVisualizer
{
    internal abstract class PlanProcessor
    {
        public string Query { get; private set; }

        public abstract string SharePlanWebsite { get; }
        protected abstract string PlanFolder { get; }

        protected string PlanFileFolderFullPath => Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData),
                                                "LINQPadQueryVisualizer", PlanFolder);

        private string planFileName = $"plan {Guid.NewGuid()}.html";

        protected string PlanFilePath => Path.Combine(PlanFileFolderFullPath, planFileName);

        public void Initialize(string query)
        {
            Query = query;
        }

        protected abstract void ExtractFiles();
        public abstract string GeneratePlanHtml(string rawPlan);
        public abstract Task<string> SharePlanAsync(string plan);
    }

    class PostgresPlanProcessor : PlanProcessor
    {
        static bool shouldExtract = true;
        public override string SharePlanWebsite => "https://explain.dalibo.com/";
        protected override string PlanFolder => "Postgres";

        protected override void ExtractFiles()
        {
            Directory.CreateDirectory(Path.Combine(PlanFileFolderFullPath, "js"));
            Directory.CreateDirectory(Path.Combine(PlanFileFolderFullPath, "css"));
			Directory.CreateDirectory(Path.Combine(PlanFileFolderFullPath, "webfonts"));

			if (shouldExtract)
            {
                var allStylesheet = Path.Combine(PlanFileFolderFullPath, "css", "all.css");
                var appStylesheet = Path.Combine(PlanFileFolderFullPath, "css", "app.css");
                var bootstrapStylesheet = Path.Combine(PlanFileFolderFullPath, "css", "bootstrap.min.css");
                var chunkJavascript = Path.Combine(PlanFileFolderFullPath, "js", "chunk-vendors.js");

				var fa_brands_400_eot = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-brands-400.eot");
				var fa_brands_400_svg = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-brands-400.svg");
				var fa_brands_400_ttf = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-brands-400.ttf");
				var fa_brands_400_woff = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-brands-400.woff");
				var fa_brands_400_woff2 = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-brands-400.woff2");

				var fa_regular_400_eot = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-regular-400.eot");
				var fa_regular_400_svg = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-regular-400.svg");
				var fa_regular_400_ttf = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-regular-400.ttf");
				var fa_regular_400_woff = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-regular-400.woff");
				var fa_regular_400_woff2 = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-regular-400.woff2");

				var fa_solid_900_eot = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-solid-900.eot");
				var fa_solid_900_svg = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-solid-900.svg");
				var fa_solid_900_ttf = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-solid-900.ttf");
				var fa_solid_900_woff = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-solid-900.woff");
				var fa_solid_900_woff2 = Path.Combine(PlanFileFolderFullPath, "webfonts", "fa-solid-900.woff2");


				File.WriteAllText(allStylesheet, PostgresResources.all);
                File.WriteAllText(appStylesheet, PostgresResources.app_css);
                File.WriteAllText(bootstrapStylesheet, PostgresResources.bootstrap_min);
                File.WriteAllText(chunkJavascript, PostgresResources.chunk_vendors);

				File.WriteAllBytes(fa_brands_400_eot, PostgresResources.fa_brands_400);
				File.WriteAllBytes(fa_brands_400_svg, PostgresResources.fa_brands_4001);
				File.WriteAllBytes(fa_brands_400_ttf, PostgresResources.fa_brands_4002);
				File.WriteAllBytes(fa_brands_400_woff, PostgresResources.fa_brands_4003);
				File.WriteAllBytes(fa_brands_400_woff2, PostgresResources.fa_brands_4004);
				File.WriteAllBytes(fa_regular_400_eot, PostgresResources.fa_regular_400);
				File.WriteAllBytes(fa_regular_400_svg, PostgresResources.fa_regular_4001);
				File.WriteAllBytes(fa_regular_400_ttf, PostgresResources.fa_regular_4002);
				File.WriteAllBytes(fa_regular_400_woff, PostgresResources.fa_regular_4003);
				File.WriteAllBytes(fa_regular_400_woff2, PostgresResources.fa_regular_4004);
				File.WriteAllBytes(fa_solid_900_eot, PostgresResources.fa_solid_900);
				File.WriteAllBytes(fa_solid_900_svg, PostgresResources.fa_solid_9001);
				File.WriteAllBytes(fa_solid_900_ttf, PostgresResources.fa_solid_9002);
				File.WriteAllBytes(fa_solid_900_woff, PostgresResources.fa_solid_9003);
				File.WriteAllBytes(fa_solid_900_woff2, PostgresResources.fa_solid_9004);

			}

			File.WriteAllText(PlanFilePath, PostgresResources.index);

			shouldExtract = false;
        }

        public override string GeneratePlanHtml(string rawPlan)
        {
            ExtractFiles();

            var appJavascript = Path.Combine(PlanFileFolderFullPath, "js", "app.js");
            var appJs = PostgresResources.app_js.Replace("{plan}", JavaScriptEncoder.UnsafeRelaxedJsonEscaping.Encode(rawPlan).Replace("'", "\\'"))
                                                .Replace("{query}", JavaScriptEncoder.UnsafeRelaxedJsonEscaping.Encode(Query).Replace("'", "\\'"));

            File.WriteAllText(appJavascript, appJs);

            return PlanFilePath;
        }

        public override async Task<string> SharePlanAsync(string plan)
        {
            using var client = new HttpClient();
            var data = new { plan = plan, title = "Query Plan from LINQPad", query = Query };
            var responseMessage = await client.PostAsJsonAsync("https://explain.dalibo.com/new.json", data);
            var doc = await JsonDocument.ParseAsync(await responseMessage.Content.ReadAsStreamAsync());
            var queryId = doc.RootElement.GetProperty("id").GetString();

            return $"https://explain.dalibo.com/plan/{queryId}";
        }
    }

    class SqlServerPlanProcessor : PlanProcessor
    {
        static bool shouldExtract = true;
        public override string SharePlanWebsite => "https://www.brentozar.com/pastetheplan/";
        protected override string PlanFolder => "SqlServer";

        protected override void ExtractFiles()
        {
            Directory.CreateDirectory(PlanFileFolderFullPath);

            if (shouldExtract)
            {
                var icons = Path.Combine(PlanFileFolderFullPath, "qp_icons.png");
                var qpJavascript = Path.Combine(PlanFileFolderFullPath, "qp.js");
                var qpStyleSheet = Path.Combine(PlanFileFolderFullPath, "qp.css");

                File.WriteAllText(qpJavascript, SqlServerResources.qp_min_js);
                File.WriteAllText(qpStyleSheet, SqlServerResources.qp_css);
                SqlServerResources.qp_icons.Save(icons);
            }

            shouldExtract = false;
        }

        public override string GeneratePlanHtml(string rawPlan)
        {
            ExtractFiles();

            var html = string.Format(SqlServerResources.template, rawPlan);

            File.WriteAllText(PlanFilePath, html);

            return PlanFilePath;
        }

        public override async Task<string> SharePlanAsync(string plan)
        {
            using var client = new HttpClient();
            var responseMessage = await client.PostAsJsonAsync("https://jeczi7iqj8.execute-api.us-west-2.amazonaws.com/prod/", new { queryplan_xml = plan });
            var doc = await JsonDocument.ParseAsync(await responseMessage.Content.ReadAsStreamAsync());
            var queryId = doc.RootElement.GetProperty("id").GetString();

            return $"https://www.brentozar.com/pastetheplan/?id={queryId}";
        }
    }
}