Package com.ptsmods.mysqlw.procedure

Class BlockBuilder

java.lang.Object

com.ptsmods.mysqlw.procedure.BlockBuilder

public final class BlockBuilder
extends Object

Method Summary

Modifier and Type	Method	Description
BlockBuilder	begin()
StatementBlock	buildBlock()
static BlockBuilder	builder()
static BlockBuilder	builder(Database.RDBMS type)
String	buildString()
BlockBuilder	case_(String variable, Consumer<CaseBlock> populator)
BlockBuilder	closeCursor(String cursor)
BlockBuilder	declare(String[] varNames, ColumnStructure<?> type)
BlockBuilder	declare(String varName, ColumnStructure<?> type)
BlockBuilder	declareCondition(String name, ConditionValue conditionValue)
BlockBuilder	declareCursor(String name, SelectBuilder query)
BlockBuilder	declareHandler(DeclareHandlerStmt.HandlerAction action, ConditionValue conditionValue, Statement statement)
BlockBuilder	empty()
BlockBuilder	end(String delimiter)
BlockBuilder	endCase()
BlockBuilder	endLoop()
BlockBuilder	endWhile()
BlockBuilder	fetchCursor(String cursor, String... columns)
List<Statement>	getStatements()
BlockBuilder	ifBlock(Consumer<IfBlock> populator)
BlockBuilder	iterate(String loop)
BlockBuilder	leave(String loop)
BlockBuilder	loop(String name)
BlockBuilder	openCursor(String cursor)
BlockBuilder	raw(String statement)
BlockBuilder	repeat(QueryCondition condition, BlockBuilder builder)
BlockBuilder	repeat(QueryCondition condition, Statement statement)
BlockBuilder	set(String variable, SelectBuilder query)
BlockBuilder	set(String variable, Object value)
BlockBuilder	stmt(int index, Statement statement)
BlockBuilder	stmt(Statement statement)
BlockBuilder	stmts(Statement... statements)
BlockBuilder	stmts(Iterable<Statement> statements)
BlockBuilder	while_(QueryCondition condition)

Methods inherited from class java.lang.Object

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

Method Details

builder

public static BlockBuilder builder()

builder

public static BlockBuilder builder(Database.RDBMS type)

getStatements

public List<Statement> getStatements()

stmt

public BlockBuilder stmt(int index,
 Statement statement)

stmt

public BlockBuilder stmt(Statement statement)

stmts

public BlockBuilder stmts(Statement... statements)

stmts

public BlockBuilder stmts(Iterable<Statement> statements)

raw

public BlockBuilder raw(String statement)

begin

public BlockBuilder begin()

declare

public BlockBuilder declare(String varName,
 ColumnStructure<?> type)

declare

public BlockBuilder declare(String[] varNames,
 ColumnStructure<?> type)

set

public BlockBuilder set(String variable,
 Object value)

set

public BlockBuilder set(String variable,
 SelectBuilder query)

declareHandler

public BlockBuilder declareHandler(DeclareHandlerStmt.HandlerAction action,
 ConditionValue conditionValue,
 Statement statement)

declareCondition

public BlockBuilder declareCondition(String name,
 ConditionValue conditionValue)

declareCursor

public BlockBuilder declareCursor(String name,
 SelectBuilder query)

openCursor

public BlockBuilder openCursor(String cursor)

fetchCursor

public BlockBuilder fetchCursor(String cursor,
 String... columns)

closeCursor

public BlockBuilder closeCursor(String cursor)

loop

public BlockBuilder loop(String name)

repeat

public BlockBuilder repeat(QueryCondition condition,
 Statement statement)

repeat

public BlockBuilder repeat(QueryCondition condition,
 BlockBuilder builder)

while_

public BlockBuilder while_(QueryCondition condition)

iterate

public BlockBuilder iterate(String loop)

leave

public BlockBuilder leave(String loop)

case_

public BlockBuilder case_(String variable,
 Consumer<CaseBlock> populator)

ifBlock

public BlockBuilder ifBlock(Consumer<IfBlock> populator)

endLoop

public BlockBuilder endLoop()

endWhile

public BlockBuilder endWhile()

endCase

public BlockBuilder endCase()

end

public BlockBuilder end(String delimiter)

empty

public BlockBuilder empty()

buildBlock

public StatementBlock buildBlock()

buildString

public String buildString()