Examples with HongsException app.hongs.HongsException used on opensource projects

Example 11 with HongsException

use of app.hongs.HongsException in project HongsCORE by ihongs.

the class Link method execute.

/**
 * 执行语句 *
 */
/**
 * 执行方法
 * @param sql
 * @param params
 * @return 成功或失败
 * @throws HongsException
 */
public boolean execute(String sql, Object... params) throws HongsException {
    this.ready();
    if (0 < Core.DEBUG && 8 != (8 & Core.DEBUG)) {
        StringBuilder sb = new StringBuilder(sql);
        List paramz = new ArrayList(Arrays.asList(params));
        checkSQLParams(sb, paramz);
        mergeSQLParams(sb, paramz);
        CoreLogger.debug("DB.execute: " + sb.toString());
    }
    PreparedStatement ps = this.prepareStatement(sql, params);
    try {
        return ps.execute();
    } catch (SQLException ex) {
        throw new HongsException(0x104a, ex);
    } finally {
        this.closeStatement(ps);
    }
}

Example 12 with HongsException

use of app.hongs.HongsException in project HongsCORE by ihongs.

the class Loop method next.

@Override
public Map next() {
    // 判断是否到达末尾
    if (!hasNext()) {
        this.close();
        return null;
    }
    il = null;
    // 获取当前字段类型
    try {
        // getMetaData();
        getTypeDict();
    } catch (HongsException ex) {
        this.close();
        throw ex.toExpedient();
    }
    // 获取行内每列数据
    try {
        int i = 0;
        Map<String, Object> row = new LinkedHashMap();
        if (ib) {
            for (Map.Entry<String, Class> et : td.entrySet()) {
                // row.put(et.getKey() , rs.getObject(++ i, et.getState()));
                Dict.put(row, rs.getObject(++i, et.getValue()), (Object[]) et.getKey().split("\\."));
            }
        } else {
            for (Map.Entry<String, Class> et : td.entrySet()) {
                // row.put(et.getKey() , rs.getString(++ i /* No Type */ ));
                Dict.put(row, rs.getString(++i), (Object[]) et.getKey().split("\\."));
            }
        }
        return row;
    } catch (SQLException ex) {
        this.close();
        throw new HongsExpedient(0x10a6, ex);
    }
}

Example 13 with HongsException

use of app.hongs.HongsException in project HongsCORE by ihongs.

the class AssocMore method insertMore.

/**
 * 关联插入
 *
 * 关联配置中有指定 unique 键的话, 会调用 updateMore 进行更新
 *
 * @param table  主表
 * @param assocs 关联配置
 * @param values 要插入的数据
 * @throws app.hongs.HongsException
 */
