public void create() { if (databaseExists()) { return; } initConnectionManager.execute( new SqlRunner(SQL_DATABASE_KILL_ACTIVITY) { @Override protected void bind() { bind("database", initDatabase()); } }); initConnectionManager.execute(String.format(SQL_DATABASE_CREATE, currentDatabase())); }
public void drop() { if (!databaseExists()) { return; } final String database = currentDatabase(); initConnectionManager.execute( new SqlRunner(SQL_DATABASE_KILL_ACTIVITY) { @Override protected void bind() { bind("database", database); } }); initConnectionManager.execute(String.format(SQL_DATABASE_DROP, database)); }
public void recreate(String schema) { connectionManager.execute( String.format("drop schema %s cascade; create schema %s;", schema, schema)); }
private void truncate(String table) { connectionManager.execute(String.format("truncate table %s cascade", table)); }
private void createTable(String kind) { connectionManager.execute(String.format(SQL_TABLE_CREATE, kind)); }