public void Can_Perform_CleanInsertUpdate_Operation_Without_Exception_When_Schema_Has_Prefix()
{
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnections.SqlConnectionString);
db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFileForSchemaPrefixTests);
db.ReadXml(XmlTestFiles.SqlServer.XmlFileForSchemaPrefixTests);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
}
public void Can_Perform_CleanInsertUpdate_Operation_Without_Exception_When_Schema_Has_Prefix()
{
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnections.SqlConnectionString);
db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFileForSchemaPrefixTests);
db.ReadXml(XmlTestFiles.SqlServer.XmlFileForSchemaPrefixTests);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
}
public void Initialize()
{
// string connectionString = "server=localhost;user=dbuser;password=dbpassword;initial catalog=MyDatabase;";
NDbUnit.Core.INDbUnitTest mySqlDatabase = new NDbUnit.Core.SqlClient.SqlDbUnitTest(connectionString);
mySqlDatabase.ReadXmlSchema(@"DBFixtures/JewelryItems.xsd");
mySqlDatabase.ReadXml(@"DBFixtures/JewelryItemsAllCategories.xml");
mySqlDatabase.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
settingManager = MockRepository.GenerateStub <ISettingManager>();
}
public void Initialize()
{
// string connectionString = "server=localhost;user=dbuser;password=dbpassword;initial catalog=MyDatabase;";
NDbUnit.Core.INDbUnitTest mySqlDatabase = new NDbUnit.Core.SqlClient.SqlDbUnitTest(connectionString);
mySqlDatabase.ReadXmlSchema(@"DBFixtures/JewelryItems.xsd");
mySqlDatabase.ReadXml(@"DBFixtures/JewelryItemsAllCategories.xml");
mySqlDatabase.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
settingManager = MockRepository.GenerateStub<ISettingManager>();
}
public static void TestInit(TestContext testContext)
{
const string xmlSchemaPath = @"..\..\DummyData\DummyDataSchema.xsd";
const string xmlSourcePath = @"..\..\DummyData\DummyDataSource.xml";
var connectionString = ConfigurationManager.ConnectionStrings["ArinnaTestContext"].ToString();
NDbUnit.Core.INDbUnitTest mySqlDatabase = new NDbUnit.Core.SqlClient.SqlDbUnitTest(connectionString);
mySqlDatabase.ReadXmlSchema(xmlSchemaPath);
mySqlDatabase.ReadXml(xmlSourcePath);
mySqlDatabase.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
}
public void Can_Invoke_Scripts_Successfully()
{
//you cannot connect to the DB you're planning to create until AFTER you create it, so you must first connect to
//something 'safe' (like 'master') when executing any DB-create or DB drop scripts!
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnections.SqlScriptTestsConnectionString);
db.Scripts.AddSingle(@"TestScripts\sqlserver-drop-create-testdb.sql");
db.ExecuteScripts();
//once the DB has been created, its possible to connect to the new DB and invoke any other scripts as needed
db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnections.SqlConnectionString);
db.Scripts.AddWithWildcard(@"TestScripts\", "sqlserver-testdb*.sql");
db.ExecuteScripts();
}
public void Can_Invoke_Scripts_Successfully()
{
//you cannot connect to the DB you're planning to create until AFTER you create it, so you must first connect to
//something 'safe' (like 'master') when executing any DB-create or DB drop scripts!
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlScriptTestsConnectionString);
db.Scripts.AddSingle(@"TestScripts\sqlserver-drop-create-testdb.sql");
db.ExecuteScripts();
//once the DB has been created, its possible to connect to the new DB and invoke any other scripts as needed
db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlConnectionString);
db.Scripts.AddWithWildcard(@"TestScripts\", "sqlserver-testdb*.sql");
db.ExecuteScripts();
}
public void Can_Perform_CleanInsertUpdate_Operation_Without_Exception()
{
try
{
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlConnectionString);
db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFileForSchemaPrefixTests);
db.ReadXml(XmlTestFiles.SqlServer.XmlFileForSchemaPrefixTests);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
}
catch (Exception)
{
Assert.Fail("Operation not successful when using tables with Schema Prefixes.");
}
}
public void Can_Perform_CleanInsertUpdate_Operation_Without_Exception_When_Schema_Has_Prefix()
{
try
{
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlConnectionString);
db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFileForSchemaPrefixTests);
db.ReadXml(XmlTestFiles.SqlServer.XmlFileForSchemaPrefixTests);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
}
catch (Exception)
{
Assert.Fail("Operation not successful when using tables with Schema Prefixes.");
}
}
public void DataSet_Contains_Both_Appended_and_New_Records()
{
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnection.SqlConnectionString);
db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFile);
db.ReadXml(XmlTestFiles.SqlServer.XmlFile);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
var preAppendDataset = db.GetDataSetFromDb();
Assert.AreEqual(2, preAppendDataset.Tables["dbo.User"].Rows.Count);
Assert.AreEqual(2, preAppendDataset.Tables["Role"].Rows.Count);
db.AppendXml(XmlTestFiles.SqlServer.XmlApppendFile);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
var postAppendDataset = db.GetDataSetFromDb();
Assert.AreEqual(4, postAppendDataset.Tables["dbo.User"].Rows.Count);
Assert.AreEqual(4, postAppendDataset.Tables["Role"].Rows.Count);
}
public void DataSet_Contains_Both_Appended_and_New_Records()
{
var db = new NDbUnit.Core.SqlClient.SqlDbUnitTest(DbConnections.SqlConnectionString);
db.ReadXmlSchema(XmlTestFiles.SqlServer.XmlSchemaFile);
db.ReadXml(XmlTestFiles.SqlServer.XmlFile);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
var preAppendDataset = db.GetDataSetFromDb(null);
Assert.AreEqual(2, preAppendDataset.Tables["dbo.User"].Rows.Count);
Assert.AreEqual(2, preAppendDataset.Tables["Role"].Rows.Count);
db.AppendXml(XmlTestFiles.SqlServer.XmlApppendFile);
db.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
var postAppendDataset = db.GetDataSetFromDb(null);
Assert.AreEqual(4, postAppendDataset.Tables["dbo.User"].Rows.Count);
Assert.AreEqual(4, postAppendDataset.Tables["Role"].Rows.Count);
}
