Package com.invirgance.convirgance.jdbc.sql

Class BooleanOrStatement<P extends WhereStatement>

java.lang.Object

com.invirgance.convirgance.jdbc.sql.WhereStatement

com.invirgance.convirgance.jdbc.sql.BooleanOrStatement<P>

Type Parameters:

P - The parent WhereStatement type this returns to when done.

All Implemented Interfaces:

ComparisonStatement, SQLStatement

public class BooleanOrStatement<P extends WhereStatement>
extends WhereStatement
implements ComparisonStatement

Creates a logical OR grouping in SQL. This wraps conditions in parentheses and joins them with OR keywords.

 Table table = layout.getCurrentSchema().getTable("customer");
 
 SQLStatement query = table
     .select()
     .column(table.getColumn("name"))
     .where()
         .or() // BooleanOrStatement                             
             .equals(table.getColumn("type"), "fish")
             .equals(table.getColumn("type"), "crustacean")
         .end()
     .done();
 

Author:

jbanes

Constructor Summary

Constructors

Constructor	Description
BooleanOrStatement(DatabaseSchemaLayout layout)

Method Summary

Modifier and Type	Method	Description
SQLStatement	done()
WhereStatement	end()
SQLRenderer	render(SQLRenderer renderer)
WhereStatement	where()

Methods inherited from class com.invirgance.convirgance.jdbc.sql.WhereStatement

and, equals, equals, equals, equals, equals, filter, filter, filter, filter, filter, getClauses, getParent, greaterThan, greaterThan, greaterThan, greaterThan, greaterThan, greaterThanOrEquals, greaterThanOrEquals, greaterThanOrEquals, greaterThanOrEquals, greaterThanOrEquals, isNotNull, isNotNull, isNotNull, isNotNull, isNull, isNull, isNull, isNull, lessThan, lessThan, lessThan, lessThan, lessThan, lessThanOrEquals, lessThanOrEquals, lessThanOrEquals, lessThanOrEquals, lessThanOrEquals, not, notEquals, notEquals, notEquals, notEquals, notEquals, or, setParent, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.invirgance.convirgance.jdbc.sql.SQLStatement

getParent, query, query, setParent

Constructor Details

BooleanOrStatement

public BooleanOrStatement(DatabaseSchemaLayout layout)

Method Details

done

public SQLStatement done()

Overrides:

done in class WhereStatement

end

public WhereStatement end()

Overrides:

end in class WhereStatement

where

public WhereStatement where()

Overrides:

where in class WhereStatement

render

public SQLRenderer render(SQLRenderer renderer)

Specified by:

render in interface SQLStatement

Overrides:

render in class WhereStatement