HOTMapper Settings

Updated with v1.0.

This page contains information about HOTMapper Settings.

Summary

• Login credentials in database (monetdb)
• Name of the database to connect to
• Backup folder and file name
• Source table definitions
• Show SQL queries sent to database
• Logging level and format of the message
• Mapping protocol columns

In the settings.py file, present on the HOTMapper main folder, you'll encounter the following options:

Login credentials in database (monetdb)

DATABASE_USER = 'monetdb'
DATABASE_USER_PASSWORD = 'monetdb'

Name of the database to connect to

DATABASE = 'hotmapper_demo'

Backup folder and file name

Absolute path of the folder where backup is created, name of the backup file.

BACKUP_FOLDER = '/home/banco/dumps/monetdb/'
BACKUP_FILE = 'backupdadoseducacionais'

Source table definitions

During the creation of your first table, HOTMapper will also create a table to store information about the data source of each table you create. Here you can define the name of this table and it's columns.

SOURCE_TABLE_NAME = 'fonte'
SOURCE_TABLE_COLUMNS = {
    'table_name': 'tabela',
    'source': 'fonte'
}

Show SQL queries sent to database

ECHO = false

Logging level and format of the message

The possible levels, that starting from the one that shows less information to the one that shows more, are: 1. CRITICAL; 2. ERROR; 3. WARNING; 4. INFO; 5. DEBUG; 6. NOT SET;

LOGGING_LEVEL = logging.INFO
LOGGING_FORMAT = "%(levelname)s - %(name)s: %(message)s"

Mapping protocol columns

You can also change the name of the columns present in the mapping protocol by editing the 'standard_columns' constant in the protocol.py file, contained in the folder hotmapper/database.

 This option will be more easily available when we finish working in the complete internationalization of the HOTMapper, then it will have presets for specific languages to facilitate understanding and use of the tool

standard_columns = {
    'description': 'Novo Rótulo',
    'target_name': 'Var.Lab',
    'standard_name': 'Rot.Padrão',
    'database_name': 'Nome Banco',
    'data_type': 'Tipo de Dado',
    'temporary_column': 'Coluna temporária'
}