com.northconcepts.datapipeline.sql.mysql

Class Insert

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.mysql.MySqlPart

com.northconcepts.datapipeline.sql.mysql.Insert

public class Insert
extends MySqlPart

Generates an INSERT INTO statement for MySQL.

Sample Generated SQL:

INSERT INTO `tableName` (`col1`, `col2`, `col3`)
VALUES (val1, val2, val3),

       (val1, val2, val3),

       (val1, val2, val3),...

Constructor Summary

Constructors

Constructor and Description
Insert(String table)

Method Summary

Modifier and Type	Method and Description
Insert	add(String columnName, Object value)
void	collectSqlFragment(CodeWriter writer)
InsertRow	getLastRow()
List<InsertRow>	getRows()
String	getTable()
Insert	nextRow()
Insert	setPretty(boolean pretty) Indicates if line breaks and indentations should be added to output insert statement (default false). Example output (pretty = true): INSERT INTO `tableName` (`col1`, `col2`, `col3`) VALUES (val1, val2, val3),

Methods inherited from class com.northconcepts.datapipeline.sql.mysql.MySqlPart

escapeKeyword, placeBackTicks

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.SqlPart

collectParameterValues, getParameterValues, getSqlFragment, isPretty, printSqlParts, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

Insert

public Insert(String table)

Method Detail

setPretty

public Insert setPretty(boolean pretty)

Indicates if line breaks and indentations should be added to output insert statement (default false).

Example output (pretty = true):
INSERT INTO `tableName` (`col1`, `col2`, `col3`)
VALUES (val1, val2, val3),

       (val1, val2, val3),

       (val1, val2, val3),...

Example output (pretty = false):
INSERT INTO `tableName` (`col1`, `col2`, `col3`) VALUES (val1, val2, val3), (val1, val2, val3), (val1, val2, val3),...

Overrides:

setPretty in class SqlPart

getTable

public String getTable()

nextRow

public Insert nextRow()

add

public Insert add(String columnName,
                  Object value)

getRows

public List<InsertRow> getRows()

getLastRow

public InsertRow getLastRow()

collectSqlFragment

public void collectSqlFragment(CodeWriter writer)

Specified by:

collectSqlFragment in class SqlPart