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