Skip to Content
This question has been flagged
databasemodelsorm
1 Atsakyti
4813 Rodiniai
Portretas
Aaron Beaudoin

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 from a view. How would I use it to have Odoo read data from a regular table, but not write or delete?

Portretas
Atmesti
Portretas
Ray Carnes (ray)
Best 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 access) and UI elements (Window Action, Menu, View), you would see:


Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
"relation already exists" after adding a Many2many field
database models orm
Portretas
Portretas
1
liep. 21
9583
What is the best way to lookup things from within a model?
models orm
Portretas
0
kov. 15
4876
Where can I read about all of the orm functions and how to use them?
models orm
Portretas
Portretas
Portretas
2
kov. 15
5636
write/create id database
database orm
Portretas
Portretas
1
kov. 15
6264
Guidance for table relation for user data independent of the others Solved
developement models orm
Portretas
Portretas
1
gruod. 21
3155