public void DateTimeNullable() { // Need a rounded date as DB can't store millis var now = DateTime.UtcNow; now = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); // Setup a record var a = new deco(); a.title = string.Format("insert {0}", r.Next()); a.draft = true; a.content = string.Format("insert {0}", r.Next()); a.date_created = now; a.date_edited = null; db.Insert(a); // Retrieve it var b = db.SingleOrDefault<deco>("WHERE id=@0", a.id); Expect(b.id, Is.EqualTo(a.id)); Expect(b.date_edited.HasValue, Is.EqualTo(false)); // Update it to NULL b.date_edited = now; db.Update(b); var c = db.SingleOrDefault<deco>("WHERE id=@0", a.id); Expect(c.id, Is.EqualTo(a.id)); Expect(c.date_edited.HasValue, Is.EqualTo(true)); // Update it to not NULL c.date_edited = null; db.Update(c); var d = db.SingleOrDefault<deco>("WHERE id=@0", a.id); Expect(d.id, Is.EqualTo(a.id)); Expect(d.date_edited.HasValue, Is.EqualTo(false)); }
deco CreateDeco() { // Need a rounded date as DB can't store millis var now = DateTime.UtcNow; now = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); // Setup a record var o = new deco(); o.title = string.Format("insert {0}", r.Next()); o.draft = true; o.content = string.Format("insert {0}", r.Next()); o.date_created = now; o.date_edited = now; o.state = State.Maybe; o.col_w_space = 23; o.nullreal = 24; return o; }
deco CreateDeco() { // Need a rounded date as DB can't store millis var now = DateTime.UtcNow; now = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); // Setup a record var o = new deco(); o.title = string.Format("insert {0}", r.Next()); o.draft = true; o.content = string.Format("insert {0}", r.Next()); o.date_created = now; o.date_edited = now; o.state = State.Maybe; o.col_w_space = 23; o.nullreal = 24; return(o); }
public void DateTimeNullable() { // Need a rounded date as DB can't store millis var now = DateTime.UtcNow; now = new DateTime(now.Year, now.Month, now.Day, now.Hour, now.Minute, now.Second); // Setup a record var a = new deco(); a.title = string.Format("insert {0}", r.Next()); a.draft = true; a.content = string.Format("insert {0}", r.Next()); a.date_created = now; a.date_edited = null; db.Insert(a); // Retrieve it var b = db.SingleOrDefault <deco>("WHERE id=@0", a.id); Expect(b.id, Is.EqualTo(a.id)); Expect(b.date_edited.HasValue, Is.EqualTo(false)); // Update it to NULL b.date_edited = now; db.Update(b); var c = db.SingleOrDefault <deco>("WHERE id=@0", a.id); Expect(c.id, Is.EqualTo(a.id)); Expect(c.date_edited.HasValue, Is.EqualTo(true)); // Update it to not NULL c.date_edited = null; db.Update(c); var d = db.SingleOrDefault <deco>("WHERE id=@0", a.id); Expect(d.id, Is.EqualTo(a.id)); Expect(d.date_edited.HasValue, Is.EqualTo(false)); }
void AssertPocos(deco a, deco b) { Assert.AreEqual(a.id, b.id); Assert.AreEqual(a.title, b.title); Assert.AreEqual(a.draft, b.draft); Assert.AreEqual(a.content, b.content); Assert.AreEqual(a.date_created, b.date_created); Assert.AreEqual(a.state, b.state); Assert.AreEqual(a.col_w_space, b.col_w_space); Assert.AreEqual(a.nullreal, b.nullreal); }
void Assert(deco a, deco b) { Expect(a.id, Is.EqualTo(b.id)); Expect(a.title, Is.EqualTo(b.title)); Expect(a.draft, Is.EqualTo(b.draft)); Expect(a.content, Is.EqualTo(b.content)); Expect(a.date_created, Is.EqualTo(b.date_created)); Expect(a.state, Is.EqualTo(b.state)); Expect(a.col_w_space, Is.EqualTo(b.col_w_space)); Expect(a.nullreal, Is.EqualTo(b.nullreal)); }