public LiteJoinTable(LiteQuery query, string _tableName, string _tableAlias, JoinTypeEnum joinType, LiteFilter _filter)
{
this.joinTables = new List <LiteJoinTable>();
this.query = query;
this.tableName = _tableName;
this.tableAlias = _tableAlias;
this.filter = _filter;
}
public static LiteFilter FieldIn(FilterField field, LiteQuery subQuery)
{
LiteVariable leftVar = LiteVariable.FromField(field);
return(new LiteFilter(leftVar, CompareTypeEnum.IN, LiteVariable.FromSubQuery(subQuery)));
}
public LiteJoinTable(LiteQuery query, string _tableName, string _tableAlias, JoinTypeEnum joinType) : this(query, _tableName, _tableAlias, joinType, null)
{
}
public static LiteField NewSubQueryField(LiteQuery subQuery, string fieldAlias)
{
return(new LiteField {
FieldType = LiteFieldTypeEnum.SubQuery, FieldAlias = fieldAlias, SubQuery = subQuery
});
}
public LiteFilter IN(LiteQuery subQuery)
{
return(LiteFilter.FieldIn(this, subQuery));
}
public static LiteVariable FromSubQuery(LiteQuery subQuery)
{
return(new LiteVariable {
VariableType = VariableTypeEnum.SubQuery, SubQuery = subQuery
});
}
private LiteVariable(LiteQuery subQuery)
{
this.VariableType = VariableTypeEnum.SubQuery;
this.SubQuery = subQuery;
}
public void AddField(LiteQuery subQuery, string fieldAlias)
{
this.SelectFields.Add(LiteField.NewSubQueryField(subQuery, fieldAlias));
}
