public void Store()
{
IBeanFactory factory = new BeanFactory();
factory.Options.ValidateGetColumns = false;
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil(), factory);
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense <Tracer>();
// ----- Insert
var id = crud.Store(bean);
Assert.Equal(0L, id);
Assert.Equal(0L, bean["id"]);
Assert.Equal($"ad: bs: bi: ai:{id} as:{id}", bean.TraceLog);
Assert.Equal($"ad: bs: bi: ai:{id} as:{id}", observer.TraceLog);
// ------ Update
bean.Put("p1", "test");
observer.TraceLog = "";
bean.TraceLog = "";
crud.Store(bean);
Assert.Equal(0L, bean["id"]);
Assert.Equal($"bs:{id} bu:{id} au:{id} as:{id}", bean.TraceLog);
Assert.Equal($"bs:{id} bu:{id} au:{id} as:{id}", observer.TraceLog);
}
public void ImplicitTransactionsOnStoreAndTrash()
{
using (var conn = SQLitePortability.CreateConnection()) {
conn.Open();
IDatabaseDetails details = new SQLiteDetails();
IDatabaseAccess db = new DatabaseAccess(conn, details);
IKeyAccess keys = new KeyUtil();
DatabaseStorage storage = new DatabaseStorage(details, db, keys);
IBeanFactory factory = new BeanFactory();
IBeanCrud crud = new BeanCrud(storage, db, keys, factory);
storage.EnterFluidMode();
var bean = crud.Dispense <ThrowingBean>();
bean["foo"] = "ok";
var id = crud.Store(bean);
bean.Throw = true;
bean["foo"] = "fail";
try { crud.Store(bean); } catch { }
Assert.Equal("ok", db.Cell <string>(true, "select foo from test where id = {0}", id));
try { crud.Trash(bean); } catch { }
Assert.True(db.Cell <int>(true, "select count(*) from test") > 0);
}
}
public void ImplicitTransactionsOnStoreAndTrash()
{
using(var conn = SQLitePortability.CreateConnection()) {
conn.Open();
IDatabaseDetails details = new SQLiteDetails();
IDatabaseAccess db = new DatabaseAccess(conn, details);
IKeyAccess keys = new KeyUtil();
DatabaseStorage storage = new DatabaseStorage(details, db, keys);
IBeanCrud crud = new BeanCrud(storage, db, keys);
storage.EnterFluidMode();
var bean = crud.Dispense<ThrowingBean>();
bean["foo"] = "ok";
var id = crud.Store(bean);
bean.Throw = true;
bean["foo"] = "fail";
try { crud.Store(bean); } catch { }
Assert.Equal("ok", db.Cell<string>(true, "select foo from test where id = {0}", id));
try { crud.Trash(bean); } catch { }
Assert.True(db.Cell<int>(true, "select count(*) from test") > 0);
}
}
public void Load()
{
IBeanFactory factory = new BeanFactory();
factory.Options.ValidateGetColumns = false;
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil(), factory);
var observer = new TracingObserver();
crud.AddObserver(observer);
// Load non-existing bean
Assert.Null(crud.Load("any", 123));
Assert.Empty(observer.TraceLog);
var bean = crud.Dispense <Tracer>();
bean.Put("p1", "test");
var id = crud.Store(bean);
observer.TraceLog = "";
bean = crud.Load <Tracer>(id);
Assert.Equal("ad: bl: al:" + id, bean.TraceLog);
Assert.Equal("ad: bl: al:" + id, observer.TraceLog);
Assert.NotNull(bean["id"]);
Assert.Equal(id, bean["id"]);
Assert.Equal("test", bean["p1"]);
}
public void Dispense_Default()
{
var crud = new BeanCrud(null, null, null);
var bean = crud.Dispense("test");
Assert.Equal("test", bean.GetKind());
Assert.Equal(typeof(Bean), bean.GetType());
}
public void Trash()
{
IBeanFactory factory = new BeanFactory();
factory.Options.ValidateGetColumns = false;
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil(), factory);
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense <Tracer>();
observer.TraceLog = bean.TraceLog = "";
crud.Trash(bean);
Assert.Empty(bean.TraceLog);
Assert.Empty(observer.TraceLog);
var id = crud.Store(bean);
observer.TraceLog = bean.TraceLog = "";
crud.Trash(bean);
Assert.Equal("bt:" + id + " at:" + id, bean.TraceLog);
Assert.Equal("bt:" + id + " at:" + id, observer.TraceLog);
Assert.Equal(id, bean["id"]);
Assert.Null(crud.Load <Tracer>(id));
}
public void Dispense_Default()
{
var crud = new BeanCrud(null, null, null);
var bean = crud.Dispense("test");
Assert.Equal("test", bean.GetKind());
Assert.Equal(typeof(Bean), bean.GetType());
}
public void Dispense_Hooks()
{
var crud = new BeanCrud(null, null, null);
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense<Tracer>();
Assert.Equal("tracer", bean.GetKind());
Assert.Equal("ad:", bean.TraceLog);
Assert.Equal("ad:", observer.TraceLog);
Assert.Same(bean, observer.LastBean);
}
public void Dispense_Hooks()
{
var crud = new BeanCrud(null, null, null);
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense <Tracer>();
Assert.Equal("tracer", bean.GetKind());
Assert.Equal("ad:", bean.TraceLog);
Assert.Equal("ad:", observer.TraceLog);
Assert.Same(bean, observer.LastBean);
}
public void Store()
{
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil());
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense <Tracer>();
var id = crud.Store(bean);
Assert.Equal(0L, id);
Assert.Equal(0L, bean["id"]);
Assert.Equal("ad: bs: as:" + id, bean.TraceLog);
Assert.Equal("ad: bs: as:" + id, observer.TraceLog);
}
public void Dispense_Hooks()
{
IBeanFactory factory = new BeanFactory();
factory.Options.ValidateGetColumns = false;
var crud = new BeanCrud(null, null, null, factory);
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense <Tracer>();
Assert.Equal("tracer", bean.GetKind());
Assert.Equal("ad:", bean.TraceLog);
Assert.Equal("ad:", observer.TraceLog);
Assert.Same(bean, observer.LastBean);
}
public void ConvertsValueToString()
{
IBeanFactory factory = new BeanFactory();
var crud = new BeanCrud(null, null, null, factory);
var bean = crud.Dispense("foo");
bean.Import(
new Dictionary <string, object>()
{
{ "null", null },
{ "bool", true },
{ "sbyte", sbyte.Parse("123") },
{ "ssbyte", sbyte.Parse("-123") },
{ "byte", byte.Parse("123") },
{ "int", 123 },
{ "long", 123456789L },
{ "double", 123.4567 },
{ "decimal", 123.45m },
{ "string", "Hello!" },
{ "datetime", new DateTime(2000, 1, 1) },
{ "guid", Guid.Parse("6161ADAD-72F0-48D1-ACE2-CD98315C9D5B") },
{ "byte[]", Encoding.UTF8.GetBytes("Hello!") }
}
);
AssertExtensions.WithCulture("de-DE", () =>
{
Assert.Equal("#NULL#", bean["null"].FormatValueToString());
Assert.Equal("true", bean["bool"].FormatValueToString());
Assert.Equal("123", bean["sbyte"].FormatValueToString());
Assert.Equal("-123", bean["ssbyte"].FormatValueToString());
Assert.Equal("123", bean["byte"].FormatValueToString());
Assert.Equal("123", bean["int"].FormatValueToString());
Assert.Equal("123456789", bean["long"].FormatValueToString());
Assert.Equal("123,4567", bean["double"].FormatValueToString());
Assert.Equal("123,45", bean["decimal"].FormatValueToString());
Assert.Equal("Hello!", bean["string"].FormatValueToString());
Assert.Equal("2000-01-01T00:00:00", bean["datetime"].FormatValueToString());
Assert.Equal("6161ADAD-72F0-48D1-ACE2-CD98315C9D5B", bean["guid"].FormatValueToString());
Assert.Equal("Hello!", bean["byte[]"].FormatValueToString());
});
}
public void Store()
{
IBeanFactory factory = new BeanFactory();
factory.Options.ValidateGetColumns = false;
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil(), factory);
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense <Tracer>();
var id = crud.Store(bean);
Assert.Equal(0L, id);
Assert.Equal(0L, bean["id"]);
Assert.Equal("ad: bs: as:" + id, bean.TraceLog);
Assert.Equal("ad: bs: as:" + id, observer.TraceLog);
}
public void Load()
{
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil());
var observer = new TracingObserver();
crud.AddObserver(observer);
// Load non-existing bean
Assert.Null(crud.Load("any", 123));
Assert.Empty(observer.TraceLog);
var bean = crud.Dispense<Tracer>();
bean.Put("p1", "test");
var id = crud.Store(bean);
observer.TraceLog = "";
bean = crud.Load<Tracer>(id);
Assert.Equal("ad: bl: al:" + id, bean.TraceLog);
Assert.Equal("ad: bl: al:" + id, observer.TraceLog);
Assert.NotNull(bean["id"]);
Assert.Equal(id, bean["id"]);
Assert.Equal("test", bean["p1"]);
}
public void Trash()
{
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil());
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense <Tracer>();
observer.TraceLog = bean.TraceLog = "";
crud.Trash(bean);
Assert.Empty(bean.TraceLog);
Assert.Empty(observer.TraceLog);
var id = crud.Store(bean);
observer.TraceLog = bean.TraceLog = "";
crud.Trash(bean);
Assert.Equal("bt:" + id + " at:" + id, bean.TraceLog);
Assert.Equal("bt:" + id + " at:" + id, observer.TraceLog);
Assert.Equal(id, bean["id"]);
Assert.Null(crud.Load <Tracer>(id));
}
public void Trash()
{
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil());
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense<Tracer>();
observer.TraceLog = bean.TraceLog = "";
crud.Trash(bean);
Assert.Empty(bean.TraceLog);
Assert.Empty(observer.TraceLog);
var id = crud.Store(bean);
observer.TraceLog = bean.TraceLog = "";
crud.Trash(bean);
Assert.Equal("bt:" + id + " at:" + id, bean.TraceLog);
Assert.Equal("bt:" + id + " at:" + id, observer.TraceLog);
Assert.Equal(id, bean["id"]);
Assert.Null(crud.Load<Tracer>(id));
}
public void Store()
{
var crud = new BeanCrud(new InMemoryStorage(), null, new KeyUtil());
var observer = new TracingObserver();
crud.AddObserver(observer);
var bean = crud.Dispense<Tracer>();
var id = crud.Store(bean);
Assert.Equal(0L, id);
Assert.Equal(0L, bean["id"]);
Assert.Equal("ad: bs: as:" + id, bean.TraceLog);
Assert.Equal("ad: bs: as:" + id, observer.TraceLog);
}