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