ch.so.agi.gretl.steps

Class JsonImportStep

java.lang.Object

ch.so.agi.gretl.steps.JsonImportStep

public class JsonImportStep
extends java.lang.Object

The JsonImportStep class is used to import a JSON file into a text column of a database.

Constructor Summary

Constructors

Constructor and Description
JsonImportStep()
JsonImportStep(java.lang.String taskName)

Method Summary

Modifier and Type	Method and Description
void	execute(Connector targetDb, java.io.File jsonFile, java.lang.String qualifiedTableName, java.lang.String columnName, boolean deleteAllRows) Imports the json file into a database text column.

Methods inherited from class java.lang.Object

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

Constructor Detail

JsonImportStep

public JsonImportStep()

JsonImportStep

public JsonImportStep(java.lang.String taskName)

Method Detail

execute

public void execute(Connector targetDb,
                    java.io.File jsonFile,
                    java.lang.String qualifiedTableName,
                    java.lang.String columnName,
                    boolean deleteAllRows)
             throws java.lang.Exception

Imports the json file into a database text column. A top level json array will be splitted into database records.

Parameters:

targetDb - Database properties to generate database connection

jsonFile - File containing json string

qualifiedTableName - The qualified table name

columnName - The name of the database text column where the json text will be stored

deleteAllRows - Delete all records from the table before importing new data

Throws:

java.lang.Exception - if file is missing, no correct extension, no connection to database, could not read file or problems while executing sql-queries