[tryton] relations

[Cato Nano]

I have 2 models, with a relation between them

Much like Sales and SaleLine

Let' s say I have Bolletta and BollettaLine

Some BollettaLine fields are calcolated and they depend on some Bolletta fields

How do I do that ?

Also, I' d like to show on the BollettaLine form view some Bolletta fields

I tried this

SomeBollettaField = fields.Many2One('tributi.bolletta', 'Some Bolletta Field')

but when I update the module, I get

psycopg2.ProgrammingError: ERRORE: non Ú possibile implementare il vincolo di chiave esterna "tributi_affissione_dataCommissione_fkey"
DETAIL: Le colonne chiave "dataCommissione" e "id" hanno tipi incompatibili: date e integer.

Translated:

ERROR: The foreign key constarint tributi_affissione_dataCommissione_fkey can't be implemented
DETAIL: The key columns "SomeBollettaField" and "id" have mismatching types: date and integer

[Cato Nano]

Post by Cato Nano
I have 2 models, with a relation between them
Much like Sales and SaleLine
Let' s say I have Bolletta and BollettaLine
Some BollettaLine fields are calcolated and they depend on some Bolletta fields
How do I do that ?
Also, I' d like to show on the BollettaLine form view some Bolletta fields
I tried this
SomeBollettaField = fields.Many2One('tributi.bolletta', 'Some Bolletta Field')
but when I update the module, I get
psycopg2.ProgrammingError: ERRORE: non Ú possibile implementare il vincolo di chiave esterna "tributi_affissione_dataCommissione_fkey"
DETAIL: Le colonne chiave "dataCommissione" e "id" hanno tipi incompatibili: date e integer.
ERROR: The foreign key constarint tributi_affissione_dataCommissione_fkey can't be implemented
DETAIL: The key columns "SomeBollettaField" and "id" have mismatching types: date and integer

ah the field has to be different

I think I made it

[Cato Nano]

Post by Cato Nano
ah the field has to be different
I think I made it

No I didn' t make it

On the client I see a key error

here it is
https://imgur.com/a/Cwct2

This is how I defined my field

bollettaDataCommissione = fields.Many2One('tributi.bolletta', 'bolletta.dataCommissione')

I guess you could read it as

SomeBollettaField = fields.Many2One('tributi.bolletta', 'bolletta.bollettaField')

[Sergi Almacellas Abellana]

Post by Cato Nano
I have 2 models, with a relation between them
Much like Sales and SaleLine
Let' s say I have Bolletta and BollettaLine
Some BollettaLine fields are calcolated and they depend on some Bolletta fields
How do I do that ?
Also, I' d like to show on the BollettaLine form view some Bolletta fields
I tried this
SomeBollettaField = fields.Many2One('tributi.bolletta', 'Some Bolletta Field')

You have to create a function fields which is updated via
on_change_with. For example the product_uom_category [1]on the sale
lines uses the value from the product relation.

[1] http://hg.tryton.org/modules/sale/file/3414b8d97403/sale.py#l1057

[Cato Nano]

Il giorno martedì 16 gennaio 2018 11:40:47 UTC+1, Sergi Almacellas Abellana ha

Post by Sergi Almacellas Abellana
You have to create a function fields which is updated via
on_change_with. For example the product_uom_category [1]on the sale
lines uses the value from the product relation.
[1] http://hg.tryton.org/modules/sale/file/3414b8d97403/sale.py#l1057
--

Thank you Sergi

This is the situation:

bollettaDataCommissione = fields.Function(fields.Many2One('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')

@fields.depends('bolletta')
def on_change_with_bollettaDataCommissione(self, name=None):
if self.bolletta:
return self.bolletta.dataCommissione


and I get

can't compare datetime.date to int

[Cato Nano]

Post by Cato Nano
Il giorno martedì 16 gennaio 2018 11:40:47 UTC+1, Sergi Almacellas Abellana ha

Post by Sergi Almacellas Abellana
You have to create a function fields which is updated via
on_change_with. For example the product_uom_category [1]on the sale
lines uses the value from the product relation.
[1] http://hg.tryton.org/modules/sale/file/3414b8d97403/sale.py#l1057
--

Thank you Sergi
bollettaDataCommissione = fields.Function(fields.Many2One('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')
@fields.depends('bolletta')
return self.bolletta.dataCommissione
and I get
can't compare datetime.date to int

This is on BollettaLine, of course

[Cato Nano]

Post by Cato Nano

Post by Cato Nano
Il giorno martedì 16 gennaio 2018 11:40:47 UTC+1, Sergi Almacellas Abellana ha

Post by Sergi Almacellas Abellana
You have to create a function fields which is updated via
on_change_with. For example the product_uom_category [1]on the sale
lines uses the value from the product relation.
[1] http://hg.tryton.org/modules/sale/file/3414b8d97403/sale.py#l1057
--

Thank you Sergi
bollettaDataCommissione = fields.Function(fields.Many2One('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')
@fields.depends('bolletta')
return self.bolletta.dataCommissione
and I get
can't compare datetime.date to int

This is on BollettaLine, of course

Aaah it' s like this

bollettaDataCommissione = fields.Function(fields.Date('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')

@fields.depends('bolletta')
def on_change_with_bollettaDataCommissione(self, name=None):
if self.bolletta:
return self.bolletta.dataCommissione

[Cato Nano]

Post by Cato Nano
Aaah it' s like this
bollettaDataCommissione = fields.Function(fields.Date('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')
@fields.depends('bolletta')
return self.bolletta.dataCommissione

The date field works, but where' s my label ?

The field name is shown instead of the field string, as you can see here

https://imgur.com/a/tu5fL

[Sergi Almacellas Abellana]

Post by Cato Nano

Post by Cato Nano
Aaah it' s like this
bollettaDataCommissione = fields.Function(fields.Date('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')
@fields.depends('bolletta')
return self.bolletta.dataCommissione

The date field works, but where' s my label ?

The label used is the string of the target field. In a date field, this
is the first argument. In your case is 'tributi.bolleta'. You should
update the field definition to show the correct label.

[Cato Nano]

Post by Sergi Almacellas Abellana

Post by Cato Nano

Post by Cato Nano
Aaah it' s like this
bollettaDataCommissione = fields.Function(fields.Date('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')
@fields.depends('bolletta')
return self.bolletta.dataCommissione

The date field works, but where' s my label ?

The label used is the string of the target field. In a date field, this
is the first argument. In your case is 'tributi.bolleta'. You should
update the field definition to show the correct label.

Thank you Sergi
I' ll try and report back

[Cato Nano]

Post by Cato Nano

Post by Sergi Almacellas Abellana

Post by Cato Nano

Post by Cato Nano
Aaah it' s like this
bollettaDataCommissione = fields.Function(fields.Date('tributi.bolletta', 'Data di Commissione'), 'on_change_with_bollettaDataCommissione')
@fields.depends('bolletta')
return self.bolletta.dataCommissione

The date field works, but where' s my label ?

The label used is the string of the target field. In a date field, this
is the first argument. In your case is 'tributi.bolleta'. You should
update the field definition to show the correct label.

Thank you Sergi
I' ll try and report back

I tried and it works

Thanks