/*
  Copyright (C) 2000 - 2026 Silverpeas

  This program is free software: you can redistribute it and/or modify
  it under the terms of the GNU Affero General Public License as
  published by the Free Software Foundation, either version 3 of the
  License, or (at your option) any later version.

  As a special exception to the terms and conditions of version 3.0 of
  the GPL, you may redistribute this Program in connection with Free/Libre
  Open Source Software ("FLOSS") applications as described in Silverpeas's
  FLOSS exception.  You should have received a copy of the text describing
  the FLOSS exception, and it is also available here:
  "https://www.silverpeas.org/legal/floss_exception.html"

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU Affero General Public License for more details.

  You should have received a copy of the GNU Affero General Public License
  along with this program.  If not, see <https://www.gnu.org/licenses/>.
 */
package org.silverpeas.setup.migration

import groovy.test.GroovyAssert
import org.junit.Before
import org.junit.Test
import org.silverpeas.setup.api.FileLogger
import org.silverpeas.setup.api.Script

import java.sql.SQLException

import static org.silverpeas.setup.migration.MigrationScriptBuilder.ScriptType.groovy
import static org.silverpeas.setup.migration.MigrationScriptBuilder.ScriptType.sql
import static org.silverpeas.setup.test.Assertion.numberOfItems
import static org.silverpeas.setup.test.Assertion.versionOfModule
/**
 * Test the case of a database migration for a fresh installation of Silverpeas.
 * @author mmoquillon
 */
class DatasourceMigrationTest extends AbstractDatabaseTest {

  def settings = ['SIVLERPEAS_HOME': '/home/silverpeas']

  @Before
  void prepareTest() {
    mockSilverpeasSetupService()
  }

  @Test
  void testMigrationForAFreshInstallation() {
    assert versionOfModule(databaseSetUp.sql, 'toto') == null

    Script script = MigrationScriptBuilder
        .fromScript("${context.migrationHome}/db/h2/toto/002/create_table.sql")
        .ofType(sql)
        .build()
    DatasourceMigration migration = DatasourceMigration.builder()
        .module('toto')
        .toVersion('002')
        .scripts([script])
        .settings(settings)
        .logger(FileLogger.getLogger(getClass().getSimpleName()))
        .build()
    migration.migrate()

    assert versionOfModule(databaseSetUp.sql, 'toto') == '002'
  }

  @Test
  void testUpgradeWithOnlySQLScripts() {
    prepareInitialData('toto', '002')
    assert versionOfModule(databaseSetUp.sql, 'toto') == '002'

    Script script = MigrationScriptBuilder
        .fromScript("${context.migrationHome}/db/h2/toto/up002/update.sql")
        .ofType(sql)
        .build()
    DatasourceMigration migration = DatasourceMigration.builder()
        .module('toto')
        .fromVersion('002')
        .toVersion('003')
        .scripts([script])
        .settings(settings)
        .logger(FileLogger.getLogger(getClass().getSimpleName()))
        .build()
    migration.migrate()

    assert versionOfModule(databaseSetUp.sql, 'toto') == '003'
  }

  @Test
  void testUpgradeWithOnlyGroovyScripts() {
    prepareInitialData('toto', '003')
    assert versionOfModule(databaseSetUp.sql, 'toto') == '003'
    assert numberOfItems(databaseSetUp.sql, 'Person') == 0

    Script script = MigrationScriptBuilder
        .fromScript("${context.migrationHome}/scripts/toto/up003/update.groovy")
        .ofType(groovy)
        .build()
    DatasourceMigration migration = DatasourceMigration.builder()
        .module('toto')
        .fromVersion('003')
        .toVersion('004')
        .scripts([script])
        .settings(settings)
        .logger(FileLogger.getLogger(getClass().getSimpleName()))
        .build()
    migration.migrate()

    assert versionOfModule(databaseSetUp.sql, 'toto') == '004'
    assert numberOfItems(databaseSetUp.sql, 'Person') == 1
  }

  @Test
  void testMigrationForAnUpgrade() {
    prepareInitialData('toto', '003')
    assert versionOfModule(databaseSetUp.sql, 'toto') == '003'
    assert numberOfItems(databaseSetUp.sql, 'Person') == 0

    Script sqlScript = MigrationScriptBuilder
        .fromScript("${context.migrationHome}/db/h2/toto/up003/create_table.sql")
        .ofType(sql)
        .build()
    Script groovyScript = MigrationScriptBuilder
        .fromScript("${context.migrationHome}/scripts/toto/up003/update.groovy")
        .ofType(groovy)
        .build()
    DatasourceMigration migration = DatasourceMigration.builder()
        .module('toto')
        .fromVersion('003')
        .toVersion('004')
        .scripts([sqlScript, groovyScript])
        .settings(settings)
        .logger(FileLogger.getLogger(getClass().getSimpleName()))
        .build()
    migration.migrate()

    assert versionOfModule(databaseSetUp.sql, 'toto') == '004'
    assert numberOfItems(databaseSetUp.sql, 'Person') == 1
  }

  @Test
  void testAnInstallationFailure() {
    assert versionOfModule(databaseSetUp.sql, 'foo') == null

    Script script = MigrationScriptBuilder
        .fromScript("${context.migrationHome}/db//h2/foo/002/create_table.sql")
        .ofType(sql)
        .build()

    GroovyAssert.shouldFail(SQLException) {
      DatasourceMigration migration = DatasourceMigration.builder()
          .module('foo')
          .toVersion('002')
          .scripts([script])
          .settings(settings)
          .logger(FileLogger.getLogger(getClass().getSimpleName()))
          .build()
      migration.migrate()
    }

    assert versionOfModule(databaseSetUp.sql, 'foo') == null
  }

  @Test
  void testAnUpgradeFailure() {
    prepareInitialData('foo', '003')
    assert versionOfModule(databaseSetUp.sql, 'foo') == '003'

    Script script = MigrationScriptBuilder
        .fromScript("${context.migrationHome}/scripts/foo/up002/update.groovy")
        .ofType(groovy)
        .build()

    GroovyAssert.shouldFail(SQLException) {
      DatasourceMigration migration = DatasourceMigration.builder()
          .module('foo')
          .fromVersion('003')
          .toVersion('004')
          .scripts([script])
          .settings(settings)
          .logger(FileLogger.getLogger(getClass().getSimpleName()))
          .build()
      migration.migrate()
    }

    assert versionOfModule(databaseSetUp.sql, 'foo') == '003'
  }
}
