Examples with SqlExpr org.apache.jena.sdb.core.sqlexpr.SqlExpr used on opensource projects

Example 1 with SqlExpr

use of org.apache.jena.sdb.core.sqlexpr.SqlExpr in project jena by apache.

the class SlotCompiler method processSlot.

public final void processSlot(SDBRequest request, SqlTable table, SqlExprList conditions, Node node, String colName) {
    SqlColumn thisCol = new SqlColumn(table, colName);
    if (!node.isVariable()) {
        constantSlot(request, node, thisCol, conditions);
        return;
    }
    Var var = Var.alloc(node);
    if (table.getIdScope().hasColumnForVar(var)) {
        ScopeEntry e = table.getIdScope().findScopeForVar(var);
        SqlColumn otherCol = e.getColumn();
        SqlExpr c = new S_Equal(otherCol, thisCol);
        conditions.add(c);
        c.addNote("processVar: " + node);
        return;
    }
    table.setIdColumnForVar(var, thisCol);
}

Example 2 with SqlExpr

use of org.apache.jena.sdb.core.sqlexpr.SqlExpr in project jena by apache.

the class SqlNodeTextVisitor method outputConditionList.

private void outputConditionList(Collection<SqlExpr> cond) {
    boolean first = true;
    for (SqlExpr c : cond) {
        out.println();
        first = false;
        out.print(DelimOpen);
        out.print("Condition ");
        out.print(c.toString());
        addAnnotations(c);
        out.print(DelimClose);
    }
}

Example 3 with SqlExpr

use of org.apache.jena.sdb.core.sqlexpr.SqlExpr in project jena by apache.

the class SQLBridge2 method insertValueGetter.

private SqlNode insertValueGetter(SDBRequest request, SqlNode sqlNode, Var var) {
    ScopeEntry e1 = sqlNode.getIdScope().findScopeForVar(var);
    if (e1 == null) {
        // Debug.
        Scope scope = sqlNode.getIdScope();
        // Variable not actually in results.
        return sqlNode;
    }
    // Already in scope (from a condition)?
    ScopeEntry e2 = sqlNode.getNodeScope().findScopeForVar(var);
    if (e2 != null)
        // Already there
        return sqlNode;
    SqlColumn c1 = e1.getColumn();
    // Not in scope -- add a table to get it
    TableDescNodes nodeTableDesc = request.getStore().getNodeTableDesc();
    String tableAlias = request.genId(NodeBase);
    SqlTable nTable = new SqlTable(tableAlias, nodeTableDesc.getTableName());
    String nodeKeyColName = nodeTableDesc.getNodeRefColName();
    SqlColumn c2 = new SqlColumn(nTable, nodeKeyColName);
    nTable.setValueColumnForVar(var, c2);
    // Condition for value: triple table column = node table id/hash 
    nTable.addNote("Var: " + var);
    SqlExpr cond = new S_Equal(c1, c2);
    SqlNode n = SqlBuilder.leftJoin(request, sqlNode, nTable, cond);
    return n;
}

Example 4 with SqlExpr

use of org.apache.jena.sdb.core.sqlexpr.SqlExpr in project jena by apache.

the class GenerateSQLVisitor method conditionList.

public void conditionList(SqlExprList conditions) {
    if (conditions.size() == 0)
        return;
    out.print("( ");
    String sep = "  AND ";
    boolean first = true;
    boolean lastAnnotated = false;
    for (SqlExpr c : conditions) {
        if (!first) {
            if (!allOnOneLine)
                out.println();
            out.print(sep);
        }
        boolean needsParens = !(c instanceof S_Equal);
        // TODO Interact with SqlExpr precedence printing
        if (needsParens)
            out.print("( ");
        out.print(c.asSQL());
        if (needsParens)
            out.print(" )");
        if (!allOnOneLine)
            lastAnnotated = annotate(c);
        first = false;
    }
    if (!allOnOneLine && lastAnnotated)
        out.println("");
    out.print(" )");
    first = true;
    if (allOnOneLine) {
        for (SqlExpr c : conditions) {
            if (c.hasNotes()) {
                if (!first)
                    out.println();
                annotate(c);
                first = false;
            }
        }
    }
}

Example 5 with SqlExpr

use of org.apache.jena.sdb.core.sqlexpr.SqlExpr in project jena by apache.

the class GenerateSQLVisitor method rewrite.

public SqlJoinInner rewrite(SqlJoinInner join) {
    if (!join.getRight().isInnerJoin())
        return join;
    // if ( join(A, join(B, C)) ) rewrite as join(join(A,B),C)
    // this then is written without brackets (and so scope changing)
    // TODO abstract as organiseJoin(List<join elements>)
    // and remember to do top down to find maximal join trees
    SqlJoinInner right = join.getRight().asInnerJoin();
    String alias1 = join.getAliasName();
    String alias2 = right.getAliasName();
    SqlNode sn_a = join.getLeft();
    SqlNode sn_b = right.getLeft();
    SqlNode sn_c = right.getRight();
    SqlExprList conditions = new SqlExprList(join.getConditions());
    conditions.addAll(right.getConditions());
    Set<SqlTable> tables_ab = sn_a.tablesInvolved();
    tables_ab.addAll(sn_b.tablesInvolved());
    // Goes to new join(A,B)
    SqlExprList newCond_ab = new SqlExprList();
    // Goes to new join(,C)
    SqlExprList newCond_c = new SqlExprList();
    // Place conditions
    for (SqlExpr e : conditions) {
        Set<SqlColumn> cols = e.getColumnsNeeded();
        // columns to tables.
        Set<SqlTable> tables = tables(cols);
        // Are the tables contained in tables_ab?
        tables.removeAll(tables_ab);
        if (tables.size() == 0)
            newCond_ab.add(e);
        else
            newCond_c.add(e);
    }
    if (newCond_ab.size() + newCond_c.size() != conditions.size())
        log.error(String.format("Conditions mismatch: (%d,%d,%d)", newCond_ab.size(), newCond_c.size(), conditions.size()));
    SqlJoinInner join2 = new SqlJoinInner(sn_a, sn_b);
    join2.addConditions(newCond_ab);
    join2 = new SqlJoinInner(join2, sn_c);
    join2.addConditions(newCond_c);
    return join2;
}