org.molgenis.migrate.version.v1_15.Step24UpdateApplicationSettings Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of molgenis-data-migrate Show documentation
There is a newer version: 8.4.5
Show newest version
package org.molgenis.migrate.version.v1_15;

import static java.util.Objects.requireNonNull;

import javax.sql.DataSource;

import org.molgenis.data.IdGenerator;
import org.molgenis.framework.MolgenisUpgrade;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;

public class Step24UpdateApplicationSettings extends MolgenisUpgrade
{
	private final Logger LOG = LoggerFactory.getLogger(Step24UpdateApplicationSettings.class);

	private final JdbcTemplate jdbcTemplate;
	private final IdGenerator idGenerator;

	@Autowired
	public Step24UpdateApplicationSettings(DataSource dataSource, IdGenerator idGenerator)
	{
		super(23, 24);
		this.jdbcTemplate = new JdbcTemplate(requireNonNull(dataSource));
		this.idGenerator = requireNonNull(idGenerator);
	}

	@Override
	public void upgrade()
	{
		LOG.info("Updating application settings ...");

		// add visible expression to sign up moderation setting
		String visibleExpression = "$('signup').eq(true).value()";
		String sql = "UPDATE attributes LEFT JOIN entities_attributes ON attributes.identifier = entities_attributes.attributes SET visibleExpression = ? WHERE fullName = ? and name= ?";
		jdbcTemplate.update(sql, visibleExpression, "settings_app", "signup_moderation");

		// add new settings between other settings
		String orderSql = "UPDATE attributes LEFT JOIN entities_attributes ON attributes.identifier = entities_attributes.attributes SET `order` = `order` + ? WHERE fullName = ? and `order` >= ?";
		jdbcTemplate.update(orderSql, 2, "settings_app", 4);

		// add google_sign_in setting
		String googleSignInId = idGenerator.generateId();
		boolean googleSignInIdDefaultValue = true;
		jdbcTemplate
				.update("INSERT INTO attributes (`identifier`,`name`,`dataType`,`refEntity`,`expression`,`nillable`,`auto`,`idAttribute`,`lookupAttribute`,`visible`,`label`,`description`,`aggregateable`,`enumOptions`,`rangeMin`,`rangeMax`,`labelAttribute`,`readOnly`,`unique`,`visibleExpression`,`validationExpression`,`defaultValue`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
						googleSignInId, "google_sign_in", "bool", null, null, false, false, false, false, true,
						"Enable Google Sign-In", "Enable users to sign in with their existing Google account", false,
						null, null, null, false, false, false,
						"$('signup').eq(true).value() && $('signup_moderation').eq(false).value()", null,
						String.valueOf(googleSignInIdDefaultValue));

		jdbcTemplate.update("INSERT INTO entities_attributes (`order`, `fullName`, `attributes`) VALUES (?, ?, ?)", 4,
				"settings_app", googleSignInId);

		// add google_app_client_id setting
		String googleAppClientId = idGenerator.generateId();
		String googleAppClientIdDefaultValue = "130634143611-e2518d1uqu0qtec89pjgn50gbg95jin4.apps.googleusercontent.com";
		jdbcTemplate
				.update("INSERT INTO attributes (`identifier`,`name`,`dataType`,`refEntity`,`expression`,`nillable`,`auto`,`idAttribute`,`lookupAttribute`,`visible`,`label`,`description`,`aggregateable`,`enumOptions`,`rangeMin`,`rangeMax`,`labelAttribute`,`readOnly`,`unique`,`visibleExpression`,`validationExpression`,`defaultValue`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
						googleAppClientId, "google_app_client_id", "string", null, null, false, false, false, false,
						true, "Google app client ID", "Google app client ID used during Google Sign-In", false, null,
						null, null, false, false, false, "$('google_sign_in').eq(true).value()", null,
						googleAppClientIdDefaultValue);

		jdbcTemplate.update("INSERT INTO entities_attributes (`order`, `fullName`, `attributes`) VALUES (?, ?, ?)", 5,
				"settings_app", googleAppClientId);

		// update existing settings table
		jdbcTemplate.execute("ALTER TABLE settings_app ADD COLUMN `google_sign_in` tinyint(1) NOT NULL");
		jdbcTemplate.execute("ALTER TABLE settings_app ADD COLUMN `google_app_client_id` text");

		// update existing settings entity
		jdbcTemplate.update("UPDATE settings_app SET google_sign_in = ?, google_app_client_id = ? WHERE id = ?",
				googleSignInIdDefaultValue, googleAppClientIdDefaultValue, "app");

		LOG.debug("Updated application settings");
	}
}