public void TemplateUpdate()
{
ITemplate t = TemplateLibrary.Update;
t.Append(SnippetLibrary.Table("users"),
SnippetLibrary.Sets("[a]=@a,[b]=@b,[c]=@c"),
SnippetLibrary.Where("age>=18"));
string sql = t.GetSql();
Assert.AreEqual(sql, "UPDATE [users] SET [a]=@a,[b]=@b,[c]=@c WHERE age>=18;");
}
public string GetSql()
{
Template result = TemplateLibrary.Update;
result.Append(SnippetLibrary.Table(this.TableName, this.Format, this.TableAlias));
result.Append(SnippetLibrary.Sets(this.Sets.GetSql(this.TableAlias)));
if (this.Where.Count > 0)
{
result.Append(SnippetLibrary.Where(this.Where.GetSql(this.TableAlias)));
}
return(result.GetSql(this.Format));
}
public string GetSql(bool EndOfStatement = true)
{
string table = Reflection.GetTableName <T>();
ITemplate result = TemplateLibrary.Update;
result.Append(SnippetLibrary.Table(table, this.TableAlias));
result.Append(SnippetLibrary.Sets(this.Sets.GetSql(this.TableAlias)));
if (this.Where.Count > 0)
{
result.Append(SnippetLibrary.Where(this.Where.GetSql(this.TableAlias)));
}
return(result.GetSql(EndOfStatement));
}
