arisnew

SELECT
    TABLE_NAME,
    COLUMN_NAME,
    CONSTRAINT_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM
    INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE

arisnew

docker compose exec NAMA_SERVICE_ODOO odoo \
-d NAMA_DB \
--db_password PASSWORD_DB \
--db_host NAMA_SERVICE_DB \
--no-xmlrpc \
--stop-after-init \
--update NAMA_ADDON

arisnew

Jika kita mendapatkan error access right odoo yg mungkin tidak tahu detail kesalahan itu dibaris kode yg mana, kita bisa traceback lebih detail. Kita perlu edit model core nya odoo.

Ref https://www.odoo.com/forum/help-1/how-to-debug-access-permissions-121603

Berikut contoh pesan errornya:

Due to security restrictions, you are not allowed to access 'Sale Order' (sale.order) records.

arisnew

example in postgresql old version:

-- login psql
-- makesure db exist
-- Disallow new connections
UPDATE pg_database SET datallowconn = false WHERE datname = "NAMA_DB";
-- ALTER DATABASE "NAMA_DB" CONNECTION LIMIT 1; -- (jika perlu)

-- teriminate existing connection
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname = "NAMA_DB";

arisnew

SELECT tmp_tbl.asset_id,
    MAX(CASE WHEN tmp_tbl.custom_sequence=1 THEN tmp_tbl.software_name ELSE NULL END) other_software_1,
    MAX(CASE WHEN tmp_tbl.custom_sequence=2 THEN tmp_tbl.software_name ELSE NULL END) other_software_2,
    MAX(CASE WHEN tmp_tbl.custom_sequence=3 THEN tmp_tbl.software_name ELSE NULL END) other_software_3,
    MAX(CASE WHEN tmp_tbl.custom_sequence=4 THEN tmp_tbl.software_name ELSE NULL END) other_software_4,
    MAX(CASE WHEN tmp_tbl.custom_sequence=5 THEN tmp_tbl.software_name ELSE NULL END) other_software_5,
    MAX(CASE WHEN tmp_tbl.custom_sequence=6 THEN tmp_tbl.software_name ELSE NULL END) other_software_6,
    MAX(CASE WHEN tmp_tbl.custom_sequence=7 THEN tmp_tbl.software_name ELSE NULL END) other_software_7,
    MAX(CASE WHEN tmp_tbl.custom_sequence=8 THEN tmp_tbl.software_name ELSE NULL END) other_software_8

arisnew

reff : https://stackoverflow.com/a/59189173/23541428

brew install libpq

sudo ln -s $(brew --prefix)/opt/libpq/bin/psql /usr/local/bin/psql

arisnew

version: '3.1'
services:
  db:
    image: mysql:latest
    container_name: db
    # restart: unless-stopped
    environment:
      MYSQL_ROOT_USERNAME: root
 MYSQL_ROOT_PASSWORD: root

arisnew

Jika dari docker tidak bisa konek ke jaringan luar via VPN bisa mencoba hal berikut:

• drop dulu container yang jalan docker compose down
• reset all network docker (Peringatan : ini akan menghapus semua network yg ada di docker) docker network prune
• kemudian jalankan lagi container docker compose up -d

Ref https://stackoverflow.com/a/65598942

arisnew

Secara default kita tidak bisa mengubah dengan inherit view atau data xml odoo yang noupdate="1", agar bisa diupdate perlu set dahulu menggunakan function.

Contoh (view xml):

    <!-- Allow updating on noupdate=True records -->
    <function name="write" model="ir.model.data">
        <function name="search" model="ir.model.data">
            <value
                eval="[('module', '=', 'base'), ('name', '=', 'partner_root')]" />

arisnew

python : manual convert output number like 1.234.567,89

num = 1234567.89

value_split = '{:.2f}'.format(float(num))
decimal_split = str(value_split).split('.')
add_separators = '{:,}'.format(int(decimal_split[0]))
result = add_separators.replace(',', '.')
if len(decimal_split) > 1: