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(" = ''''"); } } }