| 00:00.12 | darkstar_ | it allways seems to go to else |
| 00:00.29 | darkstar_ | I'll try again |
| 00:03.24 | jkakar | darkstar_: What is articulo? A dict? |
| 00:03.33 | darkstar_ | yes |
| 00:03.36 | jkakar | Ah, okay. |
| 00:03.50 | darkstar_ | it is allways doing the else |
| 00:03.52 | jkakar | darkstar_: What version of Python are you using? |
| 00:03.56 | darkstar_ | 2.6 |
| 00:03.58 | jkakar | Okay. |
| 00:03.59 | darkstar_ | why? |
| 00:04.25 | darkstar_ | sometimes I use __contains__ |
| 00:04.25 | darkstar_ | sometimes has_key |
| 00:04.25 | darkstar_ | I really don't mind |
| 00:04.39 | jkakar | Just wondering, because of the coding style. |
| 00:05.03 | jkakar | darkstar_: For example, articulo.has_key("ref") is more commonly (to me anyway) written as: "ref" in articulo. |
| 00:05.30 | jkakar | darkstar_: I also noticed you have code like i.strip().__len__() > 0 when you could instead do len(i.strip()) > 0. |
| 00:05.54 | darkstar_ | :S |
| 00:06.06 | darkstar_ | I'm changing everything, jkakar |
| 00:06.10 | jkakar | darkstar_: Heheh .:) |
| 00:06.14 | darkstar_ | because I'm becoming crazy |
| 00:06.21 | darkstar_ | more than 12 hours with this problem |
| 00:06.22 | jkakar | darkstar_: I understand. I went crazy years ago. ;) |
| 00:06.23 | darkstar_ | and no solution |
| 00:06.43 | darkstar_ | storm has the worst documentation I ever see |
| 00:06.44 | jkakar | darkstar_: When I have that kind of thing I try to break the problem into smaller pieces, to try to make each step simpler. |
| 00:06.50 | darkstar_ | THE WORSE!!!!!!!! |
| 00:06.51 | jkakar | darkstar_: Hehe, it's not great, no. :) |
| 00:07.01 | jkakar | darkstar_: Patches welcome. |
| 00:07.04 | darkstar_ | mod_python sucks |
| 00:07.07 | darkstar_ | toooooooooooooooo much |
| 00:07.28 | darkstar_ | I'm spending lot of time with it |
| 00:07.38 | darkstar_ | and everybody told me I sould use ruby on rails |
| 00:07.46 | darkstar_ | now I know they had reason |
| 00:08.14 | jkakar | darkstar_: mod_python does suck. I'm not sure jumping to rails is the only way forward. Django is pretty sweet, for example. |
| 00:09.02 | darkstar_ | now I just wanna commite suicide |
| 00:09.05 | darkstar_ | xD |
| 00:11.42 | jkakar | hugs darkstar_ :( |
| 00:12.23 | jkakar | darkstar_: If it makes you feel any better I'm trying to debug Javascript failures without a console or debugger. MUCH PAIN! :) |
| 00:13.15 | darkstar_ | :S |
| 00:13.27 | darkstar_ | don't you use seamonkey browser? |
| 00:13.39 | darkstar_ | it's come with a javascript console and debugger |
| 00:14.24 | jkakar | darkstar_: Well, I have Firebug. We use YUI3, which just released their official 3.0.0 version, so I'm upgrading code built on previous beta versions and... am having... fun. :) |
| 00:15.03 | darkstar_ | I don't know what is yui3 |
| 00:17.41 | jkakar | darkstar_: Yahoo! User Interface toolkit. Basically, a Javascript framework that has, among other things, a nice framework for building Javascript widgets. |
| 00:18.00 | darkstar_ | ammm, ok |
| 00:26.20 | *** join/#storm gabriel (n=gabriel@node-2761.tor.pppoe.execulink.com) |
| 00:34.15 | darkstar_ | jkakar, |
| 00:34.18 | darkstar_ | (1062, "Duplicate entry '45-2' for key 1") con su puta madre... |
| 00:34.54 | darkstar_ | ups, sorry, last 4 words is a message I added to error |
| 00:35.54 | jkakar | darkstar_: Hehe, I think I know what those last four words mean even. :) |
| 00:36.06 | jkakar | darkstar_: So you're trying to insert an object with a duplicate ID? |
| 00:36.15 | darkstar_ | "with it's fucking mother" (on english) |
| 00:36.32 | darkstar_ | I'm just trying to update it! |
| 00:37.10 | jkakar | Hehe |
| 00:37.23 | jkakar | darkstar_: Are you changng the ID with the update? |
| 00:37.28 | jkakar | darkstar_: Or setting it, rather? |
| 00:37.37 | darkstar_ | no |
| 00:38.36 | jkakar | darkstar_: I think the best way for us to help you is by writing a simple program that we can run that demonstrates the issue you're facing. |
| 00:38.56 | darkstar_ | but I'm doing it like you |
| 00:39.23 | darkstar_ | except I'm updating few values of an object |
| 00:40.02 | jkakar | darkstar_: That should be fine, yep. It *sounds* like what you're doing is right, but obviously something is wrong somewhere. |
| 00:40.33 | darkstar_ | mmmm |
| 00:46.13 | *** join/#storm sidnei (n=sidnei@plone/dreamcatcher) |
| 00:55.35 | darkstar_ | same result again |
| 01:07.49 | *** join/#storm stub (n=stub@ppp-58-8-7-140.revip2.asianet.co.th) |
| 01:25.47 | darkstar_ | jkakar, problem seems here |
| 01:26.39 | darkstar_ | http://pastebin.ubuntu.com/281774/ |
| 01:27.06 | darkstar_ | there is where id error happend |
| 01:27.29 | darkstar_ | oh shit! |
| 01:27.36 | darkstar_ | now I know why |
| 01:27.41 | darkstar_ | omg |
| 01:27.41 | darkstar_ | xD |
| 01:29.54 | darkstar_ | jkakar, he is trying to add article_tag and it exists |
| 01:30.01 | darkstar_ | but it shouldn't happend because of this |
| 01:30.11 | darkstar_ | <PROTECTED> |
| 01:30.11 | darkstar_ | <PROTECTED> |
| 01:32.20 | darkstar_ | it should be != |
| 01:32.22 | darkstar_ | xDDDDDDDDDD |
| 01:36.19 | jkakar | darkstar_: Oops. :) |
| 01:36.32 | jkakar | darkstar_: FYI, I'm pretty sure you can take the type() calls out of that conditional. |
| 01:46.14 | darkstar_ | this is the problem I'm seeing |
| 01:46.33 | darkstar_ | with !=, it shouldn't add elements that aren't there |
| 01:46.41 | darkstar_ | it should add them with == |
| 01:47.03 | darkstar_ | if find returns None, it shouldn't be in the db |
| 01:47.32 | darkstar_ | so I can't understand the error |
| 01:47.47 | jkakar | darkstar_: What if you change the if to: if article_tag is None: ... |
| 01:48.10 | darkstar_ | it should be the same... |
| 01:48.31 | jkakar | Yeah, it should. |
| 01:49.21 | darkstar_ | >>> article_tag = store.get(frikisdb.ArticuloTag, (6, 45)) |
| 01:49.26 | jkakar | darkstar_: I'm stepping away. Good luck. If you continue to have problems post a runnable example demonstrating the issue to the mailing list and I'l try to help you out. |
| 01:49.30 | darkstar_ | >>> article_tag |
| 01:49.31 | darkstar_ | >>> if type(article_tag) == type(None): |
| 01:49.31 | darkstar_ | ... print "lala" |
| 01:49.31 | darkstar_ | ... |
| 01:49.31 | darkstar_ | lala |
| 01:49.46 | jkakar | darkstar_: Does ArticuloTag have a compound primary key? |
| 01:49.59 | darkstar_ | of course |
| 01:50.04 | jkakar | darkstar_: Okay. |
| 01:50.08 | darkstar_ | and it's a refference |
| 01:50.19 | darkstar_ | so they are foreing key |
| 01:50.25 | jkakar | Right, it's a link table. |
| 01:50.38 | darkstar_ | n:m relation between article and tag, yes |
| 01:52.39 | darkstar_ | >>> article_tag = store.get(frikisdb.ArticuloTag, (45, 2)) |
| 01:52.39 | darkstar_ | >>> article_tag |
| 01:52.39 | darkstar_ | <frikisdb.ArticuloTag object at 0x81a774c> |
| 01:52.50 | darkstar_ | >>> if type(article_tag) == type(None): |
| 01:52.50 | darkstar_ | ... print "lala" |
| 01:52.50 | darkstar_ | ... |
| 01:52.50 | darkstar_ | >>> |
| 01:52.58 | darkstar_ | so... |
| 01:53.53 | darkstar_ | sorry, jkakar |
| 01:53.55 | darkstar_ | before go |
| 01:54.04 | jkakar | :) |
| 01:54.14 | darkstar_ | if I want to clear all entries of a table? |
| 01:54.24 | darkstar_ | should I use truncate table? |
| 01:54.34 | darkstar_ | just entries, not colums, not table |
| 01:55.12 | jkakar | darkstar_: TRUNCATE is one option, yep. |
| 01:55.23 | darkstar_ | ok |
| 01:55.36 | jkakar | darkstar_: We use PostgreSQL here and we've found that DELETE FROM foo is faster than TRUNCATE foo. |
| 01:55.41 | darkstar_ | I'll try again truncating everything before |
| 01:55.45 | jkakar | darkstar_: So, between unit tests we run DELETE statements, instead of TRUNCATE. |
| 01:55.50 | darkstar_ | wow. postgres... |
| 01:55.52 | jkakar | darkstar_: But they should both have the same effect. |
| 01:55.59 | jkakar | darkstar_: What are you using? |
| 01:56.06 | darkstar_ | it's really different than oracle and mysql |
| 01:56.09 | darkstar_ | mysql... |
| 01:56.24 | jkakar | darkstar_: Well, it uses the very cool MVCC model, so I guess it is yeah. |
| 01:56.26 | darkstar_ | I have never use postgres |
| 01:56.36 | jkakar | darkstar_: It's nice. I prefer it to MySQL. |
| 01:56.38 | jkakar | darkstar_: OOOOHHH. |
| 01:56.44 | jkakar | darkstar_: You're using MySQL? |
| 01:56.49 | darkstar_ | yeah, it seems better |
| 01:56.53 | darkstar_ | yes |
| 01:56.54 | darkstar_ | why? |
| 01:57.21 | jkakar | darkstar_: Are you using 'ENGINE=InnoDB' at the end of your CREATE TABLE statements? |
| 01:57.34 | jkakar | darkstar_: It's the only backend that works correctly with Storm, AFAIK. |
| 01:57.43 | darkstar_ | I've created it with phpmyadmin |
| 01:57.46 | darkstar_ | so I don't know |
| 01:58.12 | jkakar | darkstar_: Okay, make sure it's a InnoDB table. |
| 01:58.16 | darkstar_ | jkakar, is the only backend that works correctly?????????? |
| 01:58.20 | darkstar_ | how can I see it? |
| 01:58.22 | jkakar | darkstar_: Yes. |
| 01:58.31 | jkakar | darkstar_: When you create tables you need to include the ENGINE: |
| 01:58.43 | darkstar_ | so there are problems with mysql? |
| 01:58.52 | darkstar_ | don't f*** me, man!!!!!!!!! |
| 01:58.53 | jkakar | CREATE TABLE bin_test (id INT AUTO_INCREMENT PRIMARY KEY, b BLOB) ENGINE=InnoDB |
| 01:58.54 | darkstar_ | jajajaj |
| 01:58.56 | jkakar | Heh |
| 01:59.03 | darkstar_ | yes, but tables are created |
| 01:59.06 | jkakar | darkstar_: Not all of the MySQL backends support proper transaction semantics. |
| 01:59.18 | darkstar_ | how can I see if engine=innodb is active? |
| 01:59.20 | jkakar | darkstar_: InnoDB is the one that is known to work with Storm. |
| 01:59.36 | darkstar_ | yes, it's great |
| 01:59.48 | darkstar_ | but how can I see if engine=innodb is active? |
| 02:02.17 | jkakar | darkstar_: SHOW CREATE TABLE <table> |
| 02:02.46 | jkakar | darkstar_: If it doesn't say ENGINE=InnoDB you need to (probably) recreate the tables. |
| 02:02.53 | jkakar | darkstar_: I don't have much experience with MySQL and Storm, so sorry to be a bit vague here. |
| 02:03.10 | jkakar | darkstar_: Anyway, I need to step away and make some dinner. Good luck, let me know how it goes tomorrow. |
| 02:03.42 | darkstar_ | oh noooooooooo |
| 02:03.44 | darkstar_ | :S |
| 02:03.49 | darkstar_ | I'll try with an alter table :S |
| 02:03.55 | darkstar_ | mabe it will work |
| 02:03.59 | darkstar_ | thanks you very much, jkakar |
| 02:04.00 | darkstar_ | see you |
| 02:04.28 | darkstar_ | ENGINE=MyISAM |
| 02:04.36 | darkstar_ | jkakar, |
| 02:04.39 | jkakar | darkstar_: My pleasure, take care and good luck. |
| 02:04.41 | darkstar_ | it don't works fine? |
| 02:04.45 | jkakar | Nope, it won't. |
| 02:04.49 | jkakar | I don't think anyway. |
| 02:04.55 | darkstar_ | why not? |
| 02:05.17 | jkakar | darkstar_: The test suite uses the InnoDB engine thoughout, so that's what tested and known to work. It won't work because MyISAM doesn't have full support for transactions, AIUI. |
| 02:05.19 | darkstar_ | bad luck man |
| 02:05.39 | darkstar_ | aha |
| 02:05.41 | darkstar_ | ok, thanks you |
| 02:05.45 | darkstar_ | I'll try to change it |
| 02:05.47 | darkstar_ | by |
| 02:05.48 | darkstar_ | bye |
| 02:06.12 | jkakar | darkstar_: Interesting information here: http://en.wikipedia.org/wiki/MyISAM |
| 02:06.22 | darkstar_ | there are 3 engines |
| 02:06.31 | darkstar_ | memory |
| 02:06.37 | darkstar_ | mrg_myisam |
| 02:06.40 | darkstar_ | and isam |
| 02:50.54 | stub | truncate is preferable on larger tables, particularly with indexes - it doesn't leave a load of free space lying around and is faster. |
| 05:19.55 | *** join/#storm bigdog (n=scmikes@72-197-8-8-arpa.cust.cinci.current.net) |
| 05:23.06 | *** join/#storm jukart (i=lovely@81.189.156.94) |
| 08:40.55 | *** join/#storm cataska (n=cataska@210.64.6.233) |
| 09:47.55 | *** join/#storm zmijunkie (n=chatzill@i53871DF3.versanet.de) |
| 10:09.30 | *** join/#storm elmom_ (n=elmom@vallila-gw.hupnet.helsinki.fi) |
| 10:58.30 | *** join/#storm andrea-bs (n=andrea@ubuntu/member/beeseek.developer.andrea-bs) |
| 12:32.27 | *** join/#storm niemeyer (n=niemeyer@200-103-139-122.ctame705.dsl.brasiltelecom.net.br) |
| 12:38.31 | *** join/#storm hazmat (n=kapil@plone/hazmat) |
| 13:42.08 | *** join/#storm fcorrea (n=fcorrea@187.3.157.0) |
| 15:14.22 | *** join/#storm gabriel_ (n=gabriel@24.141.18.191) |
| 15:32.33 | *** join/#storm oubiwann (n=oubiwann@c-24-8-208-199.hsd1.co.comcast.net) |
| 16:50.06 | *** join/#storm sidnei_ (n=sidnei@189.30.217.33) |
| 17:05.01 | *** join/#storm jukart (n=jukart@86.32.163.51) |
| 17:48.28 | *** join/#storm sidnei_ (n=sidnei@189.30.217.33) |
| 17:59.53 | *** join/#storm sidnei (n=sidnei@189.30.217.33) |
| 18:42.44 | *** join/#storm elmom (n=elmom@hoasnet-ff05dd00-13.dhcp.inet.fi) |
| 18:42.44 | *** join/#storm jpds (n=jpds@ubuntu/member/jpds) [NETSPLIT VICTIM] |
| 18:42.44 | *** join/#storm thumper (n=quassel@canonical/launchpad/thumper) |
| 18:42.44 | *** join/#storm mzz (n=mzz@flits102-164.flits.rug.nl) [NETSPLIT VICTIM] |
| 19:26.39 | *** join/#storm elmom_ (n=elmom@hoasnet-ff05dd00-13.dhcp.inet.fi) |
| 20:29.17 | *** join/#storm seiflotfy1 (n=seif@82.124.86.254) |
| 20:51.08 | *** join/#storm srichter (n=quassel@c-76-19-135-180.hsd1.ma.comcast.net) |
| 20:55.55 | *** join/#storm srichter (n=quassel@c-76-19-135-180.hsd1.ma.comcast.net) |
| 22:39.16 | *** join/#storm uuid (n=uuid@f053120189.adsl.alicedsl.de) |
| 23:21.25 | *** join/#storm wgrant_ (n=wgrant@ubuntu/member/wgrant) |