IRC log of #zope3-dev for Monday, 2006-08-07

*** dobee has quit IRC00:07
*** Bernulf has quit IRC00:11
*** ktwilight has quit IRC00:23
*** batlogg has quit IRC00:26
*** ktwilight has joined #zope3-dev00:26
*** projekt01 has joined #zope3-dev00:34
*** oferw has joined #zope3-dev00:53
*** SmokeyD is now known as SmokeyD|gone01:45
*** SmokeyD|gone is now known as SmokeyD01:59
*** SmokeyD has quit IRC02:05
*** SmokeyD has joined #zope3-dev02:05
*** yota has quit IRC02:28
*** vlado has joined #zope3-dev02:29
*** pcardune has joined #zope3-dev02:43
*** xenru has quit IRC02:49
*** oferw has left #zope3-dev02:55
*** projekt01 has left #zope3-dev03:57
*** rocky is now known as rocky|Zzz03:58
*** vlado has quit IRC04:24
*** philiKON has quit IRC04:50
*** pcardune has quit IRC05:52
*** roym has quit IRC05:54
*** baijum has joined #zope3-dev06:28
*** nathany has quit IRC06:43
*** baijum has quit IRC06:51
*** baijum has joined #zope3-dev07:01
*** RealityCheck has joined #zope3-dev07:18
*** RealityCheck has quit IRC07:19
*** xenru has joined #zope3-dev07:56
*** xenru has quit IRC08:01
*** baiju1 has joined #zope3-dev08:06
*** baiju1 has left #zope3-dev08:07
*** baiju1 has joined #zope3-dev08:08
*** eins has joined #zope3-dev08:12
*** baijum has quit IRC08:15
*** baiju1 has quit IRC08:19
*** dobee has joined #zope3-dev08:23
*** replicant has joined #zope3-dev08:29
*** timte has joined #zope3-dev08:33
*** zagy has joined #zope3-dev08:40
*** baijum has joined #zope3-dev08:57
*** jukart has joined #zope3-dev09:01
*** hdima has joined #zope3-dev09:03
*** zagy has joined #zope3-dev09:08
*** dobee has quit IRC09:08
*** zagy has joined #zope3-dev09:09
*** jukart has quit IRC09:15
*** jukart has joined #zope3-dev09:17
*** baijum has quit IRC09:20
*** dobee has joined #zope3-dev09:23
*** philiKON has joined #zope3-dev09:27
*** jukart has quit IRC09:35
*** MJ has quit IRC09:37
*** dobee has quit IRC09:38
*** dobee has joined #zope3-dev09:41
*** Aiste has quit IRC09:48
*** romanofski has joined #zope3-dev09:53
*** philiKON has quit IRC10:10
*** baijum has joined #zope3-dev10:11
*** replicant has quit IRC10:20
*** dobee has quit IRC10:20
*** yota has joined #zope3-dev10:28
*** replicant has joined #zope3-dev10:31
*** baijum has quit IRC10:33
*** flox has joined #zope3-dev10:45
*** scherand has joined #zope3-dev11:08
*** MJ has joined #zope3-dev11:09
*** baijum has joined #zope3-dev11:36
*** stub has joined #zope3-dev11:38
*** niemeyer has joined #zope3-dev11:40
scherandhello zope3-dev: does anybody know the sqlos package?11:53
scherandi would be glad if someone could give me a hand with configuring it...11:56
*** baijum has quit IRC11:57
*** Aiste has joined #zope3-dev11:58
*** dobee has joined #zope3-dev12:07
* eins thinks zalchemy is a bit better choice12:09
scherandeins: zalchemy better than sqlos, you mean?12:19
einswe are going to move from our own O-R mapper to sqlalchemy12:24
scherandis there a short explanation why? ;)12:24
*** tonico has joined #zope3-dev12:26
einsit seems to be much more powerfull, it tries to be true O-R mapper. it also has good documentation with many examples:)12:27
scherandi like the last point!12:28
einsyeah, and there are plenty of use cases in documentation of O-R mapping12:29
einsafter easy going through documentation you understand this is what you need;)12:29
scherandthank you, i will have a look at it12:32
*** SteveA has joined #zope3-dev12:50
*** ignas has joined #zope3-dev12:58
*** hazmat has quit IRC13:00
*** tonico has quit IRC13:15
*** jnair has joined #zope3-dev13:20
*** jnair has left #zope3-dev13:21
*** mgedmin has joined #zope3-dev13:22
*** dobee has quit IRC13:32
*** vlado has joined #zope3-dev13:34
*** oferw has joined #zope3-dev13:47
*** volvox has joined #zope3-dev13:53
*** ktwilight has quit IRC13:56
SmokeyDeins, I'm using sqlalchemy in combination with Zope3 as well. My question is though, what are important reasons to use zalchemy and not native sqlalchemy?14:05
SmokeyDI've only heard about the existence of zalchemy yesterday14:06
SmokeyDand I am still deciding if I want to spend the time of going over to zalchemy14:06
*** ktwilight has joined #zope3-dev14:09
*** oferw has quit IRC14:12
einsSmokeyD if you want to *integrate* sqlalchemy into zope3 you have to write something like zalchemy, which you probably already did;)14:12
SmokeyD:) I've got a separate database module which uses sqlalchemy. It is not located in the ZODB. Other modules just call functions in this module14:13
SmokeyDAll the sqlalchemy code is located in this module14:13
einsso you didn't write your own container and namechooser and didn't integrate sqlalchemy transactions to zope3 transaction machinery?14:15
SmokeyDI let the database module manage it14:16
SmokeyD's own sessions14:16
einswrong approach14:16
einsif you want to have a true O-R mapper you do want it to be as transparent as possible14:17
SmokeyDWell, it actually is. I did in a way define containers and stuff. I've got some Zope objects which have methods to get data. These methods call the methods of the database module. So the zope objects only interface with other zope objects14:18
einsyou want to have a look at zalchemy:) you should try it and see the right approach:)14:19
SmokeyDok, I will. The problem is that my code works now, and I'm not that keen on changing it again :)14:20
scherandeins: is there a zalchemy page (with tutorials)? a am unable to find something "useful".14:20
SmokeyDThanks for the info14:20
einsyou have to sublass NameChooser and Persistent, Contained14:21
SmokeyDscherand, usually the sourcecode/unit tests are quite informative14:21
SmokeyDand also the ++apidoc++ (don't know if it is in there though)14:21
einsscherand afaik - no14:21
einsbut there is readme14:21
einsscherand I can send you some semi-working demo of zalchemy if you need it14:25
scherandeins: if you don't mind... that would be great. but i will look at the readme and tests (again) anyway.14:27
scherandeins: as i am a irc-newbie: how do i give you my email? no-paste? put it in here?14:27
*** rocky|Zzz is now known as rocky14:29
einsi'm putting here some files from whole project, so keep in mind it won't work out of the box14:31
einsbut it may help you:)14:31
*** romanofski has quit IRC14:31
einsyou will probably be interested in mcontainer package14:32
*** romanofski has joined #zope3-dev14:32
*** ktwilight has quit IRC14:34
scherandeins: thank you!14:36
*** benji has quit IRC14:42
floxeins: thanks, i am interesting too14:57
*** projekt01 has joined #zope3-dev15:00
SmokeyDeins, mind If I take a look as well15:03
SmokeyDat your code I mean15:03
*** niemeyer has quit IRC15:04
scherandeins: can i ask you something about your zalchemy-demo-code?15:08
scherandwell, more about the concept, actually15:08
einsgo ahead;)15:14
scheranddo i understand correctly that you have a mcontainer - ehm - object(?) that acts as a container (folder) for m objects? and the m objects themselves are the "sql-objects"...15:15
einsm objects are table rows15:17
*** stub has quit IRC15:18
scherandyes, ok. so the "wiring" between sqlalchemy and zalchemy (= zope) happens in
einsand yes, mcontainer acts as a container and contains m objects :)15:18
einsscherand the wiring happens in mcontainer (you can see subclassing from SQLAlchemyContainer class) and in configure.zcml15:22
*** dobee has joined #zope3-dev15:29
*** jukart has joined #zope3-dev15:33
scherandso i absolutely need a container that contains my zalchemy (or sqlalchemy) objects? i can not put them "anywhere"?15:35
*** nathany has joined #zope3-dev15:35
einsscherand you absolutely need a container that contains objects that will correspond some table rows15:36
einsand you can put these container anywhere15:37
einsyou can easily create container that contains other containers and so on15:38
einsyou can do with them everything you usually do with other z3 containers15:40
scherandok, thanks. i think i have to *really* look at it first :)15:51
scherandoh, but one more question in advance: do i need an integer "id" column in every table in order to use sqlalchemy (i think sqlobject needs this)?15:53
*** reco has quit IRC15:56
einsscherand every table in a properly designated RDBMS database must have primary key15:58
*** replicant has quit IRC15:58
*** vlado has quit IRC15:59
einsI don't know if sqlalchemy requires existence of primary keys :)15:59
scherandeins: primary key, yes. but does it have to be a "single field integer"?15:59
einsI haven't tried multi-column primary keys on sqlalchemy yet16:00
einsbut I'm almost sure sqlalchemy supports them16:01
scherandok, thank you!16:01
*** gumpa has joined #zope3-dev16:08
*** pcardune has joined #zope3-dev16:11
*** benji has joined #zope3-dev16:25
*** J1m has joined #zope3-dev16:28
*** stub has joined #zope3-dev16:39
*** niemeyer has joined #zope3-dev16:42
*** tonico has joined #zope3-dev16:45
*** eins has quit IRC17:15
*** hdima has quit IRC17:39
*** projekt01 has quit IRC17:58
scherandcan anyone tell me where i can get zalchemy from? i tried svn (svn co but this gives an error (svn: PROPFIND of '/z3c.zalchemy/trunk': 301 Moved ( then i googled for a .tar or similar, but no luck...18:09
*** scherand has left #zope3-dev18:24
*** TresEquis has joined #zope3-dev18:49
SteveAhi tres18:50
TresEquishow're things?18:56
SteveApretty cool18:57
SteveAwhat brings you to the zope3 channel?18:57
*** agroszer has joined #zope3-dev18:57
*** nathany has quit IRC19:00
TresEquisI'm on the channel whenever I'm on IRC, which isn't as often as I would like ;)19:02
TresEquisBTW, major kudos for dapper -- I've been extremely pleased with it19:03
TresEquisJust installed it on a pair of laptops for my wife and son :)19:03
*** MJ has quit IRC19:13
*** jukart has quit IRC19:15
*** scherand has joined #zope3-dev19:15
*** volvox has quit IRC19:17
*** romanofski has quit IRC19:19
*** alec has joined #zope3-dev19:23
*** alec is now known as alecm19:24
*** Aiste has quit IRC19:26
*** stub has quit IRC19:29
*** ktwilight has joined #zope3-dev19:35
*** projekt01 has joined #zope3-dev19:46
*** ignas has quit IRC19:49
*** Aiste has joined #zope3-dev19:52
*** stub has joined #zope3-dev20:00
*** reco has joined #zope3-dev20:06
*** RaFromBRC has joined #zope3-dev20:07
*** reco has quit IRC20:07
*** reco has joined #zope3-dev20:07
*** reco has joined #zope3-dev20:07
*** efge has joined #zope3-dev20:14
*** flox has quit IRC20:18
*** jukart has joined #zope3-dev20:19
*** efge has quit IRC20:20
*** dunny__ is now known as dunny20:43
*** philiKON has joined #zope3-dev20:43
*** jukart has quit IRC20:51
*** ktwilight has left #zope3-dev20:58
*** ktwilight has joined #zope3-dev20:59
*** dobee has joined #zope3-dev21:01
*** MJ has joined #zope3-dev21:04
SteveATresEquis: nice to hear you're having success with dapper.21:08
SteveAI'll pass it along to the distro team21:08
*** peter_ has joined #zope3-dev21:17
*** peter_ has left #zope3-dev21:17
*** reco has quit IRC21:19
*** alecm has quit IRC21:23
*** alecm has joined #zope3-dev21:24
*** ktwilight has quit IRC21:24
*** batlogg has joined #zope3-dev21:26
dobeeprojekt01: meet us at #lovely21:32
*** scherand has left #zope3-dev21:37
*** gump1 has joined #zope3-dev21:41
*** gumpa has quit IRC21:41
*** ktwilight has joined #zope3-dev21:43
*** romanofski has joined #zope3-dev21:43
*** agroszer has quit IRC21:45
*** gump1 has left #zope3-dev21:47
*** mexiKON has joined #zope3-dev21:57
*** jukart has joined #zope3-dev22:02
*** philiKON has quit IRC22:07
*** stub has quit IRC22:13
*** henri_ has joined #zope3-dev22:17
*** mgedmin has quit IRC22:20
*** jukart has quit IRC22:21
*** xenru has joined #zope3-dev22:22
*** mexiKON has quit IRC22:31
*** hazmat has joined #zope3-dev22:35
*** ChanServ sets mode: +o hazmat22:35
*** flox has joined #zope3-dev22:37
*** niemeyer has quit IRC22:39
*** nathany has joined #zope3-dev22:50
*** henri_ has left #zope3-dev22:54
*** benji has quit IRC22:57
*** rocky is now known as rocky|away23:05
*** MJ has quit IRC23:20
*** MJ has joined #zope3-dev23:27
*** niemeyer has joined #zope3-dev23:32
*** stub has joined #zope3-dev23:47
*** xenru has quit IRC23:48

Generated by 2.15.1 by Marius Gedminas - find it at!