public void BackupDatabase_overwrite_openfile_with_inmemory()
{
var tempPath = GetTempFilePath(".crz3");
RegesterFileForCleanUp(tempPath);
using (var ds = new SQLiteDatastore(tempPath))
{
var dbbuilder = new TestDBBuilder();
ds.CreateDatastore(dbbuilder);
var orgTableInfo = ds.QueryGeneric("SELECT * FROM Sqlite_Master;").ToArray();
orgTableInfo.Should().NotBeEmpty();
ds.From <POCOMultiTypeObject>().Query().Should().BeEmpty();
using (var newds = new SQLiteDatastore())
{
newds.CreateDatastore(dbbuilder);
newds.Insert(new POCOMultiTypeObject()
{
ID = 1,
});
newds.From <POCOMultiTypeObject>().Query().Should().NotBeEmpty();
newds.BackupDatabase(tempPath);
}
ds.From <POCOMultiTypeObject>().Query().Should().NotBeEmpty();
}
}
public void QueryGeneric_Test(bool nulls)
{
using (var ds = new SQLiteDatastore())
{
ds.Execute(TestDBBuilder.CREATE_MULTIPROPTABLE);
var poco = CreateRandomPoco(nulls);
ds.Insert(poco);
var stuff = ds.QueryGeneric("SELECT * FROM MultiPropTable;").ToArray();
}
}
public void QueryRowIDAsPrimaryKeyObject()
{
using (var ds = new SQLiteDatastore())
{
ds.Execute(RowIDAsPrimaryKey.CREATE_TABLE_COMMAND);
ds.Insert(new RowIDAsPrimaryKey {
StringField = "something"
});
var result = ds.From <RowIDAsPrimaryKey>().Query().First();
result.RowID.Should().Be(1);
}
}
public void Insert()
{
using (var ds = new SQLiteDatastore())
{
ds.CreateDatastore(new TestDBBuilder());
var ent = POCOMultiTypeObject.CreateWithNullID();
ent.ID.Should().BeNull();
ds.Insert(ent);
ent.ID.Should().NotBeNull();
var entAgain = ds.From <POCOMultiTypeObject>().Query().Single();
ent.Should().BeEquivalentTo(entAgain);
}
}
public void Query_Test(bool nulls)
{
using (var ds = new SQLiteDatastore())
{
ds.Execute(TestDBBuilder.CREATE_MULTIPROPTABLE);
var poco = CreateRandomPoco(nulls);
ds.Insert(poco);
var result = ds.Query <POCOMultiTypeObject>("SELECT * FROM MultiPropTable;")
.SingleOrDefault();
result.Should().NotBeNull();
result.Should().BeEquivalentTo(poco);
}
}
public void FluentInterfaceTest_Single_Record(bool nulls)
{
using (var ds = new SQLiteDatastore())
{
ds.Execute(TestDBBuilder.CREATE_MULTIPROPTABLE);
var poco = POCOMultiTypeObject.CreateWithNullID();
ds.Insert(poco);
var result = ds.From <MultiPropTypeWithAliases>().Query()
.SingleOrDefault();
result.Should().NotBeNull();
poco.Should().BeEquivalentTo(result, config => config.ExcludingMissingMembers());
result.AliasForStringField.Should().Be(result.StringField);
}
}
