Changeset 15901 for branches/2911_TSQLSymbolicExpressionFormatter

Timestamp:

04/13/18 11:11:51 (7 years ago)

Author:

fbaching

Message:

#2911: change to lowercase string identifier

File:

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

branches/2911_TSQLSymbolicExpressionFormatter/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(")");
 
@@ -106 +106 @@
       strBuilder.AppendLineIndented(1, "-- added variable declaration for convenience");
       foreach (var name in sortedVarcharIdentifiers)
-        strBuilder.AppendLineIndented(1, String.Format("-- DECLARE {0} NVARCHAR(max) = ''", name));
+        strBuilder.AppendLineIndented(1, string.Format("-- DECLARE {0} NVARCHAR(max) = ''", name));
       foreach (var name in sortedFloatIdentifiers)
-        strBuilder.AppendLineIndented(1, String.Format("-- DECLARE {0} FLOAT = 0.0", name));
+        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(String.Format("Symbol {0} not yet supported.", node.Symbol.GetType().Name));
+          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(String.Format("Symbol {0} not yet supported.", node.Symbol.GetType().Name));
+          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.");
@@ -267 +267 @@
     private void FormatFactor(int level, FactorVariableTreeNode node, StringBuilder strBuilder) {
       strBuilder.AppendLine("( ");
-      strBuilder.AppendLineIndented(level + 1, String.Format("CASE {0}", VariableName2Identifier(node.VariableName)));
+      strBuilder.AppendLineIndented(level + 1, string.Format("CASE {0}", VariableName2Identifier(node.VariableName)));
       foreach (var name in node.Symbol.GetVariableValues(node.VariableName)) {
-        strBuilder.AppendLineIndented(level + 2, String.Format("WHEN '{0}' THEN {1}", name, 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");