com.github.noraui.data.db

Class DBDataProvider

java.lang.Object

com.github.noraui.data.CommonDataProvider

com.github.noraui.data.db.DBDataProvider

All Implemented Interfaces:

DataInputProvider, DataProvider

public class DBDataProvider
extends CommonDataProvider
implements DataInputProvider

Nested Class Summary

Nested classes/interfaces inherited from class com.github.noraui.data.CommonDataProvider

CommonDataProvider.ResultColumnNames

Nested classes/interfaces inherited from interface com.github.noraui.data.DataProvider

DataProvider.type

Field Summary

Fields inherited from class com.github.noraui.data.CommonDataProvider

columns, dataInPath, dataOutPath, indexData, resultColumnName, scenarioName

Constructor Summary

Constructors

Constructor and Description
DBDataProvider(String type, String user, String password, String hostname, String port, String database)

Method Summary

Modifier and Type	Method and Description
Connection	getConnection()
int	getNbLines() Gets the number of readable lines of current opened file.
void	prepare(String scenario)
String[]	readLine(int line, boolean readResult)
String	readValue(String column, int line) Reads a cell of opened input file.
protected static void	sqlSanitized4readOnly(String sqlInput)

Methods inherited from class com.github.noraui.data.CommonDataProvider

getIndexData, getModel, getNbGherkinExample, getResultColumnName, isResultColumnNameAuthorized, setDataInPath, setDataOutPath, setIndexData, writeDataResult, writeFailedResult, writeSuccessResult, writeValue, writeWarningResult

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.github.noraui.data.DataProvider

getIndexData, getModel, getNbGherkinExample, getResultColumnName, isResultColumnNameAuthorized, setDataInPath, setDataOutPath, setIndexData

Constructor Detail

DBDataProvider

public DBDataProvider(String type,
                      String user,
                      String password,
                      String hostname,
                      String port,
                      String database)
               throws TechnicalException

Throws:

TechnicalException

Method Detail

getConnection

public Connection getConnection()
                         throws SQLException

Throws:

SQLException

prepare

public void prepare(String scenario)
             throws TechnicalException

Specified by:

prepare in interface DataProvider

Throws:

TechnicalException

getNbLines

public int getNbLines()
               throws TechnicalException

Gets the number of readable lines of current opened file. If a line does not contain 'ID' column of if it is empty, then the line is not taken into account.

Specified by:

getNbLines in interface DataInputProvider

Returns:

number of opened input file

Throws:

TechnicalException - is thrown if you have a technical error (IOException on .sql file) in NoraUi.

readValue

public String readValue(String column,
                        int line)
                 throws TechnicalException

Reads a cell of opened input file.

Specified by:

readValue in interface DataInputProvider

Parameters:

column - index of the column to read

line - index of the line to read

Returns:

a String with the value of cell

Throws:

TechnicalException - is thrown if you have a technical error (IOException on .sql file) in NoraUi.

readLine

public String[] readLine(int line,
                         boolean readResult)
                  throws TechnicalException

Specified by:

readLine in interface DataInputProvider

Parameters:

line - id of the line to read (line=0 for reading headers ; line=1 for reading 1st line, ...)

readResult - true if result must be returned, false otherwise

Returns:

all content of read line split by cell in a String array

Throws:

TechnicalException - is thrown if you have a technical error (IOException on .sql file) in NoraUi.

sqlSanitized4readOnly

protected static void sqlSanitized4readOnly(String sqlInput)
                                     throws TechnicalException

Throws:

TechnicalException