C# (CSharp) CruiseDatastore_V3.Invoking Examples

Example #1

        public void RunDelete_WithConvertedFile(string tableName)
        {
            var skipTables = new[]
            {
                "LK_CruiseMethod",
                "LK_Product",
                "LK_Purpose",
                "LK_Region",
                "LK_UOM",
                "LK_TallyEntryType",
                "Species",
                "TreeField",
            };

            // some tables don't have cascading deletes so we need to skip them
            Skip.If(skipTables.Contains(tableName));

            var testFile = "MultiTest.2014.10.31.cruise";

            var(orgFile, crz3) = SetUpTestFile(testFile);

            var initializer = new DatabaseInitializer();

            using (var database = new CruiseDatastore_V3(crz3))
            {
                //database.OpenConnection();
                //database.Execute("PRAGMA foreign_keys=0;");
                database.Invoking(x => x.Execute($"DELETE FROM {tableName};"))
                .Should().NotThrow();
                //var fKeyErrors = database.QueryGeneric("PRAGMA foreign_key_check;");
                //Output.WriteLine(string.Join("|\r\n",fKeyErrors.Select(x=> x.ToString()).ToArray()));
                //fKeyErrors.Should().BeEmpty();
            }
        }