public async Task Does_populate_and_return_new_guid_on_insert_Async()
{
using var db = await OpenDbConnectionAsync();
db.DropAndCreateTable <GuidAutoId>();
var guidA = new GuidAutoId {
Name = "A"
};
var guidB = new GuidAutoId {
Name = "B"
};
await db.InsertAsync(guidA);
await db.InsertAsync(guidB);
Assert.That(guidA.Id, Is.Not.EqualTo(Guid.Empty));
Assert.That(guidB.Id, Is.Not.EqualTo(Guid.Empty));
Assert.That(guidA.Id, Is.Not.EqualTo(guidB));
var dbA = await db.SingleByIdAsync <GuidAutoId>(guidA.Id);
Assert.That(dbA.Name, Is.EqualTo(guidA.Name));
var dbB = await db.SingleByIdAsync <GuidAutoId>(guidB.Id);
Assert.That(dbB.Name, Is.EqualTo(guidB.Name));
}
public void Does_populate_and_return_new_guid_on_insert_ObjectDictionary()
{
using var db = OpenDbConnection();
db.DropAndCreateTable <GuidAutoId>();
var guidA = new GuidAutoId {
Name = "A"
}.ToObjectDictionary();
var guidB = new GuidAutoId {
Name = "B"
}.ToObjectDictionary();
db.Insert <GuidAutoId>(guidA);
db.Insert <GuidAutoId>(guidB, selectIdentity: true);
Assert.That(guidA[nameof(GuidAutoId.Id)], Is.Not.EqualTo(Guid.Empty));
Assert.That(guidB[nameof(GuidAutoId.Id)], Is.Not.EqualTo(Guid.Empty));
Assert.That(guidA[nameof(GuidAutoId.Id)], Is.Not.EqualTo(guidB));
var dbA = db.SingleById <GuidAutoId>(guidA[nameof(GuidAutoId.Id)]);
Assert.That(dbA.Name, Is.EqualTo(guidA[nameof(GuidAutoId.Name)]));
var dbB = db.SingleById <GuidAutoId>(guidB[nameof(GuidAutoId.Id)]);
Assert.That(dbB.Name, Is.EqualTo(guidB[nameof(GuidAutoId.Name)]));
}
public void Does_populate_and_return_new_guid_on_insert()
{
using var db = OpenDbConnection();
db.DropAndCreateTable <GuidAutoId>();
var guidA = new GuidAutoId {
Name = "A"
};
var guidB = new GuidAutoId {
Name = "B"
};
db.Insert(guidA);
db.Insert(guidB);
Assert.That(guidA.Id, Is.Not.EqualTo(Guid.Empty));
Assert.That(guidB.Id, Is.Not.EqualTo(Guid.Empty));
Assert.That(guidA.Id, Is.Not.EqualTo(guidB));
var dbA = db.SingleById <GuidAutoId>(guidA.Id);
Assert.That(dbA.Name, Is.EqualTo(guidA.Name));
var dbB = db.SingleById <GuidAutoId>(guidB.Id);
Assert.That(dbB.Name, Is.EqualTo(guidB.Name));
}
public async Task Does_populate_and_return_existing_guid_on_insert_ObjectDictionary_Async()
{
using var db = await OpenDbConnectionAsync();
db.DropAndCreateTable <GuidAutoId>();
var aGuid = Guid.NewGuid();
var bGuid = Guid.NewGuid();
var guidA = new GuidAutoId {
Id = aGuid, Name = "A"
}.ToObjectDictionary();
var guidB = new GuidAutoId {
Id = bGuid, Name = "B"
}.ToObjectDictionary();
await db.InsertAsync <GuidAutoId>(guidA);
await db.InsertAsync <GuidAutoId>(guidB, selectIdentity : true);
Assert.That(guidA[nameof(GuidAutoId.Id)], Is.EqualTo(aGuid));
Assert.That(guidB[nameof(GuidAutoId.Id)], Is.EqualTo(bGuid));
Assert.That(guidA[nameof(GuidAutoId.Id)], Is.Not.EqualTo(guidB));
var dbA = await db.SingleByIdAsync <GuidAutoId>(guidA[nameof(GuidAutoId.Id)]);
Assert.That(dbA.Name, Is.EqualTo(guidA[nameof(GuidAutoId.Name)]));
var dbB = await db.SingleByIdAsync <GuidAutoId>(guidB[nameof(GuidAutoId.Id)]);
Assert.That(dbB.Name, Is.EqualTo(guidB[nameof(GuidAutoId.Name)]));
}
public async Task Does_populate_and_return_new_guid_on_save_Async()
{
using (var db = OpenDbConnection())
{
db.DropAndCreateTable <GuidAutoId>();
var guidA = new GuidAutoId {
Name = "A"
};
var guidB = new GuidAutoId {
Name = "B"
};
await db.SaveAsync(guidA);
await db.SaveAsync(guidB);
Assert.That(guidA.Id, Is.Not.EqualTo(new Guid()));
Assert.That(guidB.Id, Is.Not.EqualTo(new Guid()));
Assert.That(guidA.Id, Is.Not.EqualTo(guidB));
var dbA = await db.SingleByIdAsync <GuidAutoId>(guidA.Id);
Assert.That(dbA.Name, Is.EqualTo(guidA.Name));
var dbB = await db.SingleByIdAsync <GuidAutoId>(guidB.Id);
Assert.That(dbB.Name, Is.EqualTo(guidB.Name));
}
}
public void Uses_existing_Guid_Id_if_not_Empty()
{
using var db = OpenDbConnection();
db.DropAndCreateTable <GuidAutoId>();
var existingGuid = Guid.NewGuid();
var guidA = new GuidAutoId {
Id = existingGuid, Name = "A"
};
db.Insert(guidA);
Assert.That(guidA.Id, Is.EqualTo(existingGuid));
var fromDb = db.SingleById <GuidAutoId>(existingGuid);
Assert.That(fromDb.Id, Is.EqualTo(existingGuid));
}
public void Uses_existing_Guid_Id_if_not_Empty_for_row_inserts()
{
using (var db = OpenDbConnection())
{
db.DropAndCreateTable<GuidAutoId>();
var existingGuid = Guid.NewGuid();
var guidA = new GuidAutoId { Id = existingGuid, Name = "A" };
db.Exec(cmd => {
cmd.CommandText = db.GetDialectProvider().ToInsertRowStatement(cmd, guidA);
db.GetDialectProvider().SetParameterValues<GuidAutoId>(cmd, guidA);
cmd.ExecuteNonQuery();
});
var fromDb = db.SingleById<GuidAutoId>(existingGuid);
Assert.That(fromDb.Id, Is.EqualTo(existingGuid));
}
}