private static DelimitedLineReader GetReader(IEtlContext context, string fileName, bool removeSurroundingDoubleQuotes = true) { return(new DelimitedLineReader(context) { StreamProvider = new LocalFileStreamProvider() { FileName = fileName, }, Columns = new() {
public void WrapIsWorking() { var context = TestExecuter.GetContext(); var builder = SequenceBuilder.Fluent .ReadFromExcel(new EpPlusExcelReader(context) { StreamProvider = new LocalFileStreamProvider() { FileName = @".\TestData\Test.xlsx", }, SheetName = "DateBroken", Columns = new() {
public void Database_BranchedScenario() { SampleDatabase.EnsureBuilt(); // Make a branch of the database in "Database.Branched" string branchedFolder = Path.Combine(s_RootPath, @"..\Database.Branched"); IStreamProvider branchedStreamProvider = new LocalFileStreamProvider(branchedFolder); branchedStreamProvider.Delete("."); IStreamProvider mainStreamProvider = SampleDatabase.XDatabaseContext.StreamProvider; XDatabaseContext branchedContext = new XDatabaseContext(SampleDatabase.XDatabaseContext); branchedContext.StreamProvider = new MultipleSourceStreamProvider(branchedStreamProvider, mainStreamProvider, MultipleSourceStreamConfiguration.LocalBranch); branchedContext.Runner = new WorkflowRunner(branchedContext); // Ask for WebRequest in the main database; verify built XForm("build WebRequest", 0); Assert.IsTrue(mainStreamProvider.Attributes("Table\\WebRequest").Exists); // Ask for WebRequest in the branch. Verify the main one is loaded where it is XForm("build WebRequest", 0, branchedContext); Assert.IsFalse(branchedStreamProvider.Attributes("Table\\WebRequest").Exists); // Ask for WebRequest.Authenticated in the main database; verify built XForm("build WebRequest.Authenticated", 0); Assert.IsTrue(mainStreamProvider.Attributes("Table\\WebRequest.Authenticated").Exists); Assert.IsFalse(branchedStreamProvider.Attributes("Table\\WebRequest.Authenticated").Exists); // Make a custom query in the branch. Verify the branched source has a copy with the new query, but it isn't published back string webRequestAuthenticatedConfigNew = @" read WebRequest # Slightly different query where [UserName] != "" where [UserName] != null"; branchedStreamProvider.WriteAllText("Config\\WebRequest.Authenticated.xql", webRequestAuthenticatedConfigNew); XForm("build WebRequest.Authenticated", 0, branchedContext); Assert.IsTrue(branchedStreamProvider.Attributes("Table\\WebRequest.Authenticated").Exists); Assert.AreEqual(webRequestAuthenticatedConfigNew, ((BinaryTableReader)branchedContext.Runner.Build("WebRequest.Authenticated", branchedContext)).Query); Assert.AreNotEqual(webRequestAuthenticatedConfigNew, ((BinaryTableReader)SampleDatabase.XDatabaseContext.Runner.Build("WebRequest.Authenticated", SampleDatabase.XDatabaseContext)).Query); }