public static void FixtureSetup(TestContext context)
{
database = new SqlDbUnitTest(ConfigurationManager.ConnectionStrings["DB"].ConnectionString);
database.ReadXmlSchema(@"EmployeeADODatabase.xsd");
database.ReadXml(@"EmployeeADOTestData.xml");
database.PerformDbOperation(DbOperationFlag.DeleteAll);
}
public void CreateFixtureNow()
{
SqlDbUnitTest dbUnit = new SqlDbUnitTest(connectionString);
dbUnit.ReadXmlSchema(@"DBFixtures/JewelryItems.xsd");
DataSet ds = dbUnit.GetDataSetFromDb();
ds.WriteXml(@"DBFixtures/JewelryItemsAllCategories.xml");
}
protected static INDbUnitTest CreateDataController(string connectionStringKey)
{
var result = new SqlDbUnitTest(ConfigurationManager.ConnectionStrings[connectionStringKey].ConnectionString);
using (var stream = Assembly.GetExecutingAssembly().GetManifestResourceStream("Bits.IntegrationTests.Database.xsd"))
{
result.ReadXmlSchema(stream);
}
return(result);
}
public void GetMyTestDataXmlFile()
{
var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["IntegrationTests.Properties.Settings.TDDWithMVCConnectionString"].ConnectionString;
var mySqlDatabase = new SqlDbUnitTest(connectionString);
mySqlDatabase.ReadXmlSchema(DatabaseXsd02);
System.Data.DataSet ds = mySqlDatabase.GetDataSetFromDb();
ds.WriteXml(TestdataXml02);
}
public static void ReadXmlFromFolder(this SqlDbUnitTest test, string folderPath)
{
var xmls = Directory.GetFiles(folderPath);
if (xmls.Length == 0)
{
return;
}
test.ReadXml(xmls[0]);
for (var i = 1; i < xmls.Length; i++)
{
test.AppendXml(xmls[i]);
}
}
protected void ExportTestDataFromDatabase(
string projectPath = null,
string outputFolderName = null,
string outputFilename = null,
string connectionString = null,
string xmlSchemaFilename = null,
Type classUnderTest = null)
{
using (var context = new TContext())
{
context.Provider = TestContextBase.DatabaseProvider.SqlClient;
context.ConnectionString = connectionString ?? TestContextBase.DefaultConnectionString;
context.ProjectPath = projectPath ?? TestContextBase.DefaultProjectPath;
if (outputFolderName != null)
{
context.FolderName = outputFolderName;
}
if (classUnderTest != null)
{
context.ClassUnderTest = classUnderTest;
}
var database =
new SqlDbUnitTest(context.ConnectionString);
database.ReadXmlSchema(
!string.IsNullOrEmpty(xmlSchemaFilename)
? xmlSchemaFilename
: Path.Combine(@"..\..\Bases\Data",
TestContextBase.DefaultXmlSchemaFilename));
var dataSet = database.GetDataSetFromDb();
var fileName = string.Format(
@"..\..\{0}\Data\{1}",
context.FolderName,
outputFilename ?? string.Format(
"{0}Tests_ExportedData.xml",
context.ClassUnderTest.Name));
dataSet.WriteXml(fileName);
}
}
protected INDbUnitTest SetUpDatabase(DbOperationFlag operation, Stream datasetStream = null)
{
Assert.IsNotNull(DatabaseSchema);
SetUpNhibernateSession();
INDbUnitTest dbUnitTest = new SqlDbUnitTest(this.ConnectionString);
dbUnitTest.ReadXmlSchema(this.DatabaseSchema);
if (datasetStream != null)
{
dbUnitTest.ReadXml(datasetStream);
}
dbUnitTest.PerformDbOperation(operation);
return(dbUnitTest);
}
/// <summary>
/// Initializes the database.
/// </summary>
/// <param name="connection"></param>
public static INDbUnitTest Initialize(SqlConnection connection)
{
if (SqlLocalDbApi.GetInstanceInfo(InstanceName).Exists)
{
SqlLocalDbApi.StopInstance(InstanceName, TimeSpan.FromSeconds(10));
SqlLocalDbApi.DeleteInstance(InstanceName, true);
}
SqlLocalDbApi.CreateInstance(InstanceName);
var database = new SqlDbUnitTest(connection);
database.Scripts.AddSingle($"{TestContext.CurrentContext.TestDirectory}\\Scripts\\InitSchema.sql");
database.Scripts.AddWithWildcard($"{TestContext.CurrentContext.TestDirectory}\\Scripts", "InitTable_*.sql");
database.ExecuteScripts();
database.ReadXmlSchema(Resource.AsStream("Wikibus.xsd"));
return(database);
}
private static INDbUnitTest ObterBaseDeDados()
{
var baseDeDados = new SqlDbUnitTest(ConfiguracaoDeTestes.StringDeConexao);
return(baseDeDados);
}
public DatabaseCleaner ConnectTo(string connectionString)
{
_connection = new SqlDbUnitTest(connectionString);
return(this);
}
