| chat.freenode.net #tryton log beginning Wed Jul 23 00:00:01 CEST 2014 | ||
| 2014-07-23 00:28 -!- udono(~udono@g225057102.adsl.alicedsl.de) has joined #tryton | ||
| 2014-07-23 01:30 -!- udono1(~udono@g225057022.adsl.alicedsl.de) has joined #tryton | ||
| 2014-07-23 03:32 -!- sharkcz(~sharkcz@server.danny.cz) has joined #tryton | ||
| 2014-07-23 03:48 -!- sharoonthomas(~sharoonth@122.177.17.148) has joined #tryton | ||
| 2014-07-23 04:11 -!- digitalsatori(~Thunderbi@114.94.153.119) has joined #tryton | ||
| 2014-07-23 05:08 -!- digitalsatori(~Thunderbi@114.94.153.119) has joined #tryton | ||
| 2014-07-23 05:08 -!- vak0160(~vak0160@36.72.229.107) has joined #tryton | ||
| 2014-07-23 06:05 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-07-23 06:34 -!- prksh(~prksh@118.91.181.250) has joined #tryton | ||
| 2014-07-23 06:40 -!- frispete_(~frispete@p54A91884.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-07-23 06:50 -!- mar(~marius@v100.nfq.lt) has joined #tryton | ||
| 2014-07-23 07:01 -!- yangoon1(~mathiasb@p549F0561.dip0.t-ipconnect.de) has joined #tryton | ||
| 2014-07-23 07:02 -!- vak0160(~vak0160@36.72.229.107) has joined #tryton | ||
| 2014-07-23 07:22 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-07-23 07:29 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton | ||
| 2014-07-23 07:33 <mar> how do I update default value of property? | ||
| 2014-07-23 08:16 -!- corro(~corro@46.22.23.85) has joined #tryton | ||
| 2014-07-23 08:21 -!- zultron(~zultron@99-190-134-148.lightspeed.austtx.sbcglobal.net) has joined #tryton | ||
| 2014-07-23 08:22 -!- zultron(~zultron@99-190-134-148.lightspeed.austtx.sbcglobal.net) has joined #tryton | ||
| 2014-07-23 08:23 -!- zultron(~zultron@99-190-134-148.lightspeed.austtx.sbcglobal.net) has joined #tryton | ||
| 2014-07-23 09:09 -!- vcardon(~vcardon@LNeuilly-152-23-15-185.w193-252.abo.wanadoo.fr) has joined #tryton | ||
| 2014-07-23 09:10 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-07-23 09:11 -!- bechamel(~Adium@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton | ||
| 2014-07-23 09:35 -!- jeancavallo(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton | ||
| 2014-07-23 09:50 -!- grasbauer(~jan@ip92340dc6.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2014-07-23 09:54 <mar> how do I update default value of property? | ||
| 2014-07-23 09:56 -!- pobsteta(~Thunderbi@37.163.44.232) has joined #tryton | ||
| 2014-07-23 09:57 <pokoli> mar: not sure to understand you, default value for a ir.property field? | ||
| 2014-07-23 09:57 <pokoli> mar: or default value of a property, for example the revenue account of a product | ||
| 2014-07-23 09:58 <mar> default cost_price_method when creating new product.template | ||
| 2014-07-23 09:58 -!- nicoe(~nicoe@balisto.office.b2ck.com) has joined #tryton | ||
| 2014-07-23 09:58 <mar> cost_price_method is Property(Selection) | ||
| 2014-07-23 09:59 <mar> http://hg.tryton.org/trytond/trytond/modules/product/file/b6461c7ed59f/product.py#l42 | ||
| 2014-07-23 09:59 <mar> http://hg.tryton.org/trytond/trytond/modules/product/file/b6461c7ed59f/product.py#l92 | ||
| 2014-07-23 09:59 <mar> I override default_cost*() method, but default value doesn't change | ||
| 2014-07-23 10:00 <mar> and I see that there's Administration -> Models -> Default Properties, but I can't change it there | ||
| 2014-07-23 10:01 <mar> I can't = I save it, but after refresh old value is present | ||
| 2014-07-23 10:08 -!- jeancavallo(~giovanni@bob75-9-88-181-2-176.fbx.proxad.net) has joined #tryton | ||
| 2014-07-23 10:13 -!- open_sax(~sax@dial-109-230-31-42.orange.sk) has joined #tryton | ||
| 2014-07-23 10:17 <pokoli> mar: which cost_method do you have on the product? | ||
| 2014-07-23 10:18 <mar> I have 'fixed' now | ||
| 2014-07-23 10:18 <mar> I want it to be 'fifo' | ||
| 2014-07-23 10:19 <mar> by default ;) | ||
| 2014-07-23 10:19 <pokoli> mar: just override the default | ||
| 2014-07-23 10:20 <pokoli> mar: so If you have fixed, i don't understand whats happening there | ||
| 2014-07-23 10:20 <mar> I override it using default_* method to 'fifo' | ||
| 2014-07-23 10:21 <mar> but defaults_get call still returns 'fixed' | ||
| 2014-07-23 10:21 <mar> (not sure about name defaults_get) | ||
| 2014-07-23 10:21 <cedk> mar: cost_price_method is not a property managed by the default property as it has a default method | ||
| 2014-07-23 10:21 <cedk> mar: probably it should be changed for a value defined on a product configuration object | ||
| 2014-07-23 10:22 -!- prksh(~prksh@118.91.181.250) has joined #tryton | ||
| 2014-07-23 10:22 <mar> and I see that it fetches default value from ir.property with res=NULL | ||
| 2014-07-23 10:24 <mar> http://hg.tryton.org/trytond/trytond/modules/product/file/b6461c7ed59f/product.xml#l145 | ||
| 2014-07-23 10:26 -!- littlebit(~Thunderbi@ulmg-5d84709e.pool.mediaWays.net) has joined #tryton | ||
| 2014-07-23 10:27 <mar> what's proper way of overriding it? | ||
| 2014-07-23 10:31 <cedk> mar: oh yes, it seems that all property field default value are overriden by the default property | ||
| 2014-07-23 10:32 <cedk> mar: and there is a default property defined in product.xml | ||
| 2014-07-23 10:32 <cedk> mar: so you must change this value | ||
| 2014-07-23 10:32 -!- prksh(~prksh@122.177.182.203) has joined #tryton | ||
| 2014-07-23 10:32 <mar> so I create another module with same entry, but different value? | ||
| 2014-07-23 10:33 <mar> if I do so, I have 2 values then in Default Properties for the same model ;) | ||
| 2014-07-23 10:42 <cedk> mar: no you must edit the record | ||
| 2014-07-23 10:43 <cedk> mar: but I just test it and it seems the reference widget doesn't work any more for simple values | ||
| 2014-07-23 10:43 <mar> :/ | ||
| 2014-07-23 10:45 <cedk> mar: Property field is one more shit we have to kill from OpenERP | ||
| 2014-07-23 10:46 -!- littlebit(~Thunderbi@ulmg-5d84709e.pool.mediaWays.net) has joined #tryton | ||
| 2014-07-23 10:47 <mar> what if I just override default_get method | ||
| 2014-07-23 10:47 <mar> and return 'fifo' there? | ||
| 2014-07-23 10:48 <cedk> mar: the right way is to change the default property | ||
| 2014-07-23 10:48 <mar> what do you mean change default property? | ||
| 2014-07-23 10:48 <mar> change value in db? | ||
| 2014-07-23 10:48 <mar> and forget about it? | ||
| 2014-07-23 10:49 <cedk> mar: change in the DB | ||
| 2014-07-23 10:49 <mar> there's still one thing that makes me nervous | ||
| 2014-07-23 10:50 <mar> http://hg.tryton.org/trytond/file/7ca488082a42/trytond/ir/property.py#l160 | ||
| 2014-07-23 10:51 <mar> does this mean that it doesn't set values for values that matches defaults? | ||
| 2014-07-23 10:51 <cedk> mar: yes | ||
| 2014-07-23 10:51 <mar> so if I change the default, I have to force_set values of old default for entries that doesn't have one? | ||
| 2014-07-23 10:53 <cedk> mar: yes as I said Property field is shit | ||
| 2014-07-23 10:53 <mar> what about "workaround" way of just overriding default_get? | ||
| 2014-07-23 10:53 <mar> would it work/ | ||
| 2014-07-23 10:54 <mar> because it seems like a lot of work for such small thing | ||
| 2014-07-23 10:57 <cedk> mar: I already answered: update the database | ||
| 2014-07-23 10:58 <mar> ok thanks | ||
| 2014-07-23 11:08 -!- pobsteta(~Thunderbi@37.163.44.232) has joined #tryton | ||
| 2014-07-23 11:28 -!- open_sax(~sax@dial-109-230-31-42.orange.sk) has left #tryton | ||
| 2014-07-23 11:56 -!- digitalsatori(~Thunderbi@114.94.153.119) has joined #tryton | ||
| 2014-07-23 12:29 -!- ronaldm(~ronaldm@197.211.216.214) has joined #tryton | ||
| 2014-07-23 12:37 -!- udono(~udono@g225057022.adsl.alicedsl.de) has joined #tryton | ||
| 2014-07-23 13:44 -!- bechamel(~Adium@cismwks02-virtual1.cism.ucl.ac.be) has joined #tryton | ||
| 2014-07-23 13:45 -!- kstenger(~karla@200.124.209.158) has joined #tryton | ||
| 2014-07-23 14:03 -!- umangarora(765bb5fa@gateway/web/freenode/ip.118.91.181.250) has joined #tryton | ||
| 2014-07-23 14:06 <umangarora> pokoli: i have sent a pull request to tryton documentation which fixes all the warnings and errors because of rst syntax violations | ||
| 2014-07-23 14:07 <umangarora> https://github.com/tryton/tryton-documentation/pull/53 | ||
| 2014-07-23 14:18 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-07-23 14:31 -!- pobsteta(~Thunderbi@37.162.195.10) has joined #tryton | ||
| 2014-07-23 14:51 -!- marius_(~marius@v100.nfq.lt) has joined #tryton | ||
| 2014-07-23 15:06 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-07-23 15:36 -!- ronaldm(~ronaldm@197.211.216.214) has joined #tryton | ||
| 2014-07-23 15:40 -!- alisonken1home(~alisonken@pool-71-104-227-145.lsanca.dsl-w.verizon.net) has joined #tryton | ||
| 2014-07-23 15:54 -!- gremly(~gremly@190.85.36.58) has joined #tryton | ||
| 2014-07-23 15:58 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 16:00 -!- smarro_(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-07-23 16:41 -!- ronaldm(~ronaldm@41.78.78.189) has joined #tryton | ||
| 2014-07-23 16:44 <hiaselhans> pokoli: my pr for docs doesnt rebase correctly anymore, is it ok if i close this one and put another one with recent changes applied? also i corrected intersphinx mapping for modules in the meantime... | ||
| 2014-07-23 16:45 <pokoli> hiaselhans: just merge/rebase master in your branch and push the pull request another time | ||
| 2014-07-23 16:45 <pokoli> hiaselhans: i've merged some work that fixes rst warnings | ||
| 2014-07-23 16:46 <hiaselhans> pokoli: ive seen, cool! i just put those changes manually as all that content moved to a different file... | ||
| 2014-07-23 16:47 <pokoli> hiaselhans: thanks | ||
| 2014-07-23 16:53 <hiaselhans> pokoli: almost done, one more thing: do you think its necessary to put "TRYTOND_HOME/trytond/bin/trytond" for the command lines to update/insert modules or could i replace by simple "trytond" | ||
| 2014-07-23 16:54 <pokoli> hiaselhans: it depends on the section you are | ||
| 2014-07-23 16:55 <hiaselhans> pokoli: ok i simply leave it, just thought its easier to read as simple "trytond" | ||
| 2014-07-23 16:55 -!- meanmicio(~meanmicio@142.Red-83-42-60.dynamicIP.rima-tde.net) has joined #tryton | ||
| 2014-07-23 16:55 -!- meanmicio(~meanmicio@fsf/member/meanmicio) has joined #tryton | ||
| 2014-07-23 17:00 <pokoli> hiaselhans: but in the developer section is normal to use trytond/bin/trytond because you don't have de server installed, so it's not available as trytond | ||
| 2014-07-23 17:02 <hiaselhans> pokoli: i left it as is... just thought we were enforcing virtualenv anyhow.. :) | ||
| 2014-07-23 17:02 <hiaselhans> pokoli: (pushed as #55) | ||
| 2014-07-23 17:02 <pokoli> hiaselhans: I will review when possible | ||
| 2014-07-23 17:03 <pokoli> hiaselhans: we are just adding some travis-ci integration in order to test if build is ok and doesn't produce warnings | ||
| 2014-07-23 17:03 <hiaselhans> pokoli: thanks! (wow, we have travis... :) | ||
| 2014-07-23 17:05 <cedk> yangoon1: did you ever try to create a docker image base on debian packages? | ||
| 2014-07-23 17:07 -!- sharoonthomas(~sharoonth@122.177.182.203) has joined #tryton | ||
| 2014-07-23 17:07 <sharoonthomas> pokoli: the build has passed, do you want to merge ? https://github.com/tryton/tryton-documentation/pull/54 | ||
| 2014-07-23 17:08 -!- ronaldm(~ronaldm@41.78.78.189) has joined #tryton | ||
| 2014-07-23 17:08 <pokoli> sharoonthomas: thanks for the honor! Merged! | ||
| 2014-07-23 17:09 <sharoonthomas> pokoli: thanks | ||
| 2014-07-23 17:09 <pokoli> sharoonthomas: we should ensure no commit comes with warning, shouldn't we? | ||
| 2014-07-23 17:10 <sharoonthomas> pokoli: the pull request will show you if there are warnings | ||
| 2014-07-23 17:10 <sharoonthomas> pokoli: so we can ask the user to fix | ||
| 2014-07-23 17:10 <pokoli> sharoonthomas: perfect. I will try to add some notes about it on README | ||
| 2014-07-23 17:11 <sharoonthomas> pokoli: sure and you could also add a badge: .. image:: https://travis-ci.org/tryton/tryton-documentation.svg?branch=master | ||
| 2014-07-23 17:11 <sharoonthomas> :target: https://travis-ci.org/tryton/tryton-documentation | ||
| 2014-07-23 17:14 <pokoli> sharoonthomas: can we see the rendered version on travis? | ||
| 2014-07-23 17:14 <sharoonthomas> pokoli: you mean the built/rendered HTML ? | ||
| 2014-07-23 17:14 <pokoli> sharoonthomas: yes | ||
| 2014-07-23 17:15 <pokoli> sharoonthomas: I use the preview button, but sometimes i download and make the PR to be able to see if all references and links are OK | ||
| 2014-07-23 17:15 <pokoli> sharoonthomas: so If it is available on travis, i don't have to download and build | ||
| 2014-07-23 17:15 <pokoli> ACTION is very lazy | ||
| 2014-07-23 17:16 <sharoonthomas> pokoli: loll, let me try that. | ||
| 2014-07-23 17:16 <pokoli> sharoonthomas: if possible, never mind if it's not possible :P | ||
| 2014-07-23 17:17 <sharoonthomas> pokoli: its an interesting thing to do... we have a website built that way but uploads the contents to s3 from travis | ||
| 2014-07-23 17:18 <pokoli> sharoonthomas: If you can make it work with an ssh access, i can provide a server :P | ||
| 2014-07-23 17:20 <cedk> sharoonthomas: I saw you created a docker for trytond | ||
| 2014-07-23 17:20 <cedk> sharoonthomas: but why are you using pip instead of apt-get? | ||
| 2014-07-23 17:21 <pokoli> sharoonthomas: we can use this http://docs.travis-ci.com/user/deployment/s3/ | ||
| 2014-07-23 17:22 <pokoli> sharoonthomas: sorry, wrong link. This http://docs.travis-ci.com/user/deployment/custom/ | ||
| 2014-07-23 17:22 <sharoonthomas> cedk: are apt (deb) packages released at the same time and frequency of tryton releases (including minor ones) ? (just asking.. since we usually don't use apt) | ||
| 2014-07-23 17:22 <sharoonthomas> pokoli: thinking of using docker if you already have a server (with a public ip) | ||
| 2014-07-23 17:23 <sharoonthomas> pokoli: we can have github send HTML post to the server when there is a new PR and we could then build that on a new docker container and update the PR with the link to the built documentation | ||
| 2014-07-23 17:24 <sharoonthomas> pokoli: something like that annoying bot nicoe built for code review ;) | ||
| 2014-07-23 17:24 <pokoli> sharoonthomas: I have the server (with public ip), no docker installed (but I can install) so yes | ||
| 2014-07-23 17:24 <pokoli> sharoonthomas: I think that will be enought | ||
| 2014-07-23 17:25 <cedk> sharoonthomas: yangoon1 manage that pretty fast | ||
| 2014-07-23 17:25 <cedk> sharoonthomas: but I don't know for Ubuntu | ||
| 2014-07-23 17:25 <sharoonthomas> cedk: then we should depend on that | ||
| 2014-07-23 17:33 -!- ronaldm(~ronaldm@41.78.78.189) has joined #tryton | ||
| 2014-07-23 17:36 <pokoli> sharoonthomas: I was thinking about forgeting on docker, and make a flask-app that builds the docs | ||
| 2014-07-23 17:36 <pokoli> sharoonthomas: so where can I find an example of the POST request? | ||
| 2014-07-23 17:39 <sharoonthomas> pokoli: sending you | ||
| 2014-07-23 17:39 <sharoonthomas> pokoli: https://developer.github.com/webhooks/#events | ||
| 2014-07-23 17:39 <sharoonthomas> pokoli: meantime, i will try something too | ||
| 2014-07-23 17:40 -!- alisonken1lap3(~alisonken@18.18.ultimate-int.uia.net) has joined #tryton | ||
| 2014-07-23 17:44 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 17:47 <pokoli> sharoonthomas: thinkg about building once travis have pass the build, otherwise I will get failing builds | ||
| 2014-07-23 17:48 <sharoonthomas> pokoli: yes | ||
| 2014-07-23 17:48 <pokoli> sharoonthomas: so maybe using this http://docs.travis-ci.com/user/notifications/#Webhooks-Delivery-Format | ||
| 2014-07-23 17:50 <sharoonthomas> pokoli: sounds like a plan | ||
| 2014-07-23 17:55 -!- grasbauer(~jan@business-088-079-110-234.static.arcor-ip.net) has joined #tryton | ||
| 2014-07-23 17:55 <pokoli> sharoonthomas: it seems not so much complicated, I will try it in some time | ||
| 2014-07-23 17:56 <sharoonthomas> pokoli: whatever you do, if documented will be a good read for a blog | ||
| 2014-07-23 17:56 <sharoonthomas> pokoli: I will try a docker version of it though | ||
| 2014-07-23 17:57 <pokoli> sharoonthomas: It's a pity that i didn't blog in english (maybe it can be an exception) | ||
| 2014-07-23 17:57 <pokoli> sharoonthomas: ok, so with docker it will be a good read for a blog too :P | ||
| 2014-07-23 17:58 <sharoonthomas> pokoli: i'm trying ;) | ||
| 2014-07-23 18:08 -!- digitalsatori(~Thunderbi@116.234.181.110) has joined #tryton | ||
| 2014-07-23 18:13 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-07-23 18:18 -!- seba_(~seba@49.202.15.62.static.jazztel.es) has joined #tryton | ||
| 2014-07-23 18:19 -!- jvblasco_(~seba@49.202.15.62.static.jazztel.es) has joined #tryton | ||
| 2014-07-23 18:20 <jvblasco_> guys, any tool, documentation or wahtever, to make a tryton database migration smoother? | ||
| 2014-07-23 18:20 <pokoli> jvblasco: trytond -d <database> -u all is not smooth? | ||
| 2014-07-23 18:21 <jvblasco_> pokoli: well, some models change, i refactored a huge amount of code | ||
| 2014-07-23 18:21 <jvblasco_> pokoli: but i don't want to make my lusers type the info again | ||
| 2014-07-23 18:21 <pokoli> jvblasco: so kill your lusers :P | ||
| 2014-07-23 18:22 <pokoli> jvblasco_: jokes a part, just write a __register__ method that runs the needed sql queries | ||
| 2014-07-23 18:22 <jvblasco_> pokoli: hehehehehe, i wish i could, u can't live with them, but neither without them... | ||
| 2014-07-23 18:22 <pokoli> jvblasco_: I don't know any docs on how to write them, I always get an example from existing ones | ||
| 2014-07-23 18:23 -!- grasbauer(~jan@ip92340dc6.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2014-07-23 18:23 <jvblasco_> pokoli: is that what tryton uses to make updates? | ||
| 2014-07-23 18:24 <jvblasco_> pokoli: anyway, changes are hard enough that i think i'll write a simple etl | ||
| 2014-07-23 18:24 <pokoli> jvblasco_: if you can do it with an sql query is not hard | ||
| 2014-07-23 18:25 <jvblasco_> pokoli: i would need to create tables, redo relations etc... | ||
| 2014-07-23 18:25 <jvblasco_> pokoli: my SQL skill is not that high, i usually rely on the orm layer for that | ||
| 2014-07-23 18:26 <pokoli> jvblasco_: table structure is managed by tryton by default, you just need to update the data | ||
| 2014-07-23 18:26 <pokoli> jvblasco_: just SELECT INSERT to migrate data from tables | ||
| 2014-07-23 18:26 <jvblasco_> pokoli: oO, is that true? | ||
| 2014-07-23 18:27 <pokoli> jvblasco_: you don't belive me? | ||
| 2014-07-23 18:27 <jvblasco_> pokoli: u know i do, it just seems magical ^^ | ||
| 2014-07-23 18:27 <jvblasco_> pokoli: tryton doesn't stop surprising me | ||
| 2014-07-23 18:27 <pokoli> jvblasco_: as magical as table creation, that is also managed by tryton | ||
| 2014-07-23 18:28 <jvblasco_> pokoli: yeah, but if i create a table, only add the pk, does tryton handle to apply fk for the relations? | ||
| 2014-07-23 18:30 <hiaselhans> is there a sample setup.py file to use for new modules or do you just use one from existing modules? | ||
| 2014-07-23 18:30 <pokoli> jvblasco_: don't understand | ||
| 2014-07-23 18:30 <pokoli> hiaselhans: for contrib modules http://hg.tryton.org/tryton-tools/file/b1bf3e9fe771/contrib-module-setup.tmpl | ||
| 2014-07-23 18:30 <jvblasco_> hiaselhans: i used one from existing modules to create my own | ||
| 2014-07-23 18:31 <pokoli> hiaselhans: core modules a bit diferent, but not a lot more | ||
| 2014-07-23 18:32 <jvblasco_> pokoli: an example would be more clear, imagine i have a table x with 3 m2o relations, y now need to move table x to table y, which in fact is the refactored model | ||
| 2014-07-23 18:32 <jvblasco_> pokoli: if i don't create the fk in the table y, will tryton handle it when it notices? | ||
| 2014-07-23 18:33 <hiaselhans> jvblasco_: pokoli: cool thanks! no sed needed :) will reference in docs, ok? | ||
| 2014-07-23 18:33 <jvblasco_> pokoli: of course relations are present in the new model, othewise i would just delete the fields | ||
| 2014-07-23 18:34 <pokoli> hiaselhans: that's the perfect template for the docs :P | ||
| 2014-07-23 18:34 <pokoli> jvblasco_: if refactored why changed table name? | ||
| 2014-07-23 18:34 <jvblasco_> pokoli: cause one of my issues has become naming | ||
| 2014-07-23 18:35 <pokoli> jvblasco_: tryton will only create the table with empty data | ||
| 2014-07-23 18:35 <jvblasco_> pokoli: the code just growth much more than i expected | ||
| 2014-07-23 18:35 <pokoli> jvblasco: so you just need a register that test if the id column exists, if not exists, make the SELECT INTO with the modified fields | ||
| 2014-07-23 18:36 <pokoli> jvblasco_: and the same for the relations, as I imagine you also changed the names | ||
| 2014-07-23 18:36 <jvblasco_> pokoli: yeah, some of them, but not all the relations | ||
| 2014-07-23 18:37 <pokoli> jvblasco_: so the ones that haven't changed, just rename the column | ||
| 2014-07-23 18:37 <pokoli> jvblasco_: not sure if it will work on fields with FOREIGN KEYS, but you can try | ||
| 2014-07-23 18:37 <jvblasco_> pokoli: i c | ||
| 2014-07-23 18:38 <jvblasco_> pokoli: i wonder if it's the new model that will need to execute all those queries on a __register__ call | ||
| 2014-07-23 18:39 <pokoli> jvblasco_: yes, because it's on the new model when you know if you are creating the table | ||
| 2014-07-23 18:40 -!- ronaldm(~ronaldm@197.221.243.233) has joined #tryton | ||
| 2014-07-23 18:40 <pokoli> jvblasco_: have a look at http://hg.tryton.org/tryton-tools/file/b1bf3e9fe771/contrib-module-setup.tmpl | ||
| 2014-07-23 18:40 <pokoli> jvblasco_: sorry: http://hg.tryton.org/modules/account/file/051e6ed2781b/move.py#l106 | ||
| 2014-07-23 18:40 <pokoli> jvblasco_: the super call it's where you database tables and columns are created | ||
| 2014-07-23 18:41 <pokoli> jvblasco_: so just test if table_exist before super call, and if not, execute queries after super call | ||
| 2014-07-23 18:43 <jvblasco_> pokoli: interesting | ||
| 2014-07-23 18:44 -!- ronaldm(~ronaldm@197.221.243.233) has joined #tryton | ||
| 2014-07-23 18:44 <pokoli> jvblasco_: the super method is what you call magic ^^ | ||
| 2014-07-23 18:44 <jvblasco_> pokoli: i need to give this a bit of thinking, seems the right way to do that | ||
| 2014-07-23 18:44 <jvblasco_> pokoli: yeah, seems like it lol | ||
| 2014-07-23 18:45 <pokoli> jvblasco_: of course you can do a migration with a ETL, but i think that tryton is enough for your case | ||
| 2014-07-23 18:46 <jvblasco_> pokoli: well, that's why we created the concept of ETL, it handle anything | ||
| 2014-07-23 18:46 <jvblasco_> pokoli: but you're right handling it just with tryton it's a better approach than building an ETL | ||
| 2014-07-23 18:47 <pokoli> jvblasco_: in the ETL, you will do the same, SELECTS and INSERTS :P | ||
| 2014-07-23 18:47 <pokoli> jvblasco_: and some update you can do with a rename from tryton | ||
| 2014-07-23 18:48 <jvblasco_> pokoli: but at that layer, my tryton knowledge is really limited, i'm still scratching tryton's surface | ||
| 2014-07-23 18:48 <jvblasco_> pokoli: well, i have snipets enough around to take a more object oriented approach with the etl, and treat data a more object oriented way, and let tryton handle creates, inserts and so on | ||
| 2014-07-23 18:49 <pokoli> jvblasco_: and yes ETLs handle everything, we have ETLs that migrates from OpenERP to Tryton, taking in account the installed modules | ||
| 2014-07-23 18:50 <jvblasco_> pokoli: models are almost the same in most cases, just suffered a huge renaming, including models name | ||
| 2014-07-23 18:50 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 18:51 <pokoli> jvblasco_: so just Select the original field names and INSERT the target names | ||
| 2014-07-23 18:51 <pokoli> jvblasco_: you can use python-sql to build the queries for you https://code.google.com/p/python-sql/ | ||
| 2014-07-23 18:52 <pokoli> jvblasco_: see the Insert query with query section | ||
| 2014-07-23 18:52 -!- munro(~ronaldm@197.221.243.233) has joined #tryton | ||
| 2014-07-23 18:56 -!- sharoonthomas(~sharoonth@122.177.174.183) has joined #tryton | ||
| 2014-07-23 18:56 <jvblasco_> pokoli: mmmmm, looks like a much better approach | ||
| 2014-07-23 18:57 <jvblasco_> pokoli: going to read some docs, thnx so much for the help | ||
| 2014-07-23 18:58 -!- prksh(~prksh@180.188.243.105) has joined #tryton | ||
| 2014-07-23 18:58 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 19:08 -!- ronaldm(~ronaldm@197.221.243.233) has joined #tryton | ||
| 2014-07-23 19:13 -!- ronaldm(~ronaldm@197.221.243.233) has joined #tryton | ||
| 2014-07-23 19:15 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 19:33 -!- ronaldm(~ronaldm@197.221.243.246) has joined #tryton | ||
| 2014-07-23 19:43 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 20:19 -!- cedk(~ced@85.26.36.239) has joined #tryton | ||
| 2014-07-23 20:19 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2014-07-23 20:26 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 20:39 -!- prksh(~prksh@180.188.243.105) has joined #tryton | ||
| 2014-07-23 21:10 -!- grasbauer(~jan@ip92340dc6.dynamic.kabel-deutschland.de) has joined #tryton | ||
| 2014-07-23 21:11 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-07-23 21:14 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-07-23 21:49 -!- bechamel(~Adium@62-197-96-189.teledisnet.be) has joined #tryton | ||
| 2014-07-23 21:50 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-07-23 22:25 -!- pablovannini(~pablo@host126.186-109-85.telecom.net.ar) has joined #tryton | ||
| 2014-07-23 22:49 -!- hiaselhans(~Thunderbi@212.186.45.207) has joined #tryton | ||
| 2014-07-23 23:15 -!- smarro(~sebastian@190.105.93.196) has joined #tryton | ||
| 2014-07-23 23:43 -!- uranus(~uranus@ool-182fa854.dyn.optonline.net) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!
