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();
}
