Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use ScriptUtils class of org.testcontainers.ext package

Best Testcontainers-java code snippet using org.testcontainers.ext.ScriptUtils

Source:ScriptUtils.java

...18import javax.script.ScriptException;19import java.sql.Connection;20import java.util.List;21/**22 * Wrapper for database-agnostic ScriptUtils23 *24 * @see org.testcontainers.ext.ScriptUtils25 * @deprecated Needed only to keep binary compatibility for this internal API. Consider using database-agnostic ScriptUtils26 */27public abstract class ScriptUtils {28    /**29     * Default statement separator within SQL scripts.30     */31    public static final String DEFAULT_STATEMENT_SEPARATOR = ";";32    /**33     * Fallback statement separator within SQL scripts.34     * <p>Used if neither a custom defined separator nor the35     * {@link #DEFAULT_STATEMENT_SEPARATOR} is present in a given script.36     */37    public static final String FALLBACK_STATEMENT_SEPARATOR = "\n";38    /**39     * Default prefix for line comments within SQL scripts.40     */41    public static final String DEFAULT_COMMENT_PREFIX = "--";42    /**43     * Default start delimiter for block comments within SQL scripts.44     */45    public static final String DEFAULT_BLOCK_COMMENT_START_DELIMITER = "/*";46    /**47     * Default end delimiter for block comments within SQL scripts.48     */49    public static final String DEFAULT_BLOCK_COMMENT_END_DELIMITER = "*/";50    /**51     * Prevent instantiation of this utility class.52     */53    private ScriptUtils() {54        /* no-op */55    }56    /**57     * @see org.testcontainers.ext.ScriptUtils58     * @deprecated Needed only to keep binary compatibility for this internal API. Consider using database-agnostic ScriptUtils59     */60    public static void splitSqlScript(String resource, String script, String separator, String commentPrefix,61                                      String blockCommentStartDelimiter, String blockCommentEndDelimiter, List<String> statements) {62        org.testcontainers.ext.ScriptUtils.splitSqlScript(resource, script, separator, commentPrefix, blockCommentStartDelimiter, blockCommentEndDelimiter, statements);63    }64    /**65     * @see org.testcontainers.ext.ScriptUtils66     * @deprecated Needed only to keep binary compatibility for this internal API. Consider using database-agnostic ScriptUtils67     */68    public static boolean containsSqlScriptDelimiters(String script, String delim) {69        return org.testcontainers.ext.ScriptUtils.containsSqlScriptDelimiters(script, delim);70    }71    /**72     * @see org.testcontainers.ext.ScriptUtils73     * @deprecated Needed only to keep binary compatibility for this internal API. Consider using database-agnostic ScriptUtils74     */75    public static void executeSqlScript(Connection connection, String scriptPath, String script) throws ScriptException {76        org.testcontainers.ext.ScriptUtils.executeDatabaseScript(new ContainerLessJdbcDelegate(connection), scriptPath, script);77    }78    /**79     * @see org.testcontainers.ext.ScriptUtils80     * @deprecated Needed only to keep binary compatibility for this internal API. Consider using database-agnostic ScriptUtils81     */82    public static void executeSqlScript(Connection connection, String scriptPath, String script, boolean continueOnError,83                                        boolean ignoreFailedDrops, String commentPrefix, String separator, String blockCommentStartDelimiter,84                                        String blockCommentEndDelimiter) throws ScriptException {85        org.testcontainers.ext.ScriptUtils.executeDatabaseScript(new ContainerLessJdbcDelegate(connection), scriptPath,86                script, continueOnError, ignoreFailedDrops, commentPrefix, separator, blockCommentStartDelimiter, blockCommentEndDelimiter);87    }88}...

Source:46413.java

