@BeforeEach
    void before() {
        this.jdbcPasswordManagementTransactionTemplate.executeWithoutResult(action -> {
            val jdbcTemplate = new JdbcTemplate(this.jdbcPasswordManagementDataSource);
            dropTablesBeforeTest(jdbcTemplate);

            jdbcTemplate.execute("create table pm_table_accounts (userid varchar(255),"
                                 + "password varchar(255), email varchar(255), phone varchar(255), enabled tinyint);");
            jdbcTemplate.execute("insert into pm_table_accounts values ('casuser', 'password', 'casuser@example.org', '1234567890', 1);");
            jdbcTemplate.execute("insert into pm_table_accounts values ('locked', 'password', 'locked@example.org', '1234567890', 0);");
            jdbcTemplate.execute("insert into pm_table_accounts values ('baduser', 'password', '', '', 1);");

            jdbcTemplate.execute("create table pm_table_questions (userid varchar(255),"
                                 + " question varchar(255), answer varchar(255));");
            jdbcTemplate.execute("insert into pm_table_questions values ('casuser', 'question1', 'answer1');");
            jdbcTemplate.execute("insert into pm_table_questions values ('casuser', 'question2', 'answer2');");
        });
    }
This is {@link JdbcPasswordManagementServiceTests}.

@author Misagh Moayyed
@since 5.2.0
support/cas-server-support-pm-jdbc/src/test/java/org/apereo/cas/pm/jdbc/JdbcPasswordManagementServiceTests.java