IRC logs of #tryton for Friday, 2014-08-01

chat.freenode.net #tryton log beginning Fri Aug 1 00:00:02 CEST 2014
2014-08-01 00:53 -!- digitalsatori(~Thunderbi@116.234.181.110) has joined #tryton
2014-08-01 03:58 -!- digitalsatori(~Thunderbi@101.87.130.104) has joined #tryton
2014-08-01 06:05 -!- VaticanCameos(~pritishc@182.68.110.212) has joined #tryton
2014-08-01 06:32 -!- marius_(~marius@v100.nfq.lt) has joined #tryton
2014-08-01 06:41 -!- frispete(~frispete@p54A91DCE.dip0.t-ipconnect.de) has joined #tryton
2014-08-01 07:19 -!- VaticanCameos(~pritishc@182.68.87.28) has joined #tryton
2014-08-01 07:19 <VaticanCameos> I got disconnected....damn net
2014-08-01 07:34 <VaticanCameos> Looks like my message didn't get through. Reposting: "Can anyone point me to a resource on querying the tryton database using SQL queries? I hear it uses python-sql now but not sure how to implement it. Say I have a User class which inherits from ModelSQL. How would I use the User class to query the tryton DB?"
2014-08-01 07:54 -!- VaticanCameos(~pritishc@182.68.212.28) has joined #tryton
2014-08-01 07:57 -!- grasbauer(~jan@dslb-092-078-071-134.092.078.pools.vodafone-ip.de) has joined #tryton
2014-08-01 08:03 <Pilou> VaticanCameos: some SQL queries in tryton modules: http://hg.tryton.org/modules/account/file/74753e4bdd1f/tax.py#l185 http://hg.tryton.org/modules/sale/file/d5069bf6a171/sale.py#l1487 http://hg.tryton.org/modules/stock/file/64d376876173/product.py#l239
2014-08-01 08:03 <VaticanCameos> Pilou: thank you so much! going through those now.
2014-08-01 08:07 -!- alisonken1home(~alisonken@pool-71-104-227-145.lsanca.dsl-w.verizon.net) has joined #tryton
2014-08-01 08:09 <VaticanCameos> So basically it is like User.__table__(), and cursor = Transaction.cursor() is used to execute the query.
2014-08-01 09:00 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-08-01 09:13 -!- jeancavallo(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton
2014-08-01 09:32 -!- nicoe(~nicoe@balisto.office.b2ck.com) has joined #tryton
2014-08-01 09:40 -!- nicoe(~nicoe@balisto.office.b2ck.com) has joined #tryton
2014-08-01 09:46 -!- prksh(~prksh@122.177.107.89) has joined #tryton
2014-08-01 09:48 <grasbauer> if I make a field required in product.product which is not set on many records and I save the template from the template_form the wrong product.product gets deleted - is this the right behavoir or do I have to search for other mistakes?
2014-08-01 09:49 <cedk> grasbauer: I can not believe this could happen in vanilla code
2014-08-01 09:51 <grasbauer> cedk: do you have a hint how to debug this?
2014-08-01 09:54 <cedk> grasbauer: not at all
2014-08-01 09:55 -!- pobsteta(~Thunderbi@37.160.27.168) has joined #tryton
2014-08-01 10:02 <pokoli> grasbauer: you can search for a delete call, as it seems that there is some code that delete it
2014-08-01 10:02 <pokoli> grasbauer: and also test that the product is active, so maybe it's inactive and you don't see it
2014-08-01 10:06 -!- aasnan(~angel@142.Red-2-139-177.staticIP.rima-tde.net) has joined #tryton
2014-08-01 10:07 -!- angelnan(~angel@142.Red-2-139-177.staticIP.rima-tde.net) has joined #tryton
2014-08-01 10:07 -!- aasnan(~angel@142.Red-2-139-177.staticIP.rima-tde.net) has joined #tryton
2014-08-01 10:08 -!- aasnan(~angel@142.Red-2-139-177.staticIP.rima-tde.net) has joined #tryton
2014-08-01 10:08 -!- angelnan(~angel@142.Red-2-139-177.staticIP.rima-tde.net) has joined #tryton
2014-08-01 10:08 <grasbauer> pokoli: really starnge - I log the changes in the client it prints {u'products': None, 'id': None}
2014-08-01 10:11 <grasbauer> pokoli: but i think I found the error in a Many2Many cascading the delete
2014-08-01 10:15 <pokoli> grasbauer: should be the Many2Many
2014-08-01 10:17 -!- pobsteta(~Thunderbi@37.160.27.168) has joined #tryton
2014-08-01 10:46 -!- frispete(~frispete@p54A91DCE.dip0.t-ipconnect.de) has joined #tryton
2014-08-01 11:16 -!- alisonken1home(~alisonken@pool-71-104-227-145.lsanca.dsl-w.verizon.net) has joined #tryton
2014-08-01 11:39 -!- aasnan(~angel@142.Red-2-139-177.staticIP.rima-tde.net) has joined #tryton
2014-08-01 11:49 -!- zultron(~zultron@99-190-134-148.lightspeed.austtx.sbcglobal.net) has joined #tryton
2014-08-01 12:05 -!- zultron_(~zultron@99-190-134-148.lightspeed.austtx.sbcglobal.net) has joined #tryton
2014-08-01 12:43 -!- ronaldm(~ronaldm@197.211.216.214) has joined #tryton
2014-08-01 13:04 -!- pobsteta(~Thunderbi@37.160.27.168) has joined #tryton
2014-08-01 13:17 <grasbauer> cedk, pokoli: its a bug - but I have no idea what causes this
2014-08-01 13:18 <pokoli> grasbauer: and how can we reproduce it?
2014-08-01 13:18 <grasbauer> cedk: new database, only module product installed, add a template, after set description of product.product to required - save and the product.product gets deleted
2014-08-01 13:20 <grasbauer> pokoli: try it - empty database. than add product-module only. after create a template. save. than in the product module add required=True to product.product. reload the view. open the template. str-s - variant gone .....
2014-08-01 13:21 <grasbauer> pokoli: requiered to description for exeample
2014-08-01 13:21 <pokoli> grasbauer: sounds strange to me
2014-08-01 13:22 <pokoli> grasbauer: can you test that the product is not inactive?
2014-08-01 13:23 <grasbauer> pokoli: the product is deleted
2014-08-01 13:40 <grasbauer> :'(
2014-08-01 13:50 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton
2014-08-01 14:00 <cedk> grasbauer: it can not be deleted as it is not saved because it is invalid
2014-08-01 14:01 <grasbauer> cedk: I think it's get deleted because its invalid
2014-08-01 14:02 <grasbauer> cedk: if there a required is added afterwards, the record is read, but if you store the parent, the invalid child gets deleted ....
2014-08-01 14:06 <grasbauer> cedk: but I can't find where it is triggered ...
2014-08-01 14:09 <cedk> grasbauer: I don't understand the scenario
2014-08-01 14:12 <grasbauer> cedk: I have added a field which is required to product.product - not all product having set this right now. So if i open the template with a product where the new field is missing, saving the template results in deletion of the invalid product
2014-08-01 14:12 <cedk> grasbauer: that's not possible to save if not valid
2014-08-01 14:13 <grasbauer> cedk: yes - but I would expect the typical reaction of a highlighted field - not the deletion of the record without any noise
2014-08-01 14:16 <grasbauer> cedk: the current behavior makes it impossible to add required fields to a one2many without default values - the invalid records are deleted without any warning ....
2014-08-01 14:16 <cedk> grasbauer: first you must not expect a good behavior by adding required without default value
2014-08-01 14:18 <grasbauer> cedk: I can not decide as a developer since i don't know the records
2014-08-01 14:19 -!- smarro(~sebastian@200.107.230.29) has joined #tryton
2014-08-01 14:19 <grasbauer> cedk: customer want's a field required for having better data - he needs to set the values by his own ....
2014-08-01 14:20 <grasbauer> cedk: currently the products are deleted because they are not valid - but I would expect the typical warning on write ....
2014-08-01 14:28 <grasbauer> cedk: can you give me a hint, where the deletion is decided? searching since hours ;)
2014-08-01 14:31 <cedk> grasbauer: this is the culpitre: http://hg.tryton.org/tryton/file/3cd86f67c9c8/tryton/gui/window/view_form/model/field.py#l715
2014-08-01 14:31 <cedk> comes from the F**king OpenERP
2014-08-01 14:32 -!- kstenger(~karla@200.124.209.158) has joined #tryton
2014-08-01 14:32 <cedk> for me, it should never remove the record
2014-08-01 14:33 <grasbauer> cedk: I'm always impressed how deep you know each part of the system ;)
2014-08-01 14:34 <cedk> grasbauer: just a print stack at the deletion method
2014-08-01 14:36 <grasbauer> cedk: whats to do next? issue, review and so on or are you deleting this easter egg of open erp?
2014-08-01 14:39 <cedk> grasbauer: I think it deserve an issue and some though about the expected behavior
2014-08-01 14:39 <grasbauer> cedk: ok
2014-08-01 14:45 -!- kstenger(~karla@200.124.209.158) has joined #tryton
2014-08-01 14:46 <marius_> is it possible to have not-required selection?
2014-08-01 14:48 <cedk> marius_: you have to define a empty value: ('', '')
2014-08-01 14:54 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 15:00 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 15:14 -!- munro(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 15:22 -!- smarro(~sebastian@200.107.230.29) has joined #tryton
2014-08-01 15:23 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 15:26 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 15:43 -!- VaticanCameos(~pritishc@182.68.136.83) has joined #tryton
2014-08-01 15:50 -!- pobsteta(~Thunderbi@37.162.164.127) has joined #tryton
2014-08-01 15:54 <grasbauer> cedk: can you give me a hint where the invalid fields are highlighted. Now I have the problem, that the tabs are set to active if there is a wrong entry inside ...
2014-08-01 15:56 <cedk> grasbauer: sounds correct
2014-08-01 15:57 <grasbauer> cedk: I mean NOT active ... ;)
2014-08-01 15:57 <cedk> grasbauer: it is in form.py
2014-08-01 16:00 <cedk> grasbauer: if it is inside a one2many, it is because it is not implemented
2014-08-01 16:01 <grasbauer> cedk: ok - it's inside one2many
2014-08-01 16:09 <cedk> grasbauer: but still good to encode a feature request
2014-08-01 16:14 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 16:47 -!- alisonken1lap3(~alisonken@18.18.ultimate-int.uia.net) has joined #tryton
2014-08-01 16:51 -!- grasbauer(~jan@dslb-092-078-071-134.092.078.pools.vodafone-ip.de) has joined #tryton
2014-08-01 16:56 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 17:44 -!- sharkcz(~sharkcz@server.danny.cz) has joined #tryton
2014-08-01 17:58 -!- munro(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 18:05 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 18:08 -!- zodman(zodman@50.115.163.209) has joined #tryton
2014-08-01 18:20 -!- VaticanCameos(~pritishc@182.68.137.52) has joined #tryton
2014-08-01 18:35 -!- pobsteta(~Thunderbi@37.162.164.127) has joined #tryton
2014-08-01 19:27 -!- munro(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 19:27 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 20:10 <kstenger> say I have a One2Many relationship, call it foo. Then in a method of the class where I define this relationship I want to refer to the items in foo, but filtering them somehow, is there a way to do this with a domain (alike to foo.search(...)), or else how could I do this?
2014-08-01 20:20 -!- ronaldm(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 20:32 -!- munro(~ronaldm@197.221.242.194) has joined #tryton
2014-08-01 21:05 -!- mariomop(~quassel@host180.186-125-110.telecom.net.ar) has joined #tryton
2014-08-01 21:15 -!- prksh(~prksh@180.188.247.158) has joined #tryton
2014-08-01 21:28 -!- ronaldm(~ronaldm@wvale-ggsn-55.131.econet.co.zw) has joined #tryton
2014-08-01 23:09 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton
2014-08-01 23:36 -!- uranus(~uranus@ool-182fa854.dyn.optonline.net) has joined #tryton
2014-08-01 23:45 -!- marius_(~marius@84.240.8.12) has joined #tryton

Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!