public static void insertMore(Table table, Map assocs, Map values) throws HongsException {
    if (assocs == null || assocs.isEmpty())
        return;
    String id = (String) values.get(table.primaryKey);
    Iterator it = assocs.entrySet().iterator();
    while (it.hasNext()) {
        Map.Entry entry = (Map.Entry) it.next();
        Map config = (Map) entry.getValue();
        String type = (String) config.get("type");
        String name = (String) config.get("name");
        String tableName = (String) config.get("tableName");
        String foreignKey = (String) config.get("foreignKey");
        if (!values.containsKey(name)) {
            continue;
        }
        if (!type.equals("HAS_ONE") && !type.equals("HAS_MANY") && !type.equals("HAS_MORE")) {
            continue;
        }
        if (tableName == null || tableName.length() == 0) {
            tableName = name;
        }
        Table tb = table.db.getTable(tableName);
        // 都整理成List方便处理
        Object subValues = values.get(name);
        List subValues2 = new ArrayList();
        if ("HAS_ONE".equals(type)) {
            if (subValues instanceof Map) {
                subValues2.add(subValues);
            } else {
                throw new HongsException(0x10ca, "Sub data type for table '" + tb.name + "' must be Map");
            }
        } else {
            if (subValues instanceof Map) {
                subValues2.addAll(((Map) subValues).values());
            } else if (subValues instanceof Collection) {
                subValues2.addAll((Collection) subValues);
            } else {
                throw new HongsException(0x10cc, "Sub data type for table '" + tb.name + "' must be Map or List");
            }
        }
        /**
         * Add by Hongs on 2016/4/13
         * 当存在 filter 条件时, 可以解析 filter 条件里的值作为要插入的限制值
         */
        String wh = (String) config.get("filter");
        if (wh != null && wh.length() != 0) {
            Pattern pat = Pattern.compile("(?:`(.*?)`|(\\w+))\\s*=\\s*(?:'(.*?)'|(\\d+(?:\\.\\d+)?))");
            Matcher mat = pat.matcher(wh);
            Map map = new HashMap();
            while (mat.find()) {
                String n = mat.group(1);
                if (null == n) {
                    n = mat.group(2);
                }
                String v = mat.group(3);
                if (null == v) {
                    v = mat.group(4);
                }
                map.put(n, v);
            }
            // 填充约束
            Iterator it2 = subValues2.iterator();
            while (it2.hasNext()) {
                Map subValues3 = (Map) it2.next();
                subValues3.putAll(map);
            }
            // 附加条件
            wh = "`" + foreignKey + "`=? AND " + wh;
        } else {
            wh = "`" + foreignKey + "`=?";
        }
        /**
         * Add by Hongs on 2016/4/13
         * 当存在 convey 字段时, 可以根据 convey 从上层提取需要同步传递的数据
         */
        String cs = (String) config.get("convey");
        if (cs != null && cs.length() != 0) {
            String[] cz = cs.split("\\s*,\\s*");
            // 提取数据
            Map cd = new HashMap();
            for (String cn : cz) {
                cd.put(cn, values.get(cn));
            }
            // 传递数据
            Iterator it2 = subValues2.iterator();
            while (it2.hasNext()) {
                Map subValues3 = (Map) it2.next();
                subValues3.putAll(cd);
            }
        }
        /**
         * Add by Hongs on 2013/6/6
         * 有时候子数据会被其他数据引用, 如果更新子数据, 子数据的ID就会改变;
         * 通常这种情况存在以下规则: 如果某些字段值没发生改变则不要重新插入;
         * 所以当有指定 unique 时, 可使用 updateMore 方法更新数据, 其原理为:
         * 找出没改变的数据并更新, 然后插入新增数据, 最后删除更新和新增之外的数据.
         */
        String ks = (String) config.get("unique");
        // 2016/4/15, 也可以读取表自身的唯一键
        if (ks == null || ks.length() == 0) {
            ks = Synt.declare(tb.getParams().get("unique"), "");
        }
        if (ks != null && ks.length() != 0) {
            String[] kz = ks.split("\\s*,\\s*");
            // 填充外键
            Iterator it2 = subValues2.iterator();
            while (it2.hasNext()) {
                Map subValues3 = (Map) it2.next();
                subValues3.put(foreignKey, id);
            }
            updateMore(tb, subValues2, kz, wh, id);
        } else {
            // 先删除旧数据
            tb.remove("`" + foreignKey + "`=?", id);
            // 再插入新数据
            Iterator it2 = subValues2.iterator();
            while (it2.hasNext()) {
                Map subValues3 = (Map) it2.next();
                subValues3.put(foreignKey, id);
                // 如果存在主键而没给定主键值,则帮其添加上唯一ID
                if (tb.primaryKey != null && tb.primaryKey.length() != 0 && !subValues3.containsKey(tb.primaryKey)) {
                    subValues3.put(tb.primaryKey, Core.newIdentity());
                }
                tb.insert(subValues3);
            }
        }
    }
}

Example 14 with HongsException

use of app.hongs.HongsException in project HongsCORE by ihongs.

the class AssocMore method fetchMore.

