ODOO
ORM
ORM Methods in odoo :
- ORM is stands for Object Relational Mapping
- Used to convert data between incompatible type system
- Odoo modeling is based on "objects" but it's data is stored in a classical relational database
žsearch()
Use
to search for records in object
ž Input
> search domain
ž Output
> list of ids
ž Employee_ids = self.env[‘hr.employee’].search([‘age’,’=‘,65])
browse()
žUse
to get record set
žInput
> list of ids
žOutput
> record set
žfaculty
= self.pool.get('op.faculty').browse(self.cr,
self.uid, faculty_id)
create()
ž Used
to create new records in object
ž Input
> field’s values
ž Output
> create new reord in
object
ž Employee_id = self.env[‘hr.employee’]
ž Employee_ids.create({‘name’:Juhn,’age’:28,’gender’:’male’})
write()
ž Used
to write our update values of records
ž Input
> field’s values
ž Output
> write these values to all records in it’s record set
ž Employee_id = self.env[‘hr.employee’].search([(‘id’,’=’,1)])
ž Employee_ids.write({‘name’:’mark’,’age’:38})
Write () with relational fields
0, 0,
{ values }) link to a new record that
needs to be created with the given values dictionary
ž(1,
ID, { values }) update the
linked record with id = ID (write values on it)
ž(2,
ID) remove and delete the
linked record with id = ID
ž(3,
ID) cut the link to the linked record with id = ID
ž(4,
ID) link to
existing record with id = ID (adds a relationship)
ž(5) unlink all (like using (3,ID) for all linked records)
ž(6,
0, [IDs]) replace the
list of linked IDs
exists()
žReturns
a new recordset
containing only the records which exist in the database
žif
not record.exists():
raise Exception("The record has been deleted")
