com.goldencode.p2j.persist.deploy

Class MariaDbScriptRunner

java.lang.Object

com.goldencode.p2j.persist.deploy.ScriptRunner

com.goldencode.p2j.persist.deploy.MariaDbScriptRunner

public class MariaDbScriptRunner
extends ScriptRunner

Run SQL script against the MariaDB database

Nested Class Summary

Nested classes/interfaces inherited from class com.goldencode.p2j.persist.deploy.ScriptRunner

ScriptRunner.ScriptType

Field Summary

Fields

Modifier and Type	Field and Description
private static java.util.List<java.lang.String>	COUNT PostgreSQL query for counting the number of UDFs with a spicefic name.
private static java.util.regex.Pattern	JDBC pattern for the MaridDBC URL parsing

Fields inherited from class com.goldencode.p2j.persist.deploy.ScriptRunner

dialect, LOG, placeholders, scripts, scriptType, usePlaceholders

Constructor Summary

Constructors

Constructor and Description
MariaDbScriptRunner(Dialect dialect) Constructor.

Method Summary

Modifier and Type	Method and Description
protected void	applyUdfScripts(java.sql.Connection conn) Apply SQL scripts.
private int	countUDFs(java.sql.Connection conn, java.lang.String schema, java.lang.String name) Count number of UDFs with a given name.
protected void	createMissingUdfs(java.lang.String dbname, java.lang.String url, java.lang.String adm, java.lang.String pwd) Check for missing UDFs and create them.
protected java.util.List<java.lang.String>	defaultUdfScripts() Provide a list of default UDF scripts

Methods inherited from class com.goldencode.p2j.persist.deploy.ScriptRunner

addScriptPath, applyDDLScripts, applyPlaceholders, applySchema, applyScripts, createMissingUdfs, execute, main, makeScripts, parseCmdLine, supportsUdfScripts

Methods inherited from class java.lang.Object

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

Field Detail

JDBC

private static final java.util.regex.Pattern JDBC

pattern for the MaridDBC URL parsing

COUNT

private static final java.util.List<java.lang.String> COUNT

PostgreSQL query for counting the number of UDFs with a spicefic name.

Constructor Detail

MariaDbScriptRunner

public MariaDbScriptRunner(Dialect dialect)

Constructor.

Parameters:

dialect - The target database dialect

Method Detail

defaultUdfScripts

protected java.util.List<java.lang.String> defaultUdfScripts()

Provide a list of default UDF scripts

Overrides:

defaultUdfScripts in class ScriptRunner

Returns:

the list of default UDF scripts;

applyUdfScripts

protected void applyUdfScripts(java.sql.Connection conn)
                        throws java.sql.SQLException,
                               java.io.IOException

Apply SQL scripts.

Specified by:

applyUdfScripts in class ScriptRunner

Parameters:

conn - Database connection.

Throws:

java.sql.SQLException - on SQL error.

java.io.IOException - on script reading error.

createMissingUdfs

protected void createMissingUdfs(java.lang.String dbname,
                                 java.lang.String url,
                                 java.lang.String adm,
                                 java.lang.String pwd)
                          throws java.sql.SQLException,
                                 PersistenceException

Check for missing UDFs and create them.

Specified by:

createMissingUdfs in class ScriptRunner

Parameters:

dbname - Database name.

url - Database JDBC URL.

adm - Admin login.

pwd - Admin password.

Throws:

java.sql.SQLException - on SQL error.

PersistenceException - on script reading error.

countUDFs

private int countUDFs(java.sql.Connection conn,
                      java.lang.String schema,
                      java.lang.String name)
               throws java.sql.SQLException

Count number of UDFs with a given name.

Parameters:

conn - The database connection.

schema - Schema name.

name - UDF name.

Returns:

number of UDFs with a given name.

Throws:

java.sql.SQLException - On error.