C# (CSharp) NDbUnit.Core.SqlClient.SqlDbUnitTest.PerformDbOperationの例

コード例 #1

ファイル: SchemaPrefixTest.cs プロジェクト: fubar-coder/NDbUnit

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

コード例 #2

ファイル: SchemaPrefixTest.cs プロジェクト: v-kravets/NDbUnit

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

コード例 #3

ファイル: TabsControllerGeneralTests.cs プロジェクト: rebider/JewelryONet

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

コード例 #4

ファイル: TabsControllerGeneralTests.cs プロジェクト: mamluka/JewelryONet

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

コード例 #5

ファイル: DataSetAppendXmlTest.cs プロジェクト: GCnaoto/NDBUnit_add_ReadXls

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

コード例 #6

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

コード例 #7

ファイル: DataSetAppendXmlTest.cs プロジェクト: v-kravets/NDbUnit

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

コード例 #8

ファイル: SchemaPrefixTest.cs プロジェクト: GCnaoto/NDBUnit_add_ReadXls

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

コード例 #9

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