public TestFixtureBase() { if (dataFresh == null) { dataFresh = new SqlDataFresh(connectionString); } }
public void SnapshopPath_Resetting() { SqlDataFresh dataFresh = new SqlDataFresh(connectionString); dataFresh.SnapshotPath = null; Assert.IsTrue(dataFresh.SnapshotPath.FullName.IndexOf("Snapshot_DataFreshSample") > -1); }
public void SnapshopPath_ManualOverrideTrailingBackslash() { SqlDataFresh dataFresh = new SqlDataFresh(connectionString); string tempPath = @"c:\temp\folder"; dataFresh.SnapshotPath = new DirectoryInfo(tempPath); Assert.AreEqual(@"c:\temp\folder\", dataFresh.SnapshotPath.FullName); }
public void SnapshopPath_ManualOverride() { SqlDataFresh dataFresh = new SqlDataFresh(connectionString); DirectoryInfo tempPath = new DirectoryInfo(Path.GetTempPath()); dataFresh.SnapshotPath = tempPath; Console.Out.WriteLine("dataFresh.SnapshotPath.FullName = {0}", dataFresh.SnapshotPath.FullName); Assert.AreEqual(tempPath.FullName, dataFresh.SnapshotPath.FullName); }
public void IdentityReseedWorksWithTablesThatUseReservedWords() { InitializeTheDatabase(); SqlDataFresh dataFresh = new SqlDataFresh(connectionString); dataFresh.RemoveDataFreshFromDatabase(); dataFresh.PrepareDatabaseforDataFresh(true); ExecuteNonQuery("insert into [check] (title) values ('mike brockey takes over the world');"); dataFresh.RefreshTheDatabase(); }
public void IdentityReseedDuringRefresh_TableWithNoRows2() { InitializeTheDatabase(); SqlDataFresh dataFresh = new SqlDataFresh(connectionString); dataFresh.RemoveDataFreshFromDatabase(); dataFresh.PrepareDatabaseforDataFresh(true); ExecuteNonQuery("insert into movie2 (movieid, title) values (1, 'mike brockey takes over the world');"); dataFresh.RefreshTheDatabase(); }
public void RemoveDataFresh() { SqlDataFresh dataFresh = new SqlDataFresh(connectionString); dataFresh.RemoveDataFreshFromDatabase(); Assert.IsFalse(dataFresh.TableExists(dataFresh.ChangeTrackingTableName)); Assert.IsFalse(dataFresh.ProcedureExists(dataFresh.ExtractProcedureName)); Assert.IsFalse(dataFresh.ProcedureExists(dataFresh.ImportProcedureName)); Assert.IsFalse(dataFresh.ProcedureExists(dataFresh.PrepareProcedureName)); Assert.IsFalse(dataFresh.ProcedureExists(dataFresh.RefreshProcedureName)); }
public static void PrepareDataFresh() { var connectionString = ConfigurationManager.ConnectionStrings["dataConnection"].ConnectionString; CheckDbConnection(connectionString); var dataFresh = new SqlDataFresh(connectionString); dataFresh.SnapshotPath = new DirectoryInfo(@"C:\experts_snapshots\"); dataFresh.PrepareDatabaseforDataFresh(true); }
public void ShouldNotRefreshDeltaRunnerTable() { InitializeTheDatabase(); SqlDataFresh dataFresh = new SqlDataFresh(connectionString); dataFresh.RemoveDataFreshFromDatabase(); dataFresh.PrepareDatabaseforDataFresh(true); ExecuteNonQuery("insert into [dr_deltaversion] ([latestdelta], [hash], [filename]) values (99, 'blah-hash', 'whatever file');"); Assert.AreEqual(1, ExecuteScalar("select count(*) from [dr_deltaversion] where [filename] = 'whatever file'")); dataFresh.RefreshTheDatabase(); Assert.AreEqual(1, ExecuteScalar("select count(*) from [dr_deltaversion] where [filename] = 'whatever file'")); }
public void IdentityReseedDuringRefresh() { InitializeTheDatabase(); SqlDataFresh dataFresh = new SqlDataFresh(connectionString); dataFresh.PrepareDatabaseforDataFresh(true); int id = Convert.ToInt32(ExecuteScalar("insert into author (lastname, firstname) values ('brockey', 'mike'); select @@identity;")); Assert.AreEqual(6, id); dataFresh.RefreshTheDatabase(); int id2 = Convert.ToInt32(ExecuteScalar("insert into author (lastname, firstname) values ('brockey', 'mike'); select @@identity;")); Assert.AreEqual(6, id2); }
public void IdentityReseedDuringRefresh_TableWithNoRows() { InitializeTheDatabase(); SqlDataFresh dataFresh = new SqlDataFresh(connectionString); dataFresh.PrepareDatabaseforDataFresh(true); int id = Convert.ToInt32(ExecuteScalar("insert into movie (title) values ('mike brockey takes over the world'); select @@identity;")); Assert.AreEqual(1, id); dataFresh.RefreshTheDatabase(); int id2 = Convert.ToInt32(ExecuteScalar("insert into movie (title) values ('mike brockey takes over the world'); select @@identity;")); Assert.AreEqual(1, id2); int id3 = Convert.ToInt32(ExecuteScalar("insert into movie (title) values ('mike brockey takes over the world 2'); select @@identity;")); Assert.AreEqual(2, id3); }
public void RefreshTheDatabaseSpeedTests() { SqlDataFresh dataFresh = new SqlDataFresh(connectionString, true); dataFresh.RemoveDataFreshFromDatabase(); dataFresh.PrepareDatabaseforDataFresh(true); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); ExecuteNonQuery("insert into author (lastname, firstname) values ('brockey', 'mike');"); dataFresh.RefreshTheDatabase(); }
public void PrepDatabaseforDataFresh_NoConnectionString() { SqlDataFresh dataFresh = new SqlDataFresh(null); dataFresh.PrepareDatabaseforDataFresh(); }