Skip to content

Instantly share code, notes, and snippets.

@nvn-odoo
nvn-odoo / check_diffs.sql
Last active February 7, 2019 12:46
check differences between two databases
-- CHECK DIFF BEWEEN TWO DATABASES (A and B)
-----------------------------------------------
/*********************************************
* 1.0 CREATE THE APPROPRIATE CONFIGURATION
*********************************************/
-- create a new database AB (from terminal)
DO
$do$
declare
v_product_product_id int;
v_product_category_id int;
v_product_name varchar;
v_stock_valuation_account int;
v_company_id int;
v_stock_qty_with_date float;
@nvn-odoo
nvn-odoo / create_ab.sh
Last active May 31, 2019 08:57
Creates a database with schema 'a' and schema 'b' containing databases given in parameters
#!/bin/bash
# This tool creates a database $3 from database $1 and database $2
# database $1 will ends in the schema a
# database $2 will ends in the schema b
# this will allow comparisons between two schemas in the same database
if [ "$1" = "" ]; then
echo "USAGE: $0 <DBNAME_A> <DBNAME_B> <DBNAME_AB>" >&2
exit 1
@nvn-odoo
nvn-odoo / fix_landed_cost_issue_server_action.py
Last active April 9, 2019 08:18
Fix landed cost issue (sever action)
##################################################
# Fix landed cost issues
###################################################
counterpart_account_id_original = 1080
am_prefix = '[MIG:FIX LC]' # prefix to add to the created account_moves
aml_prefix = '[MIG:FIX LC]' # prefix to add to the created account_move_lines
def fix_it(cr, version):
""" Fix wrong landed cost
@nvn-odoo
nvn-odoo / odoo_upgrade_request.sh
Created July 19, 2019 11:29 — forked from olilau/odoo_upgrade_request.sh
Creates an Odoo upgrade request and uploads the database dump using SFTP.
#!/bin/bash
set -e
command -v curl >/dev/null 2>&1 || { echo >&2 "I require curl but it's not installed. Aborting."; exit 1; }
command -v jq >/dev/null 2>&1 || { echo >&2 "I require jq but it's not installed. Aborting."; exit 1; }
MAX_CMD_TRIES=100
BASE_WORK_DIR=${HOME}/odoo_upgrade_request
// use cjs to run javascript on pages.
String.prototype.replaceAll = function(search, replacement) {
var target = this;
return target.replace(new RegExp(search, 'g'), replacement);
};
setInterval(function(){
$('.o_thread_message_content').each(function(i, el) {
if($(el).html() !== "" ) {
quants = env['stock.quant'].search([])
move_line_ids = []
warning = ''
for quant in quants:
move_lines = env["stock.move.line"].search([
('product_id', '=', quant.product_id.id),
('location_id', '=', quant.location_id.id),
('lot_id', '=', quant.lot_id.id),
('package_id', '=', quant.package_id.id),
('owner_id', '=', quant.owner_id.id),
quants = env['stock.quant'].search([])
move_line_ids = []
warning = ''
for quant in quants:
move_lines = env["stock.move.line"].search([
('product_id', '=', quant.product_id.id),
('location_id', '=', quant.location_id.id),
('lot_id', '=', quant.lot_id.id),
('package_id', '=', quant.package_id.id),
@nvn-odoo
nvn-odoo / odoo_download_with_sftp.sh
Created April 24, 2020 17:47 — forked from olilau/odoo_download_with_sftp.sh
Download an upgraded Odoo database using SFTP.
#!/bin/bash
set -e
command -v curl >/dev/null 2>&1 || { echo >&2 "I require curl but it's not installed. Aborting."; exit 1; }
command -v jq >/dev/null 2>&1 || { echo >&2 "I require jq but it's not installed. Aborting."; exit 1; }
# REQUIRED PARAMETERS:
REQUEST_ID="17654"
KEY="0zWIetJPo7kIWSxVWKUDTQ=="
@nvn-odoo
nvn-odoo / odoo_upgrade.sh
Created April 24, 2020 17:48 — forked from olilau/odoo_upgrade.sh
Upload your database on upgrade.odoo.com
#!/bin/bash
set -e
command -v curl >/dev/null 2>&1 || { echo >&2 "I require curl but it's not installed. Aborting."; exit 1; }
command -v jq >/dev/null 2>&1 || { echo >&2 "I require jq but it's not installed. Aborting."; exit 1; }
MAX_CMD_TRIES=100
BASE_WORK_DIR=${HOME}/odoo_upgrade