IRC log of #zope for Friday, 2011-04-29

« Thursday, 2011-04-28 Index Saturday, 2011-04-30 »
*** davisagli is now known as davisagli|mtg00:00
*** J1m has quit IRC00:00
*** robohak has quit IRC00:14
*** Spanktar has joined #zope00:48
*** tam7t has joined #zope01:12
*** pjfd2 has quit IRC01:12
*** Arfrever has quit IRC01:22
*** ccomb has quit IRC01:41
*** tam7t has left #zope01:45
*** mr_jolly has left #zope01:47
*** fredvd|away is now known as fredvd01:50
*** davisagli|mtg is now known as davisagli02:07
*** robohak has joined #zope02:08
*** mr_jolly has joined #zope02:14
*** pjfd2 has joined #zope02:15
*** fredvd is now known as fredvd|sleep02:27
*** mr_jolly has left #zope02:36
*** daMaestro has quit IRC02:58
*** robohak has quit IRC03:04
*** runyaga has joined #zope03:23
*** runyaga is now known as run|away03:32
*** Spanktar has quit IRC03:42
*** tiwula has quit IRC04:11
*** menesis has quit IRC04:21
*** run|away has quit IRC04:26
*** davisagli has quit IRC05:25
*** davisagli has joined #zope05:26
*** sm has quit IRC06:33
*** pjfd2 has quit IRC07:05
*** webmaven has quit IRC07:08
*** huajie has joined #zope07:25
*** huajie has quit IRC07:29
*** tiwula has joined #zope07:29
*** tiwula has quit IRC07:50
*** kleist has joined #zope08:15
*** wosc has joined #zope09:09
*** alexpilz has joined #zope09:12
*** __mac__ has joined #zope09:12
*** altipard has joined #zope09:14
*** stoffus has joined #zope09:17
*** goschtl has joined #zope09:25
*** zagy has joined #zope09:34
*** zagy has quit IRC09:34
*** agroszer has joined #zope09:37
*** zagy has joined #zope09:38
*** kleist_ has joined #zope09:38
*** mr_jolly has joined #zope09:41
*** goschtl has quit IRC09:46
*** avoinea has joined #zope09:56
*** mcdonc has joined #zope10:01
*** planetzopebot has quit IRC10:08
*** hever has joined #zope10:08
*** planetzopebot has joined #zope10:09
*** mr_jolly has left #zope10:20
CIA-83jinty * r121474 zope.interface/src/zope/interface/ (common/interfaces.py tests/test_advice.py): Fixes for small issues when running tests under Python 3.2 using zope.testrunner10:25
*** menesis has joined #zope10:28
*** kleist_ has joined #zope10:33
*** goschtl has joined #zope10:38
*** Wu has joined #zope10:50
*** rogererens has joined #zope10:58
*** sylvain has joined #zope11:05
*** rogererens has quit IRC11:05
*** espent has left #zope11:16
*** espent has joined #zope11:16
*** vortec has joined #zope11:18
*** fredvd|sleep is now known as fredvd11:22
*** ccomb has joined #zope11:26
*** hever_ has joined #zope11:37
*** hever has quit IRC11:38
*** menesis has quit IRC11:43
*** evilbungle has joined #zope11:45
*** fredvd is now known as fredvd|awawy12:03
*** fredvd|awawy is now known as fredvd|away12:03
*** evilbungle has quit IRC12:11
*** evilbungle has joined #zope12:12
*** mr_jolly has joined #zope12:36
*** cpf_ has quit IRC12:39
*** avoinea has left #zope12:44
*** avoinea has joined #zope12:52
*** cpf_ has joined #zope12:54
*** menesis has joined #zope13:12
*** vortec has quit IRC13:14
*** menesis has quit IRC13:14
*** menesis1 has joined #zope13:14
*** cpf_ has quit IRC13:19
*** cpf_ has joined #zope13:33
*** avoinea has quit IRC13:36
*** avoinea has joined #zope13:37
*** hever_ has quit IRC13:44
espentbetabug: there?13:55
betabugyes13:55
* kosh quickly sets betabug on fire and hands out marshmallows13:57
* betabug snaps up all the marshmallows13:57
woscdamn13:57
* wosc wanted some, too13:57
espentmy kids got some coloured marshmallows for easter. Purple and green ones. Not the same as the original...14:06
betabugmore chemical fun :-)14:13
*** ccomb has quit IRC14:16
*** dayne has joined #zope14:22
*** sunew has joined #zope14:23
*** vortec has joined #zope14:24
*** fredvd|away is now known as fredvd14:27
*** eperez has joined #zope14:53
*** huajie has joined #zope15:07
*** hariom has joined #zope15:20
hariomI am trying to write a zsql script which can update multiple rows in a single query. Does anybody knows how to do that?15:21
betabughariom: maybe this helps? http://www.upfrontsystems.co.za/courses/zope/ch05.html15:23
hariombetabug: How does this article help? I have zope and postgres connected and I can write simple update query but I want to know how to write for multi row update in a single update query15:29
*** ccomb has joined #zope15:35
*** Wu has quit IRC15:37
*** giampaolo has joined #zope15:37
hariomHow to write UPDATE tables SET status = ? WHERE ids IN (1, 2, 4) in zsql?15:42
hariomHow to write UPDATE tables SET status = FALSE WHERE ids IN (1, 2, 4) in zsql?15:43
*** kleist_ has quit IRC15:45
*** agroszer has quit IRC15:52
*** agroszer has joined #zope15:54
*** altipard has quit IRC15:55
hariomHow to use 'in' operator in zsql as used in sql query:  UPDATE tablename SET status = FALSE WHERE ids IN (1, 2, 4)15:58
*** fredvd is now known as fredvd|away16:01
hariom<dtml-comment>connection_id:Psycopg2_database_connection arguments:venue_id active id max_cache:100 max_rows:-1 </dtml-comment>  update table_names set active = <dtml-sqlvar active type="nb">, where id in <dtml-sqlvar ids type="nb"> and venue_id = <dtml-sqlvar venue_id type="nb">16:06
hariom<dtml-comment>connection_id:Psycopg2_database_connection arguments:venue_id active id max_cache:100 max_rows:-1 </dtml-comment>  update table_names set active = <dtml-sqlvar active type="nb"> where id in <dtml-sqlvar id type="nb"> and venue_id = <dtml-sqlvar venue_id type="nb">16:08
*** wosc has quit IRC16:08
hariomWhere is error in this zsql script?16:09
bigkevmcdhariom: you're not getting any error messages?16:10
hariombigkevmcd: This query gets converted to: update game.table_types16:13
hariomset active = 'FALSE'16:13
hariomwhere id in '(1,2,3)'16:13
hariomand venue_id = '4'16:13
hariomI don't know how to remove comma around ( and ). i.e. (1,2,3) instead of '(1,2,3)'16:13
bigkevmcdhariom: you're using "nb" for the id16:14
bigkevmcdhariom: which is stringifying "id"16:14
hariomok16:15
bigkevmcdhariom: id seems to be a tuple of values16:15
hariomyea16:15
harioma list of values16:15
bigkevmcdstr((1, 2, 3)) = '(1, 2, 3)'16:15
bigkevmcdso, it's not clear what you actually expected to happen16:15
hariomActually I want a the final query to be of form: update game.table_types set active = 'FALSE' where id in (1,2,3) and venue_id = '4'16:16
hariomid values are integers16:17
bigkevmcdso, why stringify the tuple?16:17
hariombigkevmcd: I am not very good at zsql. What should I use in place of 'nb'?16:18
bigkevmcdhariom: I wouldn't use ZSQL16:18
hariombigkevmcd: I am working with legacy system using zope16:19
bigkevmcdyou could try "int" rather than "nb"16:19
bigkevmcdbut, am not sure if that would work16:19
hariomwhen I try int, it says invalid integer value for id16:20
bigkevmcdI haven't touched ZSQL methods for about 10 years16:21
hariombigkevmcd: How do you use database handling with zope then?16:21
bigkevmcdPython and connect to the database directly, or nowadays, we use Storm16:21
bigkevmcdyou could generate the list as a string16:22
bigkevmcdand pass it to the ZSQL method that way16:22
bigkevmcdhariom: http://www.gossamer-threads.com/lists/zope/users/21813216:23
*** eperez has quit IRC16:25
*** dayne has quit IRC16:28
*** J1m has joined #zope16:34
*** ccomb has quit IRC16:37
*** davisagli has quit IRC16:38
*** goschtl has quit IRC16:39
*** davisagli has joined #zope16:39
hariombigkevmcd: Doesn't seem to work. http://pastebin.com/3sZC7BxF16:44
bigkevmcdhariom: where are you generating the list as a string?16:45
bigkevmcdhariom: can you pastebin that bit?16:45
hariomI am not generating lists as string. I found the syntax too confusing16:45
*** ccomb has joined #zope16:48
*** rbanffy has joined #zope16:53
*** Wu has joined #zope16:54
*** astoon has joined #zope16:56
*** rbanffy has quit IRC16:58
*** pjfd2 has joined #zope17:10
*** sunew has quit IRC17:15
*** kleist_ has joined #zope17:20
*** menesis1 has quit IRC17:23
*** huajie has quit IRC17:28
*** davisagli has quit IRC17:33
*** davisagli has joined #zope17:34
*** hariom has quit IRC17:36
*** Arfrever has joined #zope17:38
*** kleist has quit IRC17:53
*** kleist has joined #zope17:53
*** redir has quit IRC17:53
*** kleist_ has quit IRC17:54
*** kleist_ has joined #zope17:54
*** kleist has quit IRC17:55
*** kleist has joined #zope17:55
*** stoffus has quit IRC17:58
*** digitalmortician has quit IRC18:00
*** tiwula has joined #zope18:01
*** agroszer has quit IRC18:05
*** alvaro_o has joined #zope18:05
*** hever_ has joined #zope18:07
*** alvaro_o has quit IRC18:08
*** zagy has quit IRC18:13
*** mr_jolly has left #zope18:23
*** sm has joined #zope18:28
CIA-83ldr * r121475 plone.z3cform/ (3 files in 2 dirs):18:31
CIA-83* Ignore form.widgets. if ++widget++ path begins with it.18:31
CIA-83[lentinj]18:31
CIA-83* Rework traverser to handle lists and subforms18:31
CIA-83[lentinj]18:31
*** __mac__ has quit IRC18:32
*** sm_ has joined #zope18:33
*** sm has quit IRC18:34
*** sm_ is now known as sm18:34
*** ccomb has quit IRC18:40
*** menesis has joined #zope19:02
*** redir has joined #zope19:09
planetzopebotBDA goes GSOC 2011 (BlueDynamics Alliance - Zope Related)  http://bluedynamics.com/articles/jens/bda-goes-gsoc19:09
*** sylvain has quit IRC19:12
*** bigkevmcd has quit IRC19:19
*** zagy has joined #zope19:44
*** TresEquis has joined #zope19:45
*** sylyc0n has quit IRC19:48
*** mcdonc has quit IRC19:49
*** hever_ has quit IRC20:02
*** menesis has quit IRC20:02
*** kleist_ has quit IRC20:02
*** kleist_ has joined #zope20:06
*** vortec has left #zope20:08
*** kleist has quit IRC20:09
*** avoinea has left #zope21:00
*** Wu has quit IRC21:24
*** menesis has joined #zope21:27
*** fredvd|away has quit IRC21:29
*** goschtl has joined #zope21:33
*** zagy has quit IRC21:37
*** mcdonc has joined #zope21:41
*** mcdonc has quit IRC21:42
*** zagy has joined #zope21:51
*** zagy has quit IRC21:52
*** giampaolo has quit IRC22:07
*** kleist_ has quit IRC22:30
*** Spanktar has joined #zope22:34
*** zagy has joined #zope22:36
*** zagy has quit IRC22:38
*** zagy has joined #zope22:38
*** zagy has quit IRC22:42
*** m8 has joined #zope22:43
*** goschtl has quit IRC22:56
*** m8 has quit IRC23:02
*** jshell has quit IRC23:43
*** TresEquis has quit IRC23:56
« Thursday, 2011-04-28 Index Saturday, 2011-04-30 »

Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!