com.enioka.jqm.model.updater.cli.GetSchemaUpdateSqlVerb Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of jqm-model-updater-cli Show documentation

Manages the JQM database schema

The newest version!

package com.enioka.jqm.model.updater.cli;

import java.sql.SQLException;
import java.util.Properties;
import java.util.ServiceLoader;

import org.kohsuke.MetaInfServices;

import com.beust.jcommander.Parameters;
import com.enioka.jqm.cli.api.CommandBase;
import com.enioka.jqm.jdbc.Db;
import com.enioka.jqm.jdbc.DbManager;
import com.enioka.jqm.model.updater.DbSchemaManager;
import com.enioka.jqm.shared.services.ServiceLoaderHelper;

@MetaInfServices(CommandBase.class)
@Parameters(commandNames = "Get-SchemaSql", commandDescription = "Displays the database schema SQL commands needed to make it up to date.")
public class GetSchemaUpdateSqlVerb extends CommandBase
{

    @Override
    public int doWork()
    {
        var dbSchemaManager = ServiceLoaderHelper.getService(ServiceLoader.load(DbSchemaManager.class));
        Properties properties = new Properties();
        properties.put("com.enioka.jqm.jdbc.waitForConnectionValid", "true");
        properties.put("com.enioka.jqm.jdbc.waitForSchemaValid", "false");

        Db db = DbManager.getDb(properties);
        try (var cnx = db.getDataSource().getConnection())
        {
            var sql = dbSchemaManager.getUpdateSchemaSql(cnx);
            jqmlogger.info("=== Start of SQL commands\n\n" + sql);
            jqmlogger.info("\n=== End of SQL commands");
            return 0;
        }
        catch (SQLException e)
        {
            jqmlogger.error("Could not get upgrade database schema SQL", e);
            return 1;
        }
    }
}