Issue 9652

Title
Problem with date field and sqlite
Priority
bug
Status
resolved
Nosy list
ced, mrichez, reviewbot, roundup-bot, tbruyere
Assigned to
ced
Keywords
review

Created on 2020-09-29.16:52:34 by mrichez, last changed 4 days ago by roundup-bot.

Messages

New changeset 0cdf9549de2a by Cédric Krier in branch 'default':
Convert read column into proper type with SQLite
https://hg.tryton.org/tryton-env/rev/0cdf9549de2a
New changeset 23acc564167b by Cédric Krier in branch 'default':
Convert read column into proper type with SQLite
https://hg.tryton.org/trytond/rev/23acc564167b
New changeset 832d0ad3bc8f by Cédric Krier in branch 'default':
Convert read column into proper type with SQLite
https://hg.tryton.org/modules/stock/rev/832d0ad3bc8f
New changeset 8b13211e3228 by Cédric Krier in branch 'default':
Convert read column into proper type with SQLite
https://hg.tryton.org/modules/sale/rev/8b13211e3228
New changeset 946e7c3b0941 by Cédric Krier in branch 'default':
Convert read column into proper type with SQLite
https://hg.tryton.org/modules/product_cost_history/rev/946e7c3b0941
Author: [hidden] (ced) Tryton committer Tryton translator
Date: 2020-10-11.23:40:37
Indeed SQLite is not really supposed to be used with client but only for testing development.
Anyway it is still better that the data read has the correct type. Here is review310801004 which ensure type conversion.
Author: [hidden] (mrichez)
Date: 2020-09-29.16:52:34
When doing some tests on product_cost_history with an sqlite database, gtk client freeze when doing a relate from variant to product_cost_price (with some prices values)

AttributeError: 'str' object has no attribute 'strftime'
ERROR:tryton.common.common:  File "/home/mrichez/Workspace/tryton/issues/add_picking_state/tryton/tryton/gui/window/view_form/view/list_gtk/widget.py", line 60, in wrapper
    return func(self, *args, **kwargs)
  File "/home/mrichez/Workspace/tryton/issues/add_picking_state/tryton/tryton/gui/window/view_form/view/list_gtk/widget.py", line 392, in setter
    super(Date, self).setter(column, cell, store, iter_, user_data)
  File "/home/mrichez/Workspace/tryton/issues/add_picking_state/tryton/tryton/gui/window/view_form/view/list_gtk/widget.py", line 60, in wrapper
    return func(self, *args, **kwargs)
  File "/home/mrichez/Workspace/tryton/issues/add_picking_state/tryton/tryton/gui/window/view_form/view/list_gtk/widget.py", line 105, in wrapper
    func(self, column, cell, store, iter_, user_data)
  File "/home/mrichez/Workspace/tryton/issues/add_picking_state/tryton/tryton/gui/window/view_form/view/list_gtk/widget.py", line 239, in setter
    text = self.get_textual_value(record)
  File "/home/mrichez/Workspace/tryton/issues/add_picking_state/tryton/tryton/gui/window/view_form/view/list_gtk/widget.py", line 405, in get_textual_value
    return value.strftime(self.renderer.props.format)
History
Date User Action Args
2020-10-21 23:11:56roundup-botsetmessages: + msg61123
2020-10-21 23:11:50roundup-botsetmessages: + msg61122
2020-10-21 23:11:44roundup-botsetmessages: + msg61121
2020-10-21 23:11:38roundup-botsetmessages: + msg61120
2020-10-21 23:11:34roundup-botsetmessages: + msg61119
nosy: + roundup-bot
status: testing -> resolved
2020-10-12 17:51:10cedsetcomponent: + trytond
2020-10-12 00:10:44reviewbotsetnosy: + reviewbot
messages: + msg60817
2020-10-11 23:40:37cedsetstatus: in-progress -> testing
reviews: 310801004
messages: + msg60812
keyword: + review
2020-10-11 23:33:37cedsetstatus: unread -> in-progress
assignedto: ced
component: + product_cost_history, - tryton
nosy: + ced
2020-09-29 16:52:34mrichezcreate

Showing 10 items. Show all history (warning: this could be VERY long)