How do I interact via the ORM with tables not managed/created by Odoo?

Question

I have an Odoo database containing tables which were created using a separate application interacting with the same database.
I know I could run SQL SELECT queries directly in Odoo to read the data, but I'm wondering if there's a way to just have the ORM read the table in a "read-only" way.
I'm already aware that you can set `_auto` to `False` on the model and override the `init()` method to disable Odoo's automatic management of the table, but I've only seen this used to have Odoo read data fro

Ray Carnes (ray) · Answer

I just tried this and quickly tested basic functionality (sort, filter, group by, export).

Note: "id" is required for Odoo to retrieve data, so as long as your table(s) have that field [I didn't test column aliases], you should be good with this approach:

Given this table:
CREATE TABLE films (id integer, code char(5), title varchar(40));
INSERT INTO films (id, code, title) VALUES (1,'LF232','Return of the Jedi');
You can create this class / model:

Then, with appropriate permissions (read acc

المنشورات ذات الصلة	الردود	أدوات العرض
"relation already exists" after adding a Many2many field database models orm	1 يوليو 21	9583
What is the best way to lookup things from within a model? models orm	0 مارس 15	4876
Where can I read about all of the orm functions and how to use them? models orm	2 مارس 15	5636
write/create id database database orm	1 مارس 15	6263
Guidance for table relation for user data independent of the others تم الحل developement models orm	1 ديسمبر 21	3155

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!