public void WorkUnitQueryParameter_Operator_UnknownOperatorsThrowExceptionOnStringValue()
{
var parameter = new WorkUnitQueryParameter {
Operator = (WorkUnitQueryOperator)Int32.MaxValue
};
Assert.Throws <InvalidOperationException>(() => parameter.GetOperatorString());
}
public void WorkUnitQueryParameter_DefaultConstructor_HasPropertyValues()
{
var parameter = new WorkUnitQueryParameter();
Assert.AreEqual(WorkUnitRowColumn.ProjectID, parameter.Column);
Assert.AreEqual(WorkUnitQueryOperator.Equal, parameter.Operator);
Assert.AreEqual("=", parameter.GetOperatorString());
}
public void WorkUnitQueryParameter_Operator_OperatorsHaveStringValue()
{
var parameter = new WorkUnitQueryParameter();
foreach (WorkUnitQueryOperator op in Enum.GetValues(typeof(WorkUnitQueryOperator)))
{
parameter.Operator = op;
Console.WriteLine(parameter.GetOperatorString());
}
}
private static PetaPoco.Sql BuildWhereCondition(PetaPoco.Sql sql, WorkUnitQueryParameter parameter)
{
string format = "[{0}] {1} @0";
if (parameter.Column.Equals(WorkUnitRowColumn.Assigned) ||
parameter.Column.Equals(WorkUnitRowColumn.Finished))
{
format = "datetime([{0}]) {1} datetime(@0)";
}
sql = sql.Append(String.Format(CultureInfo.InvariantCulture, format,
ColumnNameOverrides.ContainsKey(parameter.Column) ? ColumnNameOverrides[parameter.Column] : parameter.Column.ToString(),
parameter.GetOperatorString()), parameter.Value);
return(sql);
}
