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_Value_IntegerBehavior()
{
var parameter = new WorkUnitQueryParameter();
parameter.Value = 6900;
Assert.AreEqual("6900", parameter.Value);
parameter.Value = null;
Assert.IsNull(parameter.Value);
}
public void WorkUnitQueryParameter_Value_DateTimeBehavior()
{
var parameter = new WorkUnitQueryParameter();
parameter.Value = new DateTime(2000, 1, 1);
Assert.AreEqual(new DateTime(2000, 1, 1), parameter.Value);
parameter.Value = null;
Assert.IsNull(parameter.Value);
}
public void WorkUnitQueryParameter_Value_StringBehavior()
{
var parameter = new WorkUnitQueryParameter();
parameter.Value = "Value";
Assert.AreEqual("Value", parameter.Value);
parameter.Value = null;
Assert.IsNull(parameter.Value);
}
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);
}
public WorkUnitQuery AddParameter(WorkUnitQueryParameter parameter)
{
Parameters.Add(parameter);
return(this);
}