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); }