public void CreateLastModifiedTriggerFor_GivenTableNameAndIdCol_ShouldProduceExpectedSql()
{
//---------------Set up test pack-------------------
var sut = new MigrationFoundation_EXPOSES_Innards();
var tableName = RandomValueGen.GetRandomAlphaString(5, 10);
var idCol = RandomValueGen.GetRandomAlphaString(5, 10);
var expected = @"create trigger [dbo].[trLastUpdated_" + tableName + @"]
on [dbo].[" + tableName + @"]
for update
as
begin
set NOCOUNT ON;
update [dbo].[" + tableName + @"] set LastModified = CURRENT_TIMESTAMP where [" + idCol + @"] in (select [" + idCol + @"] from inserted);
end".Replace("\r", "");
var expectedLines = expected.Split(new[] { "\r", "\n" }, StringSplitOptions.RemoveEmptyEntries);
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
var result = sut.BaseCreateLastModifiedTriggerFor(tableName, idCol);
//---------------Test Result -----------------------
var resultLines = result.Split(new[] { "\r", "\n" }, StringSplitOptions.RemoveEmptyEntries);
CollectionAssert.AreEqual(expectedLines, resultLines);
}
public void Text_ReturnsSingleTextNodeOfElement()
{
// test setup
var text = RandomValueGen.GetRandomString(10, 20);
var tag = RandomValueGen.GetRandomAlphaString(10, 20);
var el = new XElement(tag, new XText(text));
// pre-conditions
// execute test
var result = el.Text();
// test result
Assert.IsNotNull(result);
Assert.AreEqual(text, result);
}
static async Task Main(string[] args)
{
var config = new ConfigurationBuilder()
.AddJsonFile("appsettings.json")
.AddUserSecrets <Program>()
.Build()
.Get <AppSettings>();
var sampleInfo = ObjectInfoTableEntity.GenerateSample(config.Count, config.Revisions).ToList();
await TableStorageExample.Execute(config.StorageAccount, config.Name + RandomValueGen.GetRandomAlphaString(8), sampleInfo);
await BlobStorageExample.Execute(config.StorageAccount, config.Name + RandomValueGen.GetRandomAlphaString(8), sampleInfo);
Console.WriteLine("Done!");
}
public void GetPropertyValue_WhenPropertyDataExistsAndMisMatchesTypeAndCantConvert_ShouldReturnDefault()
{
//--------------- Arrange -------------------
var expected = default(int);
var data = new Dictionary <string, object>()
{
{ "Id", RandomValueGen.GetRandomAlphaString() }
};
var sut = Create(data, typeof(IHaveId));
//--------------- Assume ----------------
//--------------- Act ----------------------
var result = sut.GetPropertyValue("Id");
//--------------- Assert -----------------------
Expect(result).To.Equal(expected);
}
public void ShouldReturnSingleTextNodeOfElement()
{
// test setup
var text = RandomValueGen.GetRandomString(10, 20);
var tag = RandomValueGen.GetRandomAlphaString(10, 20);
var el = new XElement(tag, new XText(text));
// pre-conditions
// execute test
var result = el.Text();
// test result
Expect(result)
.Not.To.Be.Null();
Expect(result)
.To.Equal(text);
}
public void Construct_ShouldBeAbleToCreateDbByName()
{
//---------------Set up test pack-------------------
var dbName = RandomValueGen.GetRandomAlphaString(5, 10);
using (var db = new TempDBLocalDb(dbName, null))
{
//---------------Assert Precondition----------------
//---------------Execute Test ----------------------
//---------------Test Result -----------------------
Assert.IsTrue(File.Exists(db.DatabasePath));
using (var conn = new SqlConnection(db.ConnectionString))
{
Assert.DoesNotThrow(conn.Open);
}
}
}
public void ShouldReturnMultipleTextNodesSeparatedWithNewlines()
{
// test setup
var t1 = RandomValueGen.GetRandomAlphaString(10, 20);
var t2 = RandomValueGen.GetRandomAlphaString(10, 20);
var tag = RandomValueGen.GetRandomAlphaString(8, 20);
var el = new XElement(tag, new XText(t1), new XText(t2));
// pre-conditions
// execute test
var result = el.Text();
// test result
var parts = result.Split('\n');
Expect(parts)
.To.Equal(new[] { t1, t2 });
}
public void Text_ReturnsMultipleTextNodesSeparatedWithNewlines()
{
// test setup
var t1 = RandomValueGen.GetRandomAlphaString(10, 20);
var t2 = RandomValueGen.GetRandomAlphaString(10, 20);
var tag = RandomValueGen.GetRandomAlphaString(8, 20);
var el = new XElement(tag, new XText(t1), new XText(t2));
// pre-conditions
// execute test
var result = el.Text();
// test result
Debug.WriteLine(result);
var parts = result.Split('\n');
Assert.AreEqual(2, parts.Length);
Assert.AreEqual(t1, parts[0]);
Assert.AreEqual(t2, parts[1]);
}
