/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="item"></param>
/// <param name="insertFields"></param>
/// <returns></returns>
public virtual Tuple <string, bool> ToInsertStatement <T>(ICollection <string> insertFields = null)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var isList = false;
var type = typeof(T);
if (type.IsArray)
{
isList = true;
type = type.GetElementType();
}
else if (type.IsGenericType)
{
bool implementsGenericIEnumerableOrIsGenericIEnumerable =
(type.GetInterfaces().Any(ti => ti.IsGenericType && ti.GetGenericTypeDefinition() == typeof(IEnumerable <>))) ||
type.GetGenericTypeDefinition() == typeof(IEnumerable <>);
isList = true;
type = type.GetGenericArguments()[0];
}
ModelDefinition modelDef = type.GetModelDefinition();
foreach (var fieldDef in modelDef.FieldDefinitions)
{
if (fieldDef.ShouldSkipInsert())
{
continue;
}
//insertFields contains Property "Name" of fields to insert ( that's how expressions work )
if (insertFields != null && !insertFields.Contains(fieldDef.Name, StringComparer.OrdinalIgnoreCase))
{
continue;
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName)));
}
catch (Exception ex)
{
throw ex;
}
}
string sql = "INSERT INTO " + GetQuotedTableName(modelDef) + "(" + StringBuilderCache.ReturnAndFree(sbColumnNames) + ") " +
"VALUES (" + StringBuilderCacheAlt.ReturnAndFree(sbColumnValues) + ")";
bool selectIdentity = false;
if (!isList && modelDef.HasAutoIncrementId)
{
selectIdentity = true;
}
return(Tuple.Create(sql, selectIdentity));
}
public override string ToCreateTableStatement(Type tableType)
{
var sbColumns = StringBuilderCache.Allocate();
var sbConstraints = StringBuilderCache.Allocate();
var modelDef = GetModel(tableType);
foreach (var fieldDef in CreateTableFieldsStrategy(modelDef))
{
if (fieldDef.CustomSelect != null || (fieldDef.IsComputed && !fieldDef.IsPersisted))
{
continue;
}
if (sbColumns.Length != 0)
{
sbColumns.Append(", \n ");
}
sbColumns.Append(GetColumnDefinition(fieldDef));
var sqlConstraint = GetCheckConstraint(modelDef, fieldDef);
if (sqlConstraint != null)
{
sbConstraints.Append(",\n" + sqlConstraint);
}
if (fieldDef.ForeignKey == null || OrmLiteConfig.SkipForeignKeys)
{
continue;
}
var refModelDef = GetModel(fieldDef.ForeignKey.ReferenceType);
sbConstraints.AppendFormat(
", \n\n CONSTRAINT {0} FOREIGN KEY ({1}) REFERENCES {2} ({3})",
GetQuotedName(fieldDef.ForeignKey.GetForeignKeyName(modelDef, refModelDef, NamingStrategy, fieldDef)),
GetQuotedColumnName(fieldDef.FieldName),
GetQuotedTableName(refModelDef),
GetQuotedColumnName(refModelDef.PrimaryKey.FieldName));
if (!string.IsNullOrEmpty(fieldDef.ForeignKey.OnDelete))
{
sbConstraints.AppendFormat(" ON DELETE {0}", fieldDef.ForeignKey.OnDelete);
}
if (!string.IsNullOrEmpty(fieldDef.ForeignKey.OnUpdate))
{
sbConstraints.AppendFormat(" ON UPDATE {0}", fieldDef.ForeignKey.OnUpdate);
}
}
var uniqueConstraints = GetUniqueConstraints(modelDef);
if (uniqueConstraints != null)
{
sbConstraints.Append(",\n" + uniqueConstraints);
}
var sql = $"CREATE TABLE {GetQuotedTableName(modelDef)} \n(\n {StringBuilderCache.ReturnAndFree(sbColumns)}{StringBuilderCacheAlt.ReturnAndFree(sbConstraints)} \n); \n";
return(sql);
}
public override string ToCreateTableStatement(Type tableType)
{
var sbColumns = StringBuilderCache.Allocate();
var sbConstraints = StringBuilderCacheAlt.Allocate();
var sbPk = new StringBuilder();
var modelDef = GetModel(tableType);
foreach (var fieldDef in modelDef.FieldDefinitions)
{
if (fieldDef.IsPrimaryKey)
{
sbPk.AppendFormat(sbPk.Length != 0 ? ",{0}" : "{0}", GetQuotedColumnName(fieldDef.FieldName));
}
if (sbColumns.Length != 0)
{
sbColumns.Append(", \n ");
}
var columnDefinition = GetColumnDefinition(
fieldDef.FieldName,
fieldDef.ColumnType,
fieldDef.IsPrimaryKey,
fieldDef.AutoIncrement,
fieldDef.IsNullable,
fieldDef.IsRowVersion,
fieldDef.FieldLength,
fieldDef.Scale,
GetDefaultValue(fieldDef),
fieldDef.CustomFieldDefinition);
sbColumns.Append(columnDefinition);
if (fieldDef.ForeignKey == null)
{
continue;
}
var refModelDef = GetModel(fieldDef.ForeignKey.ReferenceType);
var fkName = NamingStrategy.ApplyNameRestrictions(fieldDef.ForeignKey.GetForeignKeyName(modelDef, refModelDef, NamingStrategy, fieldDef)).ToLower();
sbConstraints.AppendFormat(", \n\n CONSTRAINT {0} FOREIGN KEY ({1}) REFERENCES {2} ({3})",
GetQuotedName(fkName),
GetQuotedColumnName(fieldDef.FieldName),
GetQuotedTableName(refModelDef),
GetQuotedColumnName(refModelDef.PrimaryKey.FieldName));
sbConstraints.Append(GetForeignKeyOnDeleteClause(fieldDef.ForeignKey));
sbConstraints.Append(GetForeignKeyOnUpdateClause(fieldDef.ForeignKey));
}
if (sbPk.Length != 0)
{
sbColumns.AppendFormat(", \n PRIMARY KEY({0})", sbPk);
}
var sql = string.Format(
"CREATE TABLE {0} \n(\n {1}{2} \n); \n",
GetQuotedTableName(modelDef),
StringBuilderCache.ReturnAndFree(sbColumns),
StringBuilderCacheAlt.ReturnAndFree(sbConstraints));
return(sql);
}
public override string ToCreateTableStatement(Type tableType)
{
var sbColumns = StringBuilderCache.Allocate();
var sbConstraints = StringBuilderCacheAlt.Allocate();
var sbPk = new StringBuilder();
var modelDef = GetModel(tableType);
foreach (var fieldDef in CreateTableFieldsStrategy(modelDef))
{
if (fieldDef.CustomSelect != null)
{
continue;
}
if (fieldDef.IsPrimaryKey)
{
sbPk.AppendFormat(sbPk.Length != 0 ? ",{0}" : "{0}", GetQuotedColumnName(fieldDef.FieldName));
}
if (sbColumns.Length != 0)
{
sbColumns.Append(", \n ");
}
var columnDefinition = GetColumnDefinition(fieldDef);
sbColumns.Append(columnDefinition);
if (fieldDef.ForeignKey == null || OrmLiteConfig.SkipForeignKeys)
{
continue;
}
var refModelDef = GetModel(fieldDef.ForeignKey.ReferenceType);
var fkName = NamingStrategy.ApplyNameRestrictions(fieldDef.ForeignKey.GetForeignKeyName(modelDef, refModelDef, NamingStrategy, fieldDef)).ToLower();
sbConstraints.AppendFormat(", \n\n CONSTRAINT {0} FOREIGN KEY ({1}) REFERENCES {2} ({3})",
GetQuotedName(fkName),
GetQuotedColumnName(fieldDef.FieldName),
GetQuotedTableName(refModelDef),
GetQuotedColumnName(refModelDef.PrimaryKey.FieldName));
sbConstraints.Append(GetForeignKeyOnDeleteClause(fieldDef.ForeignKey));
sbConstraints.Append(GetForeignKeyOnUpdateClause(fieldDef.ForeignKey));
}
if (sbPk.Length != 0)
{
sbColumns.AppendFormat(", \n PRIMARY KEY({0})", sbPk);
}
var sql = $"RECREATE TABLE {GetQuotedTableName(modelDef)} \n(\n {StringBuilderCache.ReturnAndFree(sbColumns)}{StringBuilderCacheAlt.ReturnAndFree(sbConstraints)} \n); \n";
return(sql);
}
public override void PrepareParameterizedInsertStatement <T>(IDbCommand cmd, ICollection <string> insertFields = null)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var sbReturningColumns = StringBuilderCacheAlt.Allocate();
var modelDef = OrmLiteUtils.GetModelDefinition(typeof(T));
cmd.Parameters.Clear();
foreach (var fieldDef in modelDef.FieldDefinitionsArray)
{
if (ShouldReturnOnInsert(modelDef, fieldDef))
{
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append("INSERTED." + GetQuotedColumnName(fieldDef.FieldName));
}
if (ShouldSkipInsert(fieldDef))
{
continue;
}
//insertFields contains Property "Name" of fields to insert ( that's how expressions work )
if (insertFields != null && !insertFields.Contains(fieldDef.Name, StringComparer.OrdinalIgnoreCase))
{
continue;
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
if (SupportsSequences(fieldDef))
{
sbColumnValues.Append("NEXT VALUE FOR " + Sequence(NamingStrategy.GetSchemaName(modelDef), fieldDef.Sequence));
}
else
{
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName)));
AddParameter(cmd, fieldDef);
}
}
catch (Exception ex)
{
Log.Error("ERROR in PrepareParameterizedInsertStatement(): " + ex.Message, ex);
throw;
}
}
var strReturning = StringBuilderCacheAlt.ReturnAndFree(sbReturningColumns);
strReturning = strReturning.Length > 0 ? "OUTPUT " + strReturning + " " : "";
cmd.CommandText = $"INSERT INTO {GetQuotedTableName(modelDef)} ({StringBuilderCache.ReturnAndFree(sbColumnNames)}) " +
strReturning +
$"VALUES ({StringBuilderCacheAlt.ReturnAndFree(sbColumnValues)})";
}
public static string HtmlList(IEnumerable items, HtmlDumpOptions options)
{
if (options == null)
{
options = new HtmlDumpOptions();
}
if (items is IDictionary <string, object> single)
{
items = new[] { single }
}
;
var depth = options.Depth;
var childDepth = options.ChildDepth;
options.Depth += 1;
try
{
var parentClass = options.ClassName;
var childClass = options.ChildClass;
var className = ((depth < childDepth ? parentClass : childClass ?? parentClass)
?? options.Defaults.GetDefaultTableClassName());
var headerStyle = options.HeaderStyle;
var headerTag = options.HeaderTag ?? "th";
var sbHeader = StringBuilderCache.Allocate();
var sbRows = StringBuilderCacheAlt.Allocate();
List <string> keys = null;
foreach (var item in items)
{
if (item is IDictionary <string, object> d)
{
if (keys == null)
{
keys = d.Keys.ToList();
sbHeader.Append("<tr>");
foreach (var key in keys)
{
sbHeader.Append('<').Append(headerTag).Append('>');
sbHeader.Append(ViewUtils.StyleText(key, headerStyle)?.HtmlEncode());
sbHeader.Append("</").Append(headerTag).Append('>');
}
sbHeader.Append("</tr>");
}
sbRows.Append("<tr>");
foreach (var key in keys)
{
var value = d[key];
if (ReferenceEquals(value, items))
{
break; // Prevent cyclical deps like 'it' binding
}
sbRows.Append("<td>");
if (!isComplexType(value))
{
sbRows.Append(GetScalarHtml(value, options.Defaults));
}
else
{
var htmlValue = HtmlDump(value, options);
sbRows.Append(htmlValue.ToRawString());
}
sbRows.Append("</td>");
}
sbRows.Append("</tr>");
}
}
var isEmpty = sbRows.Length == 0;
if (isEmpty && options.CaptionIfEmpty == null)
{
return(string.Empty);
}
var htmlHeaders = StringBuilderCache.ReturnAndFree(sbHeader);
var htmlRows = StringBuilderCacheAlt.ReturnAndFree(sbRows);
var sb = StringBuilderCache.Allocate();
sb.Append("<table");
if (options.Id != null)
{
sb.Append(" id=\"").Append(options.Id).Append("\"");
}
if (!string.IsNullOrEmpty(className))
{
sb.Append(" class=\"").Append(className).Append("\"");
}
sb.Append(">");
var caption = options.Caption;
if (isEmpty)
{
caption = options.CaptionIfEmpty;
}
if (caption != null && !options.HasCaption)
{
sb.Append("<caption>").Append(caption.HtmlEncode()).Append("</caption>");
options.HasCaption = true;
}
if (htmlHeaders.Length > 0)
{
sb.Append("<thead>").Append(htmlHeaders).Append("</thead>");
}
if (htmlRows.Length > 0)
{
sb.Append("<tbody>").Append(htmlRows).Append("</tbody>");
}
sb.Append("</table>");
var html = StringBuilderCache.ReturnAndFree(sb);
return(html);
}
finally
{
options.Depth = depth;
}
}
public string SelectInto <T>()
{
var modelDef = typeof(T).GetModelMetadata();
CheckAggregateUsage(false);
var sbSelect = StringBuilderCache.Allocate();
sbSelect.Append("SELECT ");
var dbColumns = StringBuilderCache.Allocate();
if (columnList.Count > 0)
{
if (isDistinct)
{
sbSelect.Append(" DISTINCT ");
}
foreach (var col in columnList)
{
dbColumns.AppendFormat("{0}{1}", dbColumns.Length > 0 ? "," : "", col);
}
}
else
{
// improve performance avoiding multiple calls to GetModelDefinition()
if (isDistinct && modelDef.FieldDefinitions.Count > 0)
{
sbSelect.Append(" DISTINCT ");
}
foreach (var fi in modelDef.FieldDefinitions)
{
dbColumns.AppendFormat("{0}{1}", dbColumns.Length > 0 ? "," : "", (String.IsNullOrEmpty(fi.BelongToModelName) ? (dialectProvider.GetQuotedTableName(modelDef.ModelName)) : (dialectProvider.GetQuotedTableName(fi.BelongToModelName))) + "." + dialectProvider.GetQuotedColumnName(fi.FieldName));
}
if (dbColumns.Length == 0)
{
dbColumns.AppendFormat("\"{0}{1}\".*", baseSchema, dialectProvider.GetQuotedTableName(baseTableName));
}
}
sbSelect.Append(StringBuilderCache.ReturnAndFree(dbColumns) + " \n");
var sbBody = StringBuilderCacheAlt.Allocate();
sbBody.AppendFormat("FROM {0}{1} \n", baseSchema, dialectProvider.GetQuotedTableName(baseTableName));
int i = 0;
foreach (var join in joinList)
{
i++;
if ((join.JoinType == JoinType.INNER) || (join.JoinType == JoinType.SELF))
{
sbBody.Append(" INNER JOIN ");
}
else if (join.JoinType == JoinType.LEFTOUTER)
{
sbBody.Append(" LEFT OUTER JOIN ");
}
else if (join.JoinType == JoinType.RIGHTOUTER)
{
sbBody.Append(" RIGHT OUTER JOIN ");
}
else if (join.JoinType == JoinType.FULLOUTER)
{
sbBody.Append(" FULL OUTER JOIN ");
}
else if (join.JoinType == JoinType.CROSS)
{
sbBody.Append(" CROSS JOIN ");
}
if (join.JoinType == JoinType.CROSS)
{
sbBody.AppendFormat(" {0}{1} ON {2} = {3} \n", join.RefTypeSchema, dialectProvider.GetQuotedTableName(join.RefTypeTableName));
}
else
{
if (join.JoinType != JoinType.SELF)
{
sbBody.AppendFormat(" {0}{1} ON {2} = {3} \n", join.RefTypeSchema, dialectProvider.GetQuotedTableName(join.RefTypeTableName), join.Class1ColumnName, join.Class2ColumnName);
}
else
{
sbBody.AppendFormat(" {0}{1} AS {2} ON {2}.{3} = \"{1}\".{4} \n", join.RefTypeSchema, dialectProvider.GetQuotedTableName(join.RefTypeTableName), dialectProvider.GetQuotedTableName(join.RefTypeTableName) + "_" + i.ToString(), join.Class1ColumnName, join.Class2ColumnName);
}
}
}
if (whereList.Count > 0)
{
var sbWhere = new StringBuilder();
foreach (var where in whereList)
{
sbWhere.AppendFormat("{0}{1}", sbWhere.Length > 0
? (where.Value == WhereType.OR ? " OR " : " AND ") : "", where.Key);
}
sbBody.Append("WHERE " + sbWhere + " \n");
}
var sbOrderBy = new StringBuilder();
if (orderByList.Count > 0)
{
foreach (var ob in orderByList)
{
sbOrderBy.AppendFormat("{0}{1} {2} ", sbOrderBy.Length > 0 ? "," : "", ob.Key, ob.Value ? "ASC" : "DESC");
}
sbOrderBy.Insert(0, "ORDER BY ");
sbOrderBy.Append(" \n");
}
var sql = dialectProvider.ToSelectStatement(
modelDef, StringBuilderCache.ReturnAndFree(sbSelect), StringBuilderCacheAlt.ReturnAndFree(sbBody), sbOrderBy.ToString(), Offset, Rows);
return(sql);
}
public override string ToInsertRowStatement(IDbCommand cmd, object objWithProperties, ICollection <string> insertFields = null)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var sbReturningColumns = StringBuilderCacheAlt.Allocate();
var tableType = objWithProperties.GetType();
var modelDef = GetModel(tableType);
var fieldDefs = GetInsertFieldDefinitions(modelDef, insertFields);
foreach (var fieldDef in fieldDefs)
{
if (ShouldReturnOnInsert(modelDef, fieldDef))
{
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append("INSERTED." + GetQuotedColumnName(fieldDef.FieldName));
}
if (ShouldSkipInsert(fieldDef) && !fieldDef.AutoId)
{
continue;
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName)));
var p = AddParameter(cmd, fieldDef);
p.Value = GetFieldValue(fieldDef, fieldDef.GetValue(objWithProperties)) ?? DBNull.Value;
}
catch (Exception ex)
{
Log.Error("ERROR in ToInsertRowStatement(): " + ex.Message, ex);
throw;
}
}
foreach (var fieldDef in modelDef.AutoIdFields) // need to include any AutoId fields that weren't included
{
if (fieldDefs.Contains(fieldDef))
{
continue;
}
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append("INSERTED." + GetQuotedColumnName(fieldDef.FieldName));
}
var strReturning = StringBuilderCacheAlt.ReturnAndFree(sbReturningColumns);
strReturning = strReturning.Length > 0 ? "OUTPUT " + strReturning + " " : "";
var sql = sbColumnNames.Length > 0
? $"INSERT INTO {GetQuotedTableName(modelDef)} ({StringBuilderCache.ReturnAndFree(sbColumnNames)}) " +
strReturning +
$"VALUES ({StringBuilderCacheAlt.ReturnAndFree(sbColumnValues)})"
: $"INSERT INTO {GetQuotedTableName(modelDef)} {strReturning} DEFAULT VALUES";
return(sql);
}
public override void PrepareParameterizedInsertStatement <T>(IDbCommand cmd, ICollection <string> insertFields = null,
Func <FieldDefinition, bool> shouldInclude = null)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var sbReturningColumns = StringBuilderCacheAlt.Allocate();
var modelDef = OrmLiteUtils.GetModelDefinition(typeof(T));
cmd.Parameters.Clear();
var fieldDefs = GetInsertFieldDefinitions(modelDef, insertFields);
foreach (var fieldDef in fieldDefs)
{
if (ShouldReturnOnInsert(modelDef, fieldDef))
{
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append("INSERTED." + GetQuotedColumnName(fieldDef.FieldName));
}
if ((ShouldSkipInsert(fieldDef) && !fieldDef.AutoId) &&
shouldInclude?.Invoke(fieldDef) != true)
{
continue;
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
if (SupportsSequences(fieldDef))
{
sbColumnValues.Append("NEXT VALUE FOR " + Sequence(NamingStrategy.GetSchemaName(modelDef), fieldDef.Sequence));
}
else
{
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName), fieldDef.CustomInsert));
AddParameter(cmd, fieldDef);
}
}
catch (Exception ex)
{
Log.Error("ERROR in PrepareParameterizedInsertStatement(): " + ex.Message, ex);
throw;
}
}
foreach (var fieldDef in modelDef.AutoIdFields) // need to include any AutoId fields that weren't included
{
if (fieldDefs.Contains(fieldDef))
{
continue;
}
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append("INSERTED." + GetQuotedColumnName(fieldDef.FieldName));
}
var strReturning = StringBuilderCacheAlt.ReturnAndFree(sbReturningColumns);
strReturning = strReturning.Length > 0 ? "OUTPUT " + strReturning + " " : "";
cmd.CommandText = sbColumnNames.Length > 0
? $"INSERT INTO {GetQuotedTableName(modelDef)} ({StringBuilderCache.ReturnAndFree(sbColumnNames)}) {strReturning}" +
$"VALUES ({StringBuilderCacheAlt.ReturnAndFree(sbColumnValues)})"
: $"INSERT INTO {GetQuotedTableName(modelDef)}{strReturning} DEFAULT VALUES";
}
public override string ToCreateTableStatement(Type tableType)
{
var sbColumns = StringBuilderCache.Allocate();
var sbConstraints = StringBuilderCacheAlt.Allocate();
var sbTableOptions = StringBuilderCacheAlt.Allocate();
var fileTableAttrib = tableType.FirstAttribute <SqlServerFileTableAttribute>();
var memoryTableAttrib = tableType.FirstAttribute <SqlServerMemoryOptimizedAttribute>();
var modelDef = GetModel(tableType);
if (fileTableAttrib == null)
{
foreach (var fieldDef in modelDef.FieldDefinitions)
{
if (fieldDef.CustomSelect != null)
{
continue;
}
var columnDefinition = GetColumnDefinition(fieldDef);
if (columnDefinition == null)
{
continue;
}
if (sbColumns.Length != 0)
{
sbColumns.Append(", \n ");
}
sbColumns.Append(columnDefinition);
if (fieldDef.ForeignKey == null || OrmLiteConfig.SkipForeignKeys)
{
continue;
}
var refModelDef = OrmLiteUtils.GetModelDefinition(fieldDef.ForeignKey.ReferenceType);
sbConstraints.Append(
$", \n\n CONSTRAINT {this.GetQuotedName(fieldDef.ForeignKey.GetForeignKeyName(modelDef, refModelDef, this.NamingStrategy, fieldDef))} FOREIGN KEY ({this.GetQuotedColumnName(fieldDef.FieldName)}) REFERENCES {this.GetQuotedTableName(refModelDef)} ({this.GetQuotedColumnName(refModelDef.PrimaryKey.FieldName)})");
sbConstraints.Append(GetForeignKeyOnDeleteClause(fieldDef.ForeignKey));
sbConstraints.Append(GetForeignKeyOnUpdateClause(fieldDef.ForeignKey));
}
if (memoryTableAttrib != null)
{
var attrib = tableType.FirstAttribute <SqlServerMemoryOptimizedAttribute>();
sbTableOptions.Append(" WITH (MEMORY_OPTIMIZED = ON");
if (attrib.Durability == SqlServerDurability.SchemaOnly)
{
sbTableOptions.Append(", DURABILITY = SCHEMA_ONLY");
}
else if (attrib.Durability == SqlServerDurability.SchemaAndData)
{
sbTableOptions.Append(", DURABILITY = SCHEMA_AND_DATA");
}
sbTableOptions.Append(")");
}
}
else
{
var hasFileTableDir = !string.IsNullOrEmpty(fileTableAttrib.FileTableDirectory);
var hasFileTableCollateFileName = !string.IsNullOrEmpty(fileTableAttrib.FileTableCollateFileName);
if (hasFileTableDir || hasFileTableCollateFileName)
{
sbTableOptions.Append(" WITH (");
if (hasFileTableDir)
{
sbTableOptions.Append($" FILETABLE_DIRECTORY = N'{fileTableAttrib.FileTableDirectory}'\n");
}
if (hasFileTableCollateFileName)
{
if (hasFileTableDir)
{
sbTableOptions.Append(" ,");
}
sbTableOptions.Append($" FILETABLE_COLLATE_FILENAME = {fileTableAttrib.FileTableCollateFileName ?? "database_default" }\n");
}
sbTableOptions.Append(")");
}
}
var sql = $"CREATE TABLE {GetQuotedTableName(modelDef)} ";
sql += fileTableAttrib != null
? $"\n AS FILETABLE{StringBuilderCache.ReturnAndFree(sbTableOptions)};"
: $"\n(\n {StringBuilderCache.ReturnAndFree(sbColumns)}{StringBuilderCacheAlt.ReturnAndFree(sbConstraints)} \n){StringBuilderCache.ReturnAndFree(sbTableOptions)}; \n";
return(sql);
}
/// <summary>
/// Run a Process asynchronously, returning entire captured process output, whilst streaming stdOut, stdErr callbacks
/// </summary>
public static async Task <ProcessResult> RunAsync(ProcessStartInfo startInfo, int?timeoutMs = null,
Action <string> onOut = null, Action <string> onError = null)
{
startInfo.RedirectStandardOutput = true;
startInfo.RedirectStandardError = true;
using var process = new Process
{
StartInfo = startInfo,
EnableRaisingEvents = true,
};
// List of tasks to wait for a whole process exit
var processTasks = new List <Task>();
// === EXITED Event handling ===
var processExitEvent = new TaskCompletionSource <object>();
process.Exited += (sender, args) => {
processExitEvent.TrySetResult(true);
};
processTasks.Add(processExitEvent.Task);
long callbackTicks = 0;
// === STDOUT handling ===
var stdOutBuilder = StringBuilderCache.Allocate();
var stdOutCloseEvent = new TaskCompletionSource <bool>();
process.OutputDataReceived += (s, e) => {
if (e.Data == null)
{
stdOutCloseEvent.TrySetResult(true);
}
else
{
stdOutBuilder.AppendLine(e.Data);
if (onOut != null)
{
var swCallback = Stopwatch.StartNew();
onOut(e.Data);
callbackTicks += swCallback.ElapsedTicks;
}
}
};
processTasks.Add(stdOutCloseEvent.Task);
// === STDERR handling ===
var stdErrBuilder = StringBuilderCacheAlt.Allocate();
var stdErrCloseEvent = new TaskCompletionSource <bool>();
process.ErrorDataReceived += (s, e) => {
if (e.Data == null)
{
stdErrCloseEvent.TrySetResult(true);
}
else
{
stdErrBuilder.AppendLine(e.Data);
if (onError != null)
{
var swCallback = Stopwatch.StartNew();
onError(e.Data);
callbackTicks += swCallback.ElapsedTicks;
}
}
};
processTasks.Add(stdErrCloseEvent.Task);
// === START OF PROCESS ===
var sw = Stopwatch.StartNew();
var result = new ProcessResult {
StartAt = DateTime.UtcNow,
};
if (!process.Start())
{
result.ExitCode = process.ExitCode;
return(result);
}
// Reads the output stream first as needed and then waits because deadlocks are possible
process.BeginOutputReadLine();
process.BeginErrorReadLine();
// === ASYNC WAIT OF PROCESS ===
// Process completion = exit AND stdout (if defined) AND stderr (if defined)
var processCompletionTask = Task.WhenAll(processTasks);
// Task to wait for exit OR timeout (if defined)
var awaitingTask = timeoutMs.HasValue
? Task.WhenAny(Task.Delay(timeoutMs.Value), processCompletionTask)
: Task.WhenAny(processCompletionTask);
// Let's now wait for something to end...
if ((await awaitingTask.ConfigureAwait(false)) == processCompletionTask)
{
// -> Process exited cleanly
result.ExitCode = process.ExitCode;
}
else
{
// -> Timeout, let's kill the process
try
{
process.Kill();
}
catch
{
// ignored
}
}
// Read stdout/stderr
result.EndAt = DateTime.UtcNow;
if (callbackTicks > 0)
{
var callbackMs = (callbackTicks / Stopwatch.Frequency) * 1000;
result.CallbackDurationMs = callbackMs;
result.DurationMs = sw.ElapsedMilliseconds - callbackMs;
}
else
{
result.DurationMs = sw.ElapsedMilliseconds;
}
result.StdOut = StringBuilderCache.ReturnAndFree(stdOutBuilder);
result.StdErr = StringBuilderCacheAlt.ReturnAndFree(stdErrBuilder);
return(result);
}
public override void PrepareParameterizedInsertStatement <T>(IDbCommand cmd, ICollection <string> insertFields = null)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var sbReturningColumns = StringBuilderCacheAlt.Allocate();
var modelDef = OrmLiteUtils.GetModelDefinition(typeof(T));
cmd.Parameters.Clear();
cmd.CommandTimeout = OrmLiteConfig.CommandTimeout;
foreach (var fieldDef in modelDef.FieldDefinitionsArray)
{
if (fieldDef.ReturnOnInsert || (fieldDef.IsPrimaryKey && fieldDef.AutoIncrement && HasInsertReturnValues(modelDef)))
{
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append(GetQuotedColumnName(fieldDef.FieldName));
}
if (fieldDef.ShouldSkipInsert() && !fieldDef.AutoIncrement && string.IsNullOrEmpty(fieldDef.Sequence))
{
continue;
}
//insertFields contains Property "Name" of fields to insert ( that's how expressions work )
if (insertFields != null && !insertFields.Contains(fieldDef.Name, StringComparer.OrdinalIgnoreCase))
{
continue;
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
if (fieldDef.AutoIncrement || !string.IsNullOrEmpty(fieldDef.Sequence))
{
EnsureAutoIncrementSequence(modelDef, fieldDef);
sbColumnValues.Append("NEXT VALUE FOR " + fieldDef.Sequence);
}
else
{
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName)));
AddParameter(cmd, fieldDef);
}
}
catch (Exception ex)
{
Log.Error("ERROR in PrepareParameterizedInsertStatement(): " + ex.Message, ex);
throw;
}
}
var strReturning = StringBuilderCacheAlt.ReturnAndFree(sbReturningColumns);
cmd.CommandText = string.Format("INSERT INTO {0} ({1}) VALUES ({2}) {3}",
GetQuotedTableName(modelDef),
StringBuilderCache.ReturnAndFree(sbColumnNames),
StringBuilderCacheAlt.ReturnAndFree(sbColumnValues),
strReturning.Length > 0 ? "RETURNING " + strReturning : "");
}
public IRawString formControl(TemplateScopeContext scope, object inputAttrs, string tagName, object inputOptions)
{
if (tagName == null)
{
tagName = "input";
}
var args = inputAttrs.AssertOptions(nameof(formInput));
var options = inputOptions as Dictionary <string, object> ?? TypeConstants.EmptyObjectDictionary;
string id = null;
string type = null;
string name = null;
string label = null;
string size = null;
bool inline = options.TryGetValue("inline", out var oInline) && oInline is bool b;
if (args.TryGetValue("type", out var oType))
{
type = oType as string;
}
else
{
args["type"] = type = "text";
}
var notInput = tagName != "input";
if (notInput)
{
type = tagName;
args.RemoveKey("type");
}
var inputClass = "form-control";
var labelClass = "form-label";
var helpClass = "text-muted";
var isCheck = type == "checkbox" || type == "radio";
if (isCheck)
{
inputClass = "form-check-input";
labelClass = "form-check-label";
if (!args.ContainsKey("value"))
{
args["value"] = "true";
}
}
else if (type == "range")
{
inputClass = "form-control-range";
}
if (options.TryGetValue("labelClass", out var oLabelClass))
{
labelClass = oLabelClass as string ?? "";
}
if (args.TryGetValue("id", out var oId))
{
if (!args.ContainsKey("name"))
{
args["name"] = id = oId as string;
}
if (args.TryGetValue("name", out var oName))
{
name = oName as string;
}
}
string help = options.TryGetValue("help", out var oHelp) ? oHelp as string : null;
string helpId = help != null ? (id ?? name) + "-help" : null;
if (helpId != null)
{
args["aria-describedby"] = helpId;
}
if (options.TryGetValue("label", out var oLabel))
{
label = oLabel as string;
if (!args.ContainsKey("placeholder"))
{
args["placeholder"] = label;
}
}
var values = options.TryGetValue("values", out var oValues)
? oValues
: null;
var isSingleCheck = isCheck && values == null;
string formValue = null;
var defaultFilters = Context.DefaultFilters;
var isGet = defaultFilters.isHttpGet(scope);
var preserveValue = !options.TryGetValue("preserveValue", out var oPreserve) || oPreserve as bool? == true;
if (preserveValue)
{
formValue = Context.GetServiceStackFilters().formValue(scope, name);
if (!isGet || !string.IsNullOrEmpty(formValue)) //only override value if POST or GET queryString has value
{
if (!isCheck)
{
args["value"] = formValue;
}
else if (isSingleCheck)
{
args["checked"] = formValue == "true";
}
}
}
else if (!isGet)
{
if (!isCheck)
{
args["value"] = null;
}
}
var htmlFilters = scope.Context.HtmlFilters;
var className = args.TryGetValue("class", out var oCls) || args.TryGetValue("className", out oCls)
? htmlFilters.htmlClassList(oCls)
: "";
className = htmlFilters.htmlAddClass(className, inputClass);
if (options.TryGetValue("size", out var oSize))
{
className = htmlFilters.htmlAddClass(className, inputClass + "-" + (size = oSize as string));
}
var errorMsg = Context.GetServiceStackFilters()?.errorResponse(scope, name);
if (errorMsg != null)
{
className = htmlFilters.htmlAddClass(className, "is-invalid");
}
args["class"] = className;
string inputHtml = null, labelHtml = null;
var sb = StringBuilderCache.Allocate();
if (label != null)
{
var labelArgs = new Dictionary <string, object>
{
["html"] = label,
["class"] = labelClass,
};
if (id != null)
{
labelArgs["for"] = id;
}
labelHtml = htmlFilters.htmlLabel(labelArgs).AsString();
}
var value = (args.TryGetValue("value", out var oValue)
? oValue as string
: null)
?? (oValue?.GetType().IsValueType == true
? oValue.ToString()
: null);
if (type == "radio")
{
if (values != null)
{
var sbInput = StringBuilderCacheAlt.Allocate();
var kvps = defaultFilters.toKeyValues(values);
foreach (var kvp in kvps)
{
var cls = inline ? " custom-control-inline" : "";
sbInput.AppendLine($"<div class=\"custom-control custom-radio{cls}\">");
var inputId = name + "-" + kvp.Key;
var selected = kvp.Key == formValue || kvp.Key == value ? " checked" : "";
sbInput.AppendLine($" <input type=\"radio\" id=\"{inputId}\" name=\"{name}\" value=\"{kvp.Key}\" class=\"custom-control-input\"{selected}>");
sbInput.AppendLine($" <label class=\"custom-control-label\" for=\"{inputId}\">{kvp.Value}</label>");
sbInput.AppendLine("</div>");
}
inputHtml = StringBuilderCacheAlt.ReturnAndFree(sbInput);
}
else
{
throw new NotSupportedException($"input type=radio requires 'values' inputOption containing a collection of Key/Value Pairs");
}
}
else if (type == "checkbox")
{
if (values != null)
{
var sbInput = StringBuilderCacheAlt.Allocate();
var kvps = defaultFilters.toKeyValues(values);
var selectedValues = value != null && value != "true"
? new HashSet <string> {
value
}
: oValue == null
? TypeConstants <string> .EmptyHashSet
: (Context.GetServiceStackFilters().formValues(scope, name) ?? defaultFilters.toStringList(oValue as IEnumerable).ToArray())
.ToHashSet();
foreach (var kvp in kvps)
{
var cls = inline ? " custom-control-inline" : "";
sbInput.AppendLine($"<div class=\"custom-control custom-checkbox{cls}\">");
var inputId = name + "-" + kvp.Key;
var selected = kvp.Key == formValue || selectedValues.Contains(kvp.Key) ? " checked" : "";
sbInput.AppendLine($" <input type=\"checkbox\" id=\"{inputId}\" name=\"{name}\" value=\"{kvp.Key}\" class=\"form-check-input\"{selected}>");
sbInput.AppendLine($" <label class=\"form-check-label\" for=\"{inputId}\">{kvp.Value}</label>");
sbInput.AppendLine("</div>");
}
inputHtml = StringBuilderCacheAlt.ReturnAndFree(sbInput);
}
}
else if (type == "select")
{
if (values != null)
{
args["html"] = Context.HtmlFilters.htmlOptions(values,
new Dictionary <string, object> {
{ "selected", formValue ?? value }
});
}
else if (!args.ContainsKey("html"))
{
throw new NotSupportedException($"<select> requires either 'values' inputOption containing a collection of Key/Value Pairs or 'html' argument containing innerHTML <option>'s");
}
}
if (inputHtml == null)
{
inputHtml = htmlFilters.htmlTag(args, tagName).AsString();
}
if (isCheck)
{
sb.AppendLine(inputHtml);
if (isSingleCheck)
{
sb.AppendLine(labelHtml);
}
}
else
{
sb.AppendLine(labelHtml).AppendLine(inputHtml);
}
if (help != null)
{
sb.AppendLine($"<small id='{helpId}' class='{helpClass}'>{help.HtmlEncode()}</small>");
}
string htmlError = null;
var showErrors = !options.TryGetValue("showErrors", out var oShowErrors) || oShowErrors as bool? == true;
if (showErrors && errorMsg != null)
{
var errorClass = "invalid-feedback";
if (options.TryGetValue("errorClass", out var oErrorClass))
{
errorClass = oErrorClass as string ?? "";
}
htmlError = $"<div class='{errorClass}'>{errorMsg.HtmlEncode()}</div>";
}
if (!isCheck)
{
sb.AppendLine(htmlError);
}
else
{
var cls = htmlError != null ? " is-invalid form-control" : "";
sb.Insert(0, $"<div class=\"form-check{cls}\">");
sb.AppendLine("</div>");
if (htmlError != null)
{
sb.AppendLine(htmlError);
}
}
if (isCheck && !isSingleCheck) // multi-value checkbox/radio
{
sb.Insert(0, labelHtml);
}
var html = StringBuilderCache.ReturnAndFree(sb);
return(html.ToRawString());
}
public IRawString htmltable(TemplateScopeContext scope, object target, object scopeOptions)
{
if (target is IDictionary <string, object> single)
{
target = new[] { single }
}
;
var items = target.AssertEnumerable(nameof(htmltable));
var scopedParams = scope.AssertOptions(nameof(htmltable), scopeOptions);
scopedParams.TryGetValue("headerStyle", out object oHeaderStyle);
scopedParams.TryGetValue("headerTag", out object oHeaderTag);
scopedParams.TryGetValue("emptyCaption", out object emptyCaption);
var headerTag = oHeaderTag as string ?? "th";
var headerStyle = oHeaderStyle as string ?? "splitCase";
var sbHeader = StringBuilderCache.Allocate();
var sbRows = StringBuilderCacheAlt.Allocate();
List <string> keys = null;
foreach (var item in items)
{
if (item is IDictionary <string, object> d)
{
if (keys == null)
{
keys = d.Keys.ToList();
sbHeader.Append("<tr>");
foreach (var key in keys)
{
sbHeader.Append('<').Append(headerTag).Append('>');
sbHeader.Append(TemplateDefaultFilters.Instance.textStyle(key, headerStyle)?.HtmlEncode());
sbHeader.Append("</").Append(headerTag).Append('>');
}
sbHeader.Append("</tr>");
}
sbRows.Append("<tr>");
foreach (var key in keys)
{
var value = d[key];
var encodedValue = value?.ToString()?.HtmlEncode();
sbRows.Append("<td>").Append(encodedValue).Append("</td>");
}
sbRows.Append("</tr>");
}
}
var isEmpty = sbRows.Length == 0;
if (isEmpty && emptyCaption == null)
{
return(RawString.Empty);
}
var htmlHeaders = StringBuilderCache.ReturnAndFree(sbHeader);
var htmlRows = StringBuilderCacheAlt.ReturnAndFree(sbRows);
var sb = StringBuilderCache.Allocate();
sb.Append("<table");
if (scopedParams.TryGetValue("id", out object id))
{
sb.Append(" id=\"").Append(id).Append("\"");
}
if (scopedParams.TryGetValue("className", out object className))
{
sb.Append(" class=\"").Append(className).Append("\"");
}
sb.Append(">");
scopedParams.TryGetValue("caption", out object caption);
if (isEmpty)
{
caption = emptyCaption;
}
if (caption != null)
{
sb.Append("<caption>").Append(caption.ToString().HtmlEncode()).Append("</caption>");
}
if (htmlHeaders.Length > 0)
{
sb.Append("<thead>").Append(htmlHeaders).Append("</thead>");
}
if (htmlRows.Length > 0)
{
sb.Append("<tbody>").Append(htmlRows).Append("</tbody>");
}
sb.Append("</table>");
var html = StringBuilderCache.ReturnAndFree(sb);
return(html.ToRawString());
}
}
private void ConstructEvaluator(IEnumerable <EvaluatorItem> items)
{
var codeCompiler = System.CodeDom.Compiler.CodeDomProvider.CreateProvider("CSharp");
var cp = new System.CodeDom.Compiler.CompilerParameters
{
GenerateExecutable = false,
GenerateInMemory = true,
};
Assemblies.ForEach(x => AddAssembly(cp, x.Location));
var code = StringBuilderCache.Allocate();
AssemblyNames.ForEach(x =>
code.AppendFormat("using {0};\n", x));
code.Append(
@"
namespace CSharpEval
{
public class _Expr
");
if (this.BaseType != null)
{
code.Append(" : " + GetTypeName(this.BaseType));
if (GenericArgs.Length > 0)
{
code.Append("<");
var i = 0;
foreach (var genericArg in GenericArgs)
{
if (i++ > 0)
{
code.Append(", ");
}
code.Append(GetTypeName(genericArg));
ReferenceTypesIfNotExist(cp, Assemblies, genericArg);
}
code.AppendLine(">");
}
ReferenceTypesIfNotExist(cp, Assemblies, this.BaseType);
}
code.AppendLine(" {");
AddPropertiesToTypeIfAny(code);
foreach (var item in items)
{
var sbParams = StringBuilderCacheAlt.Allocate();
foreach (var param in item.Params)
{
if (sbParams.Length > 0)
{
sbParams.Append(", ");
}
var typeName = GetTypeName(param.Value);
sbParams.AppendFormat("{0} {1}", typeName, param.Key);
var paramType = param.Value;
ReferenceAssembliesIfNotExists(cp, paramType, Assemblies);
}
var isVoid = item.ReturnType == typeof(void);
var returnType = isVoid ? "void" : GetTypeName(item.ReturnType);
code.AppendFormat(" public {0} {1}({2})",
returnType, item.Name, StringBuilderCacheAlt.ReturnAndFree(sbParams));
code.AppendLine(" {");
if (isVoid)
{
code.AppendFormat(" {0}; \n", item.Expression);
}
else
{
code.AppendFormat(" return ({0}); \n", item.Expression);
}
code.AppendLine(" }");
}
code.AppendLine(" }");
code.AppendLine("}");
if (IsVersion4AndUp)
{
if (!Env.IsMono)
{
cp.ReferencedAssemblies.Add(Env.ReferenceAssembyPath + @"System.Core.dll");
}
}
var src = StringBuilderCache.ReturnAndFree(code);
var compilerResults = codeCompiler.CompileAssemblyFromSource(cp, src);
if (compilerResults.Errors.HasErrors)
{
var error = StringBuilderCache.Allocate();
error.Append("Error Compiling Expression: ");
foreach (System.CodeDom.Compiler.CompilerError err in compilerResults.Errors)
{
error.AppendFormat("{0}\n", err.ErrorText);
}
throw new Exception(StringBuilderCache.ReturnAndFree(error));
}
compiledAssembly = compilerResults.CompiledAssembly;
compiled = compiledAssembly.CreateInstance("CSharpEval._Expr");
compiledType = compiled.GetType();
compiledTypeCtorFn = ReflectionExtensions.GetConstructorMethodToCache(compiledType);
}
public IRawString htmlList(TemplateScopeContext scope, object target, object scopeOptions)
{
if (target is IDictionary <string, object> single)
{
target = new[] { single }
}
;
var items = target.AssertEnumerable(nameof(htmlList));
var scopedParams = scope.AssertOptions(nameof(htmlList), scopeOptions);
var depth = scopedParams.TryGetValue("depth", out object oDepth) ? (int)oDepth : 0;
var childDepth = scopedParams.TryGetValue("childDepth", out object oChildDepth) ? oChildDepth.ConvertTo <int>() : 1;
scopedParams["depth"] = depth + 1;
try
{
scopedParams.TryGetValue("className", out object parentClass);
scopedParams.TryGetValue("childClass", out object childClass);
var className = ((depth < childDepth ? parentClass : childClass ?? parentClass)
?? Context.Args[TemplateConstants.DefaultTableClassName]).ToString();
scopedParams.TryGetValue("headerStyle", out object oHeaderStyle);
scopedParams.TryGetValue("headerTag", out object oHeaderTag);
scopedParams.TryGetValue("captionIfEmpty", out object captionIfEmpty);
var headerTag = oHeaderTag as string ?? "th";
var headerStyle = oHeaderStyle as string ?? "splitCase";
var sbHeader = StringBuilderCache.Allocate();
var sbRows = StringBuilderCacheAlt.Allocate();
List <string> keys = null;
foreach (var item in items)
{
if (item is IDictionary <string, object> d)
{
if (keys == null)
{
keys = d.Keys.ToList();
sbHeader.Append("<tr>");
foreach (var key in keys)
{
sbHeader.Append('<').Append(headerTag).Append('>');
sbHeader.Append(Context.DefaultFilters?.textStyle(key, headerStyle)?.HtmlEncode());
sbHeader.Append("</").Append(headerTag).Append('>');
}
sbHeader.Append("</tr>");
}
sbRows.Append("<tr>");
foreach (var key in keys)
{
var value = d[key];
sbRows.Append("<td>");
if (!isComplexType(value))
{
sbRows.Append(GetScalarHtml(value));
}
else
{
var htmlValue = htmlDump(scope, value, scopeOptions);
sbRows.Append(htmlValue.ToRawString());
}
sbRows.Append("</td>");
}
sbRows.Append("</tr>");
}
}
var isEmpty = sbRows.Length == 0;
if (isEmpty && captionIfEmpty == null)
{
return(RawString.Empty);
}
var htmlHeaders = StringBuilderCache.ReturnAndFree(sbHeader);
var htmlRows = StringBuilderCacheAlt.ReturnAndFree(sbRows);
var sb = StringBuilderCache.Allocate();
sb.Append("<table");
if (scopedParams.TryGetValue("id", out object id))
{
sb.Append(" id=\"").Append(id).Append("\"");
}
if (!string.IsNullOrEmpty(className))
{
sb.Append(" class=\"").Append(className).Append("\"");
}
sb.Append(">");
scopedParams.TryGetValue("caption", out object caption);
if (isEmpty)
{
caption = captionIfEmpty;
}
if (caption != null && !scopedParams.TryGetValue("hasCaption", out _))
{
sb.Append("<caption>").Append(caption.ToString().HtmlEncode()).Append("</caption>");
scopedParams["hasCaption"] = true;
}
if (htmlHeaders.Length > 0)
{
sb.Append("<thead>").Append(htmlHeaders).Append("</thead>");
}
if (htmlRows.Length > 0)
{
sb.Append("<tbody>").Append(htmlRows).Append("</tbody>");
}
sb.Append("</table>");
var html = StringBuilderCache.ReturnAndFree(sb);
return(html.ToRawString());
}
finally
{
scopedParams["depth"] = depth;
}
}
public static string HtmlDump(object target, HtmlDumpOptions options)
{
if (options == null)
{
options = new HtmlDumpOptions();
}
var depth = options.Depth;
var childDepth = options.ChildDepth;
options.Depth += 1;
try
{
target = DefaultScripts.ConvertDumpType(target);
if (!isComplexType(target))
{
return(GetScalarHtml(target, options.Defaults));
}
var parentClass = options.ClassName;
var childClass = options.ChildClass;
var className = ((depth < childDepth ? parentClass : childClass ?? parentClass)
?? options.Defaults.GetDefaultTableClassName());
var headerStyle = options.HeaderStyle;
var headerTag = options.HeaderTag ?? "th";
if (target is IEnumerable e)
{
var objs = e.Map(x => x);
var isEmpty = objs.Count == 0;
if (isEmpty && options.CaptionIfEmpty == null)
{
return(string.Empty);
}
var first = !isEmpty ? objs[0] : null;
if (first is IDictionary && objs.Count > 1)
{
return(HtmlList(objs, options));
}
var sb = StringBuilderCacheAlt.Allocate();
sb.Append("<table");
if (options.Id != null)
{
sb.Append(" id=\"").Append(options.Id).Append("\"");
}
if (!string.IsNullOrEmpty(className))
{
sb.Append(" class=\"").Append(className).Append("\"");
}
sb.Append(">");
var caption = options.Caption;
if (isEmpty)
{
caption = options.CaptionIfEmpty;
}
var holdCaption = options.HasCaption;
if (caption != null && !options.HasCaption)
{
sb.Append("<caption>").Append(caption.HtmlEncode()).Append("</caption>");
options.HasCaption = true;
}
if (!isEmpty)
{
sb.Append("<tbody>");
if (first is KeyValuePair <string, object> )
{
foreach (var o in objs)
{
if (o is KeyValuePair <string, object> kvp)
{
if (kvp.Value == target)
{
break; // Prevent cyclical deps like 'it' binding
}
sb.Append("<tr>");
sb.Append('<').Append(headerTag).Append('>');
sb.Append(ViewUtils.StyleText(kvp.Key, headerStyle)?.HtmlEncode());
sb.Append("</").Append(headerTag).Append('>');
sb.Append("<td>");
if (!isComplexType(kvp.Value))
{
sb.Append(GetScalarHtml(kvp.Value, options.Defaults));
}
else
{
var body = HtmlDump(kvp.Value, options);
sb.Append(body.ToRawString());
}
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
else if (!isComplexType(first))
{
foreach (var o in objs)
{
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(GetScalarHtml(o, options.Defaults));
sb.Append("</td>");
sb.Append("</tr>");
}
}
else
{
if (objs.Count > 1)
{
var rows = objs.Map(x => x.ToObjectDictionary());
StringBuilderCache.Free(sb);
options.HasCaption = holdCaption;
return(HtmlList(rows, options));
}
else
{
foreach (var o in objs)
{
sb.Append("<tr>");
if (!isComplexType(o))
{
sb.Append("<td>");
sb.Append(GetScalarHtml(o, options.Defaults));
sb.Append("</td>");
}
else
{
sb.Append("<td>");
var body = HtmlDump(o, options);
sb.Append(body.ToRawString());
sb.Append("</td>");
}
sb.Append("</tr>");
}
}
}
sb.Append("</tbody>");
}
sb.Append("</table>");
var html = StringBuilderCacheAlt.ReturnAndFree(sb);
return(html);
}
return(HtmlDump(target.ToObjectDictionary(), options));
}
finally
{
options.Depth = depth;
}
}
public IRawString htmlDump(TemplateScopeContext scope, object target, object scopeOptions)
{
var scopedParams = scope.AssertOptions(nameof(htmlDump), scopeOptions);
var depth = scopedParams.TryGetValue("depth", out object oDepth) ? (int)oDepth : 0;
var childDepth = scopedParams.TryGetValue("childDepth", out object oChildDepth) ? oChildDepth.ConvertTo <int>() : 1;
scopedParams["depth"] = depth + 1;
try
{
if (!isComplexType(target))
{
return(GetScalarHtml(target).ToRawString());
}
scopedParams.TryGetValue("captionIfEmpty", out object captionIfEmpty);
scopedParams.TryGetValue("headerStyle", out object oHeaderStyle);
scopedParams.TryGetValue("className", out object parentClass);
scopedParams.TryGetValue("childClass", out object childClass);
var headerStyle = oHeaderStyle as string ?? "splitCase";
var className = ((depth < childDepth ? parentClass : childClass ?? parentClass)
?? Context.Args[TemplateConstants.DefaultTableClassName]).ToString();
if (target is IEnumerable e)
{
var objs = e.Map(x => x);
var isEmpty = objs.Count == 0;
if (isEmpty && captionIfEmpty == null)
{
return(RawString.Empty);
}
var first = !isEmpty ? objs[0] : null;
if (first is IDictionary)
{
return(htmlList(scope, target, scopeOptions));
}
var sb = StringBuilderCacheAlt.Allocate();
sb.Append("<table");
if (scopedParams.TryGetValue("id", out object id))
{
sb.Append(" id=\"").Append(id).Append("\"");
}
sb.Append(" class=\"").Append(className).Append("\"");
sb.Append(">");
scopedParams.TryGetValue("caption", out object caption);
if (isEmpty)
{
caption = captionIfEmpty;
}
if (caption != null && !scopedParams.TryGetValue("hasCaption", out _))
{
sb.Append("<caption>").Append(caption.ToString().HtmlEncode()).Append("</caption>");
scopedParams["hasCaption"] = true;
}
if (!isEmpty)
{
sb.Append("<tbody>");
if (first is KeyValuePair <string, object> )
{
foreach (var o in objs)
{
if (o is KeyValuePair <string, object> kvp)
{
sb.Append("<tr>");
sb.Append("<th>");
sb.Append(Context.DefaultFilters?.textStyle(kvp.Key, headerStyle)?.HtmlEncode());
sb.Append("</th>");
sb.Append("<td>");
if (!isComplexType(kvp.Value))
{
sb.Append(GetScalarHtml(kvp.Value));
}
else
{
var body = htmlDump(scope, kvp.Value, scopeOptions);
sb.Append(body.ToRawString());
}
sb.Append("</td>");
sb.Append("</tr>");
}
}
}
else if (!isComplexType(first))
{
foreach (var o in objs)
{
sb.Append("<tr>");
sb.Append("<td>");
sb.Append(GetScalarHtml(o));
sb.Append("</td>");
sb.Append("</tr>");
}
}
else
{
if (objs.Count > 1)
{
var rows = objs.Map(x => x.ToObjectDictionary());
sb.Append("<tr>");
sb.Append("<td>");
var list = htmlList(scope, rows, scopeOptions);
sb.Append(list.ToRawString());
sb.Append("</td>");
sb.Append("</tr>");
}
else
{
foreach (var o in objs)
{
sb.Append("<tr>");
if (!isComplexType(o))
{
sb.Append("<td>");
sb.Append(GetScalarHtml(o));
sb.Append("</td>");
}
else
{
sb.Append("<td>");
var body = htmlDump(scope, o, scopeOptions);
sb.Append(body.ToRawString());
sb.Append("</td>");
}
sb.Append("</tr>");
}
}
}
sb.Append("</tbody>");
}
sb.Append("</table>");
var html = StringBuilderCacheAlt.ReturnAndFree(sb);
return(html.ToRawString());
}
return(htmlDump(scope, target.ToObjectDictionary(), scopeOptions));
}
finally
{
scopedParams["depth"] = depth;
}
}
private static string CreateIcons(Operation op)
{
var sbIcons = StringBuilderCache.Allocate();
if (op.RequiresAuthentication)
{
sbIcons.Append("<i class=\"auth\" title=\"");
var hasRoles = op.RequiredRoles.Count + op.RequiresAnyRole.Count > 0;
if (hasRoles)
{
sbIcons.Append("Requires Roles:");
var sbRoles = StringBuilderCacheAlt.Allocate();
foreach (var role in op.RequiredRoles)
{
if (sbRoles.Length > 0)
{
sbRoles.Append(",");
}
sbRoles.Append(" " + role);
}
foreach (var role in op.RequiresAnyRole)
{
if (sbRoles.Length > 0)
{
sbRoles.Append(", ");
}
sbRoles.Append(" " + role + "?");
}
sbIcons.Append(StringBuilderCacheAlt.ReturnAndFree(sbRoles));
}
var hasPermissions = op.RequiredPermissions.Count + op.RequiresAnyPermission.Count > 0;
if (hasPermissions)
{
if (hasRoles)
{
sbIcons.Append(". ");
}
sbIcons.Append("Requires Permissions:");
var sbPermission = StringBuilderCacheAlt.Allocate();
foreach (var permission in op.RequiredPermissions)
{
if (sbPermission.Length > 0)
{
sbPermission.Append(",");
}
sbPermission.Append(" " + permission);
}
foreach (var permission in op.RequiresAnyPermission)
{
if (sbPermission.Length > 0)
{
sbPermission.Append(",");
}
sbPermission.Append(" " + permission + "?");
}
sbIcons.Append(StringBuilderCacheAlt.ReturnAndFree(sbPermission));
}
if (!hasRoles && !hasPermissions)
{
sbIcons.Append("Requires Authentication");
}
sbIcons.Append("\"></i>");
}
var icons = sbIcons.Length > 0
? "<span class=\"icons\">" + StringBuilderCache.ReturnAndFree(sbIcons) + "</span>"
: "";
return(icons);
}
public override void PrepareInsertRowStatement <T>(IDbCommand dbCmd, Dictionary <string, object> args)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var sbReturningColumns = StringBuilderCacheAlt.Allocate();
var modelDef = OrmLiteUtils.GetModelDefinition(typeof(T));
dbCmd.Parameters.Clear();
foreach (var entry in args)
{
var fieldDef = modelDef.GetFieldDefinition(entry.Key);
if (ShouldReturnOnInsert(modelDef, fieldDef))
{
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append($"INSERTED.{this.GetQuotedColumnName(fieldDef.FieldName)}");
}
if (ShouldSkipInsert(fieldDef))
{
continue;
}
var value = entry.Value;
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
sbColumnValues.Append(this.AddParam(dbCmd, value, fieldDef).ParameterName);
}
catch (Exception ex)
{
Log.Error($"ERROR in PrepareInsertRowStatement(): {ex.Message}", ex);
throw;
}
}
var strReturning = StringBuilderCacheAlt.ReturnAndFree(sbReturningColumns);
strReturning = strReturning.Length > 0 ? $"OUTPUT {strReturning} " : string.Empty;
dbCmd.CommandText =
$"INSERT INTO {this.GetQuotedTableName(modelDef)} ({StringBuilderCache.ReturnAndFree(sbColumnNames)}) {strReturning}VALUES ({StringBuilderCacheAlt.ReturnAndFree(sbColumnValues)})";
}
public override void PrepareParameterizedInsertStatement <T>(IDbCommand cmd, ICollection <string> insertFields = null,
Func <FieldDefinition, bool> shouldInclude = null)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var sbReturningColumns = StringBuilderCacheAlt.Allocate();
var modelDef = OrmLiteUtils.GetModelDefinition(typeof(T));
cmd.Parameters.Clear();
cmd.CommandTimeout = OrmLiteConfig.CommandTimeout;
var fieldDefs = GetInsertFieldDefinitions(modelDef, insertFields);
foreach (var fieldDef in fieldDefs)
{
if (ShouldReturnOnInsert(modelDef, fieldDef))
{
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append(GetQuotedColumnName(fieldDef.FieldName));
}
if ((ShouldSkipInsert(fieldDef) && !fieldDef.AutoIncrement && !fieldDef.AutoId && string.IsNullOrEmpty(fieldDef.Sequence)) &&
shouldInclude?.Invoke(fieldDef) != true)
{
continue;
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
if (fieldDef.AutoIncrement || !string.IsNullOrEmpty(fieldDef.Sequence))
{
EnsureAutoIncrementSequence(modelDef, fieldDef);
sbColumnValues.Append("NEXT VALUE FOR " + fieldDef.Sequence);
}
else
{
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName), fieldDef.CustomInsert));
AddParameter(cmd, fieldDef);
}
}
catch (Exception ex)
{
Log.Error("ERROR in PrepareParameterizedInsertStatement(): " + ex.Message, ex);
throw;
}
}
var strReturning = StringBuilderCacheAlt.ReturnAndFree(sbReturningColumns);
cmd.CommandText = string.Format("INSERT INTO {0} ({1}) VALUES ({2}) {3}",
GetQuotedTableName(modelDef),
StringBuilderCache.ReturnAndFree(sbColumnNames),
StringBuilderCacheAlt.ReturnAndFree(sbColumnValues),
strReturning.Length > 0 ? "RETURNING " + strReturning : "");
}
//TODO: Change to parameterized query to match all other ToInsertRowStatement() impls
public override string ToInsertRowStatement(IDbCommand dbCommand, object objWithProperties, ICollection <string> insertFields = null)
{
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var tableType = objWithProperties.GetType();
var modelDef = GetModel(tableType);
var fieldDefs = GetInsertFieldDefinitions(modelDef, insertFields);
foreach (var fieldDef in fieldDefs)
{
if (fieldDef.IsComputed)
{
continue;
}
if ((fieldDef.AutoIncrement || !string.IsNullOrEmpty(fieldDef.Sequence)) &&
dbCommand != null)
{
if (fieldDef.AutoIncrement && string.IsNullOrEmpty(fieldDef.Sequence))
{
fieldDef.Sequence = Sequence(NamingStrategy.GetTableName(modelDef), fieldDef.FieldName, fieldDef.Sequence);
}
var pi = tableType.GetProperty(fieldDef.Name,
BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.FlattenHierarchy);
var result = GetNextValue(dbCommand.Connection, dbCommand.Transaction, fieldDef.Sequence,
pi.GetValue(objWithProperties, new object[] { }), isInsert: true);
if (pi.PropertyType == typeof(String))
{
pi.SetProperty(objWithProperties, result.ToString());
}
else if (pi.PropertyType == typeof(Int16))
{
pi.SetProperty(objWithProperties, Convert.ToInt16(result));
}
else if (pi.PropertyType == typeof(Int32))
{
pi.SetProperty(objWithProperties, Convert.ToInt32(result));
}
else if (pi.PropertyType == typeof(Guid))
{
pi.SetProperty(objWithProperties, result);
}
else
{
pi.SetProperty(objWithProperties, Convert.ToInt64(result));
}
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(string.Format("{0}", GetQuotedColumnName(fieldDef.FieldName)));
if (!string.IsNullOrEmpty(fieldDef.Sequence) && dbCommand == null)
{
sbColumnValues.Append(string.Format(":{0}", fieldDef.Name));
}
else
{
sbColumnValues.Append(fieldDef.GetQuotedValue(objWithProperties));
}
}
catch (Exception ex)
{
Log.ErrorFormat("Error in ToInsertRowStatement on column {0}: {1}", fieldDef.FieldName, ex);
throw;
}
}
var sql = string.Format("INSERT INTO {0} ({1}) VALUES ({2}) ",
GetQuotedTableName(modelDef),
StringBuilderCache.ReturnAndFree(sbColumnNames),
StringBuilderCacheAlt.ReturnAndFree(sbColumnValues));
return(sql);
}
public override string ToInsertRowStatement(IDbCommand cmd, object objWithProperties, ICollection <string> insertFields = null)
{
if (insertFields == null)
{
insertFields = new List <string>();
}
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var sbReturningColumns = StringBuilderCacheAlt.Allocate();
var tableType = objWithProperties.GetType();
var modelDef = GetModel(tableType);
foreach (var fieldDef in modelDef.FieldDefinitionsArray)
{
if (ShouldReturnOnInsert(modelDef, fieldDef))
{
if (sbReturningColumns.Length > 0)
{
sbReturningColumns.Append(",");
}
sbReturningColumns.Append("INSERTED." + GetQuotedColumnName(fieldDef.FieldName));
}
if (ShouldSkipInsert(fieldDef))
{
continue;
}
if (insertFields.Count > 0 && !insertFields.Contains(fieldDef.Name, StringComparer.OrdinalIgnoreCase))
{
continue;
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName)));
var p = AddParameter(cmd, fieldDef);
p.Value = fieldDef.GetValue(objWithProperties) ?? DBNull.Value;
}
catch (Exception ex)
{
Log.Error("ERROR in ToInsertRowStatement(): " + ex.Message, ex);
throw;
}
}
var strReturning = StringBuilderCacheAlt.ReturnAndFree(sbReturningColumns);
strReturning = strReturning.Length > 0 ? "OUTPUT " + strReturning + " " : "";
var sql = $"INSERT INTO {GetQuotedTableName(modelDef)} ({StringBuilderCache.ReturnAndFree(sbColumnNames)}) " +
strReturning +
$"VALUES ({StringBuilderCacheAlt.ReturnAndFree(sbColumnValues)})";
return(sql);
}
public override string ToCreateTableStatement(Type tableType)
{
var sbColumns = StringBuilderCache.Allocate();
var sbConstraints = StringBuilderCacheAlt.Allocate();
var sbTableOptions = StringBuilderCacheAlt.Allocate();
var fileTableAttrib = tableType.FirstAttribute <SqlServerFileTableAttribute>();
var modelDef = GetModel(tableType);
if (fileTableAttrib == null)
{
foreach (var fieldDef in modelDef.FieldDefinitions)
{
if (fieldDef.CustomSelect != null)
{
continue;
}
var columnDefinition = GetColumnDefinition(fieldDef);
if (columnDefinition == null)
{
continue;
}
if (sbColumns.Length != 0)
{
sbColumns.Append(", \n ");
}
sbColumns.Append(columnDefinition);
var sqlConstraint = GetCheckConstraint(fieldDef);
if (sqlConstraint != null)
{
sbConstraints.Append(",\n" + sqlConstraint);
}
if (fieldDef.ForeignKey == null || OrmLiteConfig.SkipForeignKeys)
{
continue;
}
var refModelDef = GetModel(fieldDef.ForeignKey.ReferenceType);
sbConstraints.Append(
$", \n\n CONSTRAINT {GetQuotedName(fieldDef.ForeignKey.GetForeignKeyName(modelDef, refModelDef, NamingStrategy, fieldDef))} " +
$"FOREIGN KEY ({GetQuotedColumnName(fieldDef.FieldName)}) " +
$"REFERENCES {GetQuotedTableName(refModelDef)} ({GetQuotedColumnName(refModelDef.PrimaryKey.FieldName)})");
sbConstraints.Append(GetForeignKeyOnDeleteClause(fieldDef.ForeignKey));
sbConstraints.Append(GetForeignKeyOnUpdateClause(fieldDef.ForeignKey));
}
}
else
{
if (fileTableAttrib.FileTableDirectory != null || fileTableAttrib.FileTableCollateFileName != null)
{
sbTableOptions.Append(" WITH (");
if (fileTableAttrib.FileTableDirectory != null)
{
sbTableOptions.Append($" FILETABLE_DIRECTORY = N'{fileTableAttrib.FileTableDirectory}'\n");
}
if (fileTableAttrib.FileTableCollateFileName != null)
{
if (fileTableAttrib.FileTableDirectory != null)
{
sbTableOptions.Append(" ,");
}
sbTableOptions.Append($" FILETABLE_COLLATE_FILENAME = {fileTableAttrib.FileTableCollateFileName ?? "database_default" }\n");
}
sbTableOptions.Append(")");
}
}
var uniqueConstraints = GetUniqueConstraints(modelDef);
if (uniqueConstraints != null)
{
sbConstraints.Append(",\n" + uniqueConstraints);
}
var sql = $"CREATE TABLE {GetQuotedTableName(modelDef)} ";
sql += fileTableAttrib != null
? $"\n AS FILETABLE{StringBuilderCache.ReturnAndFree(sbTableOptions)};"
: $"\n(\n {StringBuilderCache.ReturnAndFree(sbColumns)}{StringBuilderCacheAlt.ReturnAndFree(sbConstraints)} \n){StringBuilderCache.ReturnAndFree(sbTableOptions)}; \n";
return(sql);
}
public void AddProperties(StringBuilderWrapper sb, MetadataType type,
bool includeResponseStatus,
bool addPropertyAccessors,
string settersReturnType)
{
var wasAdded = false;
var sbInner = StringBuilderCacheAlt.Allocate();
var sbAccessors = new StringBuilderWrapper(sbInner);
if (addPropertyAccessors)
{
sbAccessors.AppendLine();
sbAccessors = sbAccessors.Indent().Indent();
}
var dataMemberIndex = 1;
if (type.Properties != null)
{
foreach (var prop in type.Properties)
{
if (wasAdded)
{
sb.AppendLine();
}
var propType = Type(prop.GetTypeName(Config, allTypes), prop.GenericArgs);
var fieldName = prop.Name.SafeToken().PropertyStyle();
var accessorName = fieldName.ToPascalCase();
wasAdded = AppendComments(sb, prop.Description);
wasAdded = AppendDataMember(sb, prop.DataMember, dataMemberIndex++) || wasAdded;
wasAdded = AppendAttributes(sb, prop.Attributes) || wasAdded;
if (!fieldName.IsKeyWord())
{
sb.AppendLine("public {0} {1} = null;".Fmt(propType, fieldName));
}
else
{
var originalName = fieldName;
fieldName = Char.ToUpper(fieldName[0]) + fieldName.SafeSubstring(1);
sb.AppendLine("@SerializedName(\"{0}\") public {1} {2} = null;".Fmt(originalName, propType, fieldName));
}
if (addPropertyAccessors)
{
sbAccessors.AppendPropertyAccessor(propType, fieldName, accessorName, settersReturnType);
}
}
}
if (includeResponseStatus)
{
if (wasAdded)
{
sb.AppendLine();
}
AppendDataMember(sb, null, dataMemberIndex++);
sb.AppendLine("public ResponseStatus {0} = null;".Fmt(typeof(ResponseStatus).Name.PropertyStyle()));
if (addPropertyAccessors)
{
sbAccessors.AppendPropertyAccessor("ResponseStatus", "ResponseStatus", settersReturnType);
}
}
if (sbAccessors.Length > 0)
{
sb.AppendLine(StringBuilderCacheAlt.ReturnAndFree(sbInner).TrimEnd()); //remove last \n
}
}
private string AppendType(ref StringBuilderWrapper sb, MetadataType type, string lastNS,
CreateTypeOptions options)
{
sb.AppendLine();
AppendComments(sb, type.Description);
if (type.Routes != null)
{
AppendAttributes(sb, type.Routes.ConvertAll(x => x.ToMetadataAttribute()));
}
AppendAttributes(sb, type.Attributes);
AppendDataContract(sb, type.DataContract);
PreTypeFilter?.Invoke(sb, type);
if (type.IsEnum.GetValueOrDefault())
{
var enumType = Type(type.Name, type.GenericArgs);
RegisterType(type, enumType);
var isIntEnum = type.IsEnumInt.GetValueOrDefault() || type.EnumNames.IsEmpty();
if (!isIntEnum)
{
sb.AppendLine($"enum {enumType}");
sb.AppendLine("{");
sb = sb.Indent();
foreach (var name in type.EnumNames.Safe())
{
sb.AppendLine($"{name},");
}
sb = sb.UnIndent();
sb.AppendLine("}");
}
else
{
sb.AppendLine($"class {enumType}");
sb.AppendLine("{");
sb = sb.Indent();
if (type.EnumNames != null)
{
for (var i = 0; i < type.EnumNames.Count; i++)
{
var name = type.EnumNames[i];
var value = type.EnumValues?[i];
sb.AppendLine($"static const {enumType} {name} = const {enumType}._({value});");
}
}
sb.AppendLine();
sb.AppendLine("final int _value;");
sb.AppendLine($"const {enumType}._(this._value);");
sb.AppendLine($"int get value => _value;");
var enumNames = (type.EnumNames ?? TypeConstants.EmptyStringList).Join(",");
sb.AppendLine($"static List<{enumType}> get values => const [{enumNames}];");
sb = sb.UnIndent();
sb.AppendLine("}");
}
}
else
{
var extends = new List <string>();
//: BaseClass, Interfaces
if (type.Inherits != null)
{
extends.Add(Type(type.Inherits).InDeclarationType());
}
string responseTypeExpression = null;
var interfaces = new List <string>();
var implStr = options.ImplementsFn?.Invoke();
if (!string.IsNullOrEmpty(implStr))
{
interfaces.Add(implStr);
if (implStr.StartsWith("IReturn<"))
{
var types = implStr.RightPart('<');
var returnType = types.Substring(0, types.Length - 1);
if (returnType == "any")
{
returnType = "dynamic";
}
// This is to avoid invalid syntax such as "return new string()"
responseTypeExpression = defaultValues.TryGetValue(returnType, out var newReturnInstance)
? $"createResponse() {{ return {newReturnInstance}; }}"
: $"createResponse() {{ return new {returnType}(); }}";
}
else if (implStr == "IReturnVoid")
{
responseTypeExpression = "createResponse() {}";
}
}
type.Implements.Each(x => interfaces.Add(Type(x)));
var isClass = type.IsInterface != true;
var isAbstractClass = type.IsInterface == true || type.IsAbstract == true;
var baseClass = extends.Count > 0 ? extends[0] : null;
var hasDtoBaseClass = baseClass != null;
var hasListBase = baseClass != null && baseClass.StartsWith("List<");
if (hasListBase)
{
baseClass = "ListBase" + baseClass.Substring(4);
hasDtoBaseClass = false;
}
if (!isAbstractClass)
{
interfaces.Add("IConvertible");
}
var extend = baseClass != null
? " extends " + baseClass
: "";
if (interfaces.Count > 0)
{
if (isClass)
{
extend += " implements " + string.Join(", ", interfaces.ToArray());
}
else
{
if (string.IsNullOrEmpty(extend))
{
extend = " extends ";
}
else
{
extend += ", ";
}
extend += string.Join(", ", interfaces.ToArray());
}
}
var typeDeclaration = !isAbstractClass ? "class" : "abstract class";
var typeName = Type(type.Name, type.GenericArgs);
RegisterType(type, typeName);
sb.AppendLine($"{typeDeclaration} {typeName}{extend}");
sb.AppendLine("{");
sb = sb.Indent();
var addVersionInfo = Config.AddImplicitVersion != null && options.IsRequest && !isAbstractClass;
if (addVersionInfo)
{
sb.AppendLine($"int {"Version".PropertyStyle()};");
}
if (type.Name == "IReturn`1")
{
sb.AppendLine("T createResponse();");
sb.AppendLine("String getTypeName();");
}
else if (type.Name == "IReturnVoid")
{
sb.AppendLine("void createResponse();");
sb.AppendLine("String getTypeName();");
}
AddProperties(sb, type,
includeResponseStatus: Config.AddResponseStatus && options.IsResponse &&
type.Properties.Safe().All(x => x.Name != typeof(ResponseStatus).Name));
if (isClass)
{
var typeNameWithoutGenericArgs = typeName.LeftPart('<');
var props = (type.Properties ?? TypeConstants <MetadataPropertyType> .EmptyList).ToList();
if (addVersionInfo)
{
props.Insert(0, new MetadataPropertyType {
Name = "Version".PropertyStyle(),
Type = "Int32",
TypeNamespace = "System",
IsValueType = true,
Value = Config.AddImplicitVersion.ToString()
});
}
if (props.Count > 0)
{
sb.AppendLine();
}
if (hasListBase)
{
var genericArg = baseClass.Substring(9, baseClass.Length - 10);
sb.AppendLine($"final List<{genericArg}> l = [];");
sb.AppendLine("void set length(int newLength) { l.length = newLength; }");
sb.AppendLine("int get length => l.length;");
sb.AppendLine($"{genericArg} operator [](int index) => l[index];");
sb.AppendLine($"void operator []=(int index, {genericArg} value) {{ l[index] = value; }}");
}
var sbBody = StringBuilderCacheAlt.Allocate();
if (props.Count > 0)
{
foreach (var prop in props)
{
if (sbBody.Length == 0)
{
sbBody.Append(typeNameWithoutGenericArgs + "({");
}
else
{
sbBody.Append(",");
}
sbBody.Append($"this.{prop.Name.PropertyStyle().PropertyName()}");
if (!string.IsNullOrEmpty(prop.Value))
{
sbBody.Append("=" + prop.Value);
}
}
if (sbBody.Length > 0)
{
sb.AppendLine(StringBuilderCacheAlt.ReturnAndFree(sbBody) + "});");
}
}
else
{
sb.AppendLine(typeNameWithoutGenericArgs + "();");
}
if (props.Count > 0)
{
sbBody = StringBuilderCacheAlt.Allocate();
sbBody.Append(typeNameWithoutGenericArgs + ".fromJson(Map<String, dynamic> json)");
sbBody.Append(" { fromMap(json); }");
sb.AppendLine(StringBuilderCacheAlt.ReturnAndFree(sbBody));
sb.AppendLine();
}
else
{
sb.AppendLine(typeNameWithoutGenericArgs + ".fromJson(Map<String, dynamic> json) : " +
(hasDtoBaseClass ? "super.fromJson(json);" : "super();"));
}
sbBody = StringBuilderCacheAlt.Allocate();
sbBody.AppendLine("fromMap(Map<String, dynamic> json) {");
if (hasDtoBaseClass)
{
sbBody.AppendLine(" super.fromMap(json);");
}
foreach (var prop in props)
{
var propType = DartPropertyType(prop);
var jsonName = prop.Name.PropertyStyle();
var propName = jsonName.PropertyName();
if (UseTypeConversion(prop))
{
bool registerType = true;
if (type.GenericArgs?.Length > 0 && prop.GenericArgs?.Length > 0)
{
var argIndexes = new List <int>();
foreach (var arg in prop.GenericArgs)
{
var argIndex = Array.IndexOf(type.GenericArgs, arg);
argIndexes.Add(argIndex);
}
if (argIndexes.All(x => x != -1))
{
propType = prop.Type.LeftPart('`') + "<${runtimeGenericTypeDefs(this,[" + argIndexes.Join(",") + "]).join(\",\")}>";
registerType = false;
}
}
if (registerType)
{
RegisterPropertyType(prop, propType);
}
sbBody.AppendLine($" {propName} = JsonConverters.fromJson(json['{jsonName}'],'{propType}',context);");
}
else
{
if (DartToJsonConverters.TryGetValue(propType, out var conversionFn))
{
sbBody.AppendLine($" {propName} = JsonConverters.{conversionFn}(json['{jsonName}']);");
}
else
{
sbBody.AppendLine($" {propName} = json['{jsonName}'];");
}
}
}
sbBody.AppendLine(" return this;");
sbBody.AppendLine(" }");
sb.AppendLine(StringBuilderCacheAlt.ReturnAndFree(sbBody));
sbBody = StringBuilderCacheAlt.Allocate();
if (props.Count > 0)
{
foreach (var prop in props)
{
if (sbBody.Length == 0)
{
sbBody.Append("Map<String, dynamic> toJson() => ");
if (hasDtoBaseClass)
{
sbBody.Append("super.toJson()..addAll(");
}
sbBody.AppendLine("{");
}
else
{
sbBody.AppendLine(",");
}
var propType = DartPropertyType(prop);
var jsonName = prop.Name.PropertyStyle();
var propName = jsonName.PropertyName();
if (UseTypeConversion(prop))
{
sbBody.Append($" '{jsonName}': JsonConverters.toJson({propName},'{propType}',context)");
}
else
{
sbBody.Append($" '{jsonName}': {propName}");
}
}
if (sbBody.Length > 0)
{
sb.AppendLine(StringBuilderCacheAlt.ReturnAndFree(sbBody));
sb.AppendLine(hasDtoBaseClass ? "});" : "};");
sb.AppendLine();
}
}
else
{
sb.AppendLine("Map<String, dynamic> toJson() => " +
(hasDtoBaseClass ? "super.toJson();" : "{};"));
}
if (responseTypeExpression != null)
{
sb.AppendLine(responseTypeExpression);
sb.AppendLine($"String getTypeName() {{ return \"{type.Name}\"; }}");
}
if (isClass)
{
sb.AppendLine("TypeContext context = _ctx;");
}
}
sb = sb.UnIndent();
sb.AppendLine("}");
}
PostTypeFilter?.Invoke(sb, type);
return(lastNS);
}
public override string ToInsertRowStatement(IDbCommand cmd, object objWithProperties, ICollection <string> insertFields = null)
{
if (insertFields == null)
{
insertFields = new List <string>();
}
var sbColumnNames = StringBuilderCache.Allocate();
var sbColumnValues = StringBuilderCacheAlt.Allocate();
var tableType = objWithProperties.GetType();
var modelDef = GetModel(tableType);
foreach (var fieldDef in modelDef.FieldDefinitionsArray)
{
if (fieldDef.IsComputed)
{
continue;
}
if (insertFields.Count > 0 && !insertFields.Contains(fieldDef.Name))
{
continue;
}
if ((fieldDef.AutoIncrement || !string.IsNullOrEmpty(fieldDef.Sequence) ||
fieldDef.Name == OrmLiteConfig.IdField) &&
cmd != null)
{
EnsureAutoIncrementSequence(modelDef, fieldDef);
var result = GetNextValue(cmd, fieldDef.Sequence, fieldDef.GetValue(objWithProperties));
var fieldValue = this.ConvertNumber(fieldDef.FieldType, result);
fieldDef.SetValueFn(objWithProperties, fieldValue);
}
if (sbColumnNames.Length > 0)
{
sbColumnNames.Append(",");
}
if (sbColumnValues.Length > 0)
{
sbColumnValues.Append(",");
}
try
{
sbColumnNames.Append(GetQuotedColumnName(fieldDef.FieldName));
sbColumnValues.Append(this.GetParam(SanitizeFieldNameForParamName(fieldDef.FieldName)));
var p = AddParameter(cmd, fieldDef);
p.Value = fieldDef.GetValue(objWithProperties) ?? DBNull.Value;
}
catch (Exception ex)
{
Log.Error("ERROR in ToInsertRowStatement(): " + ex.Message, ex);
throw;
}
}
var sql = string.Format("INSERT INTO {0} ({1}) VALUES ({2});",
GetQuotedTableName(modelDef),
StringBuilderCache.ReturnAndFree(sbColumnNames),
StringBuilderCacheAlt.ReturnAndFree(sbColumnValues));
return(sql);
}
public override string ToExistStatement(Type fromTableType, object objWithProperties, string sqlFilter, params object[] filterParams)
{
var fromModelDef = GetModel(fromTableType);
var sql = StringBuilderCache.Allocate();
sql.AppendFormat("SELECT 1 \nFROM {0}", this.GetQuotedTableName(fromModelDef));
var filter = StringBuilderCacheAlt.Allocate();
var hasFilter = false;
if (objWithProperties != null)
{
var tableType = objWithProperties.GetType();
if (fromTableType != tableType)
{
int i = 0;
var fpk = new List <FieldDefinition>();
var modelDef = GetModel(tableType);
foreach (var def in modelDef.FieldDefinitions)
{
if (def.IsPrimaryKey)
{
fpk.Add(def);
}
}
foreach (var fieldDef in fromModelDef.FieldDefinitions)
{
if (fieldDef.IsComputed || fieldDef.ForeignKey == null)
{
continue;
}
var model = GetModel(fieldDef.ForeignKey.ReferenceType);
if (model.ModelName != modelDef.ModelName)
{
continue;
}
if (filter.Length > 0)
{
filter.Append(" AND ");
}
filter.AppendFormat("{0} = {1}", GetQuotedColumnName(fieldDef.FieldName), fpk[i++].GetQuotedValue(objWithProperties));
}
}
else
{
var modelDef = GetModel(tableType);
foreach (var fieldDef in modelDef.FieldDefinitions)
{
if (fieldDef.IsComputed || !fieldDef.IsPrimaryKey)
{
continue;
}
if (filter.Length > 0)
{
filter.Append(" AND ");
}
filter.AppendFormat("{0} = {1}",
GetQuotedColumnName(fieldDef.FieldName), fieldDef.GetQuotedValue(objWithProperties));
}
}
hasFilter = filter.Length > 0;
if (hasFilter)
{
sql.AppendFormat("\nWHERE {0} ", StringBuilderCacheAlt.ReturnAndFree(filter));
}
}
if (!string.IsNullOrEmpty(sqlFilter))
{
sqlFilter = sqlFilter.SqlFmt(filterParams);
sql.Append(hasFilter ? " AND " : "\nWHERE ");
sql.Append(sqlFilter);
}
return(string.Format("SELECT EXISTS({0});", StringBuilderCache.ReturnAndFree(sql)));
}
public override string ToExistStatement(Type fromTableType,
object objWithProperties,
string sqlFilter,
params object[] filterParams)
{
var fromModelDef = GetModel(fromTableType);
var sql = StringBuilderCache.Allocate();
sql.AppendFormat("SELECT 1 \nFROM {0}", GetQuotedTableName(fromModelDef));
var filter = StringBuilderCacheAlt.Allocate();
var hasFilter = false;
if (objWithProperties != null)
{
var tableType = objWithProperties.GetType();
if (fromTableType != tableType)
{
int i = 0;
var fpk = new List <FieldDefinition>();
var modelDef = GetModel(tableType);
foreach (var def in modelDef.FieldDefinitions)
{
if (def.IsPrimaryKey)
{
fpk.Add(def);
}
}
foreach (var fieldDef in fromModelDef.FieldDefinitions)
{
if (fieldDef.IsComputed)
{
continue;
}
if (fieldDef.ForeignKey != null &&
GetModel(fieldDef.ForeignKey.ReferenceType).ModelName == modelDef.ModelName)
{
if (filter.Length > 0)
{
filter.Append(" AND ");
}
filter.AppendFormat("{0} = {1}", GetQuotedColumnName(fieldDef.FieldName),
fpk[i].GetQuotedValue(objWithProperties));
i++;
}
}
}
else
{
var modelDef = GetModel(tableType);
foreach (var fieldDef in modelDef.FieldDefinitions)
{
if (fieldDef.IsComputed)
{
continue;
}
if (fieldDef.IsPrimaryKey)
{
if (filter.Length > 0)
{
filter.Append(" AND ");
}
filter.AppendFormat("{0} = {1}",
GetQuotedColumnName(fieldDef.FieldName),
fieldDef.GetQuotedValue(objWithProperties));
}
}
}
hasFilter = filter.Length > 0;
if (hasFilter)
{
sql.AppendFormat("\nWHERE {0} ", StringBuilderCacheAlt.ReturnAndFree(filter));
}
}
if (!string.IsNullOrEmpty(sqlFilter))
{
sqlFilter = sqlFilter.SqlFmt(filterParams);
if (!sqlFilter.StartsWith("\nORDER ", StringComparison.OrdinalIgnoreCase) &&
!sqlFilter.StartsWith("\nROWS ", StringComparison.OrdinalIgnoreCase)) // ROWS <m> [TO <n>])
{
sql.Append(hasFilter ? " AND " : "\nWHERE ");
}
sql.Append(sqlFilter);
}
var sb = StringBuilderCacheAlt.Allocate()
.Append("select 1 from RDB$DATABASE where")
.AppendFormat(" exists ({0})", StringBuilderCache.ReturnAndFree(sql));
return(StringBuilderCacheAlt.ReturnAndFree(sb));
}
internal void Render(Markdown m, StringBuilder b)
{
switch (blockType)
{
case BlockType.Blank:
return;
case BlockType.p:
m.SpanFormatter.FormatParagraph(b, buf, contentStart, contentLen);
break;
case BlockType.span:
m.SpanFormatter.Format(b, buf, contentStart, contentLen);
b.Append("\n");
break;
case BlockType.h1:
case BlockType.h2:
case BlockType.h3:
case BlockType.h4:
case BlockType.h5:
case BlockType.h6:
if (m.ExtraMode && !m.SafeMode)
{
b.Append("<" + blockType.ToString());
string id = ResolveHeaderID(m);
if (!String.IsNullOrEmpty(id))
{
b.Append(" id=\"");
b.Append(id);
b.Append("\">");
}
else
{
b.Append(">");
}
}
else
{
b.Append("<" + blockType.ToString() + ">");
}
m.SpanFormatter.Format(b, buf, contentStart, contentLen);
b.Append("</" + blockType.ToString() + ">\n");
break;
case BlockType.hr:
b.Append("<hr />\n");
return;
case BlockType.user_break:
return;
case BlockType.ol_li:
case BlockType.ul_li:
b.Append("<li>");
m.SpanFormatter.Format(b, buf, contentStart, contentLen);
b.Append("</li>\n");
break;
case BlockType.dd:
b.Append("<dd>");
if (children != null)
{
b.Append("\n");
RenderChildren(m, b);
}
else
{
m.SpanFormatter.Format(b, buf, contentStart, contentLen);
}
b.Append("</dd>\n");
break;
case BlockType.dt:
{
if (children == null)
{
foreach (var l in Content.Split('\n'))
{
b.Append("<dt>");
m.SpanFormatter.Format(b, l.Trim());
b.Append("</dt>\n");
}
}
else
{
b.Append("<dt>\n");
RenderChildren(m, b);
b.Append("</dt>\n");
}
break;
}
case BlockType.dl:
b.Append("<dl>\n");
RenderChildren(m, b);
b.Append("</dl>\n");
return;
case BlockType.html:
b.Append(buf, contentStart, contentLen);
return;
case BlockType.unsafe_html:
m.HtmlEncode(b, buf, contentStart, contentLen);
return;
case BlockType.codeblock:
if (m.FormatCodeBlock != null)
{
var sb = StringBuilderCacheAlt.Allocate();
foreach (var line in children)
{
m.HtmlEncodeAndConvertTabsToSpaces(sb, line.buf, line.contentStart, line.contentLen);
sb.Append("\n");
}
b.Append(m.FormatCodeBlock(m, StringBuilderCacheAlt.ReturnAndFree(sb)));
}
else
{
b.Append("<pre><code>");
foreach (var line in children)
{
m.HtmlEncodeAndConvertTabsToSpaces(b, line.buf, line.contentStart, line.contentLen);
b.Append("\n");
}
b.Append("</code></pre>\n\n");
}
return;
case BlockType.quote:
b.Append("<blockquote>\n");
RenderChildren(m, b);
b.Append("</blockquote>\n");
return;
case BlockType.li:
b.Append("<li>\n");
RenderChildren(m, b);
b.Append("</li>\n");
return;
case BlockType.ol:
b.Append("<ol>\n");
RenderChildren(m, b);
b.Append("</ol>\n");
return;
case BlockType.ul:
b.Append("<ul>\n");
RenderChildren(m, b);
b.Append("</ul>\n");
return;
case BlockType.HtmlTag:
var tag = (HtmlTag)data;
// Prepare special tags
var name = tag.name.ToLowerInvariant();
if (name == "a")
{
m.OnPrepareLink(tag);
}
else if (name == "img")
{
m.OnPrepareImage(tag, m.RenderingTitledImage);
}
tag.RenderOpening(b);
b.Append("\n");
RenderChildren(m, b);
tag.RenderClosing(b);
b.Append("\n");
return;
case BlockType.Composite:
case BlockType.footnote:
RenderChildren(m, b);
return;
case BlockType.table_spec:
((TableSpec)data).Render(m, b);
break;
case BlockType.p_footnote:
b.Append("<p>");
if (contentLen > 0)
{
m.SpanFormatter.Format(b, buf, contentStart, contentLen);
b.Append(" ");
}
b.Append((string)data);
b.Append("</p>\n");
break;
default:
b.Append("<" + blockType.ToString() + ">");
m.SpanFormatter.Format(b, buf, contentStart, contentLen);
b.Append("</" + blockType.ToString() + ">\n");
break;
}
}