IRC logs of #tryton for Tuesday, 2008-07-29

chat.freenode.net #tryton log beginning Tue Jul 29 00:00:01 CEST 2008
-!- betamax_(i=betamax@gateway/tor/x-53f51feabee744ec) has joined #tryton02:49
-!- Timitos(n=Timitos@88.217.184.172) has joined #tryton07:22
-!- Gedd(n=ged@77.109.115.149) has joined #tryton08:02
-!- cedk(n=ced@gentoo/developer/cedk) has joined #tryton09:02
-!- FWiesing(n=Wiesinge@194.208.185.12) has joined #tryton09:43
-!- kultviech(n=kultviec@p54976F40.dip.t-dialin.net) has joined #tryton09:53
-!- markusleist(n=markus@212.14.79.210) has joined #tryton09:54
-!- bechamel(n=user@user-85-201-14-207.tvcablenet.be) has joined #tryton09:55
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 761:fa7f8a35e501 trytond/trytond/ (init.sql osv/orm.py): Remove old name in ir_ui_view table10:37
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 762:df9c5b99f4df trytond/trytond/ (8 files in 5 dirs):11:01
CIA-54tryton: Remove some size constraints11:01
CIA-54tryton: Fix init.sql to match the objects11:01
bechamelcedk: i just saw that the commit 767 removed the admin password from user.xml.11:30
bechamelcedk: does whe need to add it by hand each time a db is created ?11:30
cedkbechamel: yes11:31
cedkit was a security issue, because if you create a new DB on a server throuth the web11:31
cedksomebody can take control of your DB just after because he know that the password will be admin11:32
bechamelcedk: what tool can i use to encode 'admin' into sha ? i have several tools here11:36
cedkbechamel: you don't need to insert yourself in the db11:36
bechamelcedk: yes i know11:37
cedkbechamel: just put the password into the interface at the db creation11:37
bechamelcedk: at db creation ?11:37
bechamelcedk: what about the cli11:37
cedkbechamel: it is in the GTK client11:39
-!- kultviech(n=kultviec@p54976F40.dip.t-dialin.net) has left #tryton11:40
bechamelcedk: i tried to generate it with shasum, but it dosn't give me the same result11:41
cedkbechamel: fields.py line 18511:43
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 568:51eb74599936 tryton/tryton/gui/window/view_tree/view_tree.py: eval digits for each object in tree view11:46
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 162:dba8bf11fd3a account/ (account.py account.xml tax.py tax.xml): Use string digits for currency digits11:46
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 15:abf2eed69564 analytic_account/ (account.py account.xml): Use string digits for currency digits11:46
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 569:f6bbad06f14d tryton/tryton/rpc.py: Fix fields_view_get cache12:13
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 163:6371c20391b6 account/move.py: Add md5 on fields_view_get12:14
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 164:6ef1b29d9884 account/move.py: Fix open journal to use existing act_window12:14
bechamelcedk: i have got a problem with mptt stuff, on the account object, left and right field are required but the write and create fct in osv first add the record and after only update left and right.12:25
cedkbechamel: yes there is a default value to  012:27
cedkbechamel: I don't find where it is set be integer have default 012:33
bechamelcedk: yes it is a question that arose when working on the auto_init stuff, what the point in adding a default value to zero and a not null constraint on the same field, the result is that the field is no more required (because of the default value)12:33
cedkbechamel: you can remove it but you need to set a default value for right and left12:35
bechamelcedk: what i would like is to remove the required constraint12:36
cedkbechamel: no because we can not have null value12:36
bechamelcedk: so we agree that i can drop the hardocded integer = 0 in auto_init, now about the right-letf stuff: what about adding default_{left,right} which will return 0 and dropping the required=True ?12:41
cedkbechamel: ok to drop default 0 in db, ok to add default_{left,right} that return 0 but not ok to drop required12:41
bechamelcedk: why ? when will this required be usefull ?12:44
cedkbechamel: to be sure that you will have a number there12:45
bechamelcedk: you are sure there will be a number, because of the default12:46
cedkbechamel: no, if some body write with False value12:47
cedkbechamel: that the usefull of a database12:47
cedkbechamel: you can have constraint12:47
cedkso there is many place where we have required=True and a default value12:48
bechamelif somebody want to do: " update account_account set left = 'false' " it's gonna work12:50
cedkbechamel: no it will not because left is integer and false not12:50
cedkbechamel: and I mean that in the ORM, to set a field to null you must use False value12:51
bechamelcedk: that also a problem null should be None on the orm not false12:52
cedkbechamel: it is not a problem12:54
cedkit is a convention12:54
cedkand none can not be send throught xmlrpc12:55
bechamelcedk: i know there is some fucntion that return False instead of None and vice-versa, i know exactly what to fix in the auto_init stuff to make it work (i add to reproduce the old behaviour), but i dont know if its easy to fix on other places12:55
cedkbechamel: DON'T CHANGE THE FALSE = null12:56
bechamelcedk: yes, actualy  the only reason is that  xml-rpc is defective12:56
bechamelcedk: yes yes :)12:56
bechamelcedk: does None can be send with  net-rpc  ?12:57
cedkbechamel: yes but it is not a reason12:57
cedkbechamel: and there is no problem to set False = None12:57
cedkit is just for mathematician that is a proble12:58
bechamel cedk: it's not a problem because in the gui there is no way to put a none/null value on a bolean field.13:01
cedkbechamel: and if you set False or None on a boolean, it will be store in the DB as False13:03
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 165:3327e5966a44 account/account.py: Added default values for left and right fields13:05
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 166:0378545cb947 account/: merge13:05
bechamelcedk: http://pastebin.com/d445fbca413:06
cedkbechamel: because active is not required13:07
cedkbechamel: and when I talk about set False, it is using the ORM13:08
cedkbechamel: I think boolean must be always not null13:08
bechamelcedk: why ?13:08
cedkbechamel: because it has no means to have boolean = null13:09
bechamelcedk: boolean are like other type13:09
bechamelcedk: no more no less than other fields13:09
cedkbechamel: no, in the interface it is a check box that have only two state13:09
bechamelcedk: yessss, has i said it's the gui13:10
bechamelcedk: if null on boolean was meaningless than it wouldnt be available in postgres13:11
cedkbechamel: but we can not handle it so we must avoid it by setting not null on boolean field13:13
cedkbechamel: I don't say that we must modify postgresql to avoid null on boolean13:14
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 65:a5a6b44939d0 product/product.py: Fix, use correct class for inheritance13:19
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 570:d608109cbdf6 tryton/tryton/gui/window/view_form/view/form.py: Set mfields in model before display widgets13:21
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 571:9ba1e515db65 tryton/tryton/gui/window/view_form/model/group.py: Add __repr__ on ModelRecordGroup13:21
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 172:397f995c8973 stock/location.py: Add default values for left and right fields13:23
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 86:b8041336d4a3 account_invoice/invoice.py: Catch exception in on_change_product if product has no account defined16:32
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 572:f3b30009c4df tryton/tryton/gui/window/dbcreate.py: Admin password for DB creation is required17:24
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 763:fe5603a7b09f trytond/trytond/osv/orm.py: Allow to use sql statement for order_field17:48
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 114:a7dfeed0e9e7 relationship/party.py: Set order_field on code of partner17:48
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 764:4dc8dfbf3483 trytond/trytond/init.sql: Fix fields type in init.sql to follow the objects definitions18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 765:7df62e42d0e1 trytond/trytond/ir/model.py: Added missing required18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 766:bf245a3e8861 trytond/trytond/workflow/workflow.py: Added missing required18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 767:a14376b65237 trytond/trytond/init.sql: Fixes in init.sql to reflect objects definitions18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 768:79e6483ecd58 trytond/trytond/osv/fields.py: Fix sql_type on field.Selection18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 769:e8ce5062bdbb trytond/trytond/trytond.py: Remove legacy code about wkf_logs18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 770:7c1973d09c50 trytond/trytond/workflow/workflow.py: Removed size constraints on objects to reflect init.sql18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 771:cef3c8138ef7 trytond/trytond/init.sql: Removed unused field name18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 772:cdb29874ca97 trytond/trytond/ (ir/model.py ir/model.xml osv/orm.py sql_db.py):18:07
CIA-54tryton: _auto_init refectoring:18:07
CIA-54tryton: * cleaner code.18:07
CIA-54tryton: * added some constraint: avoid to do destructive migrations.18:07
CIA-54tryton: * added not null and index update.18:07
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 773:a4e59dc0c5bb trytond/trytond/ (7 files in 3 dirs): merge18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 774:205e6553df54 trytond/trytond/ (init.sql sql_db.py trytond.py workflow/workflow.py): merge18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 775:c345e4999c8e trytond/trytond/ir/rule.py: Removed useless size constaint18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 776:8d202638eaae trytond/trytond/init.sql: Re-added varchar(40) on password because fields.Sha use it18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 777:9e1340f1889c trytond/trytond/sql_db.py: removed print statement, better error message18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 778:1f1daf7e8bf7 trytond/trytond/ (osv/orm.py sql_db.py): Add default value in the db for integer and boolean field.18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 779:f279e0d669a9 trytond/trytond/sql_db.py: Print log message instead of raising exception whe migration is impossible.18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 780:568cf2c952c4 trytond/trytond/sql_db.py: Fix: dont try to create the column when migration is impossible18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 781:3872d8c7a5ed trytond/trytond/osv/orm.py: merge18:08
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 767:a14376b65237 trytond/trytond/init.sql: Fixes in init.sql to reflect objects definitions18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 768:79e6483ecd58 trytond/trytond/osv/fields.py: Fix sql_type on field.Selection18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 769:e8ce5062bdbb trytond/trytond/trytond.py: Remove legacy code about wkf_logs18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 770:7c1973d09c50 trytond/trytond/workflow/workflow.py: Removed size constraints on objects to reflect init.sql18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 771:cef3c8138ef7 trytond/trytond/init.sql: Removed unused field name18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 772:cdb29874ca97 trytond/trytond/ (ir/model.py ir/model.xml osv/orm.py sql_db.py):18:31
CIA-54tryton: _auto_init refectoring:18:31
CIA-54tryton: * cleaner code.18:31
CIA-54tryton: * added some constraint: avoid to do destructive migrations.18:31
CIA-54tryton: * added not null and index update.18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 773:a4e59dc0c5bb trytond/trytond/ (7 files in 3 dirs): merge18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 774:205e6553df54 trytond/trytond/ (init.sql sql_db.py trytond.py workflow/workflow.py): merge18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 775:c345e4999c8e trytond/trytond/ir/rule.py: Removed useless size constaint18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 776:8d202638eaae trytond/trytond/init.sql: Re-added varchar(40) on password because fields.Sha use it18:31
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 777:9e1340f1889c trytond/trytond/sql_db.py: removed print statement, better error message18:32
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 778:1f1daf7e8bf7 trytond/trytond/ (osv/orm.py sql_db.py): Add default value in the db for integer and boolean field.18:32
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 779:f279e0d669a9 trytond/trytond/sql_db.py: Print log message instead of raising exception whe migration is impossible.18:32
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 780:568cf2c952c4 trytond/trytond/sql_db.py: Fix: dont try to create the column when migration is impossible18:32
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> autoinit * 781:3872d8c7a5ed trytond/trytond/osv/orm.py: merge18:32
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 782:88fd9b722387 trytond/: Merge with autoinit branch18:32
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 764:4dc8dfbf3483 trytond/trytond/init.sql: Fix fields type in init.sql to follow the objects definitions20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 765:7df62e42d0e1 trytond/trytond/ir/model.py: Added missing required20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 766:bf245a3e8861 trytond/trytond/workflow/workflow.py: Added missing required20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 767:d575daea3849 trytond/trytond/init.sql: Fixes in init.sql to reflect objects definitions20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 768:c1ffc6364701 trytond/trytond/osv/fields.py: Fix sql_type on field.Selection20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 769:f9f0f8b6fecf trytond/trytond/trytond.py: Remove legacy code about wkf_logs20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 770:55d89bf4f62c trytond/trytond/workflow/workflow.py: Removed size constraints on objects to reflect init.sql20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 771:b43bc7f2afe4 trytond/trytond/init.sql: Removed unused field name20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 772:67dbc51f8ca2 trytond/trytond/ (ir/model.py ir/model.xml osv/orm.py sql_db.py):20:43
CIA-54tryton: _auto_init refectoring:20:43
CIA-54tryton: * cleaner code.20:43
CIA-54tryton: * added some constraint: avoid to do destructive migrations.20:43
CIA-54tryton: * added not null and index update.20:43
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 773:24a4960e0e81 trytond/trytond/ (7 files in 3 dirs): merge20:43
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 774:6dac07d6cfd2 trytond/trytond/ (init.sql sql_db.py trytond.py workflow/workflow.py): merge20:43
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 775:f624906e81a4 trytond/trytond/ir/rule.py: Removed useless size constaint20:44
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 776:fe44ce503919 trytond/trytond/init.sql: Re-added varchar(40) on password because fields.Sha use it20:44
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 777:a776bdf3779b trytond/trytond/sql_db.py: removed print statement, better error message20:44
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 778:f90edcc349e8 trytond/trytond/ (osv/orm.py sql_db.py): Add default value in the db for integer and boolean field.20:44
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 779:944b08150e85 trytond/trytond/sql_db.py: Print log message instead of raising exception whe migration is impossible.20:44
CIA-54tryton: Bertrand Chenal <bch@b2ck.com> default * 780:ab0f0b4e6627 trytond/trytond/sql_db.py: Fix: dont try to create the column when migration is impossible20:44
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 781:f35682f77c24 trytond/trytond/osv/orm.py: merge20:44
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 782:59c5492a8064 trytond/trytond/ (osv/orm.py sql_db.py): Remove print statement20:44
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 42:f4c80cab4936 company/.hgignore: Remove .hgignore20:59
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 115:263816bd3f42 relationship/.hgignore: Remove .hgignore20:59
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 783:053e0b68ed0b trytond/trytond/osv/orm.py: Set not null for boolean and not a default value21:22
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 784:65d38efaf504 trytond/trytond/osv/orm.py: Add not null constraint for integer and float21:22
CIA-54tryton: C?dric Krier <ced@b2ck.com> default * 167:f94223eb16a4 account/ (account.py journal.py): Add default value for boolean field21:22
-!- udono(n=udono@dynamic-unidsl-85-197-25-158.westend.de) has left #tryton23:16
-!- FWiesing(n=Wiesinge@194.208.185.12) has left #tryton23:50

Generated by irclog2html.py 2.11.0 by Marius Gedminas - find it at mg.pov.lt!