public static int getDB(String sql) { try { ASA db = new ASA(); db.setProperty("host", "localhost"); db.setProperty("login", "dba"); db.setProperty("password", "sql"); db.setProperty("port", "5500"); db.setProperty("driverClass", "com.sybase.jdbc3.jdbc.SybDriver"); List result = DBUtil.runSQLForResult((IDBResource) db, sql); System.out.println(result.size()); return result.size(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException("Failed to get record data from DB"); } }
public static void testMain(Object[] args) { objectmap map = new objectmap(); axeInit("C:\\AXE_Projects\\TestHarnessAPI\\TestHarnessAPI.tpj", "debug"); Dispatch.call( axe, "TestBegin", "Test4", "Try Database connect 1", "C:/AXE_Projects/TestHarnessAPI/data/Tests.xml", "Tests", "C:/AXE_Projects/TestHarnessAPI/results/debug/results.xml", ""); try { // // C:/AXE_Projects/TestHarnessAPI/data/Tests.xml:SQLUser Test01 Dispatch.call( axe, "SubtestBegin", "Test01", "", "C:/AXE_Projects/TestHarnessAPI/data/Tests.xml", "SQLUser"); Dispatch.call( axe, "StepBegin", "[]SQLUser", "set", "select * from accounts where Id in (1,2)"); Dispatch.put(axe, "ResultCode", 0); Dispatch.call( harness, "DbInitialiseQuery", Dispatch.call(axe, "GetRunCategoryOption", "connection", "MySqlLocal"), Dispatch.call( axe, "GetRunCategoryOptionProperty", "connection", "MySqlLocal", "provider"), "select * from accounts where Id in (1,2)", "System.Data.DataSet"); axeStepEnd(); Dispatch.call(axe, "StepBegin", "[]SQLUser", "Invoke", ""); Dispatch.put(axe, "ResultCode", 0); Dispatch.call(harness, "DbInvoke"); axeStepEnd(); Dispatch.call(axe, "StepBegin", "Surname", "get", ""); Dispatch.put(axe, "ResultCode", 0); Dispatch.put(axe, "Value", Dispatch.call(harness, "DbGetResultNodeText", "//Surname", false)); axeStepEnd(); Dispatch.call(axe, "StepBegin", "Surname", "val", ""); Dispatch.put(axe, "ResultCode", 0); Dispatch.put( axe, "ResultCode", Dispatch.call(axe, "StepValidateEqual", "", Dispatch.get(axe, "Value"))); axeStepEnd(); Dispatch.call(axe, "StepBegin", "ReturnValue", "get", ""); Dispatch.put(axe, "ResultCode", 0); Dispatch.put(axe, "Value", Dispatch.call(harness, "DbGetResult")); axeStepEnd(); Dispatch.call(axe, "StepBegin", "ReturnValue", "val", ""); Dispatch.put(axe, "ResultCode", 0); Dispatch.put( axe, "ResultCode", Dispatch.call(axe, "StepValidateEqual", "", Dispatch.get(axe, "Value"))); axeStepEnd(); Dispatch.call(axe, "StepBegin", "IdReturn", "get", ""); Dispatch.put(axe, "ResultCode", 0); Dispatch.put(axe, "Value", Dispatch.call(harness, "DbGetResultNodeText", "//Id", false)); axeStepEnd(); Dispatch.call(axe, "StepBegin", "IdReturn", "val", ""); Dispatch.put(axe, "ResultCode", 0); Dispatch.put( axe, "ResultCode", Dispatch.call(axe, "StepValidateEqual", "", Dispatch.get(axe, "Value"))); axeStepEnd(); axeSubtestEnd(); // // } catch (Exception ex) { axeTestAbort(ex.getMessage()); return; } Dispatch.call(axe, "TestEnd"); unregisterAll(); }