private List<string> StringifyValues(TableModel model)
{
List<string> parts = new List<string>();
foreach (Object obj in model.GetMappedColumns().Values)
{
StringBuilder builder = new StringBuilder();
if (obj.GetType() == typeof(String))
{
builder.Append("'");
builder.Append(obj);
builder.Append("'");
}
else
{
builder.Append(obj);
}
parts.Add(builder.ToString());
}
return parts;
}
private string joinColumnValues(TableModel model)
{
return " (" + String.Join(",",StringifyValues(model).ToArray()) + ") ";
}
public string ApplyTemplate(TableModel model)
{
return insert + into + model.GetTableName() + joinColumnName(model) + values + joinColumnValues(model);
}
private string joinColumnName(TableModel model)
{
return " (" + String.Join(",",model.GetMappedColumns().Keys.ToArray()) + ") ";
}
public string toInsertString(TableModel model)
{
return new ANSISQL().GetInsertTemplate().ApplyTemplate(model);
}
