SqlExprBuilder (OpenRDF Sesame 2.7.13 API)

java.lang.Object
- org.openrdf.sail.rdbms.evaluation.SqlExprBuilder

Direct Known Subclasses:

SqlBracketBuilder, SqlCastBuilder
```
public class SqlExprBuilder
extends Object
```
Assemblies an SQL expression.

Author:

James Leigh

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

protected class SqlExprBuilder.Mark

Nested Classes
Modifier and Type	Class and Description
`protected class`	`SqlExprBuilder.Mark`

Constructor Summary

Constructors
Constructor and Description

SqlExprBuilder(QueryBuilderFactory factory)

Constructors
Constructor and Description
`SqlExprBuilder(QueryBuilderFactory factory)`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`SqlBracketBuilder`	`abs()`
`protected void`	`addParameters(List<Object> params)`
`SqlExprBuilder`	`and()`
`SqlExprBuilder`	`append(CharSequence sql)`
`void`	`appendBoolean(boolean booleanValue)`
`SqlExprBuilder`	`appendNull()`
`SqlExprBuilder`	`appendNumeric(Number doubleValue)`
`void`	`appendOperator(SqlCompare.Operator op)`
`void`	`as(String column)`
`SqlCaseBuilder`	`caseBegin()`
`SqlCastBuilder`	`cast(int jdbcType)`
`SqlExprBuilder`	`column(String alias, String column)`
`SqlExprBuilder`	`columnEquals(String alias, String column, Number id)`
`SqlExprBuilder`	`columnEquals(String alias, String column, String label)`
`SqlExprBuilder`	`columnIn(String alias, String column, Number[] ids)`
`SqlExprBuilder`	`columnsEqual(String al1, String col1, String al2, String col2)`
`void`	`concat()`
`SqlExprBuilder`	`eq()`
`List<Object>`	`getParameters()`
`protected String`	`getSqlNull()`
`boolean`	`isEmpty()`
`SqlExprBuilder`	`isNotNull()`
`SqlExprBuilder`	`isNull()`
`void`	`like()`
`SqlBracketBuilder`	`lowerCase()`
`protected SqlExprBuilder.Mark`	`mark()`
`void`	`math(MathExpr.MathOp op)`
`SqlBracketBuilder`	`mod(int value)`
`SqlBracketBuilder`	`not()`
`SqlExprBuilder`	`notEqual()`
`SqlExprBuilder`	`number(Number time)`
`SqlBracketBuilder`	`open()`
`SqlExprBuilder`	`or()`
`void`	`plus(int range)`
`SqlRegexBuilder`	`regex()`
`protected void`	`reset(SqlExprBuilder.Mark mark)`
`void`	`rightShift(int rightShift)`
`CharSequence`	`toSql()`
`String`	`toString()`
`SqlExprBuilder`	`varchar(String stringValue)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

SqlExprBuilder

public SqlExprBuilder(QueryBuilderFactory factory)

Method Detail

abs
```
public SqlBracketBuilder abs()
```

and
```
public SqlExprBuilder and()
```

append

public SqlExprBuilder append(CharSequence sql)

appendBoolean

public void appendBoolean(boolean booleanValue)

appendNull
```
public SqlExprBuilder appendNull()
```

appendNumeric

public SqlExprBuilder appendNumeric(Number doubleValue)

appendOperator

public void appendOperator(SqlCompare.Operator op)

as
```
public void as(String column)
```

number

public SqlExprBuilder number(Number time)

caseBegin
```
public SqlCaseBuilder caseBegin()
```

cast

public SqlCastBuilder cast(int jdbcType)

column

public SqlExprBuilder column(String alias,
                             String column)

columnEquals

public SqlExprBuilder columnEquals(String alias,
                                   String column,
                                   Number id)

columnEquals

public SqlExprBuilder columnEquals(String alias,
                                   String column,
                                   String label)

columnIn

public SqlExprBuilder columnIn(String alias,
                               String column,
                               Number[] ids)

columnsEqual

public SqlExprBuilder columnsEqual(String al1,
                                   String col1,
                                   String al2,
                                   String col2)

concat
```
public void concat()
```

eq
```
public SqlExprBuilder eq()
```

getParameters
```
public List<Object> getParameters()
```

isEmpty
```
public boolean isEmpty()
```

isNotNull
```
public SqlExprBuilder isNotNull()
```

isNull
```
public SqlExprBuilder isNull()
```

like
```
public void like()
```

lowerCase
```
public SqlBracketBuilder lowerCase()
```

math
```
public void math(MathExpr.MathOp op)
```

mod

public SqlBracketBuilder mod(int value)

not
```
public SqlBracketBuilder not()
```

notEqual
```
public SqlExprBuilder notEqual()
```

open
```
public SqlBracketBuilder open()
```

or
```
public SqlExprBuilder or()
```

plus
```
public void plus(int range)
```

regex
```
public SqlRegexBuilder regex()
```

rightShift

public void rightShift(int rightShift)

toSql
```
public CharSequence toSql()
```

toString
```
public String toString()
```
Overrides:

toString in class Object

varchar

public SqlExprBuilder varchar(String stringValue)

addParameters

protected void addParameters(List<Object> params)

getSqlNull
```
protected String getSqlNull()
```

mark
```
protected SqlExprBuilder.Mark mark()
```

reset

protected void reset(SqlExprBuilder.Mark mark)

Class SqlExprBuilder

Nested Class Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Constructor Detail

SqlExprBuilder

Method Detail

abs

and

append

appendBoolean

appendNull

appendNumeric

appendOperator

as

number

caseBegin

cast

column

columnEquals

columnEquals

columnIn

columnsEqual

concat

eq

getParameters

isEmpty

isNotNull

isNull

like

lowerCase

math

mod

not

notEqual

open

or

plus

regex

rightShift

toSql

toString

varchar

addParameters

getSqlNull

mark

reset