{
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @BeforeEach
    public void before() {
        // 备份表
        String today = LocalDate.now().format(DateTimeFormatter.ofPattern("uuMMdd"));
        template.execute(String.format("create table test_table_%s as select * from test_table", today));
    }

    @AfterEach
    public void after() {
        String today = LocalDate.now().format(DateTimeFormatter.ofPattern("uuMMdd"));
        template.execute(String.format("insert into test_table select * from test_table_%s", today));
        template.execute(String.format("drop table test_table_%s", today));
    }

    @Test
	@Transactional(readOnly = true)
	void test() {
		// 测试包含truncate的方法
        log.info("1. " + template.queryForList("select * from test_table") + "");
        template.execute("truncate table test_table");
        log.info("2. " + template.queryForList("select * from test_table") + "");
	}
}