package flyway.pti3d;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.flywaydb.core.api.migration.jdbc.JdbcMigration;

import fi.nls.oskari.util.FlywayHelper;

public class V1_6__add_camera_controls_3d_bundle_to_3D_views implements JdbcMigration{

	private static final String BUNDLE_ID = "camera-controls-3d";
	
	@Override
	public void migrate(Connection connection) throws Exception {
		final List<Long> views = get3DApplicationViewIds(connection);
		for (Long viewId : views) {
			if (FlywayHelper.viewContainsBundle(connection, BUNDLE_ID, viewId)) {
				continue;
			}
			FlywayHelper.addBundleWithDefaults(connection, viewId, BUNDLE_ID);
		}
	}
	
	private static List<Long> get3DApplicationViewIds(Connection connection) throws SQLException {
        ArrayList<Long> ids = new ArrayList<>();
        StringBuilder sql = new StringBuilder("SELECT id FROM portti_view WHERE application IN ('geoportal-3D','embedded-3D') AND type IN ('DEFAULT','PUBLISH')");

        try (final PreparedStatement statement =
                     connection.prepareStatement(sql.toString())) {
            try (ResultSet rs = statement.executeQuery()) {
                while (rs.next()) {
                    ids.add(rs.getLong("id"));
                }
            }
        }
        return ids;
    }
}

Add camera-controls-3d bundle to 3D views
Add camera-controls-3d bundle to 3D views
