public void InheritanceWorks() { var db = new TestDb(); TableMapping mapping = db.GetMapping <Derived>(); Assert.AreEqual(3, mapping.Columns.Length); Assert.AreEqual("Id", mapping.PK.Name); }
public void ImplicitIndex() { var db = new TestDb(); db.CreateTable <NoAttributes>(CreateFlags.ImplicitIndex); TableMapping mapping = db.GetMapping <NoAttributes>(); TableMapping.Column column = mapping.Columns[2]; Assert.AreEqual("IndexedId", column.Name); Assert.IsTrue(column.Indices.Any()); }
public void HasGoodNames() { var db = new TestDb(); db.CreateTable <AFunnyTableName>(); TableMapping mapping = db.GetMapping <AFunnyTableName>(); Assert.AreEqual("AGoodTableName", mapping.TableName); Assert.AreEqual("Id", mapping.Columns[0].Name); Assert.AreEqual("AGoodColumnName", mapping.Columns[1].Name); }
public void ImplicitAutoIncAsPassedInTypes() { var db = new TestDb(); db.CreateTable(typeof(PkAttribute), CreateFlags.AutoIncPK); TableMapping mapping = db.GetMapping <PkAttribute>(); Assert.IsNotNull(mapping.PK); Assert.AreEqual("Id", mapping.PK.Name); Assert.IsTrue(mapping.PK.IsPK); Assert.IsTrue(mapping.PK.IsAutoInc); }
public void ImplicitPKAutoInc() { var db = new TestDb(); db.CreateTable(typeof(NoAttributes), CreateFlags.ImplicitPK | CreateFlags.AutoIncPK); TableMapping mapping = db.GetMapping <NoAttributes>(); Assert.IsNotNull(mapping.PK); Assert.AreEqual("Id", mapping.PK.Name); Assert.IsTrue(mapping.PK.IsPK); Assert.IsTrue(mapping.PK.IsAutoInc); }
public void ImplicitPK() { var db = new TestDb(); db.CreateTable <NoAttributes>(CreateFlags.ImplicitPK); TableMapping mapping = db.GetMapping <NoAttributes>(); Assert.IsNotNull(mapping.PK); Assert.AreEqual("Id", mapping.PK.Name); Assert.IsTrue(mapping.PK.IsPK); Assert.IsFalse(mapping.PK.IsAutoInc); CheckPK(db); }
public void WithoutImplicitMapping() { var db = new TestDb(); db.CreateTable <NoAttributes>(); TableMapping mapping = db.GetMapping <NoAttributes>(); Assert.IsNull(mapping.PK); TableMapping.Column column = mapping.Columns[2]; Assert.AreEqual("IndexedId", column.Name); Assert.IsFalse(column.Indices.Any()); Assert.Throws(typeof(AssertionException), () => CheckPK(db)); }
private static void VerifyCreations(TestDb db) { var orderLine = db.GetMapping(typeof(OrderLine)); Assert.AreEqual(6, orderLine.Columns.Length); var l = new OrderLine { Status = OrderLineStatus.Shipped }; db.Insert(l); var lo = db.Table <OrderLine>().First(x => x.Status == OrderLineStatus.Shipped); Assert.AreEqual(lo.Id, l.Id); }
public void TestColumnValues() { using (TestDb db = new TestDb()) { db.CreateTable <WithDefaultValue>(); string failed = string.Empty; foreach (var col in db.GetMapping <WithDefaultValue>().Columns) { if (col.PropertyName == "TestInt" && !col.DefaultValue.Equals(WithDefaultValue.IntVal)) { failed += " , TestInt does not equal " + WithDefaultValue.IntVal; } if (col.PropertyName == "TestDecimal" && !col.DefaultValue.Equals(WithDefaultValue.DecimalVal)) { failed += "TestDecimal does not equal " + WithDefaultValue.DecimalVal; } if (col.PropertyName == "TestDateTime" && !col.DefaultValue.Equals(WithDefaultValue.DateTimegVal)) { failed += "TestDateTime does not equal " + WithDefaultValue.DateTimegVal; } if (col.PropertyName == "TestString" && !col.DefaultValue.Equals(WithDefaultValue.StringVal)) { failed += "TestString does not equal " + WithDefaultValue.StringVal; } if (col.PropertyName == "DefaultValueInAttributeTestInt" && !col.DefaultValue.Equals(WithDefaultValue.IntVal)) { failed += " , DefaultValueInAttributeTestInt does not equal " + WithDefaultValue.IntVal; } if (col.PropertyName == "TestIntWithSubtypeOfDefault" && !col.DefaultValue.Equals(WithDefaultValue.IntVal)) { failed += " , TestIntWithSubtypeOfDefault does not equal " + WithDefaultValue.IntVal; } } Assert.True(string.IsNullOrWhiteSpace(failed), failed); } }