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