private static void fetchMore(Table table, FetchCase caze, Map assocs, List lnks2, String pn) throws HongsException {
    Set tns = (Set) caze.getOption("ASSOCS");
    Set tps = (Set) caze.getOption("ASSOC_TYPES");
    Set jns = (Set) caze.getOption("ASSOC_JOINS");
    Set jis = new HashSet(Arrays.asList("MERGE", ""));
    String tn = caze.name;
    if (tn == null || tn.length() == 0)
        tn = caze.tableName;
    for (Map.Entry et : (Set<Map.Entry>) assocs.entrySet()) {
        Map assoc = (Map) et.getValue();
        String tp = (String) assoc.get("type");
        String jn = (String) assoc.get("join");
        String an = (String) assoc.get("name");
        String rn = (String) assoc.get("tableName");
        if (rn == null || rn.length() == 0)
            rn = an;
        if (rn == null || rn.length() == 0)
            continue;
        // 检查是否许可关联
        if (tns != null && !tns.contains(rn) && !tns.contains(an)) {
            continue;
        }
        if (tps != null && !tps.contains(tp)) {
            continue;
        }
        if (jn != null && !jis.contains(jn)) {
            if (jns != null && !jns.contains(jn)) {
                continue;
            }
        } else {
            // 非JOIN表先放到一边
            assoc.put("assocName", tn);
            lnks2.add(assoc);
            continue;
        }
        Map assocs2 = (Map) assoc.get("assocs");
        String fk = (String) assoc.get("foreignKey");
        String pk = (String) assoc.get("primaryKey");
        Table table2 = table.db.getTable(rn);
        FetchCase caze2 = caze.gotJoin(an).from(table2.tableName);
        // 建立关联关系
        if ("BLS_TO".equals(tp)) {
            // 上级外键连接下级主键
            if (pk == null)
                pk = table2.primaryKey;
            fk = "`" + tn + "`.`" + fk + "`";
            pk = "`" + an + "`.`" + pk + "`";
        } else if ("HAS_ONE".equals(tp)) {
            // 上级主键连接下级外键
            if (pk == null)
                pk = table.primaryKey;
            pk = "`" + tn + "`.`" + pk + "`";
            fk = "`" + an + "`.`" + fk + "`";
        } else if ("HAS_MANY".equals(tp) || "HAS_MORE".equals(tp)) {
            throw new HongsException(0x10c2, "Unsupported assoc type '" + tp + "'");
        } else {
            throw new HongsException(0x10c2, "Unrecognized assoc type '" + tp + "'");
        }
        caze2.on(pk + "=" + fk);
        // 转化关联类型
        byte ji;
        if ("LEFT".equals(jn)) {
            ji = FetchCase.LEFT;
        } else if ("RIGHT".equals(jn)) {
            ji = FetchCase.RIGHT;
        } else if ("FULL".equals(jn)) {
            ji = FetchCase.FULL;
        } else if ("INNER".equals(jn)) {
            ji = FetchCase.INNER;
        } else if ("CROSS".equals(jn)) {
            throw new HongsException(0x10c4, "Unsupported assoc join '" + jn + "'");
        } else {
            throw new HongsException(0x10c4, "Unrecognized assoc join '" + jn + "'");
        }
        caze2.by(ji);
        // 添加关联层级名, 如果不是 CLEVER_MODE 则没作用
        String pu = null != pn ? pn + "." + an : an;
        caze2.in(pu);
        if (assocs2 != null) {
            fetchMore(table2, caze2, assocs2, lnks2, pu);
        }
        checkCase(caze2, (Map) assoc.get("params"), pu, an, table2);
    }
}

Example 15 with HongsException

use of app.hongs.HongsException in project HongsCORE by ihongs.

the class FetchCase method toString.

// ** 对象 **/
/**
 * 转换为字符串
 * @return 合并了SQL/参数
 */
@Override
public String toString() {
    StringBuilder sb = this.getSQLStrs();
    List paramz = this.getParamsList();
    try {
        Link.checkSQLParams(sb, paramz);
        Link.mergeSQLParams(sb, paramz);
    } catch (HongsException ex) {
        throw new Error(ex);
    }
    return sb.toString();
}