1diff --git a/modules/jdbc/src/main/java/org/testcontainers/jdbc/ext/ScriptUtils.java b/modules/jdbc/src/main/java/org/testcontainers/jdbc/ext/ScriptUtils.java2index 1d7a12f..286ea32 1006443--- a/modules/jdbc/src/main/java/org/testcontainers/jdbc/ext/ScriptUtils.java4+++ b/modules/jdbc/src/main/java/org/testcontainers/jdbc/ext/ScriptUtils.java5@@ -246,7 +246,7 @@6 7 		try {8 			if (LOGGER.isInfoEnabled()) {9-				LOGGER.info("Executing SQL script from " + script);10+				LOGGER.info("Executing SQL script from " + scriptPath);11 			}12 13 			long startTime = System.currentTimeMillis();...

ScriptUtils

Using AI Code Generation

1import org.testcontainers.ext.ScriptUtils;2import org.testcontainers.ext.ScriptUtils.ScriptLoadException;3import org.testcontainers.jdbc.JdbcDatabaseContainer;4import org.testcontainers.jdbc.JdbcDatabaseContainerProvider;5import org.testcontainers.utility.DockerImageName;6public class ScriptUtilsTest {7    public static void main(String[] args) throws ScriptLoadException {8        JdbcDatabaseContainer container = new JdbcDatabaseContainerProvider().newInstance(DockerImageName.parse("mysql:8.0.15"));9        container.start();10        ScriptUtils.runInitScript(container, "init.sql");11    }12}13CREATE TABLE IF NOT EXISTS `test` (14  `id` int(11) NOT NULL AUTO_INCREMENT,15  `name` varchar(255) NOT NULL,16  PRIMARY KEY (`id`)17) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;18INSERT INTO `test` (`id`, `name`) VALUES19(5, 'test5');

ScriptUtils

Using AI Code Generation

1import org.testcontainers.ext.ScriptUtils;2public class 1 {3    public static void main(String[] args) {4        ScriptUtils.runScript("1.sql");5    }6}7CREATE TABLE IF NOT EXISTS `test` (8  `id` int(11) NOT NULL AUTO_INCREMENT,9  `name` varchar(100) NOT NULL,10  PRIMARY KEY (`id`)11) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;12CREATE TABLE IF NOT EXISTS `test2` (13  `id` int(11) NOT NULL AUTO_INCREMENT,14  `name` varchar(100) NOT NULL,15  PRIMARY KEY (`id`)16) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;17import org.testcontainers.ext.ScriptUtils;18public class 2 {19    public static void main(String[] args) {20        ScriptUtils.runScript("2.sql");21    }22}23CREATE TABLE IF NOT EXISTS `test3` (24  `id` int(11) NOT NULL AUTO_INCREMENT,25  `name` varchar(100) NOT NULL,26  PRIMARY KEY (`id`)27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;28CREATE TABLE IF NOT EXISTS `test4` (29  `id` int(11) NOT NULL AUTO_INCREMENT,30  `name` varchar(100) NOT NULL,31  PRIMARY KEY (`id`)32) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ScriptUtils

Using AI Code Generation

1import org.testcontainers.ext.ScriptUtils;2public class 1 {3    public static void main(String[] args) {4        ScriptUtils.runScript("1.sql");5    }6}7CREATE TABLE IF NOT EXISTS `test` (8  `id` int(11) NOT NULL AUTO_INCREMENT,9  `name` varchar(100) NOT NULL,10  PRIMARY KEY (`id`)11) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;12CREATE TABLE IF NOT EXISTS `test2` (13  `id` int(11) NOT NULL AUTO_INCREMENT,14  `name` varchar(100) NOT NULL,15  PRIMARY KEY (`id`)16) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;17import org.testcontainers.ext.ScriptUtils;18public class 2 {19    public static void main(String[] args) {20        ScriptUtils.runScript("2.sql");21    }22}23CREATE TABLE IF NOT EXISTS `test3` (24  `id` int(11) NOT NULL AUTO_INCREMENT,25  `name` varchar(100) NOT NULL,26  PRIMARY KEY (`id`)27) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;28CREATE TABLE IF NOT EXISTS `test4` (29  `id` int(11) NOT NULL AUTO_INCREMENT,30  `name` varchar(100) NOT NULL,31  PRIMARY KEY (`id`)32) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ScriptUtils

Using AI Code Generation

1import org.testcontainers.containers.JdbcDatabaseContainer;2import org.testcontainers.ext.ScriptUtils;3import org.testcontainers.jdbc.JdbcDatabaseDelegate;4import java.sql.Connection;5import java.sql.SQLException;6public class ScriptUtilsExample {7    public static void main(String[] args) throws SQLException {8        JdbcDatabaseContainer container = null;9        Connection connection = null;10        try {11            container = new JdbcDatabaseContainer("mysql:5.7.22");12            container.start();13            connection = container.createConnection("");14            JdbcDatabaseDelegate delegate = new JdbcDatabaseDelegate(container, connection);15            ScriptUtils.runInitScript(delegate, "1.sql");16        } finally {17            if (connection != null) {18                connection.close();19            }20            if (container != null) {21                container.stop();22            }23        }24    }25}26CREATE TABLE `test` (27  `id` int(11) NOT NULL AUTO_INCREMENT,28  `name` varchar(255) NOT NULL,29  PRIMARY KEY (`id`)30) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;31INSERT INTO `test` (`id`, `name`) VALUES32(1, 'test');33INFO  o.t.utility.RegistryAuthLocator - Credential helper/store (docker-credential-desktop) does not have credentials for index.docker.io34INFO  o.t.utility.RegistryAuthLocator - Credential helper/store (docker-credential-desktop) does not have credentials for registry-1.docker.io35INFO  o.t.utility.RegistryAuthLocator - Credential helper/store (docker-credential-desktop) does not have credentials for quay.io36INFO  o.t.utility.RegistryAuthLocator - Credential helper/store (docker-credential-desktop) does not have credentials for registry.hub.docker.com37INFO  o.t.utility.RegistryAuthLocator - Credential helper/store (docker-credential-desktop) does not have credentials for docker.io38INFO  o.t.utility.RegistryAuthLocator - Credential helper/store (docker-credential-desktop) does not have credentials for gcr.io

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.