@BeforeEach
    void initialize() throws Exception {
        val props = new SearchJdbcAuthenticationProperties().setFieldUser("username")
            .setFieldPassword("password").setTableUsers("cassearchusers");
        this.handler = new SearchModeSearchDatabaseAuthenticationHandler(props, null,
            PrincipalFactoryUtils.newPrincipalFactory(), this.dataSource);

        try (val connection = this.dataSource.getConnection()) {
            try (val statement = connection.createStatement()) {
                connection.setAutoCommit(true);

                statement.execute(getSqlInsertStatementToCreateUserAccount(0));
                for (var i = 0; i < 10; i++) {
                    statement.execute(getSqlInsertStatementToCreateUserAccount(i));
                }
            }
        }
    }
Tests for {@link SearchModeSearchDatabaseAuthenticationHandler}.

@author Misagh Moayyed
@since 4.0.0
support/cas-server-support-jdbc-authentication/src/test/java/org/apereo/cas/jdbc/SearchModeSearchDatabaseAuthenticationHandlerTests.java