Odoo Help

0

_auto & _sql predefined fields

By
omprakash
on 5/21/13, 2:07 PM 1,807 views

Hai Friends ,

I have question regards OpenERP Object Attributes / Predefined Fields  -  [ _auto & _sql ] .
  1. From the technical document i have idea , but still not clear . Can anyone please explain the fields properties ?

    And once again thanks for everyone , such support for newbie .

Thanks & Regards

OMPRAKASH.A

1

Sudhir Arya (ERP Harbor Consulting Services)

--Sudhir Arya (ERP Harbor Consulting Services)--
11584
| 6 8 8
Ahmedabad, India
--Sudhir Arya (ERP Harbor Consulting Services)--

• Co-Founder & Co-Owner at ERP Harbor Consulting Services

• ERP Consultant / ERP Customization / TechnoFunctional Expert

• Sound knowledge in Python, Odoo (Open ERP), XML, PostgreSQL

• Domain knowledge of Sale Management, Purchase Management, Warehouse Management, Manufacturing, Multi Company Configuration & Management, HR Management, Medical Management, Construction Management, Education Management, Point of Sale, Third Party Integrations

• Positive attitude and quick Learner

• Good analytical skill, quick bug and issue tracing and find the solution

• Good knowledge and experience in payment gateway integration with Odoo

• Ready to accept new challenges

• Active Memeber On Stackoverflow 

LinkedIn

Blog

Stackoverflow

Sudhir Arya
ERP Harbor Consulting Services
skype: 
sudhir@erpharbor.com 
Sudhir Arya (ERP Harbor Consulting Services)
On 5/22/13, 2:36 AM

_sql: SQL code executed upon creation of the object (only if _auto is True). It means this code gets executed after the table is created.


_auto: Determines whether a corresponding PostgreSQL table must be generated automatically from the object. Setting _auto to False can be useful in case of OpenERP objects generated from PostgreSQL views. See the “Reporting From PostgreSQL Views” section for more details.

For example in sale.order class if you are defining _auto=False, sale_order table will not be created in PostgreSQL database.

_auto=False option mostly used to generated PostgreSQL views. You can see example of _auto here and here

Reference: Predefined Fields

Hi , Sudhir Arya thanks for immediate reply .. I like to know is there any existing example (module ) to understand about _sql & _auto ... OMPRAKASH.A

omprakash
on 5/22/13, 3:06 AM

_sql: SQL code to create the table/view for this object (if _auto is False) – can be replaced by SQL execution in the init() method. (Reference: Technical Memento )

Vasiliy Birukov
on 5/22/13, 5:34 AM

Hi , Sudhir Arya .. Thanks for your reply ..Surely i will make use of it ....

omprakash
on 5/22/13, 1:39 PM

Hi wowas , Thanks for your reply ...

omprakash
on 5/22/13, 1:40 PM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

Asked: 5/21/13, 2:07 PM
Seen: 1807 times
Last updated: 3/16/15, 8:10 AM