Export query from postgresql to csv

postgresSQL

Example from: Stackoverflow import sys #set up psycopg2 environment import psycopg2 #driving_distance module #note the lack of trailing semi-colon in the query string, as per the Postgres documentation query = “”” select * from driving_distance ($$ select gid as id, start_id::int4 as source, end_id::int4 as target, shape_leng::double precision as cost from network $$, %s, %s, … Leggi tutto

Azioni automatiche in Odoo

Come impostare da codice le azioni automatiche in Odoo, ad esempio in un modulo aggiuntivo. Creiamo l’xml: <?xml version=”1.0″ encoding=”utf-8″?> <openerp> <data> <record forcecreate=”True” id=”ir_cron_ticket_close” model=”ir.cron”> <field name=”name”>Close Ticket after 24H solved</field> <field eval=”True” name=”active” /> <field name=”user_id” ref=”base.user_root” /> <field name=”interval_number”>1</field> <field name=”interval_type”>days</field> <field name=”numbercall”>-1</field> <field eval=”False” name=”doall” /> <field eval=”‘crm.claim'” name=”model”/> <field eval=”‘close_ticket'” … Leggi tutto