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

Related Posts	Replies	Views
Database for my module not created Solved python module database	4 Apr 24	1343
How to connect to Odoo.sh database from external application? Solved python database odoo.sh	3 May 22	14924
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 Dec 16	2836
How is qty on hand calculated? python database orm	1 Mar 15	11866
Get field value And Use It In Data Base Statement? python fields database	0 Mar 15	3035