(Solved) Problem with Functional fields with query SQL

jdonat · **Joined:** Tue Feb 15, 2011 2:18 pm **Posts:** 26

Hello. I'm new at this and need some help.
I have a method that makes a SQL query to the database, and the result I get is the reference of a product in the specified field. The code is as follows:

class product_product(osv.osv):

def _get_nombre(self, cr, uid, ids, field_name, arg, context):
for i in ids:
sql_req="""
SELECT f.id AS func_id
FROM product_product c
WHERE
(c.default_code = %d)
""" % (i,)
cr.execute(sql_req)
sql_res=cr.dictfetchone()
if sql_res:
res[i] = sql_res['func_id']
else:
res[i] = False
return res

_inherit = 'product.product'
_name = 'product.product'
_columns = {
'campo' : fields.function(_get_nombre, 'campo', type="char", size=64, method=True, store=True),
}

product_product()

I have created products, but the function it returns no value.
Could someone explain what I'm doing wrong.

Thanks. Sorry for my level of english.

dieck · **Posted:** Wed Mar 09, 2011 1:54 pm

Code:

       SELECT f.id AS func_id
       FROM product_product c
       WHERE
           (c.default_code = %d)

First of all: In your SQL there is no definition to f, so f.id would not return anything.
And ids is a list of integer database ids, you compare them to a character field default_code.
So I have to assume you left out something for this to be an example?

Second: instead of using SQL queries which may slow down your system, you should use the optimized browse functions of OpenERP.

Code:

def _get_nombre(self, cr, uid, ids, field_name, arg, context):
    res = {}
    for session in self.browse(cr, uid, ids, context=context):
        if (session.default_code == False):
            res[session.id] = session.product_tmpl_id.name
        else:
            res[session.id] = session.default_code
    return res

jdonat · **Joined:** Tue Feb 15, 2011 2:18 pm **Posts:** 26

Thank you very much for answering the post. It's been a great addition for me.

Greetings.

Ulrich · **Joined:** Sat May 07, 2011 12:04 pm **Posts:** 11

Hi,
can someone give me a link or an explanation of the browse functions?

That would be very kind.

dieck · **Posted:** Sat May 14, 2011 2:18 pm

Browse is a kind of "read" returning an iterable object, where you can access the fields as attributes. And it has a specialty: You can traverse over relations.

Code:

sobj = self.pool.get("sale.order")
sales = sobj.search(cr, uid, [('user_id','=',uid)])

for s in sobj.browse(cr, uid, sales):
  print s.partner_invoice_id.partner_id.country_id

Would hangle along from sale.order to res.partner.address to res.partner and accesses the field "country_id" there.

If trying this, you will notice you get a browse object back, because country_id is a relation.
To access the id itself, to be written to another dataset, use country_id.id.