public static void ToParameter(this ISqlDefinitionBuilder self,
string parameterName, object value,
string dbType = null, byte?precision = null,
byte?scale = null, int?size = null, bool?isNullable = null)
{
Throws.NotEmpty(parameterName, nameof(parameterName));
self.Text.ReplacePrev(val =>
{
var target = val.TrimEnd();
var parameterText = string.Format(self.Options.ParameterFormat, parameterName);
if (target.EndsWith("'", StringComparison.InvariantCulture))
{
target = Regex.Replace(target, "\'(\'{2}|[^\'])+?\'$", parameterText);
}
else
{
target = Regex.Replace(target, "((?<=[\\s\\=\\<\\>\\(\\,])|^)[^\\s\\=\\<\\>\\(\\,]+$", parameterText);
}
if (string.IsNullOrEmpty(dbType) && value != null)
{
var map = DbTypeNameMap.Default();
var valueType = value.GetType();
if (map.ContainsKey(valueType))
{
dbType = map[valueType];
}
}
self.Parameter.Add(new ParameterDefinition(parameterName, value)
{
DbType = dbType, Precision = precision, Scale = scale, Size = size, IsNullable = isNullable
});
return(target);
});
}
public static void ToInParameter <T>(this ISqlDefinitionBuilder self,
string parameterPrefix, IEnumerable <T> values,
string dbType = null, byte?precision = null,
byte?scale = null, int?size = null, bool?isNullable = null)
{
Throws.NotEmpty(parameterPrefix, nameof(parameterPrefix));
if (values == null || !values.Any())
{
throw new ArgumentNullException(nameof(values));
}
if (string.IsNullOrEmpty(dbType))
{
var map = DbTypeNameMap.Default();
var valueType = typeof(T);
if (map.ContainsKey(valueType))
{
dbType = map[valueType];
}
}
var paramDefinitions = values.Select((v, i) =>
{
var parameterName = $"{parameterPrefix}{i}";
return(new ParameterDefinition(parameterName, v)
{
DbType = dbType,
Precision = precision,
Scale = scale,
Size = size,
IsNullable = isNullable
});
});
self.Text.ReplacePrev(v =>
{
return($"{v.Substring(0, v.LastIndexOf("(", StringComparison.InvariantCulture))}( {paramDefinitions.Select(p => string.Format(self.Options.ParameterFormat, p.Name)).ConcatWith(", ")}");
});
foreach (var p in paramDefinitions)
{
self.Parameter.Add(p);
}
}
public async Task <SqlDefinition> ExecuteAsync(string sqlTemplate, object model, TemplateOptions options)
{
Throws.NotEmpty(sqlTemplate, nameof(sqlTemplate));
Throws.NotNull(model, nameof(model));
if (options == null)
{
options = TemplateOptions.Default;
}
var modelType = model.GetType();
ValidateModel(modelType, model);
var globalsType = typeof(Globals <>).MakeGenericType(modelType);
var runner = pool.GetOrAdd(Tuple.Create(sqlTemplate, modelType), v =>
{
var parser = new CSharpScriptCodeParser(sqlTemplate);
var parseResult = parser.Parse();
var scriptOptions = ScriptOptions.Default.AddReferences(
typeof(SqlTemplateEngine).GetTypeInfo().Assembly,
modelType.GetTypeInfo().Assembly
).AddImports("Km.Toi.Template", "System", "System.Linq")
.AddImports(parseResult.Imports);
return(CSharpScript.Create(parseResult.Code, scriptOptions, globalsType).CreateDelegate());
});
var builder = new SqlDefinitionBuilder(options);
var global = Activator.CreateInstance(globalsType, model, builder) as IGlobals;
await runner(global);
return(builder.Build());
}
public BaseCSharpParser(string templateCode)
{
Throws.NotEmpty(templateCode, nameof(templateCode));
this.TemplateCode = templateCode;
}
