Changeset 15900 for branches/2911_TSQLSymbolicExpressionFormatter

Timestamp:

04/13/18 10:25:22 (7 years ago)

Author:

fbaching

Message:

#2911: remove c# 6.0 string interpolation

File:

• branches/2911_TSQLSymbolicExpressionFormatter/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/TSQLExpressionFormatter.cs (modified) (7 diffs)

branches/2911_TSQLSymbolicExpressionFormatter/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/TSQLExpressionFormatter.cs

@@ -83 +83 @@
 
       //Generate comment and instructions
-      strBuilder.Append($"-- generated. created function can be used like 'SELECT dbo.REGRESSIONMODEL(");
+      strBuilder.Append("-- generated. created function can be used like 'SELECT dbo.REGRESSIONMODEL(");
       strBuilder.Append(string.Join(", ", sortedVarcharIdentifiers));
       if (varcharVarNames.Any() && floatVarNames.Any())
@@ -89 +89 @@
       strBuilder.Append(string.Join(", ", sortedFloatIdentifiers));
       strBuilder.AppendLine(")'");
-      strBuilder.AppendLine($"-- use the expression after the RETURN statement if you want to incorporate the model in a query without creating a function.");
+      strBuilder.AppendLine("-- use the expression after the RETURN statement if you want to incorporate the model in a query without creating a function.");
 
       //Generate function header
-      strBuilder.Append($"CREATE FUNCTION dbo.REGRESSIONMODEL(");
-      strBuilder.Append(string.Join(", ", sortedVarcharIdentifiers.Select(n => $"{n} NVARCHAR(max)")));
+      strBuilder.Append("CREATE FUNCTION dbo.REGRESSIONMODEL(");
+      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 => $"{n} FLOAT")));
+      strBuilder.Append(string.Join(", ", sortedFloatIdentifiers.Select(n => String.Format("{0} FLOAT",n))));
       strBuilder.AppendLine(")");
 
@@ -104 +104 @@
 
       //add variable declaration for convenience
-      strBuilder.AppendLineIndented(1, $"-- added variable declaration for convenience");
+      strBuilder.AppendLineIndented(1, "-- added variable declaration for convenience");
       foreach (var name in sortedVarcharIdentifiers)
-        strBuilder.AppendLineIndented(1, $"-- DECLARE {name} NVARCHAR(max) = ''");
+        strBuilder.AppendLineIndented(1, String.Format("-- DECLARE {0} NVARCHAR(max) = ''", name));
       foreach (var name in sortedFloatIdentifiers)
-        strBuilder.AppendLineIndented(1, $"-- DECLARE {name} FLOAT = 0.0");
-      strBuilder.AppendLineIndented(1, $"-- SELECT");
+        strBuilder.AppendLineIndented(1, String.Format("-- DECLARE {0} FLOAT = 0.0", name));
+      strBuilder.AppendLineIndented(1, "-- SELECT");
       strBuilder.AppendLine("RETURN ");
     }
@@ -142 +142 @@
           FormatOperator(level, node, "OR", strBuilder);
         } else if (node.Symbol is Xor) {
-          throw new NotSupportedException($"Symbol {node.Symbol.GetType().Name} not yet supported.");
+          throw new NotSupportedException(String.Format("Symbol {0} not yet supported.", node.Symbol.GetType().Name));
         } else if (node.Symbol is Sine) {
           FormatFunction(level, node, "SIN", strBuilder);
@@ -172 +172 @@
         } else if (node.Symbol is BinaryFactorVariable) {
           var binFactorNode = node as BinaryFactorVariableTreeNode;
-          throw new NotSupportedException($"Symbol {node.Symbol.GetType().Name} not yet supported.");
+          throw new NotSupportedException(String.Format("Symbol {0} not yet supported.", node.Symbol.GetType().Name));
         } else {
           throw new NotSupportedException("Formatting of symbol: " + node.Symbol + " not supported for TSQL symbolic expression tree formatter.");
@@ -199 +199 @@
           strBuilder.Append(" + ");
       }
-      strBuilder.Append($") / {node.Subtrees.Count()}");
+      strBuilder.AppendFormat(") / {0}", node.Subtrees.Count());
     }
 
     private string VariableName2Identifier(string variableName) {
-      return $"@{variableName.Replace(' ', '_')}";
+      return "@"+variableName.Replace(' ', '_');
     }
 
     private void GenerateFooter(StringBuilder strBuilder) {
-      strBuilder.AppendLine($"{Environment.NewLine}END");
+      strBuilder.Append(Environment.NewLine);
+      strBuilder.AppendLine("END");
     }
 
@@ -265 +266 @@
 
     private void FormatFactor(int level, FactorVariableTreeNode node, StringBuilder strBuilder) {
-      strBuilder.AppendLine($"( ");
-      strBuilder.AppendLineIndented(level + 1, $"CASE {VariableName2Identifier(node.VariableName)}");
+      strBuilder.AppendLine("( ");
+      strBuilder.AppendLineIndented(level + 1, String.Format("CASE {0}", VariableName2Identifier(node.VariableName)));
       foreach (var name in node.Symbol.GetVariableValues(node.VariableName)) {
-        strBuilder.AppendLineIndented(level + 2, $"WHEN '{name}' THEN {node.GetValue(name).ToString(CultureInfo.InvariantCulture)}");
+        strBuilder.AppendLineIndented(level + 2, String.Format("WHEN '{0}' THEN {1}", name, node.GetValue(name).ToString(CultureInfo.InvariantCulture)));
       }
       strBuilder.AppendLineIndented(level + 1, "ELSE NULL END");