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