Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Apskaita
Atsarga
PoS
Projektas
MRP

All apps

All Posts People Badges

Žymos (View all)

odoo accounting v14 pos v15

About this forum

Pagalba

How to insert current date column in many2many relational table in odoo 8 ?

many2many datetime odoo8.0

3 Replies

10825 Rodiniai

odooPrac

ok, so I've been stuck with this for a while now. I'm trying to create a current date field (date_added) in model stock.location.lock.code.rel (which is a relational model for stock.location.lock.code and stock.location models). My problem is that the table and field gets created in postgres db but its not getting populated and I'm getting error (mentioned below code). My code is below (I'm a beginner in odoo, so please do suggest correct way of doing)

in stock.location class :

class StockLocation(models.Model):

_name = 'stock.location'

_inherit = 'stock.location'

@api.multi

def write(self, vals):

#I've overriden this method because I need to edit a form view and this method will be called when I press save button

now = datetime.now()

current_time = now.strftime('%m/%d/%Y %H:%M:%S')

vals = ({'date_added': current_time, 'active': True})

http.request.env['stock.location.lock.codes.rel'].create(vals)

return super(StockLocation, self).write(vals)

level = fields.Char('Level', size=1, default=None)

position = fields.Char('Position', size=1, default=None)

lock_code_ids = fields.Many2many('stock.location.lock.codes','stock_location_lock_code_rel','location_ids','lock_code_ids','Lock Code to apply', ondelete="cascade", default=None)

not_on_hand = fields.Boolean('not_on_hand', readonly=True, default=False)

class StockLocationLockCodeRel(models.Model):

_name = "stock.location.lock.code.rel"

location_ids = fields.Many2one('stock.location', 'Lock code location', required=True, ondelete="cascade")

lock_code_ids = fields.Many2one('stock.location.lock.codes', 'Lock code', required=True, ondelete="cascade")

active = fields.Boolean('Active', default=True)

date_added = fields.Datetime('Date Added')

id = fields.Char('id')

@api.multi

def create(self, vals):

return super(StockLocationLockCodeRel, self).create(vals)

Now my code for stock.location.lock.codes is :

from openerp import models, fields

class StockLocationLockCodes(models.Model):

_name = 'stock.location.lock.codes'

code = fields.Char('Code', size=2)

name = fields.Char('Name', size=100)

description = fields.Text('Description')

not_on_hand = fields.Boolean('On Hand', default=None)

unavailable = fields.Boolean('Available', default=None)

lock_in = fields.Boolean('Put', default=None)

lock_out = fields.Boolean('Pull', default=None)

active = fields.Boolean('Active', default=None)

show = fields.Boolean('Show in Location', default=None)

location_ids = fields.Many2many('stock.location','stock_location_lock_code_rel','lock_code_ids','location_ids','Lock code location', ondelete="cascade", default=None)

The error on logs is :

Traceback (most recent call last):

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 551, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 588, in dispatch

result = self._call_function(**self.params)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 324, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/service/model.py", line 118, in wrapper

return f(dbname, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 321, in checked_call

return self.endpoint(*a, **kw)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 817, in __call__

return self.method(*args, **kw)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/http.py", line 417, in response_wrap

response = f(*args, **kw)

File "/home/rohitupadhyay/git/odoo-IC-32/addons/web/controllers/main.py", line 944, in call_kw

return self._call_kw(model, method, args, kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/addons/web/controllers/main.py", line 936, in _call_kw

return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 268, in wrapper

return old_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 399, in old_api

result = method(recs, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/staples-addons/wms_stock/models/stock_location.py", line 167, in write

http.request.env['stock.location.lock.code.rel'].create(vals)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 266, in wrapper

return new_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/staples-addons/wms_stock/models/stock_location.py", line 275, in create

return super(StockLocationLockCodeRel, self).create(vals)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 266, in wrapper

return new_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/models.py", line 4094, in create

record = self.browse(self._create(old_vals))

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 266, in wrapper

return new_api(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/api.py", line 508, in new_api

result = method(self._model, cr, uid, *args, **old_kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/models.py", line 4232, in _create

tuple([u[2] for u in updates if len(u) > 2])

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/sql_db.py", line 158, in wrapper

return f(self, *args, **kwargs)

File "/home/rohitupadhyay/git/odoo-IC-32/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

ProgrammingError: column "id" of relation "stock_location_lock_code_rel" does not exist

LINE 1: INSERT INTO "stock_location_lock_code_rel" ("id", "active", ...

Deepa Venkatesh

Best Answer

First you need the understand of concept of Many2Many relation & its table

A relation table created between 2 objects is just used to store the link of those, ideally it will have 2 fields, i.e ID of respective tables, hence you can not create any column in it.

odooPrac

Autorius

thank you deep for your reply, but it is possible to add an extra field in Many2Many relational table. Please see this link :

https://www.odoo.com/forum/help-1/question/can-i-add-a-field-to-many2many-relation-table-30118

Also, there is a many2many relational table in odoo by name "im_chat_session_res_users_rel" which has more than 2 columns. I also looked into its source code before posting this question, but unable to figure out how this has been done. Thanks

John Doe

I used the following in OERP 7, which I believe it very similar to OERP 8 (aka ODOO)

class left_model(osv.osv):
    _name = 'left.model'


    _columns = {
        'rigths': fields.many2many(obj='right.model.id', rel='left_model_right_model_rel', id1='left_model_id', id2='right_model_id', string='Rigths'),
    }

left_model()


class right_model(osv.osv):
    _name = 'right.model'


    _columns = {
        'lefts': fields.many2many(obj='left.model.id', rel='left_model_right_model_rel', id1='right_model_id', id2='left_model_id', string='Lefts'),
    }

right_model()


class center_model(osv.osv):
    _name = 'center.model'
    _table = 'left_model_right_model_rel'  # this should match the rel argument in the other two models OR what ever OERP auto created. 


    _columns = {
        'left_model_id': fields.many2one(obj='left.model.id', string='Left Model ID'),
        'right_model_id': fields.many2one(obj='right.model.id', string='Right Model ID'),
        'new_field': fields.char(string='New Field'),  # this is your new field, customize it to your needs
    }

center_model()

In this example the new field is a char which the original question would have customized to his required type.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registracija

Related Posts	Replies	Rodiniai
Datetime in Odoo Solved datetime odoo8.0	2 liep. 18	7700
From Datetime to Date Solved datetime odoo8.0	1 rugp. 15	5109
Add a constraint to a many2many field Solved constraint many2many odoo8.0	1 birž. 17	8235
Cannot execute name_create, no _rec_name defined Solved many2many name_search many2many_tags odoo8.0	1 saus. 22	11474
How to filter for any day of the week in odoo filter date datetime odoo8.0	0 bal. 18	6566

This question has been flagged

Enjoying the discussion? Don't just read, join in!