Java JdbcTestUtils.deleteFromTables方法代码示例

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
private void ddlOrDelete() {
    try {

        final int pathsCount = JdbcTestUtils.countRowsInTable(jdbcTemplate, NAMES_TABLE);
        if (pathsCount > 0) {
            JdbcTestUtils.deleteFromTables(jdbcTemplate, NAMES_TABLE);
        }

    } catch (BadSqlGrammarException e) {
        switch (e.getSQLException().getErrorCode()) {
            case ErrorCode.TABLE_OR_VIEW_NOT_FOUND_1:

                jdbcTemplate.execute(new StringBuilder()
                        .append("CREATE TABLE ").append(NAMES_TABLE).append(" (\n")
                        .append(" id INT PRIMARY KEY,\n")
                        .append(" name VARCHAR,\n")
                        .append(" automat VARCHAR\n")
                        .append(");").toString());

                break;
            default:
                throw e;
        }
    }
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
public final void doTearDown() {
	try {
		solrServer.deleteByQuery("*:*");
		JdbcTestUtils.deleteFromTables(jdbc, tableNames());
	} catch (SolrServerException | IOException e) {
		logger.error("Error tearing down test data");
		e.printStackTrace();
	}
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
@Override
public void beforeTestClass(TestContext testContext) throws Exception {
    ApplicationContext applicationContext = testContext.getApplicationContext();
    DataSource dataSource = applicationContext.getBean("dataSource", DataSource.class);
    JdbcTestUtils.deleteFromTables(new JdbcTemplate(dataSource), "claim");
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
@Before
public void setUp() {
    JdbcTestUtils.deleteFromTables(simpleJdbcTemplate, "SERVICETICKET");
    JdbcTestUtils.deleteFromTables(simpleJdbcTemplate, "TICKETGRANTINGTICKET");
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
protected int deleteFromTables(String... names) {
	return JdbcTestUtils.deleteFromTables(this.jdbcTemplate, names);
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
private void savePathsIntoDb(List<Path> paths) throws SQLException {
        LOG.info("--- savePathsIntoDb ---");

        try {

            final int pathsCount = JdbcTestUtils.countRowsInTable(jdbcTemplate, PATHS_TABLE);
            if (pathsCount > 0) {
                JdbcTestUtils.deleteFromTables(jdbcTemplate, PATHS_TABLE);
            }

        } catch (BadSqlGrammarException e) {
            switch (e.getSQLException().getErrorCode()) {
                case ErrorCode.TABLE_OR_VIEW_NOT_FOUND_1:

                    jdbcTemplate.execute(new StringBuilder()
                            .append("CREATE TABLE ").append(PATHS_TABLE).append(" (\n")
                            .append(" id INT PRIMARY KEY AUTO_INCREMENT,\n")
                            .append(" source_uid INT,\n")
                            .append(" target_uid INT,\n")
                            .append(" distance DOUBLE,\n")
                            .append(" bbox VARCHAR,\n")
                            .append(" weight DOUBLE,\n")
                            .append(" time INT,\n")
                            .append(" points CLOB\n")
                            .append(");").toString());

                    jdbcTemplate.execute(String.format("CREATE UNIQUE INDEX IDX_source_target ON %s (source_uid, target_uid);", PATHS_TABLE));
                    jdbcTemplate.execute(String.format("CREATE INDEX IDX_source_uid ON %s (source_uid);", PATHS_TABLE));
                    jdbcTemplate.execute(String.format("CREATE INDEX IDX_target_uid ON %s (target_uid);", PATHS_TABLE));
                    jdbcTemplate.execute(String.format("CREATE INDEX IDX_distance ON %s (distance);", PATHS_TABLE));
                    jdbcTemplate.execute(String.format("CREATE INDEX IDX_time ON %s (time);", PATHS_TABLE));

                    break;
                default:
                    throw e;
            }
        }

        final String insertSql = "INSERT INTO " + PATHS_TABLE + " (source_uid, target_uid, distance, bbox, weight, time, points) VALUES (?, ?, ?, ?, ?, ?, ?)";
        jdbcTemplate.batchUpdate(insertSql, paths, paths.size(), (ps, argument) -> {
            ps.setInt(1, argument.source.uid);
            ps.setInt(2, argument.target.uid);
            ps.setDouble(3, argument.distance);
            ps.setString(4, Joiner.on(',').join(argument.bbox));
            ps.setDouble(5, argument.weight);
            ps.setInt(6, argument.time);
            ps.setString(7, argument.points);
        });


//        System.out.println(JdbcTestUtils.countRowsInTable(jdbcTemplate, PATHS_TABLE));
//        List<Map<String, Object>> list = jdbcTemplate.queryForList("SELECT * FROM " + PATHS_TABLE);
//        for (Map<String, Object> map : list) {
//            System.out.println(map);
//        }
    }
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
@Override
public void beforeTestMethod(final TestContext testContext) throws Exception {
    JdbcTestUtils.deleteFromTables(getJdbcTemplate(testContext.getApplicationContext()), "pets", "people");

    log.info("Deleted data from tables: 'pets', 'people'...");
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
/**
 * One-time test initialization.
 *
 * @throws Exception On setup errors.
 */
public void afterPropertiesSet() throws Exception {
    JdbcTestUtils.deleteFromTables(simpleJdbcTemplate, "locks");
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
/**
 * Convenience method for deleting all rows from the specified tables.
 * <p>Use with caution outside of a transaction!
 * @param names the names of the tables from which to delete
 * @return the total number of rows deleted from all specified tables
 * @see JdbcTestUtils#deleteFromTables
 */
protected int deleteFromTables(String... names) {
	return JdbcTestUtils.deleteFromTables(this.jdbcTemplate, names);
}
 

import org.springframework.test.jdbc.JdbcTestUtils; //导入方法依赖的package包/类
/**
 * Convenience method for deleting all rows from the specified tables. Use
 * with caution outside of a transaction!
 * @param names the names of the tables from which to delete
 * @return the total number of rows deleted from all specified tables
 */
protected int deleteFromTables(String... names) {
	return JdbcTestUtils.deleteFromTables(this.jdbcTemplate, names);
}