Skip to content

Instantly share code, notes, and snippets.

View ZERO20's full-sized avatar
🏠
Working from home

Edgar de la Cruz ZERO20

🏠
Working from home
View GitHub Profile
@ilyasProgrammer
ilyasProgrammer / ext_id.xml
Last active April 25, 2019 19:15
Odoo add xml identifier to modify record via xml
<!-- Trick to bind to record created with UI -->
<record id="amz_warehouse_to_fba_ext_id" model="ir.model.data">
<field name="res_id">10</field>
<field name="model">stock.picking.type</field>
<field name="module">sale_store_amazon</field>
<field name="name">amz_warehouse_to_fba</field>
<field name="noupdate">False</field>
</record>
<record id="amz_warehouse_to_fba" model="stock.picking.type">
<field name="name">Ama A</field>
@rgreenjr
rgreenjr / postgres_queries_and_commands.sql
Last active May 10, 2024 17:12
Useful PostgreSQL Queries and Commands
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
FROM pg_stat_activity
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'