public void TestSession05_BothDbWithAttachMainTablesAndEmptySession()
{
// close replica we just created and attach db file to our primary db as "replica"
dbReplica.Close();
dbPrimary.AttachDB(dbReplicaPath, "replica");
// create a session for "main" database
//Assert.That(SQLiteSession.Create(dbPrimary, out session), Is.EqualTo(SQLite3.Result.OK));
Assert.That(dbPrimary.CreateSession("main", out session), Is.EqualTo(SQLite3.Result.OK));
// attach all tables [from "main"] to it
Assert.That(SQLiteSession.AttachToTable(session, null), Is.EqualTo(SQLite3.Result.OK));
// enable watching for changes with this session
Assert.That(SQLiteSession.Enable(session, SQLiteSession.EnableState.EnableSession), Is.EqualTo(SQLiteSession.EnableState.EnableSession));
// validate no changes have occurred
Assert.That(SQLiteSession.IsEmptySession(session), Is.True);
// remove secondary db
dbPrimary.DetachDB("replica");
// done with our session
SQLiteSession.Delete(session);
}
public void TestSession04_WithAttachAllAndEmptySession()
{
// create a session for "main" database
Assert.That(SQLiteSession.Create(dbPrimary, out session), Is.EqualTo(SQLite3.Result.OK));
// attach all tables to it
Assert.That(SQLiteSession.AttachToTable(session, null), Is.EqualTo(SQLite3.Result.OK));
// enable watching for changes with this session
Assert.That(SQLiteSession.Enable(session, SQLiteSession.EnableState.EnableSession), Is.EqualTo(SQLiteSession.EnableState.EnableSession));
// validate no changes have occurred
Assert.That(SQLiteSession.IsEmptySession(session), Is.True);
// done with our session
SQLiteSession.Delete(session);
}