SqlScriptDOM/SqlScriptDom/ScriptDom/SqlServer/ScriptGenerator/SqlScriptGeneratorVisitor.StatisticsOption.cs at c8cdd1b29739c48ed5a897eecea17c0390c711b5 · microsoft/SqlScriptDOM · 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
//------------------------------------------------------------------------------
// <copyright file="SqlScriptGeneratorVisitor.StatisticsOption.cs" company="Microsoft">
//         Copyright (c) Microsoft Corporation.  All rights reserved.
// </copyright>
//------------------------------------------------------------------------------
using Microsoft.SqlServer.TransactSql.ScriptDom;
using System;

namespace Microsoft.SqlServer.TransactSql.ScriptDom.ScriptGenerator
{
    partial class SqlScriptGeneratorVisitor
    {
        public override void ExplicitVisit(StatisticsOption node)
        {
            switch (node.OptionKind)
            {
                case StatisticsOptionKind.FullScan:
                    GenerateIdentifier(CodeGenerationSupporter.FullScan);
                    break;
                case StatisticsOptionKind.NoRecompute:
                    GenerateIdentifier(CodeGenerationSupporter.NoRecompute);
                    break;
                case StatisticsOptionKind.Resample:
                    GenerateIdentifier(CodeGenerationSupporter.Resample);
                    break;
                case StatisticsOptionKind.All:
                    GenerateKeyword(TSqlTokenType.All);
                    break;
                case StatisticsOptionKind.Columns:
                    GenerateIdentifier(CodeGenerationSupporter.Columns);
                    break;
                case StatisticsOptionKind.Index:
                    GenerateKeyword(TSqlTokenType.Index);
                    break;
                case StatisticsOptionKind.Rows:
                    GenerateIdentifier(CodeGenerationSupporter.Rows);
                    break;
                default:
                    System.Diagnostics.Debug.Assert(false, "invalid option encountered");
                    break;
            }
        }

        public override void ExplicitVisit(LiteralStatisticsOption node)
        {
            switch (node.OptionKind)
            {
                case StatisticsOptionKind.SamplePercent:
                    GenerateIdentifier(CodeGenerationSupporter.Sample);
                    GenerateSpaceAndFragmentIfNotNull(node.Literal);
                    GenerateSpaceAndKeyword(TSqlTokenType.Percent);
                    break;
                case StatisticsOptionKind.SampleRows:
                    GenerateIdentifier(CodeGenerationSupporter.Sample);
                    GenerateSpaceAndFragmentIfNotNull(node.Literal);
                    GenerateSpaceAndIdentifier(CodeGenerationSupporter.Rows);
                    break;
                case StatisticsOptionKind.StatsStream:
                    GenerateNameEqualsValue(CodeGenerationSupporter.StatsStream, node.Literal);
                    break;
                case StatisticsOptionKind.RowCount:
                    GenerateNameEqualsValue(TSqlTokenType.RowCount, node.Literal);
                    break;
                case StatisticsOptionKind.PageCount:
                    GenerateNameEqualsValue(CodeGenerationSupporter.PageCount, node.Literal);
                    break;
                default:
                    System.Diagnostics.Debug.Assert(false, "invalid option encountered");
                    break;
            }
        }

        public override void ExplicitVisit(OnOffStatisticsOption node)
        {
            String optionName = String.Empty;
            switch (node.OptionKind)
            {
                case StatisticsOptionKind.Incremental:
                    optionName = CodeGenerationSupporter.Incremental;
                    break;
                case StatisticsOptionKind.AutoDrop:
                    optionName = CodeGenerationSupporter.AutoDrop;
                    break;
                case StatisticsOptionKind.PersistSamplePercent:
                    optionName = CodeGenerationSupporter.PersistSamplePercent;
                    break;
                default:
                    System.Diagnostics.Debug.Assert(false, "invalid option encountered");
                    break;
            }
            GenerateOptionStateWithEqualSign(optionName, node.OptionState);
        }

        public override void ExplicitVisit(ResampleStatisticsOption node)
        {
            String optionName = String.Empty;
            switch (node.OptionKind)
            {
                case StatisticsOptionKind.Resample:
                    optionName = CodeGenerationSupporter.Resample;
                    break;
                default:
                    System.Diagnostics.Debug.Assert(false, "invalid option encountered");
                    break;
            }
            GenerateIdentifier(optionName);
            if (node.Partitions.Count > 0)
            {
                GenerateSpaceAndKeyword(TSqlTokenType.On);
                GenerateSpaceAndIdentifier(CodeGenerationSupporter.Partitions);
                GenerateSpace();
                GenerateParenthesisedCommaSeparatedList(node.Partitions);
            }
        }
    }
}