Examples of org.datanucleus.store.rdbms.sql.expression.BooleanSubqueryExpression

Package org.datanucleus.store.rdbms.sql.expression

Examples of org.datanucleus.store.rdbms.sql.expression.BooleanSubqueryExpression

org.datanucleus.store.rdbms.sql.expression.BooleanSubqueryExpression
Boolean expression to wrap a subquery. The subquery will be a "SELECT 1 FROM ..." resulting in SQL like
```
{keyword} (SELECT 1 FROM ...)
```
where the keyword is supplied (e.g EXISTS). e.g
```
EXISTS (SELECT 1 FROM TBL WHERE TBL.ID = A0.ID)
```

                // EXISTS expressions need to be Boolean
                if (subquerySqlExpr instanceof org.datanucleus.store.rdbms.sql.expression.SubqueryExpression)
                {
                    SQLStatement subStmt = 
                        ((org.datanucleus.store.rdbms.sql.expression.SubqueryExpression)subquerySqlExpr).getSubqueryStatement();
                    subquerySqlExpr = new BooleanSubqueryExpression(stmt, keyword, subStmt);
                }
                else
                {
                    SQLStatement subStmt = ((SubqueryExpressionComponent)subquerySqlExpr).getSubqueryStatement();
                    subquerySqlExpr = new BooleanSubqueryExpression(stmt, keyword, subStmt);
                }
            }
            else if (subquerySqlExpr instanceof org.datanucleus.store.rdbms.sql.expression.SubqueryExpression)
            {
                SQLStatement subStmt = 
                    ((org.datanucleus.store.rdbms.sql.expression.SubqueryExpression)subquerySqlExpr).getSubqueryStatement();
                subquerySqlExpr = new BooleanSubqueryExpression(stmt, keyword, subStmt);
            }
            else if (subquerySqlExpr instanceof NumericSubqueryExpression)
            {
                // Apply keyword (e.g ALL, SOME, ANY) to numeric expressions
                ((NumericSubqueryExpression)subquerySqlExpr).setKeyword(keyword);

View Full Code Here

                SQLExpression keyIdExpr = exprFactory.newExpression(subStmt, subStmt.getPrimaryTable(), keyMapping);
                subStmt.whereAnd(keyIdExpr.eq(keyExpr), true);
            }
        }


        return new BooleanSubqueryExpression(stmt, "EXISTS", subStmt);
    }

View Full Code Here

        {
            // TODO Support FK array ?
            throw new NucleusException("Dont support evaluation of ARRAY.contains when no join table is used");
        }


        return new BooleanSubqueryExpression(stmt, "EXISTS", subStmt);
    }

View Full Code Here

                // Add restrict to key
                subStmt.whereAnd(keyIdExpr.eq(keyExpr), true);
            }
        }


        return new BooleanSubqueryExpression(stmt, "EXISTS", subStmt);
    }

View Full Code Here

                    subStmt.whereAnd(valIdExpr.eq(valExpr), true);
                }
            }
        }


        return new BooleanSubqueryExpression(stmt, "EXISTS", subStmt);
    }

View Full Code Here

                    elemTbl.getIdMapping());
                subStmt.whereAnd(elemIdExpr.eq(elemExpr), true);
            }
        }


        return new BooleanSubqueryExpression(stmt, "EXISTS", subStmt);
    }

View Full Code Here

TOP

Related Classes of org.datanucleus.store.rdbms.sql.expression.BooleanSubqueryExpression

org.datanucleus.store.rdbms.query.QueryToSQLMapper

org.datanucleus.store.rdbms.sql.method.ArrayContainsMethod

org.datanucleus.store.rdbms.sql.method.CollectionContainsMethod

org.datanucleus.store.rdbms.sql.method.MapContainsEntryMethod

org.datanucleus.store.rdbms.sql.method.MapContainsKeyMethod

org.datanucleus.store.rdbms.sql.method.MapContainsValueMethod

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.