Method update

CodenameOne/src/com/codename1/properties/SQLMap.java:376–417

(PropertyBusinessObject cmp)

    ///
    /// - `IOException`
    public void update(PropertyBusinessObject cmp) throws IOException {
        String pkName = (String) cmp.getPropertyIndex().getMetaDataOfClass("cn1$pk");
        if (pkName == null) {
            throw new IOException("Primary key required for update");
        }
        String tableName = getTableName(cmp);
        StringBuilder createStatement = new StringBuilder("UPDATE ");
        createStatement.append(tableName);
        createStatement.append(" SET ");

        int count = 0;
        ArrayList<Object> values = new ArrayList<Object>();
        for (PropertyBase p : cmp.getPropertyIndex()) {
            SqlType tp = getSqlType(p);
            if (tp == SqlType.SQL_EXCLUDE) {
                continue;
            }
            if (count > 0) {
                createStatement.append(",");
            }
            if (p instanceof Property) {
                values.add(tp.asUpdateInsertValue(p.get(), (Property) p));
            } else {
                // TODO
                values.add(null);
            }
            count++;
            String columnName = getColumnName(p);
            createStatement.append(columnName);
            createStatement.append(" = ?");
        }

        createStatement.append(" WHERE ");

        createStatement.append(pkName);
        createStatement.append(" = ?");

        Property p = (Property) cmp.getPropertyIndex().getIgnoreCase(pkName);
        values.add(p.get());

        execute(createStatement.toString(), values.toArray());
    }

    /// Deletes a table row matching the component
    ///