Fixed bugs

• getl.mysql.MySQLDriver fixed bug related to the creation of temporary tables.
• getl.vertica.ReverseEngineering: changed name parameter sqlFile to script_path
• getl.vertica.ReverseEngineering: modified config sections to three section: drop, create and filename (see below for a description of the structure of the configuration file)
• getl.vertica.ReverseEngineering: fix bug in define cascade pools
• getl.vertica.ReverseEngineering: fix bug if object has long name
• getl.vertica.ReverseEngineering: fix bug sorting of grants
• getl.vertica.ReverseEngineering: fix bug for first description line in script files
• getl.utils.EMailer: fix bug in send by text plain format

Future

• getl.utils.DateUtils: added support work this module under other not current time zone

Structure of sections in config file by ReverseEngineering

generate drop statement for objects

"drop": {
    "pools": false,
    "roles": false,
    "users": false,
    "schemas": false,
    "sequences": false,
    "tables": false,
    "views": false,
    "sql_functions": false
}

create statement for objects

"create": {
    "pools": false,
    "pool_empty": false, (generate only create pools without parameters)
    "roles": false,
    "users": false,
    "user_empty": false, (generate only create users without parameters)
    "schemas": false,
    "sequences": false,
    "sequences_current": false, (generate statement for setting current value)
    "tables": false,
    "table_constraints": false,
    "column_comments": false,
    "projection_tables": false,
    "projection_ksafe": 1, (generate other ksafe in projections than current ksafe by server)
    "projection_analyze_super": false, (added /*+createtype(A)*/ to super projections if they don't have hints)
    "views": false,
    "sql_functions": false,
    "grants": false
}

-- the mask of file for objects, you can specify a single file for each object type (default file mask <objects>.sql) or use variables to split the object files

"filename":{
    "pools": "pools/{pool}",
    "tables": "tables/{schema}/{table}",
    "views": "views/{schema}/{view}",
    "roles": "roles/{role}",
    "users": "users/{user}",
    "schemas": "schemas/{schema}",
    "sequences": "sequences/{schema}/{sequence}",
    "sql_functions": "functions/{sql_function}"
}