Changeset 18115 for branches/3140_NumberSymbol/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/TSQLExpressionFormatter.cs

Timestamp:

12/13/21 17:49:34 (2 years ago)

Author:

gkronber

Message:

#3140: made several more changes for the constant -> number branch

File:

• branches/3140_NumberSymbol/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/TSQLExpressionFormatter.cs (modified) (4 diffs)

branches/3140_NumberSymbol/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/TSQLExpressionFormatter.cs

@@ -93 +93 @@
       //Generate function header
       strBuilder.Append("CREATE FUNCTION dbo.REGRESSIONMODEL(");
-      strBuilder.Append(string.Join(", ", sortedVarcharIdentifiers.Select(n => string.Format("{0} NVARCHAR(max)",n))));
+      strBuilder.Append(string.Join(", ", sortedVarcharIdentifiers.Select(n => string.Format("{0} NVARCHAR(max)", n))));
       if (varcharVarNames.Any() && floatVarNames.Any())
         strBuilder.Append(",");
-      strBuilder.Append(string.Join(", ", sortedFloatIdentifiers.Select(n => string.Format("{0} FLOAT",n))));
+      strBuilder.Append(string.Join(", ", sortedFloatIdentifiers.Select(n => string.Format("{0} FLOAT", n))));
       strBuilder.AppendLine(")");
 
@@ -166 +166 @@
         } else if (node is INumericTreeNode numNode) {
           strBuilder.Append(numNode.Value.ToString("g17", CultureInfo.InvariantCulture));
-        }else if (node.Symbol is FactorVariable) {
+        } else if (node.Symbol is FactorVariable) {
           var factorNode = node as FactorVariableTreeNode;
           FormatFactor(level, factorNode, strBuilder);
@@ -180 +180 @@
     private void FormatIfThenElse(int level, ISymbolicExpressionTreeNode node, StringBuilder strBuilder) {
       strBuilder.Append("CASE ISNULL((SELECT 1 WHERE");
-      FormatRecursively(level,node.GetSubtree(0), strBuilder);
+      FormatRecursively(level, node.GetSubtree(0), strBuilder);
       strBuilder.AppendLine("),0)");
-      strBuilder.AppendIndented(level,"WHEN 1 THEN ");
+      strBuilder.AppendIndented(level, "WHEN 1 THEN ");
       FormatRecursively(level, node.GetSubtree(1), strBuilder);
       strBuilder.AppendLine();
@@ -202 +202 @@
 
     private string VariableName2Identifier(string variableName) {
-      return "@"+variableName.Replace(' ', '_');
+      return "@" + variableName.Replace(' ', '_');
     }