| chat.freenode.net #tryton log beginning Thu Mar 21 00:00:01 CET 2019 | ||
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 00:44 | |
| -!- shard_(~shard@223.74.176.48) has joined #tryton | 02:10 | |
| -!- yangoon1(~mathiasb@i59F4FE89.versanet.de) has joined #tryton | 03:06 | |
| -!- kapil____(uid36151@gateway/web/irccloud.com/x-vkkfgmtailwucuyy) has joined #tryton | 04:53 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 06:19 | |
| -!- thaneor(~lenovo3@r179-24-113-156.dialup.adsl.anteldata.net.uy) has joined #tryton | 06:29 | |
| -!- udono(~udono@183-058-210-188.ip-addr.inexio.net) has joined #tryton | 07:02 | |
| -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | 07:04 | |
| -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton | 07:49 | |
| -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 08:16 | |
| alexbodn | good morning friends, pokoli, cedk | 09:06 |
|---|---|---|
| -!- rpit(~rpit@p200300C88F3074009483377F147C344D.dip0.t-ipconnect.de) has joined #tryton | 09:10 | |
| alexbodn | i've looked at tryton through the clients, the gtk local one and the sao web client and it looks beautiful indeed. i don't see the full correspondence between the labels on the screen and the model fields organization: not all the fields are in the same model / table. could i please see the proteus program that you use to load the demo db? | 09:12 |
| -!- rpit(~rpit@p4FFB7256.dip0.t-ipconnect.de) has joined #tryton | 09:16 | |
| -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 09:19 | |
| -!- Springwurm_(~Springwur@5.104.149.54) has joined #tryton | 09:32 | |
| -!- Springwurm_(~Springwur@5.104.149.54) has left #tryton | 09:33 | |
| -!- springwurm(~Springwur@5.104.149.54) has left #tryton | 09:33 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 09:33 | |
| -!- Springwurm_(~Springwur@5.104.149.54) has joined #tryton | 09:35 | |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 09:35 | |
| -!- rpit(~rpit@p200300C88F307400C2CDE6C91283B9CF.dip0.t-ipconnect.de) has joined #tryton | 09:38 | |
| pokoli | alexbodn: http://hg.tryton.org/tryton-tools/file/9c47c389f87c/tryton_demo.py | 10:40 |
| -!- csotelo(~csotelo@181.67.16.48) has joined #tryton | 10:47 | |
| -!- rpit(~rpit@p4FFB7256.dip0.t-ipconnect.de) has joined #tryton | 10:47 | |
| -!- mariomop(~quassel@host155.186-109-209.telecom.net.ar) has joined #tryton | 10:51 | |
| alexbodn | thank you very very much pokoli. i see clear examples of code i've missed. | 11:15 |
| alexbodn | proteus is a true client. kudos | 11:15 |
| pokoli | alexbodn: yes, it is the tryton client from commandline and mimics as much as possible the standard client | 11:20 |
| pokoli | alexbodn: it's a very good solution for running e2e test with our code | 11:21 |
| springwurm | alexbodn; i think another great resources, are the test scenarios: e.g. http://hg.tryton.org/modules/sale/file/tip/tests/scenario_sale.rst | 11:24 |
| alexbodn | yes, until now i found my way through the test files, but they didn't always create complete objects, thus my appeal to a true client. a big warm thank you for accepting my queer way to learn. i have applied to nantic that support universities and asked for a background theoretic book on erp. | 12:03 |
| alexbodn | the rst scenariouses are very cool too. thanks again pokoli. thanks author cedk | 12:07 |
| -!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 13:23 | |
| mrichez | hi, any tips to order a date function field which is a timedelta based on a date and a value from another field? | 14:34 |
| mrichez | or is it easier to convert this function field to a readonly date field? | 14:35 |
| -!- rpit(~rpit@p200300C88F307400C2CDE6C91283B9CF.dip0.t-ipconnect.de) has joined #tryton | 14:41 | |
| pokoli | mrichez: order based on cast | 14:46 |
| mrichez | pokoli: ? | 14:46 |
| pokoli | mrichez: something like http://hg.tryton.org/modules/party/file/ff3dd9d1efd6/party.py#l99 but using cast instead of Charlength | 14:46 |
| pokoli | mrichez: replace code with your functional field name | 14:47 |
| pokoli | ACTION bbl | 14:47 |
| nicoe | Can't you just order by this field? | 14:48 |
| mrichez | as field is a function field, i have to define an order method | 14:49 |
| nicoe | Oh I thought it was a real field | 14:50 |
| mrichez | nicoe: :-) | 14:51 |
| mrichez | pokoli: your example is with a real field... | 14:51 |
| -!- shard__(~shard@2409:8a55:d23f:8560:dccf:96a9:94fd:60a4) has joined #tryton | 14:51 | |
| nicoe | Then you can probably use and "order_" function that do the computation between the two real fields | 14:51 |
| mrichez | nicoe: that was i thougt , but dont see sql date functions for ordering | 14:53 |
| mrichez | here's my code: https://pastebin.com/8BnbTEeP | 14:53 |
| mrichez | nicoe: and my ordering is based on a compute between a date and a value | 14:54 |
| mrichez | if this is not possible, i'll convert my function field to a real field readonly.. | 14:57 |
| nicoe | mrichez: estimated_time_delivery should be a TimeDelta, no ? | 14:57 |
| nicoe | But you can use the python-sql datetime expressions | 14:58 |
| nicoe | in your code | 14:58 |
| mrichez | nicoe: no, a date, it is the result between a substraction of number days on a planned date | 14:59 |
| mrichez | nicoe: result of an order method is an sql expression, no ? | 14:59 |
| nicoe | Something like [table.planned_date - Now()] should work | 15:00 |
| nicoe | But you should be able to use any SQL expression indeed | 15:01 |
| mrichez | nicoe: More something like [dateadd(dd,nbdays,table.planned_date)] | 15:01 |
| mrichez | don't see sql date functions in sql.operators | 15:02 |
| cedk | mrichez: your data layer is bad because you use integer to store a timedelta instead of timedelta | 15:04 |
| cedk | mrichez: if you had nbdays stored as timedelta, the computation could be done in SQL | 15:04 |
| mrichez | cedk: ok | 15:05 |
| mrichez | cedk: will convert the field in timedelta and doing compute in my order method | 15:06 |
| mrichez | thanks to all | 15:06 |
| -!- udono1(~udono@183-058-210-188.ip-addr.inexio.net) has joined #tryton | 16:37 | |
| -!- udono(~udono@183-058-210-188.ip-addr.inexio.net) has joined #tryton | 16:41 | |
| -!- udono1(~udono@183-058-210-188.ip-addr.inexio.net) has joined #tryton | 16:44 | |
| -!- rpit(~rpit@p4FFB7256.dip0.t-ipconnect.de) has joined #tryton | 16:46 | |
| -!- udono(~udono@183-058-210-188.ip-addr.inexio.net) has joined #tryton | 16:47 | |
| -!- udono1(~udono@183-058-210-188.ip-addr.inexio.net) has joined #tryton | 16:50 | |
| -!- udono(~udono@183-058-210-188.ip-addr.inexio.net) has joined #tryton | 16:53 | |
| -!- gdrius(~gdrius@m90-143-121-251.cust.tele2.lt) has joined #tryton | 17:31 | |
| -!- thaneor1(~lenovo3@r179-24-153-172.dialup.adsl.anteldata.net.uy) has joined #tryton | 18:34 | |
| -!- csotelo(~csotelo@181.67.16.48) has joined #tryton | 20:32 | |
| -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | 21:01 | |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!