public void MappingIgnoreColumn()
{
var db = new TestDb();
var m = db.GetMapping <TestObj> ();
Assert.AreEqual(2, m.Columns.Length);
}
public void InheritanceWorks()
{
var db = new TestDb();
var 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);
var mapping = db.GetMapping <NoAttributes>();
var column = mapping.Columns[2];
Assert.AreEqual("IndexedId", column.Name);
Assert.IsTrue(column.Indices.Any());
}
public void ImplicitAutoInc()
{
var db = new TestDb();
db.CreateTable <PkAttribute>(CreateFlags.AutoIncPK);
var 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 ImplicitPKAutoIncAsPassedInTypes()
{
var db = new TestDb();
db.CreateTable(typeof(NoAttributes), CreateFlags.ImplicitPK | CreateFlags.AutoIncPK);
var 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 HasGoodNames()
{
var db = new TestDb();
db.CreateTable <AFunnyTableName> ();
var 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 ImplicitPK()
{
var db = new TestDb();
db.CreateTable <NoAttributes>(CreateFlags.ImplicitPK);
var 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);
}
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 WithoutImplicitMapping()
{
var db = new TestDb();
db.CreateTable <NoAttributes>();
var mapping = db.GetMapping <NoAttributes>();
Assert.IsNull(mapping.PK);
var column = mapping.Columns[2];
Assert.AreEqual("IndexedId", column.Name);
Assert.IsFalse(column.Indices.Any());
CheckPK(db);
}
