Examples with NVPair org.eclipse.scout.rt.platform.holders.NVPair used on opensource projects

Example 6 with NVPair

use of org.eclipse.scout.rt.platform.holders.NVPair in project scout.rt by eclipse.

the class SelectIntoArrayTest method testSelectIntoFormDataArray.

@Test
public void testSelectIntoFormDataArray() throws Exception {
    SqlServiceMock sql = createSqlServiceMock(DATA);
    // 
    Object[][] expectedData = DATA;
    BeanArrayHolder<MyFormData> h = new BeanArrayHolder<SelectIntoArrayTest.MyFormData>(MyFormData.class);
    sql.selectInto("SELECT A,B,C FROM T WHERE D=0 INTO :{h.active},:{h.state},:{h.name}", new NVPair("h", h));
    MyFormData[] a = h.getBeans();
    assertNotNull(a);
    assertEquals(4, a.length);
    for (int i = 0; i < a.length; i++) {
        a[i].assertValues(expectedData[i]);
    }
}

Example 7 with NVPair

use of org.eclipse.scout.rt.platform.holders.NVPair in project scout.rt by eclipse.

the class FormDataStatementBuilder method addWhere.

/**
 * add sql part with custom binds the ADD keyword is NOT added (pre-pended) automatically
 */
public void addWhere(String sql, NVPair... customBinds) {
    if (sql != null) {
        m_where.append(" ");
        m_where.append(sql);
        for (NVPair p : customBinds) {
            addBind(p.getName(), p.getValue());
        }
    }
}

Example 8 with NVPair

use of org.eclipse.scout.rt.platform.holders.NVPair in project scout.rt by eclipse.

the class StatementProcessorTest method testIgnoreInvalidDuplicateBinds.

@Test
public void testIgnoreInvalidDuplicateBinds() {
    AbstractSqlService sqlService = new AbstractSqlService() {
    };
    BeanInstanceUtil.initializeBeanInstance(sqlService);
    // The abstract server session contains active but without a setter and is thus not a valid bind
    // In this test, the NVPair active should be used and there should be no exception throw
    StatementProcessor sp = new StatementProcessor(sqlService, "SELECT 1 FROM DUAL INTO :active ", new Object[] { new Session(), new NVPair("active", new IntegerHolder()) });
    sp.simulate();
}

Example 9 with NVPair

use of org.eclipse.scout.rt.platform.holders.NVPair in project scout.rt by eclipse.

the class StatementProcessor method createOutputRec.

