Package org.openrefine.extension.database.mysql

Class MySQLDatabaseService

java.lang.Object

org.openrefine.extension.database.DatabaseService

org.openrefine.extension.database.mysql.MySQLDatabaseService

public class MySQLDatabaseService
extends DatabaseService

Nested Class Summary

Nested classes/interfaces inherited from class org.openrefine.extension.database.DatabaseService

DatabaseService.DBType

Field Summary

Fields

Modifier and Type	Field	Description
static String	DB_DRIVER
static String	DB_NAME

Method Summary

Modifier and Type	Method	Description
DatabaseInfo	connect(DatabaseConfiguration dbConfig)
DatabaseInfo	executeQuery(DatabaseConfiguration dbConfig, String query)
ArrayList<DatabaseColumn>	getColumns(DatabaseConfiguration dbConfig, String query)
Connection	getConnection(DatabaseConfiguration dbConfig)
protected String	getDatabaseUrl(DatabaseConfiguration dbConfig)
static MySQLDatabaseService	getInstance()
List<DatabaseRow>	getRows(DatabaseConfiguration dbConfig, String query)
boolean	testConnection(DatabaseConfiguration dbConfig)
DatabaseInfo	testQuery(DatabaseConfiguration dbConfig, String query)

Methods inherited from class org.openrefine.extension.database.DatabaseService

buildLimitQuery, get

Methods inherited from class java.lang.Object

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

Field Detail

DB_NAME

public static final String DB_NAME

See Also:

Constant Field Values

DB_DRIVER

public static final String DB_DRIVER

See Also:

Constant Field Values

Method Detail

getInstance

public static MySQLDatabaseService getInstance()

testConnection

public boolean testConnection(DatabaseConfiguration dbConfig)
                       throws DatabaseServiceException

Specified by:

testConnection in class DatabaseService

Throws:

DatabaseServiceException

connect

public DatabaseInfo connect(DatabaseConfiguration dbConfig)
                     throws DatabaseServiceException

Specified by:

connect in class DatabaseService

Throws:

DatabaseServiceException

executeQuery

public DatabaseInfo executeQuery(DatabaseConfiguration dbConfig,
                                 String query)
                          throws DatabaseServiceException

Specified by:

executeQuery in class DatabaseService

Throws:

DatabaseServiceException

getColumns

public ArrayList<DatabaseColumn> getColumns(DatabaseConfiguration dbConfig,
                                            String query)
                                     throws DatabaseServiceException

Specified by:

getColumns in class DatabaseService

Throws:

DatabaseServiceException

getRows

public List<DatabaseRow> getRows(DatabaseConfiguration dbConfig,
                                 String query)
                          throws DatabaseServiceException

Specified by:

getRows in class DatabaseService

Throws:

DatabaseServiceException

getDatabaseUrl

protected String getDatabaseUrl(DatabaseConfiguration dbConfig)

Overrides:

getDatabaseUrl in class DatabaseService

getConnection

public Connection getConnection(DatabaseConfiguration dbConfig)
                         throws DatabaseServiceException

Specified by:

getConnection in class DatabaseService

Throws:

DatabaseServiceException

testQuery

public DatabaseInfo testQuery(DatabaseConfiguration dbConfig,
                              String query)
                       throws DatabaseServiceException

Specified by:

testQuery in class DatabaseService

Throws:

DatabaseServiceException