Odoo commands

Create new DB and init with demo data:

$ createdb testdb && odoo-bin -d testdb

Remove database:

$ dropdb dbname 

$ rm -rf ~/.local/share/odoo/filestore/dbname

Create database bacup and restore

$ pg_dump -Fc -f dbname.dump dbname

Odoo template addon:

$ ~/odoo-dev/odoo/odoo-bin scaffold my_module

Odoo pycharm

 https://github.com/odoo-ide/pycharm-odoo

Odoo install

Download and install wkhtmltopdf

$ wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.5/wkhtmltox_0.12.5-1.trusty_amd64.deb
$ sudo dpkg -i wkhtmltox_0.12.5-1.trusty_amd64.deb
$ sudo apt-get install -f

Download postgress

$ sudo apt install postgresql -y

 

Problem: psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  database "sup" does not exist


Solution:

$ sudo service postgresql start 

$ sudo su - postgres psql


$ postgres=# CREATE DATABASE sup;




Download odoo source 

$ mkdir ~/odoo-dev && cd ~/odoo-dev
$ git clone -b 15.0 --single-branch --depth 1 https://github.com/odoo/odoo.git

Insalling requirements:

$ python3 -m venv ~/venv-odoo-14.0
$ source ~/venv-odoo-14.0/bin/activate

$ cd ~/odoo-dev/odoo/
$ pip3 install -r requirements.txt

python ORM

SQL lite viewer editor:

 sqlite_web /home/sup/PycharmProjects/orm/test.db

 

nano ~/.bashrc

export PATH="/home/$USER/.local/bin:$PATH"