Dsl features

• engine: at the start of the Getl application, you can now describe the configuration resource file "getl-properties.conf", in which you can set the Getl work properties for the project
• repository: in annotation "SaveToRepository" it is now possible to list several stands at once in "env" separated by commas
• models: in model "referenceVerticaTable", now when creating a reference schema, when calling method "createReferenceTables", the created schema is automatically assigned the grants to the roles that are set by default for the session login
• test: added property "autoLoadProperties" to class "GetlDslTest", which indicates that when starting the test case, use the resource configuration file "getl-properties.conf" (see below for a description of the configuration file format)

Dsl bugs

• repository: fixed a bug when saving objects to files, where object passwords during encoding changed the password value for saved objects
• options: fixed a bug when an object's options parameter was set to null and an NullPointerException was thrown

Getl features

• getl.utils.Map: added method Clone that allows you to clone a map at the level of new keys and nested structures, but without changing references to item values
• getl.jdbc.TableDataset: added automatic commit for methods "countRow" and "copyTo" if they are called outside of a transaction
• getl.utils.MapUtils: added method "ProcessSections" that allows you to describe the code for each section of the map that needs to be executed (see test case for example)

Getl bugs

• getl.impala.ImpalaTable: fixed a bug in method SelectListForInsert where the types of fields could be incorrectly listed
• getl.files.SFTPManager: fixed the error when the resource name of the keys file was specified for "identityFile" and there was an exception that the file was not found

Getl configuration file description

For Getl to automatically set its properties when the application starts, create file getl-properties.conf in the resource directory of the project, in which you describe:

:::groovy
engine {
    // initialization class (if needed)
    initClass = 'full class name' 
    // clone connections for threads
    connectionThreadModel = true

    // dataset for checking permission to start scripts (there should be two fields: name and enabled)
    controlDataset = 'repository dataset'
    // check the permissions of scripts to start
    controlStart = true
    // check the permissions of scripts while executing in threads
    controlThreads = false
    // automatically create temporary csv files for jdbc tables
    csvTempForTables = false
}

logging {
    // log the executable script to the specified file
    logFileName = '{PROJECT_PATH}/logs/{env}/{process}/{date}.log'
    // write logs of executed SQL commands for working with jdbc connections to the specified directory
    jdbcLogPath = '{PROJECT_PATH}/logs/{env}/jdbc'
    // write logs of executed commands for working with file sources to the specified directory
    filesLogPath = '{PROJECT_PATH}/logs/{env}/files'
}

profile {
    // profile the execution of getl statements
    enabled = true
    // enable debugging for profiling to fix the start time of the statement
    debug = false
    // log level for profiling output
    level = java.util.logging.Level.FINER
    // logging level when outputting echo commands from SQL scripts
    sqlEchoLevel = java.util.logging.Level.FINER
}

project {
    // check for OS environments at startup
    needEnvironments = ['PROJECT_PATH']
    // the name of the configuration file with the project description
    configFileName = 'resource:/my-project.conf'
}

repository {
    // path to configuration files of Getl repository
    path = 'resource:/repository'
    // path to the configuration files of the Getl repository for scripts for saving objects to the repository from RepositorySave
    repositorySavePath = 'src/main/resource/repository'
    // encryption key for passwords of connections and file managers in the repository files
    encryptKey = 'repository password key'
}