Changeset 18115 for branches/3140_NumberSymbol/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/TSQLExpressionFormatter.cs
- Timestamp:
- 12/13/21 17:49:34 (3 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/3140_NumberSymbol/HeuristicLab.Problems.DataAnalysis.Symbolic/3.4/Formatters/TSQLExpressionFormatter.cs
r18100 r18115 93 93 //Generate function header 94 94 strBuilder.Append("CREATE FUNCTION dbo.REGRESSIONMODEL("); 95 strBuilder.Append(string.Join(", ", sortedVarcharIdentifiers.Select(n => string.Format("{0} NVARCHAR(max)", n))));95 strBuilder.Append(string.Join(", ", sortedVarcharIdentifiers.Select(n => string.Format("{0} NVARCHAR(max)", n)))); 96 96 if (varcharVarNames.Any() && floatVarNames.Any()) 97 97 strBuilder.Append(","); 98 strBuilder.Append(string.Join(", ", sortedFloatIdentifiers.Select(n => string.Format("{0} FLOAT", n))));98 strBuilder.Append(string.Join(", ", sortedFloatIdentifiers.Select(n => string.Format("{0} FLOAT", n)))); 99 99 strBuilder.AppendLine(")"); 100 100 … … 166 166 } else if (node is INumericTreeNode numNode) { 167 167 strBuilder.Append(numNode.Value.ToString("g17", CultureInfo.InvariantCulture)); 168 } else if (node.Symbol is FactorVariable) {168 } else if (node.Symbol is FactorVariable) { 169 169 var factorNode = node as FactorVariableTreeNode; 170 170 FormatFactor(level, factorNode, strBuilder); … … 180 180 private void FormatIfThenElse(int level, ISymbolicExpressionTreeNode node, StringBuilder strBuilder) { 181 181 strBuilder.Append("CASE ISNULL((SELECT 1 WHERE"); 182 FormatRecursively(level, node.GetSubtree(0), strBuilder);182 FormatRecursively(level, node.GetSubtree(0), strBuilder); 183 183 strBuilder.AppendLine("),0)"); 184 strBuilder.AppendIndented(level, "WHEN 1 THEN ");184 strBuilder.AppendIndented(level, "WHEN 1 THEN "); 185 185 FormatRecursively(level, node.GetSubtree(1), strBuilder); 186 186 strBuilder.AppendLine(); … … 202 202 203 203 private string VariableName2Identifier(string variableName) { 204 return "@" +variableName.Replace(' ', '_');204 return "@" + variableName.Replace(' ', '_'); 205 205 } 206 206
Note: See TracChangeset
for help on using the changeset viewer.