chat.freenode.net #tryton log beginning Tue Apr 9 00:00:01 CEST 2019 | ||
-!- csotelo(~csotelo@190.234.41.50) has joined #tryton | 00:05 | |
-!- shard_(~shard@223.74.176.91) has joined #tryton | 00:37 | |
-!- shard_(~shard@223.74.176.91) has joined #tryton | 00:51 | |
-!- sharkcz(~sharkcz@72.155.broadband6.iol.cz) has joined #tryton | 01:10 | |
-!- shard__(~shard@2409:8a55:d23c:f480:ec84:e9a7:cc37:81b6) has joined #tryton | 01:17 | |
-!- shard(~shard@223.74.176.91) has joined #tryton | 02:00 | |
-!- shard(~shard@223.74.176.91) has joined #tryton | 02:22 | |
-!- yangoon(~mathiasb@i59F52CC9.versanet.de) has joined #tryton | 02:32 | |
-!- shard_(~shard@223.74.176.91) has joined #tryton | 02:33 | |
-!- shard__(~shard@2409:8a55:d23c:f480:ec84:e9a7:cc37:81b6) has joined #tryton | 02:43 | |
-!- shard__(~shard@223.74.176.91) has joined #tryton | 02:56 | |
-!- kapil____(uid36151@gateway/web/irccloud.com/x-jtuzzlbuxfgronus) has joined #tryton | 04:01 | |
-!- udono1(~udono@104-139-067-156.ip-addr.inexio.net) has joined #tryton | 04:03 | |
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 05:06 | |
-!- shard(~shard@223.74.176.91) has joined #tryton | 05:14 | |
-!- shard(~shard@223.74.176.91) has joined #tryton | 05:22 | |
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | 05:56 | |
-!- thaneor(~lenovo3@r179-25-79-139.dialup.adsl.anteldata.net.uy) has joined #tryton | 06:17 | |
-!- mrichez(~smuxi@mail.saluc.com) has joined #tryton | 06:47 | |
-!- plaes(~plaes@plaes.org) has joined #tryton | 07:17 | |
-!- plaes(~plaes@unaffiliated/amd) has joined #tryton | 07:17 | |
alexbodn | hello my friends. i have 2 questions: | 07:40 |
---|---|---|
alexbodn | 1. is there a way to send sql queries in proteus, or i should define the query as a method to a model (probably in a module)? i see the transaction is exposed in trytonconfig, but no in the xmlrpc client. | 07:40 |
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 07:43 | |
pokoli | alexbodn: you should define the query as method to the model and expose it on RPC | 07:44 |
alexbodn | thank you pokoli, and a good day to you. i had such a feeling :) | 07:47 |
alexbodn | i also have a python sql question: i wish to build the where of a query dynamically, based on a dict. how should the key=value clause be combined? in the spirit of AND([(k==v) for (k,v) in clauses.items()]) or by functools.reduce(lambda a,b : a&b,clauses.items()) | 07:51 |
-!- rpit(~rpit@p200300C88F0A6700F0BEFC50CEB0A731.dip0.t-ipconnect.de) has joined #tryton | 07:52 | |
-!- rmu(~robert@cpe90-146-69-94.liwest.at) has joined #tryton | 07:58 | |
-!- kapil____(uid36151@gateway/web/irccloud.com/x-wjadeutvnubkvaxd) has joined #tryton | 07:59 | |
-!- thaneor(~lenovo3@r179-25-79-139.dialup.adsl.anteldata.net.uy) has joined #tryton | 08:01 | |
pokoli | alexbodn: why not using a domain instead of a dict? | 08:02 |
pokoli | alexbodn: you can get the sql version of a domain with Model.serach(domain, query=True) | 08:02 |
alexbodn | good question at the where level, but i also want to group by and filter the having results on this query. as i understand, the domain will provide or/and of a list of = clauses | 08:12 |
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | 08:36 | |
alexbodn | i can manually create the where, but i wanted the autoescaping and maybe backend specifics already done in sql | 10:41 |
-!- csotelo(~csotelo@190.234.41.50) has joined #tryton | 11:02 | |
-!- mariomop(~quassel@host26.201-253-197.telecom.net.ar) has joined #tryton | 11:07 | |
pokoli | alexbodn: if you want to create the query, you should use python-sql so you will have the backend specifics | 11:14 |
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton | 12:06 | |
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | 12:27 | |
-!- shard(~shard@2409:8a55:d23f:5e0:efa4:d7ef:712f:4934) has joined #tryton | 12:48 | |
-!- thaneor(~lenovo3@r179-25-79-139.dialup.adsl.anteldata.net.uy) has joined #tryton | 13:16 | |
-!- CarlosCHF(beea2932@gateway/web/freenode/ip.190.234.41.50) has joined #tryton | 14:04 | |
-!- shard(~shard@223.74.176.118) has joined #tryton | 14:15 | |
-!- shard(~shard@2409:8a55:d23f:5e0:d333:87ec:e7b1:858b) has joined #tryton | 15:05 | |
-!- thaneor1(~lenovo3@179.26.111.241) has joined #tryton | 18:20 | |
-!- udono(~udono@104-139-067-156.ip-addr.inexio.net) has joined #tryton | 18:22 | |
-!- rmu(~robert@cpe90-146-69-94.liwest.at) has joined #tryton | 18:35 | |
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | 20:00 | |
alexbodn | thanks pokoli, that's what i'll do | 20:09 |
-!- rmu(~robert@cpe90-146-69-94.liwest.at) has joined #tryton | 21:25 | |
-!- CarlosCHF(beea2932@gateway/web/freenode/ip.190.234.41.50) has joined #tryton | 21:31 | |
CarlosCHF | hi community | 21:32 |
CarlosCHF | how can i avoid to print when i have many records in my reports context ? | 21:34 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!