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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

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

many2many datetime odoo8.0

3 Vastaukset

10775 Näkymät

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

Paras vastaus

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

Tekijä

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.

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Datetime in Odoo Ratkaistu datetime odoo8.0	2 heinäk. 18	7658
From Datetime to Date Ratkaistu datetime odoo8.0	1 elok. 15	5052
Add a constraint to a many2many field Ratkaistu constraint many2many odoo8.0	1 kesäk. 17	8178
Cannot execute name_create, no _rec_name defined Ratkaistu many2many name_search many2many_tags odoo8.0	1 tammik. 22	11396
How to filter for any day of the week in odoo filter date datetime odoo8.0	0 huhtik. 18	6530

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!