public void TestGetColumnInfoFromMeta() { String path = Environment.CurrentDirectory + string.Format ("{0}Resources{0}test.db", Path.DirectorySeparatorChar); SqliteConnectionStringBuilder constrBuilder = new SqliteConnectionStringBuilder (); constrBuilder.DataSource = path; IDbServerConnection serverCon = new SqliteDbServerConnection ("test.db", constrBuilder.ConnectionString); var con = serverCon.CreateConnection (); List<ColumnInfo> colInfos; try { con.Open(); using (IDbCommand cmd = con.CreateCommand ()) { cmd.CommandText = "select * from testtable"; using (var reader = cmd.ExecuteReader ()) { colInfos = serverCon.GetColumnInfosFromMeta( reader.GetSchemaTable () ); } } } finally { if (con.State == ConnectionState.Open) con.Close (); } Assert.Greater (colInfos.Count, 1); }
public void TestSqliteStatePersistanceProvider() { IDbServerConnection session = new SqliteDbServerConnection ("testdb", "someconnectionstring"); SqliteStatePersistanceProvider prov = new SqliteStatePersistanceProvider (); SqliteConnectionStringBuilder conStrBuilder = new SqliteConnectionStringBuilder (); conStrBuilder.DataSource = ":memory:"; using (SqliteConnection con = new SqliteConnection (conStrBuilder.ConnectionString)) { con.Open (); // Start calling RestoreSessions method even though no session is saved. This triggers the initialization logic // in the SqliteStatePersistanceProvider. var providersShouldBeEmpty = prov.RestoreSessions (con); Assert.AreEqual (0, providersShouldBeEmpty.Length); // Save session prov.SaveSessions (new IDbServerConnection[] { session }, con); // restore saved session IDbServerConnection[] restoredSessions = prov.RestoreSessions (con); Assert.AreEqual (1, restoredSessions.Length); Assert.AreEqual (session, restoredSessions [0]); } }
public void TestSqliteSessionStateProvider() { SqliteConnectionStringBuilder conStrBuilder = new SqliteConnectionStringBuilder (); SqliteDbServerConnection serverCon = new SqliteDbServerConnection ("test", conStrBuilder.ConnectionString); ISessionStateProvider sessionStateProvider = new SqliteSessionStateProvider(serverCon); String state = sessionStateProvider.getSerializedState (); IDbServerConnection restoredCon = sessionStateProvider.restoreSessionFromState (state); Assert.AreEqual (restoredCon, serverCon); }
public override bool Equals(object obj) { if (obj.GetType() != this.GetType()) { return(false); } SqliteDbServerConnection other = (SqliteDbServerConnection)obj; return (this.Name == other.Name && this.SqliteConnectionString == other.SqliteConnectionString); }