public void Dispose()
{
_ndbUnitTest.PerformDbOperation(DbOperationFlag.DeleteAll);
_ndbUnitTest.Dispose();
Migrate.Down(_connection.ConnectionString);
}
public void InsertIdentity_Operation_Matches_Expected_Data()
{
using (INDbUnitTest database = GetNDbUnitTest())
{
DataSet expectedDataSet = BuildDataSet(GetXmlFilename());
database.ReadXmlSchema(ReadOnlyStreamFromFilename(GetXmlSchemaFilename()));
database.ReadXml(ReadOnlyStreamFromFilename(GetXmlFilename()));
database.PerformDbOperation(DbOperationFlag.DeleteAll);
database.PerformDbOperation(DbOperationFlag.InsertIdentity);
DataSet actualDataSet = database.GetDataSetFromDb(null);
Assert.That(actualDataSet.HasTheSameDataAs(expectedDataSet));
}
}
public void Issue38_Test()
{
INDbUnitTest db = GetNDbUnitTest();
db.ReadXmlSchema(@"Xml\MySql\DateAsPrimaryKey.xsd");
db.ReadXml(@"Xml\MySql\DateAsPrimaryKey.xml");
db.PerformDbOperation(DbOperationFlag.CleanInsertIdentity);
}
public void Setup(string data)
{
Migrate.Up(_connection.ConnectionString);
_ndbUnitTest = new PostgresqlDbUnitTest(_connection.ConnectionString);
_ndbUnitTest.ReadXmlSchema("Files/Schema.xsd");
if (!string.IsNullOrEmpty(data))
{
_ndbUnitTest.ReadXml(data);
}
_ndbUnitTest.PerformDbOperation(DbOperationFlag.CleanInsertIdentity);
}
public void Refresh_Operation_Matches_Expected_Data()
{
using (INDbUnitTest database = GetNDbUnitTest())
{
database.ReadXmlSchema(ReadOnlyStreamFromFilename(GetXmlSchemaFilename()));
database.ReadXml(ReadOnlyStreamFromFilename(GetXmlFilename()));
database.PerformDbOperation(DbOperationFlag.DeleteAll);
database.PerformDbOperation(DbOperationFlag.InsertIdentity);
database.ReadXml(GetXmlRefreshFilename());
database.PerformDbOperation(DbOperationFlag.Refresh);
DataSet actualDataSet = database.GetDataSetFromDb(null);
DataSet originalDataSet = BuildDataSet(GetXmlFilename());
DataSet refreshDataSet = BuildDataSet(GetXmlRefreshFilename());
var expectedDataSet = new DataSet();
expectedDataSet.ReadXmlSchema(ReadOnlyStreamFromFilename(GetXmlSchemaFilename()));
MergeDataSet(expectedDataSet, originalDataSet, refreshDataSet);
Assert.That(actualDataSet.HasTheSameDataAs(expectedDataSet));
}
}
public void Test()
{
_connectionString = "Data Source=:memory:;Version=3;New=True;";
//Create an Instance of the NDbUnit database test class
donSqlDatabase = new SqlLiteDbUnitTest(_connectionString);
//Tell the NDbUnit test class what schema and data files to use
donSqlDatabase.ReadXmlSchema(@"..\..\MyDataset.xsd");
donSqlDatabase.ReadXml(@"..\..\DonTestData.xml");
//Delete all existing data in the database and load test data
donSqlDatabase.PerformDbOperation(NDbUnit.Core.DbOperationFlag.CleanInsertIdentity);
var connection = new SqlLiteDbCommandBuilder(_connectionString);
}
public void GiveDataInserted()
{
database.PerformDbOperation(DbOperationFlag.Insert);
}
public void PutDataSetToDatabase(string xsdFilePath, string xmlFilePath)
{
_database.ReadXmlSchema(xsdFilePath);
_database.ReadXml(xmlFilePath);
_database.PerformDbOperation(DbOperationFlag.CleanInsertIdentity);
}
protected void Clean()
{
_unitTest.PerformDbOperation(DbOperationFlag.DeleteAll);
}
public void FixtureTeardown()
{
_database.PerformDbOperation(DbOperationFlag.DeleteAll);
}
