/*
 * $Id$
 *
 * This file is part of the Cloud Services Integration Platform (CSIP),
 * a Model-as-a-Service framework, API, and application suite.
 *
 * 2012-2024, OMSLab, Colorado State University.
 *
 * OMSLab licenses this file to you under the MIT license.
 * See the LICENSE file in the project root for more information.
 */
package crlmod;

import static crlmod.ServiceResources.*;
import csip.annotations.*;
import static csip.annotations.ResourceType.*;

/**
 * Shared CRLMOD Service resources.
 *
 * @author lucasy
 */
// LMOD SQL DB
@Resource(type = JDBC, file = "${lmod.db}", id = LMOD_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)
// CR_LMOD SQL DB
@Resource(type = JDBC, file = "${crlmod.db}", id = CR_LMOD_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)
// CR_LMOD_2018 SQL DB
@Resource(type = JDBC, file = "${crlmod.2018.db}", id = CR_LMOD_2018_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)
//CR_LMOD_2018_June SQL DB
@Resource(type = JDBC, file = "${crlmod.2018.june.db}", id = CR_LMOD_2018_JUNE_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)
// CR_LMOD_2019 SQL DB
@Resource(type = JDBC, file = "${crlmod.2019.db}", id = CR_LMOD_2019_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)
// CR_LMOD_2019_step SQL DB
@Resource(type = JDBC, file = "${crlmod.2019.step.db}", id = CR_LMOD_2019_STEP_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)

// CR_LMOD_2021 SQL DB
@Resource(type = JDBC, file = "${crlmod.2021.db}", id = CR_LMOD_2021_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)

// CR_LMOD_2022 SQL DB
@Resource(type = JDBC, file = "${crlmod.2022.db}", id = CR_LMOD_2022_ID,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)

// CR_LMOD_2022 SQL DB
@Resource(type = JDBC, file = "${crlmod.latest.db}", id = CR_LMOD_R2,
        env = {
          "maxWait=6000000",
          "jmxEnabled=false",
          "logAbandoned=true",
          "removeAbandonedTimeout=3000",
          "testOnBorrow=true",
          "validationQuery=SELECT 1",
          "testOnReturn=false",
          "validationInterval=30000",
          "timeBetweenEvictionRunsMillis=30000",
          "removeAbandoned=true",
          "defaultAutoCommit=false"
        }
)

// SQL Lite
//@Resource(type = FILE, file = "/bin/win-x86/sqlite.exe", id = SQLITE_ID)
//@Resource(type = FILE, file = "/bin/win-x86/sqlite3.exe", id = SQLITE3_ID)
// CMD line
//@Resource(type = REFERENCE, file = "cmd", id = CMD_ID)
public interface ServiceResources {

  // resource ids
  String LMOD_ID = "lmod";
  String CR_LMOD_ID = "cr_lmod";
  String CR_LMOD_2018_ID = "cr_lmod_2018";
  String CR_LMOD_2018_JUNE_ID = "cr_lmod_2018_june";
  String CR_LMOD_2019_ID = "cr_lmod_2019";
  String CR_LMOD_2019_STEP_ID = "cr_lmod_2019_step";
  String CR_LMOD_2021_ID = "cr_lmod_2021";
  String CR_LMOD_2022_ID = "cr_lmod_2022";  
  String CR_LMOD_R2 = "cr_lmod_current_year_plus_r2_step";
//  String SQLITE_ID = "sqllite";
//  String SQLITE3_ID = "sqllite3";
//  String CMD_ID = "cmd";

  // keys
  String KEY_NAME = "name";
  String KEY_PATH = "path";
  String KEY_PARTIAL_PATH = "partial_path";
  String KEY_KEYWORDS = "keywords";
  String KEY_CMZ = "cmz";
  String KEY_STIR_MIN = "stir_min";
  String KEY_STIR_MAX = "stir_max";
  String KEY_LIMIT = "limit";
  String KEY_OFFSET = "offset";
  String KEY_ID = "id";
  String KEY_FULLDATA = "full_data";
  String KEY_FORMAT = "format";
  String KEY_STATUS = "status";
  String KEY_USER_ID = "user_id";
  String KEY_R2DATA = "r2data";
  String KEY_R2FILENAME = "r2_file_name";
  String KEY_WEPSDATA = "wepsdata";
  String KEY_WEPSFILENAME = "weps_file_name";
  String KEY_TRANSFILE = "transfile";
  String KEY_NAMESONLY = "names_only";
  String KEY_NATIVEFORMATS = "native_formats";
}