Package com.invirgance.convirgance.jdbc.sql

Class BooleanNotStatement<P extends WhereStatement>

java.lang.Object

com.invirgance.convirgance.jdbc.sql.WhereStatement

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

Type Parameters:

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

All Implemented Interfaces:

ComparisonStatement, SQLStatement

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

Creates a logical NOT operator in SQL, negating the conditions it contains. This prepends NOT to a condition or group of conditions joined with AND.

 Table table = layout.getCurrentSchema().getTable("customer");
 
 SQLStatement query = table
     .select()
     .column(table.getColumn("name"))
     .where()
         .not() // BooleanNotStatement
             .equals(table.getColumn("type"), value)
             .greaterThan(table.getColumn("height"), value)
         .end()
     .done();
 

Author:

jbanes

Constructor Summary

Constructors

Constructor	Description
BooleanNotStatement(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

BooleanNotStatement

public BooleanNotStatement(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