com.whitestein.lsps.stdlib.function.sqlparser

Class FlywaySqlScript

java.lang.Object

com.whitestein.lsps.stdlib.function.sqlparser.FlywaySqlScript

public class FlywaySqlScript
extends Object

Sql script containing a series of statements terminated by a delimiter (eg: ;). Single-line (--) and multi-line (/* * /) comments are stripped and ignored.

Constructor Summary

Constructors

Constructor and Description
FlywaySqlScript(com.whitestein.flywaydb.core.internal.dbsupport.DbSupport dbSupport, com.whitestein.flywaydb.core.internal.util.scanner.Resource sqlScriptResource, com.whitestein.flywaydb.core.internal.util.PlaceholderReplacer placeholderReplacer, String encoding) Creates a new sql script from this resource.
FlywaySqlScript(String sqlScriptSource, int initialLineNumber, com.whitestein.flywaydb.core.internal.dbsupport.DbSupport dbSupport) Creates a new sql script from this source.

Method Summary

Modifier and Type	Method and Description
void	execute(com.whitestein.flywaydb.core.internal.dbsupport.JdbcTemplate jdbcTemplate) Executes this script against the database.
com.whitestein.flywaydb.core.internal.util.scanner.Resource	getResource()
List<com.whitestein.flywaydb.core.internal.dbsupport.SqlStatement>	getSqlStatements() For increased testability.
protected List<com.whitestein.flywaydb.core.internal.dbsupport.SqlStatement>	linesToStatements(List<String> lines, int initialLineNumber) Turns these lines in a series of statements.

Methods inherited from class java.lang.Object

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

Constructor Detail

FlywaySqlScript

public FlywaySqlScript(String sqlScriptSource,
                       int initialLineNumber,
                       com.whitestein.flywaydb.core.internal.dbsupport.DbSupport dbSupport)

Creates a new sql script from this source.

Parameters:

sqlScriptSource - The sql script as a text block with all placeholders already replaced.

initialLineNumber -

dbSupport - The database-specific support.

FlywaySqlScript

public FlywaySqlScript(com.whitestein.flywaydb.core.internal.dbsupport.DbSupport dbSupport,
                       com.whitestein.flywaydb.core.internal.util.scanner.Resource sqlScriptResource,
                       com.whitestein.flywaydb.core.internal.util.PlaceholderReplacer placeholderReplacer,
                       String encoding)

Creates a new sql script from this resource.

Parameters:

dbSupport - The database-specific support.

sqlScriptResource - The resource containing the statements.

placeholderReplacer - The placeholder replacer.

encoding - The encoding to use.

Method Detail

getSqlStatements

public List<com.whitestein.flywaydb.core.internal.dbsupport.SqlStatement> getSqlStatements()

For increased testability.

Returns:

The sql statements contained in this script.

getResource

public com.whitestein.flywaydb.core.internal.util.scanner.Resource getResource()

Returns:

The resource containing the statements.

execute

public void execute(com.whitestein.flywaydb.core.internal.dbsupport.JdbcTemplate jdbcTemplate)

Executes this script against the database.

Parameters:

jdbcTemplate - The jdbc template to use to execute this script.

linesToStatements

protected List<com.whitestein.flywaydb.core.internal.dbsupport.SqlStatement> linesToStatements(List<String> lines,
                                                                                               int initialLineNumber)

Turns these lines in a series of statements.

Parameters:

lines - The lines to analyse.

initialLineNumber -

Returns:

The statements contained in these lines (in order).