IRC logs of #tryton for Tuesday, 2019-04-09

chat.freenode.net #tryton log beginning Tue Apr 9 00:00:01 CEST 2019
-!- csotelo(~csotelo@190.234.41.50) has joined #tryton00:05
-!- shard_(~shard@223.74.176.91) has joined #tryton00:37
-!- shard_(~shard@223.74.176.91) has joined #tryton00:51
-!- sharkcz(~sharkcz@72.155.broadband6.iol.cz) has joined #tryton01:10
-!- shard__(~shard@2409:8a55:d23c:f480:ec84:e9a7:cc37:81b6) has joined #tryton01:17
-!- shard(~shard@223.74.176.91) has joined #tryton02:00
-!- shard(~shard@223.74.176.91) has joined #tryton02:22
-!- yangoon(~mathiasb@i59F52CC9.versanet.de) has joined #tryton02:32
-!- shard_(~shard@223.74.176.91) has joined #tryton02:33
-!- shard__(~shard@2409:8a55:d23c:f480:ec84:e9a7:cc37:81b6) has joined #tryton02:43
-!- shard__(~shard@223.74.176.91) has joined #tryton02:56
-!- kapil____(uid36151@gateway/web/irccloud.com/x-jtuzzlbuxfgronus) has joined #tryton04:01
-!- udono1(~udono@104-139-067-156.ip-addr.inexio.net) has joined #tryton04:03
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton05:06
-!- shard(~shard@223.74.176.91) has joined #tryton05:14
-!- shard(~shard@223.74.176.91) has joined #tryton05:22
-!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton05:56
-!- thaneor(~lenovo3@r179-25-79-139.dialup.adsl.anteldata.net.uy) has joined #tryton06:17
-!- mrichez(~smuxi@mail.saluc.com) has joined #tryton06:47
-!- plaes(~plaes@plaes.org) has joined #tryton07:17
-!- plaes(~plaes@unaffiliated/amd) has joined #tryton07:17
alexbodnhello my friends. i have 2 questions:07:40
alexbodn1. 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 #tryton07:43
pokolialexbodn: you should define the query as method to the model and expose it on RPC07:44
alexbodnthank you pokoli, and a good day to you. i had such a feeling :)07:47
alexbodni 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 #tryton07:52
-!- rmu(~robert@cpe90-146-69-94.liwest.at) has joined #tryton07:58
-!- kapil____(uid36151@gateway/web/irccloud.com/x-wjadeutvnubkvaxd) has joined #tryton07:59
-!- thaneor(~lenovo3@r179-25-79-139.dialup.adsl.anteldata.net.uy) has joined #tryton08:01
pokolialexbodn: why not using a domain instead of a dict?08:02
pokolialexbodn: you can get the sql version of a domain with Model.serach(domain, query=True)08:02
alexbodngood 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 = clauses08:12
-!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton08:36
alexbodni can manually create the where, but i wanted the autoescaping and maybe backend specifics already done in sql10:41
-!- csotelo(~csotelo@190.234.41.50) has joined #tryton11:02
-!- mariomop(~quassel@host26.201-253-197.telecom.net.ar) has joined #tryton11:07
pokolialexbodn: if you want to create the query, you should use python-sql so you will have the backend specifics11:14
-!- springwurm(~Springwur@5.104.149.54) has joined #tryton12:06
-!- cedk(~ced@gentoo/developer/cedk) has joined #tryton12:27
-!- shard(~shard@2409:8a55:d23f:5e0:efa4:d7ef:712f:4934) has joined #tryton12:48
-!- thaneor(~lenovo3@r179-25-79-139.dialup.adsl.anteldata.net.uy) has joined #tryton13:16
-!- CarlosCHF(beea2932@gateway/web/freenode/ip.190.234.41.50) has joined #tryton14:04
-!- shard(~shard@223.74.176.118) has joined #tryton14:15
-!- shard(~shard@2409:8a55:d23f:5e0:d333:87ec:e7b1:858b) has joined #tryton15:05
-!- thaneor1(~lenovo3@179.26.111.241) has joined #tryton18:20
-!- udono(~udono@104-139-067-156.ip-addr.inexio.net) has joined #tryton18:22
-!- rmu(~robert@cpe90-146-69-94.liwest.at) has joined #tryton18:35
-!- semarie(~semarie@unaffiliated/semarie) has joined #tryton20:00
alexbodnthanks pokoli, that's what i'll do20:09
-!- rmu(~robert@cpe90-146-69-94.liwest.at) has joined #tryton21:25
-!- CarlosCHF(beea2932@gateway/web/freenode/ip.190.234.41.50) has joined #tryton21:31
CarlosCHFhi community21:32
CarlosCHFhow 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/!