Package io.ebean

Interface ScriptRunner

public interface ScriptRunner
Runs DDL and SQL scripts.

Typically these are scripts used for testing such as seed SQL scripts or truncate SQL scripts.

Scripts are executed in their own transaction and committed on successful completion.

Example of simple use



   Database database = DB.getDefault();
   database.script().run("/scripts/test-script.sql");

  • Method Summary

    Modifier and Type
    Method
    Description
    void
    run​(String path)
    Run a script given the resource path (that should start with "/").
    void
    run​(String path, Map<String,​String> placeholderMap)
    Run a script given the resource path (that should start with "/") and place holders.
    void
    run​(URL resource)
    Run a DDL or SQL script given the resource.
    void
    run​(URL resource, Map<String,​String> placeholderMap)
    Run a DDL or SQL script given the resource and place holders.
    void
    runScript​(String name, String content, boolean useAutoCommit)
    Run the raw provided DDL or SQL script.

  • Method Details

    • run

      void run​(String path)
      Run a script given the resource path (that should start with "/").

    • run

      void run​(String path, Map<String,​String> placeholderMap)
      Run a script given the resource path (that should start with "/") and place holders. 
      

   Map<String,String> placeholders = new HashMap<>();
   placeholders.put("tableName", "e_basic");

   Database database = DB.getDefault();
   database.script().run("/scripts/test-script.sql", placeholders);

    • run

      void run​(URL resource)
      Run a DDL or SQL script given the resource.

    • run

      void run​(URL resource, Map<String,​String> placeholderMap)
      Run a DDL or SQL script given the resource and place holders.

    • runScript

      void runScript​(String name, String content, boolean useAutoCommit)
      Run the raw provided DDL or SQL script.
      Parameters:
      name - The name of the script for logging purposes
      content - The SQL content
      useAutoCommit - Set to true to use auto commit true and continue when any errors occur