Package org.openrefine.exporters.sql

Class SqlInsertBuilder

java.lang.Object

org.openrefine.exporters.sql.SqlInsertBuilder

public class SqlInsertBuilder
extends Object

Constructor Summary

Constructors

Constructor	Description
SqlInsertBuilder(String table, List<String> columns, List<ArrayList<SqlData>> rows, com.fasterxml.jackson.databind.JsonNode sqlOptions)

Method Summary

Modifier and Type	Method	Description
String	getInsertSQL()	Get Insert Sql
void	handleNullField(boolean allowNullChkBox, String defaultValue, boolean nullValueNull, String col, StringBuilder rowValue, boolean quote)

Methods inherited from class java.lang.Object

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

Constructor Detail

SqlInsertBuilder

public SqlInsertBuilder(String table,
                        List<String> columns,
                        List<ArrayList<SqlData>> rows,
                        com.fasterxml.jackson.databind.JsonNode sqlOptions)

Parameters:

table -

columns -

rows -

sqlOptions -

Method Detail

getInsertSQL

public String getInsertSQL()

Get Insert Sql

Returns:

handleNullField

public void handleNullField(boolean allowNullChkBox,
                            String defaultValue,
                            boolean nullValueNull,
                            String col,
                            StringBuilder rowValue,
                            boolean quote)

Parameters:

allowNullChkBox -

defaultValue -

nullValueNull -

col -

rowValue -

quote -