import psycopg2, sys, psycopg2.extras, time

order = 4419

try:
    con = psycopg2.connect(host='localhost', database='DB01', user='odoo', password='******')
cur = con.cursor()
po_lines = 'SELECT pos_order_line.id FROM public.pos_order_line, public.product_template '
           'WHERE pos_order_line.product_id = product_template.id AND  pos_order_line.order_id = %s '
           'AND (product_template.pos_categ_id != 5 AND product_template.pos_categ_id != 6)'
           'ORDER BY pos_order_line.id ASC'
po_lines2 = 'SELECT pos_order_line.id, pos_order_line.order_id, product_template.name, pos_order_line.qty, product_template.pos_categ_id '
            'FROM public.pos_order_line, public.product_template  '
            'WHERE pos_order_line.product_id = product_template.id AND  pos_order_line.id = %s '
            'ORDER BY pos_order_line.id ASC'

cur.execute(po_lines,[order]); fetch_lines = cur.fetchall()
dish = ''; instr = []; kot = 0; dp = 0
print fetch_lines
for line in fetch_lines:
    cur.execute(po_lines2, [line]); pos_lines = cur.fetchone()
    if pos_lines[2].startswith('#'):
        instr.insert(1, pos_lines[2][2:]); kot = 1
    elif pos_lines[2].startswith('----'):
        dp = 1
    else:
        dish = pos_lines[2]
        kot = 0; instr = []
        if dp == 1:
            instr.insert(0, '!SERVIR DEPOIS!'); dp = 0
    if dish != pos_lines[2]:
        print 'Ordem: ', order, ' - Prato:', dish, ' - Instr:', instr, 'qt: ', pos_lines[3],'kot: ', kot, 'dp status:', dp

except psycopg2.DatabaseError, e:
print 'Error %s' % e
sys.exit(1)

finally:
    if con:
        con.close()

ID     ORDER PRODUCT                    QTY     CAT
12811  4419  "Crudo GR"                 1.0       1
12812  4419  "Salame e Grana GR"        1.0       1
12813  4419  "---- servir depois ----"  1.0       7
12814  4419  "Nutella Ban GR"           1.0       3
12815  4419  "# Cortar em dois"         1.0       7