How to use H2VersionUtils class of org.evomaster.client.java.controller.db.h2 package

Best EvoMaster code snippet using org.evomaster.client.java.controller.db.h2.H2VersionUtils

Source:DbCleaner.java

1package org.evomaster.client.java.controller.db;2import org.evomaster.client.java.controller.api.dto.database.schema.DatabaseType;3import org.evomaster.client.java.controller.db.h2.H2VersionUtils;4import org.evomaster.client.java.utils.SimpleLogger;5import java.sql.Connection;6import java.sql.ResultSet;7import java.sql.SQLException;8import java.sql.Statement;9import java.util.HashSet;10import java.util.List;11import java.util.Set;12import java.util.stream.Collectors;13/**14 * Class used to clean/reset the state of the current database15 */16public class DbCleaner {17    public static void clearDatabase_H2(Connection connection) {18        clearDatabase_H2(connection, null);19    }20    public static void clearDatabase_H2(Connection connection, List<String> tableToSkip) {21        clearDatabase_H2(connection, getDefaultSchema(DatabaseType.H2), tableToSkip);22    }23    public static void clearDatabase_H2(Connection connection, String schemaName, List<String> tableToSkip) {24        clearDatabase_H2(connection, schemaName, tableToSkip, null);25    }26    public static void clearDatabase_H2(Connection connection, String schemaName, List<String> tableToSkip, List<String> tableToClean) {27        final String h2Version;28        try {29            h2Version = H2VersionUtils.getH2Version(connection);30        } catch (SQLException e) {31            throw new RuntimeException("Unexpected SQLException while fetching H2 version", e);32        }33        /*34         * The SQL command "TRUNCATE TABLE my_table RESTART IDENTITY"35         * is not supported by H2 version 1.4.199 or lower36         */37        final boolean restartIdentitiyWhenTruncating = H2VersionUtils.isVersionGreaterOrEqual(h2Version, H2VersionUtils.H2_VERSION_2_0_0);38        clearDatabase(getDefaultRetries(DatabaseType.H2), connection, schemaName, tableToSkip, tableToClean, DatabaseType.H2,39                false, true, restartIdentitiyWhenTruncating);40    }41    /*42        [non-determinism-source] Man: retries might lead to non-determinate logs43     */44    private static void clearDatabase(int retries,45                                      Connection connection,46                                      String schemaName,47                                      List<String> tableToSkip,48                                      List<String> tableToClean,49                                      DatabaseType type,50                                      boolean doDropTable,51                                      boolean doResetSequence,52                                      boolean restartIdentityWhenTruncating) {53        /*54            Code based on55            https://stackoverflow.com/questions/8523423/reset-embedded-h2-database-periodically56         */57        try {58            Statement statement = connection.createStatement();59            /*60                For H2, we have to delete tables one at a time... but, to avoid issues61                with FKs, we must temporarily disable the integrity checks62             */63            disableReferentialIntegrity(statement, type);64            List<String> cleanedTable = cleanDataInTables(tableToSkip,65                    tableToClean,66                    statement,67                    type,68                    schemaName,69                    isSingleCleanCommand(type),70                    doDropTable,71                    restartIdentityWhenTruncating);72            if (doResetSequence) {73                List<String> sequenceToClean = null;74                if (type == DatabaseType.MYSQL || type == DatabaseType.MARIADB)75                    sequenceToClean = cleanedTable;76                resetSequences(statement, type, schemaName, sequenceToClean);77            }78            enableReferentialIntegrity(statement, type);79            statement.close();80        } catch (Exception e) {81            /*82                this could happen if there is a current transaction with a lock on any table.83                We could check the content of INFORMATION_SCHEMA.LOCKS, or simply look at error message84             */85            String msg = e.getMessage();86            if (msg != null && msg.toLowerCase().contains("timeout")) {87                if (retries > 0) {88                    SimpleLogger.warn("Timeout issue with cleaning DB. Trying again.");89                    //let's just wait a bit, and retry90                    try {91                        Thread.sleep(2000);92                    } catch (InterruptedException interruptedException) {93                        // empty block94                    }95                    retries--;96                    clearDatabase(retries, connection, schemaName, tableToSkip, tableToClean, type, doDropTable, doResetSequence, restartIdentityWhenTruncating);97                } else {98                    SimpleLogger.error("Giving up cleaning the DB. There are still timeouts.");99                }100            }101            throw new RuntimeException(e);102        }103    }104    public static void clearDatabase(Connection connection, List<String> tablesToSkip, DatabaseType type, boolean doResetSequence) {105        clearDatabase(connection, getDefaultSchema(type), tablesToSkip, type, doResetSequence);106    }107    public static void clearDatabase(Connection connection, List<String> tablesToSkip, DatabaseType type) {108        clearDatabase(connection, tablesToSkip, type, true);109    }110    public static void clearDatabase(Connection connection, List<String> tableToSkip, List<String> tableToClean, DatabaseType type) {111        clearDatabase(connection, tableToSkip, tableToClean, type, true);112    }113    public static void clearDatabase(Connection connection, List<String> tableToSkip, List<String> tableToClean, DatabaseType type, boolean doResetSequence) {114        clearDatabase(connection, getDefaultSchema(type), tableToSkip, tableToClean, type, doResetSequence);115    }116    public static void clearDatabase(Connection connection, String schemaName, List<String> tablesToSkip, DatabaseType type) {117        clearDatabase(connection, getSchemaName(schemaName, type), tablesToSkip, type, true);118    }119    public static void clearDatabase(Connection connection, String schemaName, List<String> tablesToSkip, DatabaseType type, boolean doResetSequence) {120        clearDatabase(connection, getSchemaName(schemaName, type), tablesToSkip, null, type, doResetSequence);121    }122    public static void clearDatabase(Connection connection, String schemaName, List<String> tableToSkip, List<String> tableToClean, DatabaseType type) {123        clearDatabase(connection, getSchemaName(schemaName, type), tableToSkip, tableToClean, type, true);124    }125    public static void clearDatabase(Connection connection, String schemaName, List<String> tableToSkip, List<String> tableToClean, DatabaseType type, boolean doResetSequence) {126        /*127         * Enable the restarting of Identity fields only if sequences are to be restarted128         * and the database type is H2129         */130        boolean restartIdentityWhenTruncating;131        if (doResetSequence && type.equals(DatabaseType.H2)) {132            try {133                String h2Version = H2VersionUtils.getH2Version(connection);134                restartIdentityWhenTruncating = H2VersionUtils.isVersionGreaterOrEqual(h2Version, H2VersionUtils.H2_VERSION_2_0_0);135            } catch (SQLException ex) {136                throw new RuntimeException("Unexpected SQL exception while getting H2 version", ex);137            }138        } else {139            restartIdentityWhenTruncating = false;140        }141        clearDatabase(getDefaultRetries(type), connection, getSchemaName(schemaName, type), tableToSkip, tableToClean, type, false, doResetSequence, restartIdentityWhenTruncating);142    }143    public static void dropDatabaseTables(Connection connection, String schemaName, List<String> tablesToSkip, DatabaseType type) {144        if (type != DatabaseType.MYSQL && type != DatabaseType.MARIADB)145            throw new IllegalArgumentException("Dropping tables are not supported by " + type);146        clearDatabase(getDefaultRetries(type), connection, getSchemaName(schemaName, type), tablesToSkip, null, type, true, true, false);147    }148    public static void clearDatabase_Postgres(Connection connection, String schemaName, List<String> tablesToSkip) {...

Source:H2ConstraintExtractor.java

1package org.evomaster.client.java.controller.internal.db.constraint;2import org.evomaster.client.java.controller.api.dto.database.schema.DbSchemaDto;3import org.evomaster.client.java.controller.api.dto.database.schema.TableDto;4import org.evomaster.client.java.controller.db.h2.H2VersionUtils;5import org.evomaster.client.java.utils.SimpleLogger;6import java.sql.Connection;7import java.sql.ResultSet;8import java.sql.SQLException;9import java.sql.Statement;10import java.util.ArrayList;11import java.util.Arrays;12import java.util.List;13import java.util.stream.Collectors;14public class H2ConstraintExtractor extends TableConstraintExtractor {15    private static final String CONSTRAINT_TYPE = "CONSTRAINT_TYPE";16    private static final String CHECK_EXPRESSION = "CHECK_EXPRESSION";17    private static final String COLUMN_LIST = "COLUMN_LIST";18    private static final String UNIQUE = "UNIQUE";19    private static final String REFERENTIAL = "REFERENTIAL";20    private static final String PRIMARY_KEY = "PRIMARY_KEY";21    private static final String PRIMARY_KEY_BLANK = "PRIMARY KEY";22    private static final String CHECK = "CHECK";23    private static final String CHECK_CONSTRAINT = "CHECK_CONSTRAINT";24    private static final String CONSTRAINT_CATALOG = "CONSTRAINT_CATALOG";25    private static final String COLUMN_NAME = "COLUMN_NAME";26    private static final String CONSTRAINT_SCHEMA = "CONSTRAINT_SCHEMA";27    private static final String CONSTRAINT_NAME = "CONSTRAINT_NAME";28    /**29     * Expects the schema explained in30     * http://www.h2database.com/html/systemtables.html#information_schema31     *32     * @param connectionToH2 a connection to a H2 database33     * @param schemaDto      a DTO schema with retrieved information from the JBDC metadata34     * @throws SQLException if the connection to the H2 database fails35     */36    public List<DbTableConstraint> extract(Connection connectionToH2, DbSchemaDto schemaDto) throws SQLException {37        final String h2DatabaseVersion = H2VersionUtils.getH2Version(connectionToH2);38        List<DbTableConstraint> columnConstraints = extractColumnConstraints(connectionToH2, schemaDto, h2DatabaseVersion);39        List<DbTableConstraint> tableCheckExpressions = extractTableConstraints(connectionToH2, schemaDto, h2DatabaseVersion);40        List<DbTableConstraint> allConstraints = new ArrayList<>();41        allConstraints.addAll(columnConstraints);42        allConstraints.addAll(tableCheckExpressions);43        return allConstraints;44    }45    /**46     * Logs that a constraint could not be handled by the extractor.47     *48     * @param constraintType the type of SQL constraint49     */50    private static void cannotHandle(String constraintType) {51        SimpleLogger.uniqueWarn("WARNING, EvoMaster cannot extract H2 constraints with type '" + constraintType);52    }53    private List<DbTableConstraint> extractColumnConstraints(Connection connectionToH2, DbSchemaDto schemaDto, String h2DatabaseVersion) throws SQLException {54        if (H2VersionUtils.isVersionGreaterOrEqual(h2DatabaseVersion, H2VersionUtils.H2_VERSION_2_0_0)) {55            return new ArrayList<>();56        } else {57            return extractColumnConstraintsVersion1OrLower(connectionToH2, schemaDto, h2DatabaseVersion);58        }59    }60    private List<DbTableConstraint> extractTableConstraints(Connection connectionToH2, DbSchemaDto schemaDto, String h2DatabaseVersion) throws SQLException {61        if (H2VersionUtils.isVersionGreaterOrEqual(h2DatabaseVersion, H2VersionUtils.H2_VERSION_2_0_0)) {62            return extractTableConstraintsVersionTwoOrHigher(connectionToH2, schemaDto);63        } else {64            return extractTableConstraintsVersionOneOrLower(connectionToH2, schemaDto);65        }66    }67    /**68     * For each table in the schema DTO, this method appends69     * the constraints that are originated in the ALTER TABLE commands70     * for those particular tables.71     * <p>72     * Foreign keys are handled separately in the JDBC metadata73     *74     * @param connectionToH2 a connection to a H2 database75     * @param schemaDto      DTO with database schema information76     * @throws SQLException if the connection to the H2 database fails77     */78    private List<DbTableConstraint> extractTableConstraintsVersionTwoOrHigher(Connection connectionToH2,79                                                                              DbSchemaDto schemaDto) throws SQLException {80        List<DbTableConstraint> tableCheckExpressions = new ArrayList<>();81        String tableSchema = schemaDto.name;82        for (TableDto tableDto : schemaDto.tables) {83            String tableName = tableDto.name;84            try (Statement statement = connectionToH2.createStatement()) {85                final String query = String.format("Select CONSTRAINT_CATALOG,CONSTRAINT_SCHEMA,CONSTRAINT_NAME,CONSTRAINT_TYPE From INFORMATION_SCHEMA.TABLE_CONSTRAINTS\n" +86                        " where TABLE_CONSTRAINTS.TABLE_SCHEMA='%s' \n"87                        + " and TABLE_CONSTRAINTS.TABLE_NAME='%s' ", tableSchema, tableName);88                try (ResultSet constraints = statement.executeQuery(query)) {89                    while (constraints.next()) {90                        String constraintCatalog = constraints.getString(CONSTRAINT_CATALOG);91                        String constraintSchema = constraints.getString(CONSTRAINT_SCHEMA);92                        String constraintName = constraints.getString(CONSTRAINT_NAME);93                        String constraintType = constraints.getString(CONSTRAINT_TYPE);94                        switch (constraintType) {95                            case UNIQUE: {96                                DbTableUniqueConstraint constraint = getTableUniqueConstraint(connectionToH2, tableName,97                                        constraintCatalog, constraintSchema, constraintName);98                                tableCheckExpressions.add(constraint);99                                break;100                            }101                            case CHECK: {102                                DbTableCheckExpression constraint = getTableCheckExpression(connectionToH2, tableName, constraintCatalog, constraintSchema, constraintName);103                                tableCheckExpressions.add(constraint);104                                break;105                            }106                            case PRIMARY_KEY:107                            case PRIMARY_KEY_BLANK:108                            case REFERENTIAL:109                                /*110                                 * This type of constraint is already handled by111                                 * JDBC Metadata112                                 **/113                                break;114                            default:115                                cannotHandle(constraintType);116                        }117                    }118                }119            }120        }121        return tableCheckExpressions;122    }123    private DbTableUniqueConstraint getTableUniqueConstraint(Connection connectionToH2,124                                                             String tableName,125                                                             String constraintCatalog,126                                                             String constraintSchema,127                                                             String constraintName) throws SQLException {128        try (Statement columnsUsageStatement = connectionToH2.createStatement()) {129            String columnsUsageQuery = String.format("SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE "130                            + "WHERE CONSTRAINT_CATALOG='%s' AND CONSTRAINT_SCHEMA='%s' AND CONSTRAINT_NAME='%s' ",131                    constraintCatalog, constraintSchema, constraintName);132            try (ResultSet columnsUsageResultSet = columnsUsageStatement.executeQuery(columnsUsageQuery)) {133                List<String> uniqueColumnNames = new ArrayList<>();134                while (columnsUsageResultSet.next()) {135                    String columnName = columnsUsageResultSet.getString(COLUMN_NAME);136                    uniqueColumnNames.add(columnName);137                }138                return new DbTableUniqueConstraint(tableName, uniqueColumnNames);139            }140        }141    }142    private DbTableCheckExpression getTableCheckExpression(Connection connectionToH2,143                                                           String tableName,144                                                           String constraintCatalog,145                                                           String constraintSchema,146                                                           String constraintName) throws SQLException {147        try (Statement checkClauseStatement = connectionToH2.createStatement()) {148            String checkClauseQuery = String.format("SELECT CHECK_CLAUSE FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS "149                            + "WHERE CONSTRAINT_CATALOG='%s' AND CONSTRAINT_SCHEMA='%s' AND CONSTRAINT_NAME='%s' ",150                    constraintCatalog, constraintSchema, constraintName);151            try (ResultSet checkClauseResultSet = checkClauseStatement.executeQuery(checkClauseQuery)) {152                if (checkClauseResultSet.next()) {153                    String sqlCheckExpression = checkClauseResultSet.getString("CHECK_CLAUSE");154                    return new DbTableCheckExpression(tableName, "(" + sqlCheckExpression + ")");155                } else {156                    throw new IllegalArgumentException(String.format("Cannot find constraint such that CONSTRAINT_CATALOG='%s' AND CONSTRAINT_SCHEMA='%s' AND CONSTRAINT_NAME='%s' ", constraintCatalog, constraintSchema, constraintName));157                }158            }159        }160    }161    /**162     * Extracts DbTableConstraints for version 0.xxx and 1.xxx163     *164     * @param connectionToH2 the connection to the H2 database165     * @param schemaDto      the schema166     * @return the list of constraints in the table167     * @throws SQLException an unexpected exception while executing the queries168     */169    private List<DbTableConstraint> extractTableConstraintsVersionOneOrLower(Connection connectionToH2, DbSchemaDto schemaDto) throws SQLException {170        List<DbTableConstraint> tableCheckExpressions = new ArrayList<>();171        String tableSchema = schemaDto.name;172        for (TableDto tableDto : schemaDto.tables) {173            String tableName = tableDto.name;174            try (Statement statement = connectionToH2.createStatement()) {175                final String query = String.format("Select CONSTRAINT_TYPE, CHECK_EXPRESSION, COLUMN_LIST From INFORMATION_SCHEMA.CONSTRAINTS\n" +176                        " where CONSTRAINTS.TABLE_SCHEMA='%s' \n"177                        + " and CONSTRAINTS.TABLE_NAME='%s' ", tableSchema, tableName);178                try (ResultSet constraints = statement.executeQuery(query)) {179                    while (constraints.next()) {180                        String constraintType = constraints.getString(CONSTRAINT_TYPE);181                        DbTableConstraint constraint;182                        switch (constraintType) {183                            case UNIQUE: {184                                String columnList = constraints.getString(COLUMN_LIST);185                                List<String> uniqueColumnNames = Arrays.stream(columnList.split(",")).map(String::trim).collect(Collectors.toList());186                                constraint = new DbTableUniqueConstraint(tableName, uniqueColumnNames);187                                tableCheckExpressions.add(constraint);188                                break;189                            }190                            case PRIMARY_KEY:191                            case PRIMARY_KEY_BLANK:192                            case REFERENTIAL:193                                /*194                                 * This type of constraint is already handled by195                                 * JDBC Metadata196                                 **/197                                break;198                            case CHECK:199                                String sqlCheckExpression = constraints.getString(CHECK_EXPRESSION);200                                constraint = new DbTableCheckExpression(tableName, sqlCheckExpression);201                                tableCheckExpressions.add(constraint);202                                break;203                            default:204                                cannotHandle(constraintType);205                        }206                    }207                }208            }209        }210        return tableCheckExpressions;211    }212    /**213     * For each table in the schema DTO, this method appends214     * the constraints that are originated in the CREATE TABLE commands215     * for those particular tables.216     * <p>217     * Unique constraints and Foreign keys are handled separately in the JDBC metadata218     *219     * @param connectionToH2 a connection to a H2 database220     * @param schemaDto      DTO with database schema information221     * @throws SQLException if the connection to the database fails222     */223    private List<DbTableConstraint> extractColumnConstraintsVersion1OrLower(Connection connectionToH2, DbSchemaDto schemaDto, String h2DatabaseVersion) throws SQLException {224        if (H2VersionUtils.isVersionGreaterOrEqual(h2DatabaseVersion, H2VersionUtils.H2_VERSION_2_0_0)) {225            throw new IllegalArgumentException("Cannot extract column constraints for H2 version 2 or higher with H2 database version  " + h2DatabaseVersion);226        }227        String tableSchema = schemaDto.name;228        List<DbTableConstraint> columnConstraints = new ArrayList<>();229        for (TableDto tableDto : schemaDto.tables) {230            String tableName = tableDto.name;231            try (Statement statement = connectionToH2.createStatement()) {232                final String query = String.format("Select * From INFORMATION_SCHEMA.COLUMNS where COLUMNS.TABLE_SCHEMA='%s' and COLUMNS.TABLE_NAME='%s' ", tableSchema, tableName);233                try (ResultSet columns = statement.executeQuery(query)) {234                    while (columns.next()) {235                        String sqlCheckExpression = columns.getString(CHECK_CONSTRAINT);236                        if (sqlCheckExpression != null && !sqlCheckExpression.equals("")) {237                            DbTableCheckExpression constraint = new DbTableCheckExpression(tableName, sqlCheckExpression);238                            columnConstraints.add(constraint);...

Source:H2VersionUtilsTest.java

1package org.evomaster.client.java.controller.db.h2;2import org.junit.jupiter.api.Test;3import static org.junit.jupiter.api.Assertions.assertFalse;4import static org.junit.jupiter.api.Assertions.assertTrue;5public class H2VersionUtilsTest {6    @Test7    public void testEqual() {8        assertTrue(H2VersionUtils.isVersionGreaterOrEqual("1.4.193","1.4.193"));9    }10    @Test11    public void testLess() {12        assertTrue(H2VersionUtils.isVersionGreaterOrEqual("1.4.200","1.4.193"));13    }14    @Test15    public void testLessVersion2() {16        assertTrue(H2VersionUtils.isVersionGreaterOrEqual("2.1.214","1.3.193"));17    }18    @Test19    public void testGreater() {20        assertFalse(H2VersionUtils.isVersionGreaterOrEqual("1.4.193","1.4.199"));21    }22}...

H2VersionUtils

Using AI Code Generation

1package org.evomaster.client.java.controller.db.h2;2import org.evomaster.client.java.controller.db.DbActionBuilder;3import org.evomaster.client.java.controller.db.DbActionTransformer;4import org.evomaster.client.java.controller.db.DbAction;5import org.evomaster.client.java.controller.db.SqlScriptRunner;6import org.evomaster.client.java.controller.db.Table;7import org.evomaster.client.java.controller.db.TableRow;8import org.evomaster.client.java.controller.db.h2.H2Controller;9import org.evomaster.client.java.controller.db.h2.H2VersionUtils;10import org.evomaster.client.java.controller.problem.ProblemInfo;11import org.evomaster.client.java.controller.problem.RestProblem;12import org.evomaster.client.java.controller.problem.RestResourceCalls;13import org.evomaster.client.java.controller.problem.RestResourceInfo;14import org.evomaster.client.java.controller.problem.rest.*;15import org.evomaster.client.java.controller.problem.rest.param.BodyParam;16import org.evomaster.client.java.controller.problem.rest.param.HeaderParam;17import org.evomaster.client.java.controller.problem.rest.param.PathParam;18import org.evomaster.client.java.controller.problem.rest.param.QueryParam;19import org.evomaster.client.java.controller.problem.rest.resource.RestResource;20import org.evomaster.client.java.controller.problem.rest.resource.RestResourceNode;21import org.evomaster.client.java.controller.problem.rest.resource.RestResourceCalls;22import org.evomaster.client.java.controller.problem.rest.resource.RestResourceDep;23import org.evomaster.client.java.controller.problem.rest.resource.RestResourceNode;24import org.evomaster.client.java.controller.problem.rest.resource.RestResourceCalls;25import org.evomaster.client.java.controller.problem.rest.resource.RestResourceDep;26import org.evomaster.client.java.controller.problem.rest.resource.RestResourceNode;27import org.evomaster.client.java.controller.problem.rest.resource.RestResourceCalls;28import org.evomaster.client.java.controller.problem.rest.resource.RestResourceDep;29import org.evomaster.client.java.controller.problem.rest.resource.RestResourceNode;30import org.evomaster.client.java.controller.problem.rest.resource.RestResourceCalls;31import org.evomaster.client.java.controller.problem.rest.resource.RestResourceDep;32import org.evomaster.client.java.controller.problem.rest.resource.RestResourceNode;33import org.evomaster.client.java.controller.problem.rest.resource.RestResourceCalls;34import org.evomaster.client.java.controller.problem.rest.resource.RestResourceDep;35import org.evomaster.client.java.controller.problem.rest.resource.RestResourceNode;36import org.evomaster.client.java.controller.problem

H2VersionUtils

Using AI Code Generation

1package org.evomaster.client.java.controller.db.h2;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5public class H2VersionUtils {6    public static void main(String[] args) throws SQLException {7        Connection connection = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");8        H2VersionUtils.printVersion(connection);9    }10    public static void printVersion(Connection connection) throws SQLException {11        System.out.println("H2 version: " + H2VersionUtils.getVersion(connection));12    }13    public static String getVersion(Connection connection) throws SQLException {14        return connection.getMetaData().getDatabaseProductVersion();15    }16}17package org.evomaster.client.java.controller.db.h2;18import java.sql.Connection;19import java.sql.DriverManager;20import java.sql.SQLException;21public class H2VersionUtils {22    public static void main(String[] args) throws SQLException {23        Connection connection = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");24        H2VersionUtils.printVersion(connection);25    }26    public static void printVersion(Connection connection) throws SQLException {27        System.out.println("H2 version: " + H2VersionUtils.getVersion(connection));28    }29    public static String getVersion(Connection connection) throws SQLException {30        return connection.getMetaData().getDatabaseProductVersion();31    }32}33package org.evomaster.client.java.controller.db.h2;34import java.sql.Connection;35import java.sql.DriverManager;36import java.sql.SQLException;37public class H2VersionUtils {38    public static void main(String[] args) throws SQLException {39        Connection connection = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1", "sa", "");40        H2VersionUtils.printVersion(connection);41    }42    public static void printVersion(Connection connection) throws SQLException {43        System.out.println("H2 version: " + H2VersionUtils.getVersion(connection));44    }45    public static String getVersion(Connection connection) throws SQLException {46        return connection.getMetaData().getDatabaseProductVersion();47    }48}

H2VersionUtils

Using AI Code Generation

1import org.evomaster.client.java.controller.db.h2.H2VersionUtils;2import org.h2.Driver;3import org.hibernate.dialect.H2Dialect;4import org.hibernate.dialect.H2Dialect;5import org.hibernate.dialect.H2Dialect;6public class 3 {7    public static void main(String[] args) {8        H2VersionUtils.getVersion();9        Driver driver = new Driver();10        H2Dialect dialect = new H2Dialect();11        H2Dialect dialect = new H2Dialect();12        H2Dialect dialect = new H2Dialect();13    }14}15import org.evomaster.client.java.controller.db.h2.H2VersionUtils;16import org.h2.Driver;17import org.hibernate.dialect.H2Dialect;18import org.hibernate.dialect.H2Dialect;19import org.hibernate.dialect.H2Dialect;20public class 4 {21    public static void main(String[] args) {22        H2VersionUtils.getVersion();23        Driver driver = new Driver();

H2VersionUtils

Using AI Code Generation

1import org.evomaster.client.java.controller.db.h2.H2VersionUtils;2import java.sql.Connection;3import java.sql.DriverManager;4import java.sql.SQLException;5import java.sql.Statement;6import java.util.List;7import java.util.stream.Collectors;8public class 3 {9    public static void main(String[] args) throws SQLException {10        String url = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1";11        Connection conn = DriverManager.getConnection(url);12        Statement stmt = conn.createStatement();13        stmt.execute("CREATE TABLE IF NOT EXISTS test (id int, name varchar(100))");14        stmt.execute("INSERT INTO test VALUES (1, 'one')");15        stmt.execute("INSERT INTO test VALUES (2, 'two')");16        stmt.execute("INSERT INTO test VALUES (3, 'three')");17        List<String> versions = H2VersionUtils.getVersions(conn);18        System.out.println(versions.stream().collect(Collectors.joining(", ")));19    }20}21import org.evomaster.client.java.controller.db.h2.H2VersionUtils;22import org.junit.jupiter.api.Test;23import java.sql.Connection;24import java.sql.DriverManager;25import java.sql.SQLException;26import java.sql.Statement;27import static org.junit.jupiter.api.Assertions.assertTrue;28public class H2VersionUtilsTest {29    public void testGetVersions() throws SQLException {30        String url = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1";31        Connection conn = DriverManager.getConnection(url);32        Statement stmt = conn.createStatement();33        stmt.execute("CREATE TABLE IF NOT EXISTS test (id int, name varchar(100))");34        stmt.execute("INSERT INTO test VALUES (1, 'one')");35        stmt.execute("INSERT INTO test VALUES (2, 'two')");36        stmt.execute("INSERT INTO test VALUES (3, 'three')");37        List<String> versions = H2VersionUtils.getVersions(conn);38        assertTrue(versions.contains("1.4.200"));39    }40}41You can also use the H2VersionUtils class to check if the H2 database supports a specific feature. For example, you can check if the H2 database supports the function ROW_NUMBER() as follows:42import

H2VersionUtils

Using AI Code Generation

1package org.evomaster.client.java.controller.db.h2;2import org.evomaster.client.java.controller.db.h2.H2VersionUtils;3public class H2Version {4    public static void main(String[] args) {5        System.out.println("H2 version: " + H2VersionUtils.getH2Version());6    }7}8package org.evomaster.client.java.controller.db.h2;9import org.evomaster.client.java.controller.db.h2.H2VersionUtils;10public class H2Version {11    public static void main(String[] args) {12        System.out.println("H2 version: " + H2VersionUtils.getH2Version());13    }14}15package org.evomaster.client.java.controller.db.h2;16import org.evomaster.client.java.controller.db.h2.H2VersionUtils;17public class H2Version {18    public static void main(String[] args) {19        System.out.println("H2 version: " + H2VersionUtils.getH2Version());20    }21}22package org.evomaster.client.java.controller.db.h2;23import org.evomaster.client.java.controller.db.h2.H2VersionUtils;24public class H2Version {25    public static void main(String[] args) {26        System.out.println("H2 version: " + H2VersionUtils.getH2Version());27    }28}29package org.evomaster.client.java.controller.db.h2;30import org.evomaster.client.java.controller.db.h2.H2VersionUtils;31public class H2Version {32    public static void main(String[] args) {33        System.out.println("H2 version: " + H2VersionUtils.getH2Version());34    }35}

H2VersionUtils

Using AI Code Generation

1import org.evomaster.client.java.controller.db.h2.H2VersionUtils;2public class Main {3    public static void main(String[] args) {4        System.out.println("H2 version: " + H2VersionUtils.getH2Version());5    }6}7import org.evomaster.client.java.controller.db.h2.H2Driver;8import java.sql.Connection;9import java.sql.DriverManager;10import java.sql.SQLException;11public class Main {12    public static void main(String[] args) throws SQLException {13        Connection connection = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1");14        System.out.println("H2 version: " + H2Driver

H2VersionUtils

Using AI Code Generation

1public class 3 {2	public static void main(String[] args) throws Exception {3		String version = H2VersionUtils.getH2Version();4		System.out.println("Version: " + version);5	}6}

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.