39 lines
1.0 KiB
Bash
Executable File
39 lines
1.0 KiB
Bash
Executable File
#!/bin/sh
|
|
# link: https://github.com/camptocamp/docker-odoo-project
|
|
|
|
if [ -n "${ODOO_BASE_URL}" ]; then
|
|
|
|
if [ "$( psql -tAc "SELECT 1 FROM pg_database WHERE datname='${DB_NAME}'" )" != '1' ]
|
|
then
|
|
echo "Database does not exist, ignoring script"
|
|
exit 0
|
|
fi
|
|
|
|
echo "Setting Base URL to domain ${ODOO_BASE_URL}"
|
|
psql --quiet << EOF
|
|
|
|
WITH update_param AS (
|
|
UPDATE ir_config_parameter
|
|
SET value = '${ODOO_BASE_URL}'
|
|
WHERE key = 'web.base.url'
|
|
RETURNING *
|
|
)
|
|
INSERT INTO ir_config_parameter
|
|
(value, key, create_uid, write_uid, create_date, write_date)
|
|
SELECT '${ODOO_BASE_URL}', 'web.base.url', 1, 1, now(), now()
|
|
WHERE NOT EXISTS (SELECT * FROM update_param);
|
|
|
|
WITH update_param AS (
|
|
UPDATE ir_config_parameter
|
|
SET value = 'True'
|
|
WHERE key = 'web.base.url.freeze'
|
|
RETURNING *
|
|
)
|
|
INSERT INTO ir_config_parameter
|
|
(value, key, create_uid, write_uid, create_date, write_date)
|
|
SELECT 'True', 'web.base.url.freeze', 1, 1, now(), now()
|
|
WHERE NOT EXISTS (SELECT * FROM update_param);
|
|
|
|
EOF
|
|
fi
|