Update test

sakapon · sakapon · commit c3fd455ead5d · 2018-04-07T11:52:59.000+09:00
diff --git a/RandomData2/UnitTest/Database/SqlServerTest.cs b/RandomData2/UnitTest/Database/SqlServerTest.cs
@@ -49,18 +49,18 @@ static void GetData()
         {
             using (var db = new RandomTestDb())
             {
-                var lower = new DateTime(2014, 4, 10, 14, 54, 59).ToSqlGuid2();
-                var upper = new DateTime(2014, 4, 10, 14, 55, 1).ToSqlGuid2();
+                var now = DateTime.UtcNow;
+                var lower = now.AddSeconds(-30).ToSqlGuid2();
+                var upper = now.ToSqlGuid2();
 
                 var products = db.Products
                     .Where(p => p.Id.CompareTo(lower) > 0)
                     .Where(p => p.Id.CompareTo(upper) < 0)
                     .ToArray();
 
-                foreach (var item in products)
-                {
-                    Console.WriteLine(item.Created);
-                }
+                Assert.AreEqual(20, products.Length);
+                foreach (var product in products)
+                    Console.WriteLine(product.Created.ToIso8601String());
             }
         }
     }

Original file line number	Diff line number	Diff line change
`@@ -49,18 +49,18 @@ static void GetData()`
`49`	`49`	`{`
`50`	`50`	`using (var db = new RandomTestDb())`
`51`	`51`	`{`
`52`		`- var lower = new DateTime(2014, 4, 10, 14, 54, 59).ToSqlGuid2();`
`53`		`- var upper = new DateTime(2014, 4, 10, 14, 55, 1).ToSqlGuid2();`
	`52`	`+ var now = DateTime.UtcNow;`
	`53`	`+ var lower = now.AddSeconds(-30).ToSqlGuid2();`
	`54`	`+ var upper = now.ToSqlGuid2();`
`54`	`55`
`55`	`56`	`var products = db.Products`
`56`	`57`	`.Where(p => p.Id.CompareTo(lower) > 0)`
`57`	`58`	`.Where(p => p.Id.CompareTo(upper) < 0)`
`58`	`59`	`.ToArray();`
`59`	`60`
`60`		`- foreach (var item in products)`
`61`		`- {`
`62`		`- Console.WriteLine(item.Created);`
`63`		`- }`
	`61`	`+ Assert.AreEqual(20, products.Length);`
	`62`	`+ foreach (var product in products)`
	`63`	`+ Console.WriteLine(product.Created.ToIso8601String());`
`64`	`64`	`}`
`65`	`65`	`}`
`66`	`66`	`}`