public void To_String()
{
IAlias person = sql.Alias("dbo.person");
IFrom from = sql.From(person);
Assert.Equal("FROM dbo.person", from.ToString());
}
public void To_String_Subquery()
{
IAlias person = sql.Alias("person");
IFrom from = sql.From(sql.RawQuery("Subquery"), person);
Assert.Equal("FROM (Subquery) AS person", from.ToString());
}
// twin method
internal static FromChainer From(this IFrom prev, IOpenView table, DbNode node)
{
var cfrom = new FromChainer((Chainer)prev, table);
cfrom.SetNode(node);
return(cfrom);
}
public void To_String_Typed_Alias()
{
IAlias <Person> person = sql.Alias <Person>();
IFrom from = sql.From(person);
Assert.Equal("FROM Person AS person", from.ToString());
}
public void To_String_Options()
{
IAlias person = sql.Alias("person");
IFrom from = sql.From(person).Options(sql.Raw("WITH (NO LOCK)"));
Assert.Equal("FROM person WITH (NO LOCK)", from.ToString());
}
public void WriteFragment_Parentheses()
{
IFrom from = sql.From("person");
string result = ToStringBuilder.Build(b => b.WriteFragment(from, true));
Assert.Equal("(FROM person)", result);
}
public void To_String_Typed_Alias_With_Alias_Name()
{
IAlias <Person2> person = sql.Alias <Person2>("per");
IFrom from = sql.From(person);
Assert.Equal("FROM Person2 AS per", from.ToString());
}
public void AliasOrTableName_Property_Alias_Name()
{
IAlias person = sql.Alias("dbo.person", "per");
IFrom from = sql.From(person);
Assert.Equal("per", from.AliasOrTableName);
}
public void WriteValue_Fragment()
{
IFrom from = sql.From("person");
string result = ToStringBuilder.Build(b => b.WriteValue(from));
Assert.Equal("FROM person", result);
}
public void To_String_With_Alias_Name()
{
IAlias person = sql.Alias("dbo.person", "per");
IFrom from = sql.From(person);
Assert.Equal("FROM dbo.person AS per", from.ToString());
}
public void From_Subquery_String()
{
IFrom from = sql.From(sql.RawQuery("Subquery"), "sub");
QueryResult result = engine.Compile(from);
Assert.Equal("FROM (Subquery) AS \"sub\"", result.Sql);
}
public void IfNotNull_Null_Value()
{
IFrom from = null;
string result = ToStringBuilder.Build(b => b
.IfNotNull(from, (x) => b.WriteFragment(x)));
Assert.Equal("", result);
}
public void IfNotNull_Delegate_Without_Value_Null_Value()
{
IFrom from = null;
string result = ToStringBuilder.Build(b => b
.IfNotNull(from, () => b.WriteFragment(from)));
Assert.Equal("", result);
}
public void IfNot_True()
{
IFrom from = sql.From("person");
string result = ToStringBuilder.Build(b => b
.IfNot(from == null, () => b.WriteFragment(from)));
Assert.Equal("FROM person", result);
}
public void IfNot_False()
{
IFrom from = null;
string result = ToStringBuilder.Build(b => b
.IfNot(from == null, () => b.WriteFragment(from)));
Assert.Equal("", result);
}
public void From_String()
{
IFrom from = sql.From("dbo.person");
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"dbo\".\"person\"", result.Sql);
}
public void IfNotNull()
{
IFrom from = sql.From("person");
string result = ToStringBuilder.Build(b => b
.IfNotNull(from, (x) => b.WriteFragment(x)));
Assert.Equal("FROM person", result);
}
public void From_String_With_Alias_Name()
{
IFrom from = sql.From("dbo.person", "per");
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"dbo\".\"person\" AS \"per\"", result.Sql);
}
public void IfNotNull_Delegate_Without_Value()
{
IFrom from = sql.From("person");
string result = ToStringBuilder.Build(b => b
.IfNotNull(from, () => b.WriteFragment(from)));
Assert.Equal("FROM person", result);
}
public void From_Typed_Alias()
{
IAlias <Person> person = sql.Alias <Person>();
IFrom from = sql.From(person);
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"Person\" AS \"person\"", result.Sql);
}
public void From_Subquery_Expression()
{
Person person = null;
IFrom from = sql.From(sql.RawQuery("Subquery"), () => person);
QueryResult result = engine.Compile(from);
Assert.Equal("FROM (Subquery) AS \"person\"", result.Sql);
}
public void From_Expression()
{
Person2 person = null;
IFrom from = sql.From(() => person);
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"dbo\".\"Person\" AS \"person\"", result.Sql);
}
public void From_Typed_Alias_With_Alias_Name()
{
IAlias <Person2> person = sql.Alias <Person2>("per");
IFrom from = sql.From(person);
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"dbo\".\"Person\" AS \"per\"", result.Sql);
}
public void From_Alias()
{
IAlias person = sql.Alias("dbo.person");
IFrom from = sql.From(person);
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"dbo\".\"person\"", result.Sql);
}
public void Options()
{
Person person = null;
IFrom from = sql.From(() => person).Options(sql.Raw("WITH (NO LOCK)"));
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"Person\" AS \"person\" WITH (NO LOCK)", result.Sql);
}
public void From_Alias_With_Alias_Name()
{
IAlias person = sql.Alias("person", "per");
IFrom from = sql.From(person);
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"person\" AS \"per\"", result.Sql);
}
public void From_Subquery_Alias()
{
IAlias person = sql.Alias("person");
IFrom from = sql.From(sql.RawQuery("Subquery"), person);
QueryResult result = engine.Compile(from);
Assert.Equal("FROM (Subquery) AS \"person\"", result.Sql);
}
public InnerJoin(IFrom thisEntity, Attribute thisJoinAttr, IFrom joinedEntity, Attribute joinedAttr,
string alias = null)
{
_thisEntity = thisEntity;
_thisJoinAttr = thisJoinAttr;
_joinedEntity = joinedEntity;
_joinedAttr = joinedAttr;
_alias = alias;
}
public void From_Cte_String()
{
IAlias person = sql.Alias("person");
ICte cte = sql.Cte("cte").As(sql.Query.Select(person.All).From(person));
IFrom from = sql.From(cte, "personCte");
QueryResult result = engine.Compile(from);
Assert.Equal("FROM \"cte\" AS \"personCte\"", result.Sql);
}
public SelectFrom <TSelectedColumns> From(IFrom from)
{
if (this.FromNode != null)
{
throw new ApplicationException();
}
QueryNodeHelper.SwitchParent(from, this);
this.FromNode = from;
return(this);
}
public TSelect(StringBuilder sb,IFrom tf,IWhere tw)
{
this.sql = sb;
this.tfrom = tf;
this.twhere = tw;
}
public TSelect()
{
sql = new StringBuilder();
twhere = new TWhere(sql);
tfrom = new TFrom(sql);
}
public TUpdate()
{
this.sql = new StringBuilder();
tfrom = new TFrom(sql);
this.twhere = new TWhere(sql);
}
public TUpdate(StringBuilder sb)
{
this.sql = sb;
tfrom = new TFrom(sql);
this.twhere = new TWhere(sql);
}
public TDelete()
{
sql = new StringBuilder();
tfrom = new TFrom(sql);
}
public TDelete(StringBuilder sb)
{
this.sql = sb;
tfrom = new TFrom(sql);
}
