Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
2 Odgovori
7666 Prikazi
Avatar
Nabil

Hi all, 

Thanks in advance for your answers.

I created a class with a model with fields 

like : 

class odoo_model(models.Model):
    _name = 'sql_model'
    _description = 'values from database'
  field1 = fields.Char(string="sql value", required=True, )

i created also a database view with the same fields 

like : 

create view sql_values as 

select field1 from table1


i want to update my odoo class model with values on my database view 

how can i do that ? 

please give me also a sample

Thanks a lot.  

Avatar
Opusti
Nabil
Avtor

Hi Vishnu,

i am using odoo version 9

i got error that modul dont have attribute _cr

for the init

@api.model_cr

def init(self):

tools.drop_view_if_exists(self._cr, 'report_sql_test')

self._cr.execute("""CREATE or REPLACE VIEW report_sql_test ​AS (SELECT MIN(id) as id, product_id as product_id From table1) """)

Vishnu Vanneri

You didn't mentioned the Version first time so i updated the 12 code. Now check the answer i have updated.

Avatar
Vishnu Vanneri
Best Answer

Hello,

Please Try Below Code

Assume you have a table as table1 and column named date and product.

#code below

from openerp import fields, models
from openerp import tools

class ReportSqlTest(models.Model): 
_name = 'report.sql.test'
_auto = False
_description = 'Sql Test Report' 

date = fields.Date(string='Date')
product_id = fields.Many2one('product.product', string='Product', readonly=True) 

def init(self, cr):
tools.drop_view_if_exists(cr, 'report_sql_test') 
        cr.execute("""CREATE or REPLACE VIEW report_sql_test ​AS (SELECT MIN(id) as id, product_id as product_id From table1) """)
Avatar
Opusti
Avatar
Adil Akbar
Best Answer

HI, you can follow following tutorial for this:

https://youtu.be/kwkddYoFQCE

Hope it helps,

Thanks

Avatar
Opusti