Package net.bugreaper.modules.db.jdbc.builders

Class QueryBuilder

java.lang.Object

net.bugreaper.modules.db.jdbc.builders.QueryConditionsBuilder

net.bugreaper.modules.db.jdbc.builders.QueryBuilder

public class QueryBuilder
extends QueryConditionsBuilder

Class with builders from arrays (Object[][]) to sql scripts

Constructor Summary

Constructors

Constructor	Description
QueryBuilder(String dbType)

Method Summary

Modifier and Type	Method	Description
String	sqlConditionBuilder(Object[][] conditionsArray)	Create sql script from array (Object[][]) for conditions
String	sqlInsertBuilder(String tableName, Object[][] templateArray, Object[][] providedArray)	Create sql script from arrays for Insert
String	sqlSetBuilder(Object[][] setArray)	Create sql script from array (Object[][]) for conditions

Methods inherited from class net.bugreaper.modules.db.jdbc.builders.QueryConditionsBuilder

arrayCondition2Mapper, arrayCondition3Mapper, arrayCondition4Mapper

Methods inherited from class java.lang.Object

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

Constructor Details

QueryBuilder

public QueryBuilder(String dbType)

Method Details

sqlSetBuilder

public String sqlSetBuilder(Object[][] setArray)

Create sql script from array (Object[][]) for conditions

Parameters:

setArray - array with conditions: {condition array: {column1, value1 }...}

Returns:

condition part: " SET column1 =\is value1 AND ..."

sqlConditionBuilder

public String sqlConditionBuilder(Object[][] conditionsArray)

Create sql script from array (Object[][]) for conditions

Parameters:

conditionsArray - array with conditions: {condition array: {column1, value1 }...}

Returns:

condition part: " where column1 =\is value1, ..."

sqlInsertBuilder

public String sqlInsertBuilder(String tableName,
 Object[][] templateArray,
 Object[][] providedArray)

Create sql script from arrays for Insert

Parameters:

tableName - table name with schema (SCHEMA.TABLE1)

templateArray - array with table template {{column1, value1 }...}

providedArray - array with data from test case {{column1, test_value1 }...}

Returns:

String with sql script (INSERT INTO SCHEMA.TABLE1 (column1,...) VALUES (value1,...))