public void CanParseSingleLineScript() { const string singleCommand = "create table FOO (myid INT NOT NULL)/"; var connectionManager = new OracleConnectionManager("connectionstring", new OracleCommandSplitter('/')); var result = connectionManager.SplitScriptIntoCommands(singleCommand); result.Count().ShouldBe(1); }
public void CanParseMultilineScript() { var multiCommand = "create table FOO (myid INT NOT NULL)/"; multiCommand += Environment.NewLine; multiCommand += "create table BAR (myid INT NOT NULL)"; var connectionManager = new OracleConnectionManager("connectionstring", new OracleCommandSplitter('/')); var result = connectionManager.SplitScriptIntoCommands(multiCommand); result.Count().ShouldBe(2); }
public async Task <ActionResult> OracleConnectionManager() { try { OracleConnectionManager orcon = new OracleConnectionManager(new OracleConnectionString(oracleconStr)); ControlFlow.DefaultDbConnection = orcon; CreateTableTask.Create(orcon, "ATABLE1", new List <TableColumn>() { new TableColumn("VCH_DIST_NAME", "varchar2(20)", allowNulls: true), new TableColumn("INT_DIST_ID", "varchar2(20)", allowNulls: true) }); CsvSource <string[]> source = new CsvSource <string[]>("t_covid_care_center.csv"); RowTransformation <string[], MyData> row = new RowTransformation <string[], MyData> ( input => new MyData() { VCH_DIST_NAME = input[1], INT_DIST_ID = input[2] } ); DbDestination <MyData> destOralce = new DbDestination <MyData>(orcon, "ATABLE1"); source.LinkTo(row); row.LinkTo(destOralce); await source.ExecuteAsync(); destOralce.Wait(); return(View()); } catch (Exception ex) { throw ex; } }
public void CanParseMultilineProcedureScriptWithDivideByOperator() { var multiCommand = "create or replace procedure divide_two_numbers(p_first_number in number, "; multiCommand += Environment.NewLine; multiCommand += "p_second_number in number, "; multiCommand += Environment.NewLine; multiCommand += "p_result out number) is "; multiCommand += Environment.NewLine; multiCommand += "begin"; multiCommand += Environment.NewLine; multiCommand += "p_result := p_first_number / p_second_number;"; multiCommand += Environment.NewLine; multiCommand += "end;"; multiCommand += Environment.NewLine; multiCommand += "/"; var connectionManager = new OracleConnectionManager("connectionstring"); var result = connectionManager.SplitScriptIntoCommands(multiCommand); result.Count().ShouldBe(1); }