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

Gerelateerde posts	Antwoorden	Weergaven
Database for my module not created Opgelost python module database	4 apr. 24	3948
How to connect to Odoo.sh database from external application? Opgelost python database odoo.sh	3 mei 22	18751
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	4686
How is qty on hand calculated? python database orm	1 mrt. 15	13638
Get field value And Use It In Data Base Statement? python fields database	0 mrt. 15	4707