public void LoadFileRepository() { dynamic queries = new FileRepository(@"TestData\*.sql"); string selectQuery = queries.Select; TestDataUtility.AreEqual(selectQuery, ".sql", "select"); }
public void GetDbCommandText() { var dbConnection = new DbConnectionMock(); dynamic queries = new DbCommandRepository(dbConnection, "TestData"); string commandText = queries.Select; // Behavior inherited from FileRepository TestDataUtility.AreEqual(commandText, ".sql", "select"); }
public void GetDbCommand() { var dbConnection = new DbConnectionMock(); dynamic queries = new DbCommandRepository(dbConnection, "TestData"); IDbCommand command = queries.Select(); TestDataUtility.AreEqual(command.CommandText, ".sql", "select"); Assert.IsInstanceOfType(command, typeof(DbCommandMock)); var commandMock = (DbCommandMock)command; Assert.AreEqual(0, commandMock.ParameterMocks.Count); }
public virtual void CanWriteBatchedTasks() { var service = CreateService(); var name = "CanWriteBatchedTasks"; var batchSize = 100; var numberOfIds = 1005; var ids = TestDataUtility.GenerateRandomStringList(numberOfIds, 20); var taskCount = service.WriteTasks(name, batchSize, ids); var expectedCount = (numberOfIds / batchSize) + (numberOfIds % batchSize > 0 ? 1 : 0); taskCount.Should().Be(expectedCount); Clear(name); }
public void GenerateSimpleText() { var generator = new MarkdownGenerator(); string text = generator .Heading1("Heading 1") .Text("This is a demo of text in ").Bold("bold").Text(", ").Italic("italic").LineEnd() .Text("and ").Code("mono-spaced").ParagraphEnd() .Heading2("Subheading: lists") .Paragraph("First a numbered list:") .Numbered("Some text", "other text", 42).Numbered("A new numbered list") .Paragraph("Then a bullet list:") .Bullet(1, "another bullet") .ToString(); TestDataUtility.AreEqual(text, ".md"); }
public virtual void CanDeleteAllTasks() { var service = CreateService(); var name = "CanDeleteAllTasks"; var batchSize = 100; var numberOfIds = 1005; var ids = TestDataUtility.GenerateRandomStringList(numberOfIds, 20); var taskCount = service.WriteTasks(name, batchSize, ids); var expectedCount = (numberOfIds / batchSize) + (numberOfIds % batchSize > 0 ? 1 : 0); taskCount.Should().Be(expectedCount); service.DeleteAllTasks(name); var shouldBeNull = service.GetNextTask(name); shouldBeNull.Should().BeNull("All tasks should've been deleted"); Clear(name); }
public void GetDbCommandWithParameters() { var dbConnection = new DbConnectionMock(); dynamic queries = new DbCommandRepository(dbConnection, "TestData"); IDbCommand command = queries.Select("Param1", 123); TestDataUtility.AreEqual(command.CommandText, ".sql", "select"); Assert.IsInstanceOfType(command, typeof(DbCommandMock)); var commandMock = (DbCommandMock)command; Assert.AreEqual(2, commandMock.ParameterMocks.Count); Assert.AreEqual("0", commandMock.ParameterMocks[0].ParameterName); Assert.AreEqual("Param1", commandMock.ParameterMocks[0].Value); Assert.AreEqual("1", commandMock.ParameterMocks[1].ParameterName); Assert.AreEqual(123, commandMock.ParameterMocks[1].Value); }
public virtual void CanWriteNonBatchedTasks() { var service = CreateService(); var name = "CanWriteNonBatchedTasks"; var numberOfIds = 110; var ids = TestDataUtility.GenerateRandomStringList(numberOfIds, 20); var shouldBeNull = service.GetNextTask(name); shouldBeNull.Should().BeNull("No tasks should exist yet"); service.WriteTasks(name, ids); var task = service.GetNextTask(name); task.Should().NotBeNull("One task should exist"); task.GroupName.Should().Be(name); task.Instructions.Should().BeEquivalentTo(ids); shouldBeNull = service.GetNextTask(name); shouldBeNull.Should().BeNull("No more tasks should exist"); Clear(name); }
public virtual void CanGetNextTask() { var service = CreateService(); var name = "CanGetNextTask"; var batchSize = 100; var numberOfIds = 200; var ids = TestDataUtility.GenerateRandomStringList(numberOfIds, 20); var taskCount = service.WriteTasks(name, batchSize, ids); taskCount.Should().Be(2); var firstTask = service.GetNextTask(name); var secondTask = service.GetNextTask(name); var thirdTask = service.GetNextTask(name); firstTask.Should().NotBeNull(); secondTask.Should().NotBeNull(); thirdTask.Should().BeNull(); firstTask.Instructions.Should().HaveCount(batchSize); secondTask.Instructions.Should().HaveCount(batchSize); Clear(name); }