public void TestInsertNoDirectDatabaseReaderIntegration()
{
//arrange
ProviderChecker.Check(Providername, ConnectionString);
var rdr = new ScriptWriter();
//act
var txt = rdr.ReadTable("Customers", ConnectionString, Providername);
//assert
Assert.IsTrue(txt.Contains("INSERT INTO [Customers]"), "Insert statments created");
Assert.IsTrue(txt.Contains("[CustomerID], [CompanyName]"), "Insert names the columns");
Assert.IsTrue(txt.Contains("'ALFKI'"), "Data includes Alfreds Futterkiste");
}
public void TestInsertNoDirectDatabaseReaderIntegration()
{
//arrange
ProviderChecker.Check(Providername, _connectionString);
var rdr = new ScriptWriter();
//act
var txt = rdr.ReadTable("Categories", _connectionString, Providername, 0);
//assert
Assert.IsTrue(txt.Contains("INSERT INTO [Categories]"), "Insert statments created: [" + txt + "]");
Assert.IsTrue(txt.Contains("[CategoryName], [Description]"), "Insert names the columns: [" + txt + "]");
Assert.IsTrue(txt.Contains("'Beverages'"), "Data includes Beverages: [" + txt + "]");
}
public void GetData(DatabaseTable databaseTable, string connectionString, string providerName)
{
try
{
var sw = new ScriptWriter();
sw.IncludeBlobs = false;
sw.IncludeIdentity = true;
sw.PageSize = 100;
var txt = sw.ReadTable(databaseTable, connectionString, providerName);
Clipboard.SetText(txt, TextDataFormat.UnicodeText);
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
}
}
public void TestInsertIntegration()
{
//arrange
var dbReader = TestHelper.GetNorthwindReader();
var table = dbReader.Table("Categories");
var rdr = new ScriptWriter();
//act
var txt = rdr.ReadTable(table, _connectionString, Providername);
//assert
Assert.IsTrue(txt.Contains("INSERT INTO [Categories]"), "Insert statments created: [" + txt + "]");
Assert.IsTrue(txt.Contains("[CategoryName], [Description]"), "Insert names the columns: [" + txt + "]");
Assert.IsTrue(txt.Contains("'Beverages'"), "Data includes Beverages: [" + txt + "]");
}
public string GetData(DatabaseTable databaseTable, string connectionString, string providerName)
{
StringBuilder sb = new StringBuilder();
try
{
var sw = new ScriptWriter();
sw.IncludeBlobs = false;
sw.IncludeIdentity = true;
sw.PageSize = 10000;
sb.Append(sw.ReadTable(databaseTable, connectionString, providerName));
}
catch (Exception exception)
{
Debug.WriteLine(exception.Message);
}
return(sb.ToString());
}
public void TestInsertWithDataReader()
{
//arrange
var dbReader = TestHelper.GetNorthwindReader();
dbReader.DataTypes(); //need the datatypes here, so this must be called before or after
var table = dbReader.Table("Categories");
var rdr = new ScriptWriter();
string result = null;
//act
rdr.ReadTable(table, _connectionString, Providername, insertString =>
{
result = insertString;
return(false); //only need one record, return
});
//assert
Assert.IsNotNull(result);
Assert.IsTrue(result.Contains("INSERT INTO [Categories]"), "Insert statments created: " + result);
Assert.IsTrue(result.Contains("[CategoryName],"), "Insert names the columns: " + result);
}
