public void TestInsertNoDirectDatabaseReaderIntegration() { //arrange ProviderChecker.Check(Providername, _connectionString); var rdr = new ScriptWriter(); //act var txt = rdr.ReadTable("Categories", _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 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 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 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); }