public static void ToSql(NotExists expression, StringBuilder builder)
{
if (null == expression)
{
throw new ArgumentNullException("expression");
}
if (null == builder)
{
throw new ArgumentNullException("builder");
}
if (expression.Operands.Count > 0)
{
IToken operand = expression.Operands.First();
if (operand is ViewToken)
{
builder.Append(" not exists (");
ViewToken viewToken = operand as ViewToken;
View view = viewToken.ViewsManager.Views[viewToken.ViewName];
view.ToSql(builder, true);
builder.Append(")");
}
else
{
operand.ToSql(builder);
builder.Append(" IS NULL OR ");
operand.ToSql(builder);
builder.Append(" = ''''");
}
}
}
public static NotExists NotExists(this Where where, string values)
{
NotExists _notEists = new NotExists(values);
_notEists.SqlString = where.SqlString + _notEists.ToString();
return(_notEists);
}
public async Task should_delete_time_entry()
{
// GIVEN
await _sandbox.Scenario !.UserProfile.WithProfile();
var existingId = await _sandbox.Scenario.TimeEntry.With("2019/01/01", TimeEntryType.In);
_sandbox.ClearMediator();
var command = new DeleteTimeEntries(new[] { existingId });
// WHEN
await _sandbox.Mediator !.Send(command);
// THEN
_sandbox.Should !.Mediator !.Be("DeleteTimeEntry -> TimeEntryDeleted");
await _sandbox.Should !.Redis !.NotExists.Set("time-entry", existingId);
await _sandbox.Should !.Redis !.NotExists.SortedSet("time-entry", "by-when");
}
public static void ToSql(NotExists expression, StringBuilder builder)
{
if (null == expression) throw new ArgumentNullException("expression");
if (null == builder) throw new ArgumentNullException("builder");
if (expression.Operands.Count > 0)
{
IToken operand = expression.Operands.First();
if (operand is ViewToken)
{
builder.Append(" not exists (");
ViewToken viewToken = operand as ViewToken;
View view = viewToken.ViewsManager.Views[viewToken.ViewName];
view.ToSql(builder, true);
builder.Append(")");
}
else
{
operand.ToSql(builder);
builder.Append(" IS NULL OR ");
operand.ToSql(builder);
builder.Append(" = ''''");
}
}
}
