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)); }