public EntityCommandBuilder(EntityDescription entDesc)
{
EntityDescription = entDesc;
if (EntityDescription.Source != null)
{
_selectCommand = MakeSelectCommand();
//InitializeLegacySelectCommand();
}
}
public void NestedSourcesTest()
{
var provider = new SQLite.SQLiteProviderFactory();
SQLSelectBuilder builder = new SQLSelectBuilder();
builder.Source = new TableOrSubQuery("something", "t1");
builder.ResultColumns.Add("col1");
VerifyCommandSyntex(provider, builder.ToSQL());
var builder2 = new SQLSelectBuilder();
builder2.Source = new TableOrSubQuery(builder, "t2");
builder2.ResultColumns.Add("col2");
VerifyCommandSyntex(provider, builder2.ToSQL());
}
public void FluentInterfaceTest()
{
base.StartTimer();
SQLSelectBuilder builder = new SQLSelectBuilder();
builder.Source = new TableOrSubQuery("something", "t1");
builder.ResultColumns.Add("col1");
builder.Join("something2", "Using (FKey)", null)
.Join("something3", "Using (FKey2)", null)
.Where("x > 1")
.GroupBy("col1", "col2")
.Limit(1, 0);
var sql = builder.ToSQL();
Assert.Contains("Join", sql, StringComparison.InvariantCultureIgnoreCase);
Assert.Contains("Where", sql, StringComparison.InvariantCultureIgnoreCase);
Assert.Contains("Group By", sql, StringComparison.InvariantCultureIgnoreCase);
Assert.Contains("Limit", sql, StringComparison.InvariantCultureIgnoreCase);
base.EndTimer();
var provider = new SQLite.SQLiteProviderFactory();
VerifyCommandSyntex(provider, builder.ToSQL());
}
public TableOrSubQuery(SQLSelectBuilder subQuery, string alias)
: this()
{
this.SubQuery = subQuery;
this.Alias = alias;
}
public SQLSelectBuilder MakeSelectCommand()
{
var selectBuilder = new SQLSelectBuilder();
selectBuilder.Source = EntityDescription.Source;
//order fields by ordinal
var fields = new List<FieldAttribute>(EntityDescription.Fields);
fields.Sort(CompareFieldsByOrdinal);
foreach(FieldAttribute field in fields)
{
selectBuilder.ResultColumns.Add(field.GetResultColumnExpression());
}
return selectBuilder;
}
