Configuration
Here is some information about the configuration of the app.
Configuration File
The config.js file is located in the same folder as the app executable. This file contains all the configuration options for the app. You can find a list of all the configuration options below.
Configuration Options
- General
- Databases
General Options
| Command | Default | Description |
|---|---|---|
dbdAccountId | - | Your account ID of your DBD account, more info about this here |
updateIntervalSec | 60 | The amount of seconds between data updates by the app |
databases | databases[] | The databases that should be used by the app, options for databases are listed in the databases tab |
Databases Options
All options inside the databases config option.
| Command | Default | Description |
|---|---|---|
enabled | true | If the database should be used by the app |
sources | sources[] | The sources that should be used by the app, the sources options are listed below |
destination | - | The destination that should be used by the app, the destination options are listed below |
columnNameConversions | columnNameConversions[] | The column name conversions that should be used by the app, the column name conversions options are listed below |
Sources Options
All options inside the databases.sources config option.
| Command | Default | Description |
|---|---|---|
host | localhost | The host of the database |
user | root | The user of the database |
password | - | The password of the database |
database | - | The name of the database |
tables | tables[] | The tables of the database the options inside this option are listed below. |
Tables Options
All options inside the databases.sources.tables config option.
| Command | Default | Description |
|---|---|---|
table | - | The name of the table |
searchByColumn | - | The column to search by |
mergeColumns | - | The columns to merge, these columns will be added into the merge table |
Destination Options
All options inside the destination config option.
| Command | Default | Description |
|---|---|---|
host | localhost | The host of the database |
user | root | The user of the database |
password | - | The password of the database |
database | - | The name of the database where the merged table should be created/updated |
table | - | The name of the table that should be created, this table has all the merged data. |
Column Name Conversions Options
All options inside the columnNameConversions config option.
| Command | Default | Description |
|---|---|---|
from | - | The column name that should be converted |
to | - | The column name that the column name should be converted to |