how to retive datafrom the table?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- 客戶關係
- e-Commerce
- 會計
- 庫存
- PoS
- Project
- MRP
此問題已被標幟
2
回覆
2682
瀏覽次數
This is the example to retreive information from database for a table.
Here [('user_id', '=', uid)] --> Here we can include the condition we put in WHERE clause
emp_obj = self.pool.get('hr.employee')
emp_ids = emp_obj.search(cr, uid, [('user_id', '=', uid)], context=context)
if emp_ids:
for employee in emp_obj.browse(cr, uid, emp_ids, context=context):
return {'name': employee.name}
--->Hope this helps you
It is recomandable to use object model to read data from the database, however some times it is more efficient to read data with SQL. If you want to read data with direct SQL, you can use the cr (cursor) that is passed to your methods as follows:
cr.execute(""" SELECT name FROM res_partner""")
result = cr.fetchall()
for partner in result:
print partner[0]
