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);
}
