base.cfg

[buildout]
extends =
    https://raw.githubusercontent.com/syslabcom/metabase.buildout/master/base.cfg
    picked-versions.cfg
metabase-instances =
    metabase-global
    metabase-eu
    metabase-fr
parts +=
    ${:metabase-instances}
    create-databases.sql
    dump-metabase
    init-metabase

[metabase-instance]
metabase-user = admin@syslab.com

[metabase-global]
<= metabase-instance
metabase-port = 3001
database-name = metabase_global
database-name-statistics = statistics_global

[metabase-eu]
<= metabase-instance
metabase-port = 3002
database-name = metabase_eu
database-name-statistics = statistics_eu

[metabase-fr]
<= metabase-instance
metabase-port = 3003
database-name = metabase_fr
database-name-statistics = statistics_fr

[sqlformat]
recipe = zc.recipe.egg:scripts
eggs =
    sqlparse

[dump-metabase]
<= metabase-instance
=> sqlformat
recipe = collective.recipe.template
input = ${buildout:directory}/templates/dump-metabase.tmpl
output = ${buildout:directory}/bin/${:_buildout_section_name_}
mode = 755

[create-databases.sql]
recipe = collective.recipe.template[genshi]:genshi
input = ${buildout:directory}/templates/create-databases.sql.tmpl
output = ${buildout:directory}/scripts/${:_buildout_section_name_}

[oira-scripts]
recipe = zc.recipe.egg
eggs =
    oira.statistics.deployment

[init-metabase]
=> oira-scripts
recipe = collective.recipe.template[genshi]:genshi
input = ${buildout:directory}/templates/init-metabase.tmpl
output = ${buildout:directory}/bin/${:_buildout_section_name_}
mode = 755

[supervisor]
programs +=
    200 metabase-global (environment=MB_JETTY_PORT=${metabase-global:metabase-port},MB_DB_DBNAME=${metabase-global:database-name}) java [-jar ${metabase-jar:location}/metabase.jar] ${metabase-jar:location} true
    210 metabase-eu     (environment=MB_JETTY_PORT=${metabase-eu:metabase-port},MB_DB_DBNAME=${metabase-eu:database-name})         java [-jar ${metabase-jar:location}/metabase.jar] ${metabase-jar:location} true
    220 metabase-fr     (environment=MB_JETTY_PORT=${metabase-fr:metabase-port},MB_DB_DBNAME=${metabase-fr:database-name})         java [-jar ${metabase-jar:location}/metabase.jar] ${metabase-jar:location} true