Package com.hp.hpl.jena.sdb.core.sqlexpr

Examples of com.hp.hpl.jena.sdb.core.sqlexpr.SqlColumn

113
114
115
116
117
118
119
120
121
122
123
124
125
            // Access nodes table.
            SqlTable nTable = new SqlTable(getRequest().genId(NodeConstBase),
                                           nodeTableDesc.getTableName()) ;
           
            nTable.addNote("Const: "+FmtUtils.stringForNode(n, getRequest().getPrefixMapping())) ;
            SqlColumn cHash = new SqlColumn(nTable, nodeTableDesc.getHashColName()) ;
            // Record
            constantCols.put(n, new SqlColumn(nTable, nodeTableDesc.getIdColName())) ;
            SqlExpr c = new S_Equal(cHash, hashValue) ;
            sqlNode = SqlBuilder.innerJoin(getRequest(), sqlNode, nTable) ;
            sqlNode = SqlBuilder.restrict(getRequest(), sqlNode, c)  ;
        }
        return sqlNode ;
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
       
        for ( Var v : sqlNode.getCoalesceVars()  )
        {
            if ( ! first ) out.print(" ") ;
            first = false ;
            SqlColumn col = sqlNode.getIdScope().findScopeForVar(v).getColumn() ;
            out.print(v.toString()) ;
            SqlColumn leftCol = join.getLeft().getIdScope().findScopeForVar(v).getColumn() ;
            SqlColumn rightCol = join.getRight().getIdScope().findScopeForVar(v).getColumn() ;
            out.print("["+leftCol+"/"+rightCol+"]") ;
        }
        for ( Var v : sqlNode.getNonCoalesceVars()  )
        {
            if ( ! first ) out.print(" ") ;
            first = false ;
            out.print(v.toString()) ;
            // and where is came from.
            SqlColumn col = join.getIdScope().findScopeForVar(v).getColumn() ;
            out.print("["+col+"]") ;
        }
       
        out.ensureStartOfLine() ;
        visitJoin(sqlNode.getJoinNode()) ;
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
    {
        String str = "" ;
        String sep = "" ;
        for ( Var v : frame.keySet() )
        {
            SqlColumn c = frame.get(v) ;
            str = str + sep + v + ":"+c ;
            sep = " " ;
        }
        if ( parent != null )
            str = str + "=>" + parent.toString() ;
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
    }
   
    @Override
    protected SqlColumn getLexSqlColumn(SqlTable table) {
       
        return new SqlColumn(table, "lex") {
            @Override
            public String getFullColumnName() {
                String col = getTable().getAliasName()+"."+getColumnName();
                return  "CASE WHEN LENGTH("+col+
                        ") <= 2000 THEN NULL ELSE "+col+" END";             
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
    }
   
    @Override
    protected SqlColumn getLexNCharSqlColumn(SqlTable table) {
       
        return new SqlColumn(table, "lexNChar") {
            @Override
            public String getFullColumnName() {
                String col = getTable().getAliasName()+".lex";
                return "CASE WHEN LENGTH("+col+") <= 2000 THEN TO_NCHAR("+
                       col+") ELSE NULL END ";             
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
                return expr ;

            // Find the column for this variable.
            ScopeEntry sc = ssb.getNodeScope().findScopeForVar(v) ;
            // Get the lexical column : this is layout2 specific.
            SqlColumn col = new SqlColumn(sc.getColumn().getTable(), "lex") ;
           
            S_Like sreg = new S_Like(col, patternLike, caseInsensitive) ;
            ssb.getConditions().add(sreg) ;
           
            // Completely replace the filter - so remove from OpFilter.
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
   
    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 ;
     }
View Full Code Here
122
123
124
125
126
127
128
   
    protected void addProject(SqlColumn col, String colOutName)
    {
        sqlNode = SqlBuilder.project(request,
                                     sqlNode,
                                     new ColAlias(col, new SqlColumn(null, colOutName))) ;
    }
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
            if ( e == null )
            {
                // Should be a column mentioned in the SELECT which is not mentioned in this block
                continue ;
            }
            SqlColumn vCol = e.getColumn() ;
   
            SqlTable table = vCol.getTable() ;
            String sqlVarName = allocSqlName(v) ;
           
            // Need to allocate aliases because otherwise we need to access
            // "table.column" as a label and "." is illegal in a label

            String vLex = SQLUtils.gen(sqlVarName,"lex") ;
            // Call overrideable helper method for lex column (Oracle)
            SqlColumn cLex = getLexSqlColumn(table);

            String vLexNChar = SQLUtils.gen(sqlVarName,"lexNChar") ;
            // Call overrideable helper method for lex column (Oracle)
            SqlColumn cLexNChar = getLexNCharSqlColumn(table);
   
            String vDatatype = SQLUtils.gen(sqlVarName,"datatype") ;
            SqlColumn cDatatype = new SqlColumn(table, "datatype") ;
   
            String vLang = SQLUtils.gen(sqlVarName,"lang") ;
            SqlColumn cLang = new SqlColumn(table, "lang") ;
   
            String vType = SQLUtils.gen(sqlVarName,"type") ;
            SqlColumn cType = new SqlColumn(table, "type") ;
   
            addProject(cLex, vLex) ;
            // Oracle NCLOB support
            if (cLexNChar != null) {
                addProject(cLexNChar, vLexNChar);
View Full Code Here
128
129
130
131
132
133
134
     * @param table
     * @author skagels
     *
     */
    protected SqlColumn getLexSqlColumn(SqlTable table) {
        return new SqlColumn(table, "lex") ;
    }
View Full Code Here
TOP

Related Classes of com.hp.hpl.jena.sdb.core.sqlexpr.SqlColumn

  • com.hp.hpl.jena.sdb.compiler.PatternTable$SqlStagePatternTable
  • com.hp.hpl.jena.sdb.compiler.SlotCompiler
  • com.hp.hpl.jena.sdb.compiler.TransformSDB
  • com.hp.hpl.jena.sdb.core.ScopeBase
  • com.hp.hpl.jena.sdb.core.sqlnode.GenerateSQLVisitor
  • com.hp.hpl.jena.sdb.core.sqlnode.SqlCoalesce
  • com.hp.hpl.jena.sdb.core.sqlnode.SqlNodeTextVisitor
  • com.hp.hpl.jena.sdb.core.sqlnode.SqlProject
  • com.hp.hpl.jena.sdb.core.sqlnode.SqlRename
  • com.hp.hpl.jena.sdb.core.sqlnode.SqlSelectBlock
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.