public static void Startup(TestContext context)
{
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
_xmlInsert = new XmlInsert(true,
new Dictionary <string, object>
{
{ "age", _age },
{ "otherLastName", _otherLastName }
},
path + "\\examplexmld" //Currently just contains Persons.xmld. Add \\ora\\Persons for Oracle
);
}
public static void Startup(TestContext context)
{
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
_xmlInsert = new XmlInsert(true,
new Dictionary <string, object>
{
{ "maxSalary", _maxSalary },
{ "lastName", _lastName }
},
path + "\\examplexmld\\ora"
);
}
public XmlDataImportOraTest()
{
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
_xmlInsert = new XmlInsert(true,
new Dictionary <string, object>
{
{ "maxSalary", _maxSalary },
{ "lastName", _lastName }
},
path + "\\examplexmld\\ora"
);
}
public static void Startup(TestContext context)
{
string path = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
_xmlInsert = new XmlInsert(new RunConfig
{
Variables = new Dictionary <string, object>
{
{ "maxSalary", _maxSalary },
{ "lastName", _lastName }
},
ConnectionStringId = "OracleTest2",
DbVendor = "Oracle",
Paths = new List <string>
{
path + "\\examplexmld\\ora"
}
});
}
public void must_insert_string_xml()
{
var lastName = "Barns";
string actualLastName;
using (var insert = new XmlInsert(
true,
new Dictionary <string, object>
{
{ "lastName", lastName }
},
"OracleTest2",
"Oracle",
$@"<?xml version='1.0' encoding='utf-8' ?>
<Root>
<Setup>
DELETE FROM EMPLOYEES WHERE LAST_NAME = '{lastName}';
DELETE FROM JOBS WHERE JOB_ID = 'BLA_BLA';
</Setup>
<JOBS>
<JOB_ID>BLA_BLA</JOB_ID>
<JOB_TITLE>Bla bla job</JOB_TITLE>
<MIN_SALARY>4200</MIN_SALARY>
<MAX_SALARY>4200</MAX_SALARY>
</JOBS>
<EMPLOYEES>
<EMPLOYEE_ID>(EMPLOYEES_SEQ.NextVal)</EMPLOYEE_ID>
<FIRST_NAME>Bob</FIRST_NAME>
<LAST_NAME>variable('lastName')</LAST_NAME>
<EMAIL>[email protected]</EMAIL>
<PHONE_NUMBER>555-1234</PHONE_NUMBER>
<HIRE_DATE>TO_DATE('2003/07/09', 'yyyy/mm/dd')</HIRE_DATE>
<JOB_ID>BLA_BLA</JOB_ID>
</EMPLOYEES>
</Root>"))
{
actualLastName = insert.DataContext
.ExecuteScalar($"SELECT LAST_NAME FROM EMPLOYEES WHERE LAST_NAME = '{lastName}'").ToString();
}
Assert.AreEqual(actualLastName, lastName);
}
