@Test public void testCallWithReturnParam() throws QueryParserException { helpTestGetExec("{?=call procedure_name(?, ?, ?)}", true); //$NON-NLS-1$ helpTestGetExec(" {?=call procedure_name(?, ?, ?)}", true); //$NON-NLS-1$ helpTestGetExec("{ ?=call procedure_name(?, ?, ?)}", true); //$NON-NLS-1$ helpTestGetExec("{? =call procedure_name(?, ?, ?)}", true); //$NON-NLS-1$ helpTestGetExec("{?= call procedure_name(?, ?, ?)}", true); //$NON-NLS-1$ helpTestGetExec("{?=\ncall procedure_name(?, ?, ?)}", true); //$NON-NLS-1$ }
@Test public void testIllegalCalls() { helpTestIllegalCall("{call procedure_name"); //$NON-NLS-1$ helpTestIllegalCall("call procedure_name}"); //$NON-NLS-1$ helpTestIllegalCall("{call procedure_name(}"); //$NON-NLS-1$ helpTestIllegalCall("{callprocedure_name()}"); //$NON-NLS-1$ helpTestIllegalCall("{call procedure_name)}"); //$NON-NLS-1$ helpTestIllegalCall("{call procedure name}"); //$NON-NLS-1$ helpTestIllegalCall("{call procedure name()}"); //$NON-NLS-1$ helpTestIllegalCall("{?call procedure_name}"); //$NON-NLS-1$ helpTestIllegalCall("{=call procedure_name}"); //$NON-NLS-1$ helpTestIllegalCall("{?=cal procedure_name}"); //$NON-NLS-1$ }
private void helpTestGetExec(String call, boolean returnValue) throws QueryParserException { StoredProcedure sp = helpTest(call, returnValue); assertEquals((returnValue ? "? = ":"") +"EXEC procedure_name(?, ?, ?)", sp.toString()); //$NON-NLS-1$ }
@Test public void testNamedParams() throws QueryParserException { assertEquals("? = EXEC procedure_name(a => ?)", helpTest("{?=call procedure_name(a=>?)}", true).toString()); }
@Test public void testGetExec() throws QueryParserException { helpTestGetExec("{call procedure_name(?, ?, ?)}", false); //$NON-NLS-1$ helpTestGetExec(" {call procedure_name(?, ?, ?)}", false); //$NON-NLS-1$ helpTestGetExec("{ call procedure_name(?, ?, ?)}", false); //$NON-NLS-1$ helpTestGetExec("{call\tprocedure_name(?, ?, ?)}", false); //$NON-NLS-1$ helpTestGetExec("{call procedure_name (?, ?, ?)}", false); //$NON-NLS-1$ helpTestGetExec("{call procedure_name(?, ?, ?) }", false); //$NON-NLS-1$ helpTestGetExec("{CALL procedure_name(?, ?, ?)} ", false); //$NON-NLS-1$ }