Examples with EntityNet com.github.drinkjava2.jsqlbox.entitynet.EntityNet used on opensource projects

Example 26 with EntityNet

use of com.github.drinkjava2.jsqlbox.entitynet.EntityNet in project jSqlBox by drinkjava2.

the class EntityNetFactory method createEntityNet.

/**
 * Create a EntityNet instance, load data from database buy given loadKeyOnly
 * and configObjects parameters
 *
 * @param ctx
 *            A SqlBoxContext instance
 * @param loadKeyOnly
 *            If true will only load PKey and FKeys field, otherwise load all
 *            columns
 * @param configObjects
 *            netConfigs array, can be entity class, entity, SqlBox or
 *            TableModel instance
 * @return The EntityNet
 */
public static EntityNet createEntityNet(SqlBoxContext ctx, boolean loadKeyOnly, Object... configObjects) {
    if (configObjects == null || configObjects.length == 0)
        throw new EntityNetException("LoadNet() does not support empty netConfigs parameter");
    TableModel[] models = EntityNetUtils.objectConfigsToModels(ctx, configObjects);
    EntityNet net = new EntityNet();
    String starOrSharp = loadKeyOnly ? ".##" : ".**";
    for (TableModel t : models) {
        List<Map<String, Object>> mapList = null;
        String alias = t.getAlias();
        if (StrUtils.isEmpty(alias))
            alias = t.getTableName();
        try {
            mapList = ctx.nQuery(new EntitySqlMapListHandler(t), "select " + alias + starOrSharp + " from " + t.getTableName() + " as " + alias);
        } finally {
            EntityNetUtils.removeBindedTableModel(mapList);
        }
        net.addMapList(mapList, t);
    }
    return net;
}

Example 27 with EntityNet

use of com.github.drinkjava2.jsqlbox.entitynet.EntityNet in project jSqlBox by drinkjava2.

the class PathUtils method getRelationShip.

/**
 * The the relationship between from and to
 */
static Object[] getRelationShip(EntityNet net, Class<?> from, Class<?> to) {
    TableModel fromModel = net.getConfigModels().get(from);
    String fromTable = fromModel.getTableName();
    TableModel toModel = net.getConfigModels().get(to);
    String toTable = toModel.getTableName();
    Object[] result = null;
    // assume from is child, like from is RoleUser, to is UserPOJO
    for (FKeyModel fKeyModel : fromModel.getFkeyConstraints()) {
        String parentTableName = fKeyModel.getRefTableAndColumns()[0];
        if (toTable.equalsIgnoreCase(parentTableName)) {
            if (result != null)
                throw new EntityNetException("Auto path can not determined, multiple relationships found between class " + from + " and " + to);
            result = new Object[3];
            result[0] = "P-";
            result[1] = to;
            String[] refs = fKeyModel.getColumnNames().toArray(new String[fKeyModel.getColumnNames().size()]);
            result[2] = refs;
        }
    }
    // assume to is child, like from is UserPOJO, to is UserRole
    for (FKeyModel fKeyModel : toModel.getFkeyConstraints()) {
        String parentTableName = fKeyModel.getRefTableAndColumns()[0];
        if (fromTable.equalsIgnoreCase(parentTableName)) {
            if (result != null)
                throw new EntityNetException("Auto path can not determined, multiple relationships found between class " + from + " and " + to);
            result = new Object[3];
            result[0] = "C-";
            result[1] = to;
            String[] refs = fKeyModel.getColumnNames().toArray(new String[fKeyModel.getColumnNames().size()]);
            result[2] = refs;
        }
    }
    if (result != null)
        return result;
    throw new EntityNetException("Auto path can not determined, no relationship found between class " + from + " and " + to);
}