IRC logs of #tryton for Friday, 2011-11-04

chat.freenode.net #tryton log beginning Fri Nov 4 00:00:02 CET 2011
zxq9Is there a way to save a picture as binary data in the database, and then display it in a view?05:46
enlightxhi *, does tryton have this problem too? https://bugs.launchpad.net/openobject-addons/+bug/70792310:07
enlightxvat computation "by row" or "by column" is the topic10:07
cedkenlightx: http://hg.tryton.org/modules/account_invoice/file/713048f28dc6/invoice.py#l40610:14
cedkenlightx: http://hg.tryton.org/modules/sale/file/309ef16bf19b/sale.py#l45710:14
cedkenlightx: rounding is done per tax key10:14
enlightxcedk: actually it's not a real rounding problems, that depends on the way you sum the vat. you can compute the vat of each line then sum it, or you can compute the vat on the total amount (everything grouped by tax rate of course)10:15
enlightxopenerp does it the first way10:16
enlightxwhich is not ok in italy and switzerland and germany afaik10:16
cedkenlightx: I think both method are valid in all countries but it is not the natural way10:18
cedkenlightx: especially when there is only 1 taxes10:18
cedksee the screenshot https://bugs.launchpad.net/openobject-addons/+bug/707923/+attachment/1807906/+files/tax_rounding.png10:18
enlightxcedk: yes, the problem happens when you have more than one tax10:18
enlightxand we are always talking about 1 cents of difference10:19
enlightxcedk: anyway, in italy and switzerland we usually compute vat by column, in fact with openerp we often cannot record supplier invoices for this reason10:20
enlightxand WE CANNOT trick the invoice as Fabien suggested (rant)10:20
enlightxso, i'm starting to be quite upset and searching for an openerp alternative :-)10:21
zxq9<-- Would be upset if his country had VAT in the first place...10:21
cedkenlightx: rounding as we do is a little bit more complicate but it works better for every one10:22
enlightxzxq9: both ways must be supported10:22
cedkzxq9: in Japan there is no VAT?10:22
enlightxcedk: that could be enough indeed10:22
zxq9No VAT the way you guys have it in Europe -- and no taxes which cross national boundaries, that is tricky/dangerous.10:24
enlightxzxq9: you lucky :)10:26
zxq9Actually, for that reason I've had to remove a lot of VAT related code to use Tryton in Japan and USA -- there are very many European specific assumptions.10:26
cedkzxq9: I don't understand? What did you remove?10:26
zxq9Anything called "VAT" for one thing.10:27
zxq9And there is a lot, in accounting and invoice code.10:27
nicoeyou meant the vocabulary10:27
zxq9But not all countries have VAT, and VIES only makes sense in Europe.10:27
nicoenot the code10:27
zxq9Not just vocabulary.10:27
zxq9Supplier-supplier transactions are not taxed in many countries.10:28
cedkzxq9: it is just one field in Party form10:28
zxq9Retail is taxed in such countries.10:28
nicoeI don't understand what you had to remove10:28
cedkzxq9: there is no VAT reference in the account module10:28
nicoeDo you have a patch ?10:28
zxq9nicoe: Just branched modules, not patches.10:30
cedkzxq9: that's a bad idea for the future10:31
zxq9Maybe. But the structure for things like the party module don't fit what we're using the engine for.10:31
zxq9But the engine is extremely useful to build on.10:31
cedkzxq9: it is very strange because party module is very generic10:34
zxq9Which reminds me... is there a straightforward way to suppress the output of commas on large integer fields in a form?10:34
cedkzxq9: in language definition10:35
zxq9cedk: it makes assumptions about certain things related to how organizations are formed, and doesn't permit many2many location/address relationships, etc.10:35
cedkzxq9: what ?10:35
cedkzxq9: you mean that a company could have only one address?10:36
zxq9Is it possible to suppress commas in integer output in one specific form field? Or should I cast it to a string before displaying?10:36
zxq9cedk: No, that many people may share the same address.10:36
cedkzxq9: it is global10:36
cedkzxq9: ok but you can not share it10:36
zxq9cedk: Also, addressing in Asia is by zone, sub-zone, etc. There are no street names or anything, as well as the typical CJK language issues.10:36
cedkzxq9: have you a schema of such addresses?10:39
zxq9I have made one. It is a bit complex because it must accept three optional spellings for each field. When using PostgreSQL directly this would be usually done by making each field an array, but in Tryton we've just made 3 fields for each (for now anyway).10:40
udonozxq9: do you mean the thousand-seperator on integer fields?10:42
zxq9udono: yes10:42
zxq9Is there a way to store an image as binary data, and then display it within a form?10:45
zxq9or does it need to be saved in share/pixmaps first and then referenced by name?10:45
cedkhttps://secure.wikimedia.org/wikipedia/en/wiki/Japanese_addressing_system10:48
cedkzxq9: I looks like it can match10:48
nicoezxq9: you can display images in the client. gnuhealth do so.10:49
nicoeUse a binary field and a widget image10:49
nicoe<field name="my_picture" widget="image" />10:49
zxq9cedk: Match what? The current schema? Because it doesn't. The order problem is resolved with simply making a new form view, but the bigger problem is handling spellings in international business environment (even domestic, actually)10:50
cedkzxq9: it matches the current schema10:50
zxq9nicoe: Oh, haha. Nice. Thank you.10:50
zxq9cedk: No, it doesn't.10:51
zxq9cedk: Spellings are very complex. I mentioned this before, and making 3-languages to represent just Japanese does not work well.10:51
cedkzxq9: I don't speak about spelling10:51
zxq9Each element of the address must be searchable in hiragana, katakana, roman letters and kanji.10:51
cedkzxq9: I speak about database structure !10:52
cedkzxq9: that's must be managed with the translation feature10:52
zxq9And we have country, prefecture, municipality, city, town, village, neighborhood, number-clock, bunch, building name, building number, and room number fields. This is more than Tryton has room for.10:52
cedkzxq9: what city, town and village are not the same thing?10:53
zxq9The common solution is to just lump municipality, city and town together, then lump village and neighborhood, etc to make things fit.10:53
zxq9But this makes searching bad, and does not model the reality at all -- which makes mapping very difficult.10:54
zxq9city, town and village can all be different for the same address.10:54
zxq9And places like Ishikawa prefecture, Osaka and especially Tokyo have MANY layers to the address.10:54
cedkzxq9: so you don't use the right english name for you concept10:54
zxq9So many that often people just skip some fields when writing but because of the post code the mail people know what you mean.10:54
zxq9(usually)10:55
zxq9No, a "city" in English can mean many things. Consider Macau or Hong Kong.10:55
zxq9Or ancient Athens.10:55
zxq9Anyway, there are some region ideas in Japan and China that do not have exact words in English. And this is part of the addressing problem.10:56
cedkzxq9: I don't see at all all thos fields in https://secure.wikimedia.org/wikipedia/en/wiki/Japanese_addressing_system10:56
zxq9Look at the part of the article titled "Address parts". This is not 100% accurate, because where it is talking about wards (ku), it doesn't mention that within a ky you can have a gun, and within a gun you can have a cho, and within a cho you can have a mura *and* a son in some cases. They are not exclusive.10:58
zxq9My own address has ken, ku, shi, gun, son, kinjo, banchi, building number, room number.10:59
nicoeThe real question is why do you need to split those fields ?11:00
zxq9Anyway, we still need option for street names.11:00
nicoeAre you searching by 'mura' or 'son' ?11:01
zxq9nicoe: Because we are using SQL calls from another program to tie this to mapped locations.11:01
zxq9nicoe: Search must be enabled for any level, not just mura or son. Sometimes usually mura and son are the same thing, but not cho.11:03
nicoeJapan should revise its system if 'sometimes mura and son are the same thing but not cho' :D11:04
zxq9lol11:04
zxq9There is a lot of history behind place names here... that is why things are complex. And spellings are radically non-standard for old names, which is why we have to support search in three writing systems.11:05
zxq9Actually, most software completely ignores this problem -- and most users just get angry all the time here and do things by hand instead because of this.11:05
nicoeAnyway it looks like a specific use for you ... Other companies in japan can probably use the party.address as is11:06
zxq9Other companies just "deal with it" and survive with imperfect solutions.11:06
zxq9Ours is uniquely user friendly, just a little more complex to model initially.11:07
zxq9But that is the value -- not ignoring problems like this make really nice things possible for the user end.11:07
cedkzxq9: I find it is difficult to solve a problem which is not clearly defined11:08
cedkzxq9: a problem definition that contains "sometimes" doesn't have a solution11:08
bechamelcedk: sometimes = not required11:09
cedkbechamel: sometimes means fuzzy11:10
zxq9cedk: Proper modeling of addresses here isn't impossible. It just requires adding 3 more fields to the depth of addresses, and then treating most of the fields as a 3-element array.11:10
cedkzxq9: for you character, the solution is the translation11:10
cedkzxq9: so if it is just adding 3 fields, it is easy to extend address model11:11
cedkzxq9: and for searching on the three caracters set just override the search method of address to search on the 3 languages11:11
cedkACTION Japan solved11:12
zxq9cedk: adding three languages to represent asingle language is inelegant, to say the least -- and winds up confusing uers who accidentally select "katakan" as a language preference and suddenly get an all-English interface instead.11:12
cedkzxq9: for me it is the best solution11:13
cedkzxq9: and it simplify the screen as translation is managed at the client side11:14
cedkzxq9: also if you don't like 3 languages so rename lanugage into character set11:15
nicoeIt's the same concept "translated" in different spelling11:15
zxq9cedk: But we need language also. We have German, Russian, Japanese and English users currently.11:15
nicoeWhen you say Japanase, which japanese ?11:15
cedkzxq9: yes it is the same11:16
zxq9nicoe: What do you mean?11:16
cedkzxq9: i hope for you that you don't write english into the 3 sets of characters11:16
zxq9cedk: ?11:16
cedkzxq9: if your 3 sets of char are not language, I understand that you want also to write english name like 'New-York" into the 3 sets of char11:18
nicoezxq9: When you say that you have japanese users, which spelling do they use ?11:19
zxq9nicoe: All three are required for things like printing government forms. Names for people and companies (and sometimes addresses, depending on the form) are always required to input katakan or hiragana above the kanji, and sometimes Romanized spelling below that.11:21
zxq9cedk: A name like "New York" would only occupy the Roman letter line, and remain as is. But some specific international place names, like England, for example, are written three or four ways correctly on different documents.11:22
cedkzxq9: for me, it is definitly 3 languages11:23
zxq9But we can reduce to three consistently by always converting hiragana to katakana, since they are the same values, only a script difference.11:23
cedkzxq9: so hiragana and katakana are just formatting11:25
zxq9cedk: If we treat them that way, yes. Of course, they are different unicode characters, but its easy to cast beteen them because they are just different ound spellings.11:28
zxq9cedk: kanji and romaji is where it is tricky, and kanji is impossible to cast into or out of accurately.11:29
cedkzxq9: yes so it is a different language11:31
zxq9lol11:33
zxq9Is there any reason why the admin user doesn't see the thousands separator but a normal user does? Both have same language setting, etc.11:40
cedkzxq9: no11:42
cedkzxq9: admin is like any users11:42
udonozxq9: cedk: for me the thousands-separator should not be shown on integer fields. Or if there is need for this, it should be possible to disable.11:47
zxq9udono: A possible way (ugly, temprary kludge) is to cast before/after operation or passing the value somewhere else to make it not appear.11:48
zxq9udono: This raises new problems with bad input handling, though.11:49
cedkudono: why, you got a formating of number I don't see why it should be different if it is an int or a float11:50
udonocedk: Some numbers like zip numbers, account numbers are usually not shown with thousand separator, when represented by integer. Maybe the true problem is (mentioned by zxq9) the handling of bad input. This seems better solved with domains for simple fields.12:03
bechameludono: aren't zip and account numbers Char fields ?12:04
yangoonudono: zip must not be a number12:04
zxq9udono: I just tested the ugly casting method. If a field that needs to show no separator is Char type, any logic with that field must wrap it in int() and return with str(int()).12:05
zxq9udono: If the user inputs something like "blue" which is legal in a Char field, but not legal when an operation involving the int() cast happens, Tryton throws an ugly popup, but won't crash.12:05
zxq9Just the operation fails. Not a good solution, but a manageable kludge.12:06
zxq9Unless you have a lot of fields like this. Then that would be a really bad way.12:06
yangoonACTION configurable display of thousands separator per field would be a good feature12:09
cedkzxq9: catch ValueError except and raise a UserError instead12:10
cedkyangoon: why?12:10
cedkudono: so you don't have any example12:10
yangooncedk: because you can indeed wish to display this separator in some fields, in others not12:11
cedkyangoon: but why?12:11
cedkyangoon: a number is a number12:11
yangoonif you are handling financial numbers, you perhaps will prefer display with separator12:12
cedkyangoon: what do you mean?12:12
yangoonthere could be other usage of int fields, where you don't wishj12:12
yangoonlotto numbers:D12:12
cedkyangoon: not numbers12:12
yangoondo you know what I mean by lotto?12:12
cedkyangoon: it is a series of number12:12
cedkyangoon: yes and it is not a big number12:13
cedknext example…12:13
yangooncedk: depends, there are different lotto species12:14
cedkACTION tell me your need, I will explain how to do without12:14
yangooncedk: quantity, you could prefer to national preferneces to have them without separator12:14
cedkyangoon: there is a formating for currencies12:15
cedkI agree that it will be good to allow currency formating in the client but it is a complex task (I already tried)12:16
udonocedk: When I think about, it is realy the input validation aspect of integer we would like to use. But as said, this aspect would be more flexible solved with domains for char, text, integer, ... fields.12:18
udonobechamel: yangoon: I am comfortable with zip and account numbers represented as Char in tryton.12:19
yangooncedk one more;): room number, which is really a *number*, not a string12:19
yangoonI never saw a panel indicating romm number 1.00012:19
cedkyangoon: also I always find difficult to work with other language/currency number formating so I even don't think it is a good idea to have in the client currency formatting12:19
cedkyangoon: no room numbers could be: 15A12:19
cedkyangoon: next12:20
bechamel:)12:20
cedkudono: agree someking of pattern matching will be great12:20
cedkudono: like for dates12:20
zxq9cedk: About the exception. Very nice. Ty.12:22
zxq9Ah, about separators, if it were configurable per field it would be nice (but not necessary). This is another Japanese thing, of course. Counting here isdone in periods of four, not three, but some things are counted in periods of three.12:23
zxq9So most of the time counting goes like this: 10,0000,0000. But for some things like this 1,000,000,000.12:24
zxq9It is a very minor thing, though.12:24
cedkzxq9: WTF, it has no utilities to use a convention if it is not always used12:24
zxq9cedk: That would be true, if we lived in a world ruled by computers, not people (who are crazy, fickle and expect the most arbitrary things).12:25
cedkzxq9: no, formatting rules doesn't come from computers12:25
zxq9cedk: Anyway, this is cultural with a very long history to it. The language of Japanese itself formats numbers this way.12:26
cedkzxq9: it has an utility but it seems Japanese did not understand it12:26
cedkzxq9: I guess the Japan takes the number to arabs12:26
zxq9lol12:26
cedkzxq9: so not long specifici history12:26
nicoezxq9: In europe there was like a thousand different way to count and measure ... then Napoleon arrived with the metric system and invaded everything. It was so good even the english use it now.12:26
zxq9Actually its long before that, but happens to be periods of 412:26
cedkzxq9: or did they also have different charset to write numbers ?12:27
zxq9Yes, different charset for numbers.12:27
zxq9With specific ones to huge numbers in several bases, actually. But that is mostly academic now.12:27
zxq9But in common speech base-10 counting is done in periods of 4, not 3.12:27
cedkzxq9: yes we also get this, it is named float point representation12:28
zxq9You can also drop leading zeroes between periods when writing using Japanese characters as separators (instead of commas). This is very common with huge numbers.12:29
zxq9Sort of the way IP6 works.12:29
nicoefunny12:29
cedkACTION Japan needs to come to the 20 century12:29
zxq9So we need to roll IP6 back.12:30
zxq9because its not very 21st century.12:30
zxq9Anyway, notations are arbitrary. Providing hooks to switch between them shouldn't be any more unusual than providing type casting functions.12:30
zxq9I think the only real universal is binary. Its what our computers speak, anyway.12:31
cedkzxq9: I say that especially about grouping that depends on xxx12:31
zxq9Anyhow, this conversation demonstrates how deep unintentional cultural bias can extend, I think.12:31
cedkzxq9: I don't care about missing 0 but I don't think there is any standard formating lib that allow that12:32
cedkzxq9: no the real issue with Japan is the rules that has no rules12:32
zxq9There are some Japanese ones that do, particularly for financial systems and video game models. But I doubt they see any use outside of japan.12:32
zxq9cedk: There are rules to things. Domains of use, etc.12:33
zxq9cedk: We're not screaming about how dumb Germans are for having three ways to write "ss" and two ways to note umlauts. Or Spanish computer users for frequently omitting ~.12:34
udonozxq9: +1 :-)12:34
zxq9User expectations trump all other considerations when it comes to everything but research software. And in this case "research software" == "software with no users"12:34
cedkACTION Japan looks like the England about metric system12:35
zxq9cedk: Or America. And its still the only superpower.12:35
zxq9So, my challenge is how to make the interface meet my users' crazy expectations -- as non-standard as they are. Humans are just non-standard and they all suck.12:36
zxq9And every programming language and operating system sucks in exactly the same way.12:36
zxq9(^.^)12:36
-!- sharoon(~sharoon@187.35.109.225) has left #tryton12:37
cedkzxq9: so what is the rule about grouping numbers?12:37
zxq9cedk: Just depends on the use case.12:38
cedkzxq9: what is the rules of use case12:38
cedkzxq9: if there is a rules, you can explain it or there is no rules12:38
zxq9lol12:38
zxq9There is not a law signed by a committee about it, but there are common conventions.12:39
cedkzxq9: if you can not explain then there is no rules12:39
zxq9For common tabulation either way is acceptable. For formal reporting periods of 4 are most common, especially in finance. And for presentations using kanji separators is most common, unless leaving lots of zeroes for emphasis.12:39
zxq9Most software developed in the US, however, does not have a concept of flexible periods or kanji separators, so users can tolerate periods of 3 with commas.12:40
zxq9Basically, any number field that is likely to have a result > 10E9 should be in periods of 4.12:41
zxq9Because it is very difficult to read a number in your head converting many periods of 3 into periods of 4.12:41
zxq9So, general rule: Default to 4. 3 is OK for small numbers, 4 always for large values. Kanji separators for formal reporting.12:42
zxq9Not very mysterious, especially if you live here it makes sense.12:42
zxq9Anyway, being a cultural quirk, it is a lot like trying to explain slang grammar without being trained in linguistic instruction: It makes perfect sense to you and your friends, but diagramming the semantics is suddenly not very clean. But yet it works.12:43
cedkzxq9: so I really suggest you to drop the 3 periods as it is not so useful12:43
zxq9And most native developed software does.12:44
cedkzxq9: so you can have 4 periods in Tryton12:44
zxq9But ah... here is the exception! Haha... when delivering reports to foreign parties, like on inter-governmental projects and things.12:45
cedkzxq9: but number formatting depends of the language so no problem12:47
zxq9cedk: Ah, this is very nice.12:49
zxq9What am I doing wrong here: <notebook tabpos="up" colspan="6"> ... </notebook> ? Without 'tabpos="up"' everything works fine. I get Invalid XML in view error.13:43
cedkzxq9: tabpos is removed in 2.213:49
zxq9Ah.13:51
zxq9I was referencing the website docs -- still just 2.0. Hehe!13:51
zxq9Is there another way to get the same effect, or was the feature just removed completely?13:52
cedkzxq9: it is a configuration of the client13:53
cedkhttps://bugs.tryton.org/issue213513:53
zxq9oic13:54
zxq9ty13:54
-!- hedayat(~hedayat@fedora/hedayatvk) has left #tryton14:15
hedayatHi all!14:18
hedayatI have a problem with tryton access control settings14:18
hedayatCan anybody help me?14:18
hedayat:P14:18
zxq9I haven't learned much about that yet myself, but there are some very knowledgable (and helpful) people here.14:19
zxq9But sometimes it takes a while to get a response. (^.^)14:19
hedayatzxq9: :) Thanks14:20
cedkhedayat: don't ask to ask, just ask14:20
hedayatcedk: :) OK14:20
hedayatI have installed Tryton, and I want to restrict access to Party information for all users except a single group14:21
hedayatI go to Model Access page and add a rule which doesn't allow anything (even read access) to Party model14:22
cedkhedayat: you want to restrict access to party, this is a big change as party is used wildly in the system14:22
hedayatThen I try to access Party page with a non-admin user, it gives an error that you cannot read that document,14:23
cedkhedayat: yes you must create a default model access and an other one for the specific group14:23
hedayatI press OK but it brings the error dialog again and again. I'm forced to kill tryton in this case!14:23
cedkhedayat: yes it is a know issue, you should also hide menu for it14:23
hedayatcedk: Aha! hmmm sorry, how can I hide a specific menu entry? (sorry I'm a newbie in the Tryton world :P)14:24
cedkhttp://codereview.tryton.org/165003/14:24
cedkhedayat: this is the patch that prevent the inifit loop14:25
cedkhedayat: to hide a menu, you must add groups to it14:25
hedayatcedk: And please let me know if there are any online documentation for tryton since I didn't find much except the installation documentation and the14:25
hedayatwiki14:25
cedkhedayat: once a menu has a group, it is hidden for all others14:27
cedkhedayat: there is doc.tryton.org but not sure if it talk about that14:28
hedayatcedk: Thanks a lot for the info. let me see if I can do it14:28
cedkhedayat: becareful that playing with access, you can break your setup by preventing your self to access some part of the software14:31
zxq9O.o14:31
hedayatcedk: Yes! Thanks :)14:31
hedayatcedk: Thanks a lot. It worked. Also thank you for the patch.14:36
hedayat:)14:36
hedayatAnd yes, the document in the doc.tryton.org is very limited. I've already seen that.14:37
cedkhedayat: best doc is the code :-)14:38
zxq9hedayat: He's right about that. It just takes a bit to get familiar with it at first.14:39
cedkany way, help is welcome to complete the current doc14:42
hedayatcedk: :)14:42
hedayatcedk: Yes, I'm thinking about that. I might find some people who are interested to contribute in that part14:42
hedayatzxq9: so maybe I should start reading it if I decided to seriously work on it14:43
zxq9hedayat: Yep. But the best way to get familiar is to write a toy module or two to play with it. Then you really start seeing how things go together.14:44
hedayatzxq9: Thanks for the suggestion. I'll do that14:45
zxq9hedayat: Try the "hello world" module from the wiki howto. Just remember to not include the icon tag in the XML form (it'll do bad things if you don't have the party module installed, I think).14:45
hedayatzxq9: :) OK!14:47
zxq9If you do that one, then between referencing doc.tryton.org, docs.python.org (especially the language definition and library), and reading the code you can do a lot. Even if you never used Python before.14:48
cedkhedayat: I suggest also the training mqueue repo14:54
cedkhttp://hg.tryton.org/2.0/training/14:54
cedkit is not yet updated to 2.2 but it cover step by step almost all the principal concepts14:55
hedayatcedk: Thanks, I'll look into it15:05
hedayatAnother question, how can I customize the search operation?! It looks very limited! For example, in the Party/Parties there is only a15:05
hedayatsearch box15:05
hedayatEven if I write a few characters in the middle of a party name, it doesn't find it!15:06
hedayatFor example I search for et15:06
hedayatbut it doesn't find "Tet4"15:06
hedayatAnd isn't there any way for me to specify in which fields should it search?15:07
bechamelhedayat: type the name of the field15:11
bechamelhedayat: the entry will auto-complete it15:11
hedayatbechamel: Thanks! What about looking for words containing some characters, e.g. searching for 'st' and finding 'test'? Is it possible?15:14
bechamelhedayat: you have to prefix the search with "%"15:15
bechamelit's the wildcard caracter in slq15:15
bechamel*sql15:15
hedayatbechamel: Thanks!15:15
bechamelhedayat: but it may be slow on big tables15:16
hedayatbechamel: OK!15:17
hedayat:)15:17
bechamelhedayat: and of course you can combine several query15:20
bechamelhedayat: "name: > T or name: < U"15:20
hedayatbechamel: I'm trying this one but doesn't work: Name: >Tet or Name: <T15:24
hedayatbechamel: it is converted to: Name: >"Tet OR" Name: <T15:24
hedayat:P15:24
bechamelhedayat: hum15:24
bechamelhedayat: you have found a bug15:25
hedayatbechamel: OK! I think I found another one too:15:27
hedayatbechamel: write "Name: >T or Name: <U" and press enter15:27
hedayatbechamel: then delete T15:27
hedayatAn exception is thrown15:28
hedayat!15:28
bechamelhedayat: I cannot reproduce it15:31
bechamelhedayat: oh yes, I was missing the "or"15:32
bechamelhedayat: can you fill a bug ?15:32
hedayatbechamel: Yes, I'm going for it15:32
bechamelthx15:33
hedayatbechamel: https://bugs.tryton.org/issue226215:36
hedayatOops,let me provide more info there about how to reproduce it15:36
-!- hedayat(~hedayat@fedora/hedayatvk) has left #tryton16:34
cjbarnes18cedk: hello o/, I have been looking at your suggestion in codereview 167007.21:47
cjbarnes18cedk: it seems to me that we can either require lock for cron, or detect a lock and continue if found.21:48
cjbarnes18cedk: I am not sure which would be preferable.21:48
cjbarnes18cedk: the usual exception that occurs seems to be triggered by the test for the presence of the ir.cron module, would it be better to sanitise this?21:55
cjbarnes18cedk: or maybe even set a maintenance property for the database during each of the maintenance functions that we check for.21:55
cjbarnes18would it be appropriate to create a new property on the pool instances?21:55
cedkcjbarnes18: I preferp to use the lock22:03
cjbarnes18cedk: ok, I am guessing it should not block?22:05
cedkcjbarnes18: I think it should22:06
cjbarnes18that would stop cron for other databases while it it22:08
cjbarnes18is waiting for the lock?22:08
cjbarnes18same effect as setting CONFIG22:08
cjbarnes18cedk:  as far as I can tell at least anyway...22:11
cedkcjbarnes18: ok I mean try to get the lock in the cron for a database, if did not succeed skip it22:43
cedkcjbarnes18: but keep the lock, during the cron process22:44
cedkcjbarnes18: but of course don't wait to get the database lock22:44
cjbarnes18cedk: ok, thanks for your help, will have a go.22:45
hoRndumb at evening again :-(23:41
hoRnwhats wrong with: product_obj.search_read([('id', 'in', template['products']), ('quantity', '>', 0.0)]) - get all products with no quantity23:45
hoRnis there a limitation for function_fields in search_read?23:58
hoRnnever used search_read before ...23:59

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