how to access database using python code?

Question

I want to access database and get the name from a table to check if the name exist or not.

I know that I need to override the create function but I have no idea for what should I put inside the function

Also, i'd like to ask how to pop up en error message like the validate checking when the name is existed

Deepa Venkatesh · Answer

you can use *cursor*(or cr) present in a method..

almost all ORM methods will have these paramaters: /*self, cr, uid*/

so one can use cr, which is nothing but cursor paramater used to deal with database...

/Example:/ cr.execute("select * from res_partner")

And to do validation: you can set *_sql_constraints* in your object

Hint: use Ctrl + H to search in you the addons, if you are using EDI like eclipse/aptana studio

Publicaciones relacionadas	Respuestas	Vistas
Database for my module not created Resuelto python module database	4 abr 24	3536
How to connect to Odoo.sh database from external application? Resuelto python database odoo.sh	3 may 22	18213
What is the best way to guarantee my model fields are added in the database, so I don't have to add them manually via SQL? python fields database	1 dic 16	4474
How is qty on hand calculated? python database orm	1 mar 15	13394
Get field value And Use It In Data Base Statement? python fields database	0 mar 15	4518