@SuppressWarnings({ "unchecked", "squid:S2583", "squid:S138" })
private IBindOutput createOutputRec(ValueOutputToken bindToken, String[] path, final Object bindBase) {
    boolean terminal = (path.length == 1);
    Object o = null;
    boolean found = false;
    if (bindBase instanceof Map) {
        // handle all terminal cases for map
        o = ((Map) bindBase).get(path[0]);
        if (o != null) {
            found = true;
        } else if (((Map) bindBase).containsKey(path[0])) {
            found = true;
        }
        if (found) {
            if (o instanceof ITableBeanHolder) {
                ITableBeanHolder table = (ITableBeanHolder) o;
                return new TableBeanHolderOutput(table, path[1], bindToken);
            } else if (o instanceof IBeanArrayHolder) {
                IBeanArrayHolder holder = (IBeanArrayHolder) o;
                return new BeanArrayHolderOutput(holder, path[1], bindToken);
            } else if (o instanceof IHolder) {
                if (terminal) {
                    return createOutputTerminal((IHolder) o, bindToken);
                } else {
                    o = ((IHolder) o).getValue();
                }
            } else if (o == null) {
                if (terminal) {
                    return new MapOutput((Map) bindBase, path[0], bindToken);
                } else {
                    throw new ProcessingException("output bind {} resolves to null on path element: {}", bindToken, path[0]);
                }
            } else {
                if (terminal) {
                    return new MapOutput((Map) bindBase, path[0], bindToken);
                }
            }
        }
    } else if (bindBase instanceof NVPair) {
        // handle all terminal cases for nvpair
        if (((NVPair) bindBase).getName().equals(path[0])) {
            o = ((NVPair) bindBase).getValue();
            found = true;
            if (o instanceof ITableBeanHolder) {
                ITableBeanHolder table = (ITableBeanHolder) o;
                return new TableBeanHolderOutput(table, path[1], bindToken);
            } else if (o instanceof IBeanArrayHolder) {
                IBeanArrayHolder holder = (IBeanArrayHolder) o;
                return new BeanArrayHolderOutput(holder, path[1], bindToken);
            } else if (o instanceof IHolder) {
                if (terminal) {
                    return createOutputTerminal((IHolder) o, bindToken);
                } else {
                    o = ((IHolder) o).getValue();
                }
            } else if (o == null) {
                throw new ProcessingException("output bind {} resolves to null on path element: {}", bindToken, path[0]);
            } else {
                if (terminal) {
                    throw new ProcessingException("output bind {} is not a valid output container", bindToken);
                }
            }
        }
    } else if (bindBase instanceof ITableBeanHolder) {
        // handle all terminal cases for table holder
        ITableBeanHolder table = (ITableBeanHolder) bindBase;
        try {
            Method m = table.getRowType().getMethod("get" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
            if (m != null) {
                found = true;
                return new TableBeanHolderOutput(table, path[0], bindToken);
            }
        } catch (NoSuchMethodException | SecurityException t) {
            // nop
            found = false;
        }
    } else if (bindBase instanceof IBeanArrayHolder) {
        // handle all terminal cases for BeanArrayHolder
        IBeanArrayHolder holder = (IBeanArrayHolder) bindBase;
        try {
            Method m = holder.getHolderType().getMethod("get" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
            if (m != null) {
                found = true;
                return new BeanArrayHolderOutput(holder, path[0], bindToken);
            }
        } catch (NoSuchMethodException | SecurityException t1) {
            try {
                Method m = holder.getHolderType().getMethod("is" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
                if (m != null) {
                    found = true;
                    return new BeanArrayHolderOutput(holder, path[0], bindToken);
                }
            } catch (NoSuchMethodException | SecurityException t2) {
                found = false;
            // nop
            }
        }
    } else /* bean property */
    {
        // handle all terminal cases for bean property
        try {
            FastPropertyDescriptor pd = BeanUtility.getFastBeanInfo(bindBase.getClass(), null).getPropertyDescriptor(path[0]);
            if (terminal) {
                Method setter = pd != null ? pd.getWriteMethod() : null;
                if (setter != null) {
                    found = true;
                    return new AbstractBeanPropertyOutput(bindBase.getClass(), path[0], bindToken) {

                        @Override
                        protected Object[] getFinalBeanArray() {
                            return new Object[] { bindBase };
                        }
                    };
                } else {
                    Method getter = pd != null ? pd.getReadMethod() : null;
                    if (getter != null) {
                        o = getter.invoke(bindBase, (Object[]) null);
                        if (o instanceof ITableBeanHolder) {
                            throw new ProcessingException("output bind '{}' is a table bean and should not be a terminal", bindToken.getName());
                        } else if (o instanceof IBeanArrayHolder) {
                            throw new ProcessingException("output bind '{}' is a bean array and should not be a terminal", bindToken.getName());
                        } else if (o instanceof IHolder) {
                            return createOutputTerminal((IHolder) o, bindToken);
                        } else {
                            return null;
                        }
                    }
                }
            } else {
                Method getter = pd != null ? pd.getReadMethod() : null;
                if (getter != null) {
                    Object readValue = getter.invoke(bindBase, (Object[]) null);
                    o = readValue;
                    found = true;
                }
            }
        } catch (IllegalAccessException | InvocationTargetException e) {
            LOG.warn("Exception while invoking bean getter", e);
        }
    }
    // 
    if (found) {
        if (terminal) {
            throw new ProcessingException("output bind '{}' was not recognized as a terminal", bindToken.getName());
        }
        // continue
        String[] newPath = new String[path.length - 1];
        System.arraycopy(path, 1, newPath, 0, newPath.length);
        return createOutputRec(bindToken, newPath, o);
    } else {
        return null;
    }
}

Example 10 with NVPair

use of org.eclipse.scout.rt.platform.holders.NVPair in project scout.rt by eclipse.

the class StatementProcessor method createInputRec.

@SuppressWarnings({ "squid:S2583", "squid:S138" })
private IBindInput createInputRec(ValueInputToken bindToken, String[] path, Object bindBase, Class nullType) {
    boolean terminal = (path.length == 1);
    Object o = null;
    boolean found = false;
    if (bindBase instanceof Map) {
        // handle all terminal cases for map
        o = ((Map) bindBase).get(path[0]);
        if (o != null) {
            found = true;
        } else if (((Map) bindBase).containsKey(path[0])) {
            found = true;
        }
        if (found) {
            if (o instanceof ITableBeanHolder) {
                return new TableBeanHolderInput((ITableBeanHolder) o, null, path[1], bindToken);
            } else if (o instanceof TableBeanHolderFilter) {
                return new TableBeanHolderInput(((TableBeanHolderFilter) o).getTableBeanHolder(), ((TableBeanHolderFilter) o).getFilteredRows(), path[1], bindToken);
            } else if (o instanceof IBeanArrayHolder) {
                return new BeanArrayHolderInput((IBeanArrayHolder) o, null, path[1], bindToken);
            } else if (o instanceof BeanArrayHolderFilter) {
                return new BeanArrayHolderInput(((BeanArrayHolderFilter) o).getBeanArrayHolder(), ((BeanArrayHolderFilter) o).getFilteredBeans(), path[1], bindToken);
            } else {
                if (terminal) {
                    return createInputTerminal(o, nullType, bindToken);
                } else {
                    if (o == null) {
                        throw new ProcessingException("input bind {} resolves to null on path element: {}", bindToken, path[0]);
                    }
                }
            }
        }
    } else if (bindBase instanceof NVPair) {
        // handle all terminal cases for nvpair
        if (((NVPair) bindBase).getName().equals(path[0])) {
            o = ((NVPair) bindBase).getValue();
            found = true;
            if (o instanceof ITableBeanHolder) {
                return new TableBeanHolderInput((ITableBeanHolder) o, null, path[1], bindToken);
            } else if (o instanceof TableBeanHolderFilter) {
                return new TableBeanHolderInput(((TableBeanHolderFilter) o).getTableBeanHolder(), ((TableBeanHolderFilter) o).getFilteredRows(), path[1], bindToken);
            } else if (o instanceof IBeanArrayHolder) {
                return new BeanArrayHolderInput((IBeanArrayHolder) o, null, path[1], bindToken);
            } else if (o instanceof BeanArrayHolderFilter) {
                return new BeanArrayHolderInput(((BeanArrayHolderFilter) o).getBeanArrayHolder(), ((BeanArrayHolderFilter) o).getFilteredBeans(), path[1], bindToken);
            } else {
                if (terminal) {
                    return createInputTerminal(o, nullType, bindToken);
                } else {
                    if (o == null) {
                        throw new ProcessingException("input bind {} resolves to null on path element: {}", bindToken, path[0]);
                    }
                }
            }
        }
    } else if (bindBase instanceof ITableBeanHolder) {
        // handle all terminal cases for table holder
        ITableBeanHolder table = (ITableBeanHolder) bindBase;
        try {
            Method m = table.getRowType().getMethod("get" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
            if (m != null) {
                found = true;
                return new TableBeanHolderInput(table, null, path[0], bindToken);
            }
        } catch (NoSuchMethodException | SecurityException t) {
            found = false;
        // nop
        }
    } else if (bindBase instanceof TableBeanHolderFilter) {
        // handle all terminal cases for table holder filter
        TableBeanHolderFilter filter = (TableBeanHolderFilter) bindBase;
        ITableBeanHolder table = filter.getTableBeanHolder();
        try {
            Method m = table.getRowType().getMethod("get" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
            if (m != null) {
                found = true;
                return new TableBeanHolderInput(table, filter.getFilteredRows(), path[0], bindToken);
            }
        } catch (NoSuchMethodException | SecurityException t) {
            // nop
            found = false;
        }
    } else if (bindBase instanceof IBeanArrayHolder) {
        // handle all terminal cases for BeanArrayHolder
        IBeanArrayHolder<?> holder = (IBeanArrayHolder) bindBase;
        try {
            Method m = holder.getHolderType().getMethod("get" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
            if (m != null) {
                found = true;
                return new BeanArrayHolderInput(holder, null, path[0], bindToken);
            }
        } catch (NoSuchMethodException | SecurityException t1) {
            try {
                Method m = holder.getHolderType().getMethod("is" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
                if (m != null) {
                    found = true;
                    return new BeanArrayHolderInput(holder, null, path[0], bindToken);
                }
            } catch (NoSuchMethodException | SecurityException t2) {
                found = false;
            // nop
            }
        }
    } else if (bindBase instanceof BeanArrayHolderFilter) {
        // handle all terminal cases for table holder filter
        BeanArrayHolderFilter filter = (BeanArrayHolderFilter) bindBase;
        IBeanArrayHolder<?> holder = filter.getBeanArrayHolder();
        try {
            Method m = holder.getHolderType().getMethod("get" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
            if (m != null) {
                found = true;
                return new BeanArrayHolderInput(holder, filter.getFilteredBeans(), path[0], bindToken);
            }
        } catch (NoSuchMethodException | SecurityException t1) {
            try {
                Method m = holder.getHolderType().getMethod("is" + Character.toUpperCase(path[0].charAt(0)) + path[0].substring(1));
                if (m != null) {
                    found = true;
                    return new BeanArrayHolderInput(holder, null, path[0], bindToken);
                }
            } catch (NoSuchMethodException | SecurityException t2) {
                found = false;
            // nop
            }
        }
    } else if (bindBase != null) {
        if (bindBase.getClass().isArray() && terminal) {
            return new BeanPropertyInput(path[0], (Object[]) bindBase, bindToken);
        }
        if (bindBase instanceof Collection && terminal) {
            return new BeanPropertyInput(path[0], ((Collection) bindBase).toArray(), bindToken);
        }
        /* bean property */
        try {
            Object propertyBean = bindBase;
            FastPropertyDescriptor pd = BeanUtility.getFastBeanInfo(propertyBean.getClass(), null).getPropertyDescriptor(path[0]);
            Method getter = pd != null ? pd.getReadMethod() : null;
            if (getter != null) {
                // getter exists
                o = getter.invoke(propertyBean);
                found = true;
                if (terminal) {
                    return createInputTerminal(o, getter.getReturnType(), bindToken);
                } else {
                    if (o == null) {
                        throw new ProcessingException("input bind {} resolves to null on path element: {}", bindToken, path[0]);
                    }
                }
            }
        } catch (IllegalAccessException | InvocationTargetException e) {
            LOG.warn("Exception while invoking bean getter", e);
            LOG.debug("Cannot access property.", e);
        }
    }
    // 
    if (found) {
        if (terminal) {
            throw new ProcessingException("input bind '{}' was not recognized as a terminal", bindToken.getName());
        }
        // continue
        String[] newPath = new String[path.length - 1];
        System.arraycopy(path, 1, newPath, 0, newPath.length);
        IBindInput input = null;
        if (o instanceof IHolder<?>) {
            /* dereference value if current object is an IHolder. If input cannot be resolved (i.e. ProcessingException occurs),
         * search given property names on holder. Hence both of the following forms are supported on holder types:
         * :holder.property
         * :holder.value.property
         */
            try {
                input = createInputRec(bindToken, newPath, ((IHolder) o).getValue(), nullType);
            } catch (RuntimeException pe) {
            // nop, see below
            }
        }
        if (input == null) {
            // strict search without dereferncing holder objects
            input = createInputRec(bindToken, newPath, o, nullType);
        }
        return input;
    } else {
        return null;
    }
}