| *** dobee has quit IRC | 00:07 | |
| *** Bernulf has quit IRC | 00:11 | |
| *** ktwilight has quit IRC | 00:23 | |
| *** batlogg has quit IRC | 00:26 | |
| *** ktwilight has joined #zope3-dev | 00:26 | |
| *** projekt01 has joined #zope3-dev | 00:34 | |
| *** oferw has joined #zope3-dev | 00:53 | |
| *** SmokeyD is now known as SmokeyD|gone | 01:45 | |
| *** SmokeyD|gone is now known as SmokeyD | 01:59 | |
| *** SmokeyD has quit IRC | 02:05 | |
| *** SmokeyD has joined #zope3-dev | 02:05 | |
| *** yota has quit IRC | 02:28 | |
| *** vlado has joined #zope3-dev | 02:29 | |
| *** pcardune has joined #zope3-dev | 02:43 | |
| *** xenru has quit IRC | 02:49 | |
| *** oferw has left #zope3-dev | 02:55 | |
| *** projekt01 has left #zope3-dev | 03:57 | |
| *** rocky is now known as rocky|Zzz | 03:58 | |
| *** vlado has quit IRC | 04:24 | |
| *** philiKON has quit IRC | 04:50 | |
| *** pcardune has quit IRC | 05:52 | |
| *** roym has quit IRC | 05:54 | |
| *** baijum has joined #zope3-dev | 06:28 | |
| *** nathany has quit IRC | 06:43 | |
| *** baijum has quit IRC | 06:51 | |
| *** baijum has joined #zope3-dev | 07:01 | |
| *** RealityCheck has joined #zope3-dev | 07:18 | |
| *** RealityCheck has quit IRC | 07:19 | |
| *** xenru has joined #zope3-dev | 07:56 | |
| *** xenru has quit IRC | 08:01 | |
| *** baiju1 has joined #zope3-dev | 08:06 | |
| *** baiju1 has left #zope3-dev | 08:07 | |
| *** baiju1 has joined #zope3-dev | 08:08 | |
| *** eins has joined #zope3-dev | 08:12 | |
| eins | hi | 08:12 |
|---|---|---|
| *** baijum has quit IRC | 08:15 | |
| *** baiju1 has quit IRC | 08:19 | |
| *** dobee has joined #zope3-dev | 08:23 | |
| *** replicant has joined #zope3-dev | 08:29 | |
| *** timte has joined #zope3-dev | 08:33 | |
| *** zagy has joined #zope3-dev | 08:40 | |
| *** baijum has joined #zope3-dev | 08:57 | |
| *** jukart has joined #zope3-dev | 09:01 | |
| *** hdima has joined #zope3-dev | 09:03 | |
| *** zagy has joined #zope3-dev | 09:08 | |
| *** dobee has quit IRC | 09:08 | |
| *** zagy has joined #zope3-dev | 09:09 | |
| *** jukart has quit IRC | 09:15 | |
| *** jukart has joined #zope3-dev | 09:17 | |
| *** baijum has quit IRC | 09:20 | |
| *** dobee has joined #zope3-dev | 09:23 | |
| *** philiKON has joined #zope3-dev | 09:27 | |
| *** jukart has quit IRC | 09:35 | |
| *** MJ has quit IRC | 09:37 | |
| *** dobee has quit IRC | 09:38 | |
| *** dobee has joined #zope3-dev | 09:41 | |
| *** Aiste has quit IRC | 09:48 | |
| *** romanofski has joined #zope3-dev | 09:53 | |
| *** philiKON has quit IRC | 10:10 | |
| *** baijum has joined #zope3-dev | 10:11 | |
| *** replicant has quit IRC | 10:20 | |
| *** dobee has quit IRC | 10:20 | |
| *** yota has joined #zope3-dev | 10:28 | |
| *** replicant has joined #zope3-dev | 10:31 | |
| *** baijum has quit IRC | 10:33 | |
| *** flox has joined #zope3-dev | 10:45 | |
| *** scherand has joined #zope3-dev | 11:08 | |
| *** MJ has joined #zope3-dev | 11:09 | |
| *** baijum has joined #zope3-dev | 11:36 | |
| *** stub has joined #zope3-dev | 11:38 | |
| *** niemeyer has joined #zope3-dev | 11:40 | |
| scherand | hello zope3-dev: does anybody know the sqlos package? | 11:53 |
| scherand | i would be glad if someone could give me a hand with configuring it... | 11:56 |
| *** baijum has quit IRC | 11:57 | |
| *** Aiste has joined #zope3-dev | 11:58 | |
| *** dobee has joined #zope3-dev | 12:07 | |
| * eins thinks zalchemy is a bit better choice | 12:09 | |
| scherand | eins: zalchemy better than sqlos, you mean? | 12:19 |
| eins | yup | 12:22 |
| eins | we are going to move from our own O-R mapper to sqlalchemy | 12:24 |
| scherand | is there a short explanation why? ;) | 12:24 |
| *** tonico has joined #zope3-dev | 12:26 | |
| eins | it seems to be much more powerfull, it tries to be true O-R mapper. it also has good documentation with many examples:) | 12:27 |
| scherand | i like the last point! | 12:28 |
| eins | yeah, and there are plenty of use cases in documentation of O-R mapping | 12:29 |
| eins | after easy going through documentation you understand this is what you need;) | 12:29 |
| scherand | thank you, i will have a look at it | 12:32 |
| eins | np | 12:32 |
| *** SteveA has joined #zope3-dev | 12:50 | |
| *** ignas has joined #zope3-dev | 12:58 | |
| *** hazmat has quit IRC | 13:00 | |
| *** tonico has quit IRC | 13:15 | |
| *** jnair has joined #zope3-dev | 13:20 | |
| *** jnair has left #zope3-dev | 13:21 | |
| *** mgedmin has joined #zope3-dev | 13:22 | |
| *** dobee has quit IRC | 13:32 | |
| *** vlado has joined #zope3-dev | 13:34 | |
| *** oferw has joined #zope3-dev | 13:47 | |
| *** volvox has joined #zope3-dev | 13:53 | |
| *** ktwilight has quit IRC | 13:56 | |
| SmokeyD | eins, 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 |
| SmokeyD | I've only heard about the existence of zalchemy yesterday | 14:06 |
| SmokeyD | and I am still deciding if I want to spend the time of going over to zalchemy | 14:06 |
| *** ktwilight has joined #zope3-dev | 14:09 | |
| *** oferw has quit IRC | 14:12 | |
| eins | SmokeyD 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 module | 14:13 |
| SmokeyD | All the sqlalchemy code is located in this module | 14:13 |
| eins | so you didn't write your own container and namechooser and didn't integrate sqlalchemy transactions to zope3 transaction machinery? | 14:15 |
| SmokeyD | nope | 14:15 |
| SmokeyD | I let the database module manage it | 14:16 |
| SmokeyD | 's own sessions | 14:16 |
| eins | wrong approach | 14:16 |
| SmokeyD | why? | 14:16 |
| eins | if you want to have a true O-R mapper you do want it to be as transparent as possible | 14:17 |
| SmokeyD | Well, 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 objects | 14:18 |
| eins | you want to have a look at zalchemy:) you should try it and see the right approach:) | 14:19 |
| SmokeyD | ok, I will. The problem is that my code works now, and I'm not that keen on changing it again :) | 14:20 |
| scherand | eins: is there a zalchemy page (with tutorials)? a am unable to find something "useful". | 14:20 |
| SmokeyD | Thanks for the info | 14:20 |
| eins | you have to sublass NameChooser and Persistent, Contained | 14:21 |
| SmokeyD | scherand, usually the sourcecode/unit tests are quite informative | 14:21 |
| SmokeyD | and also the ++apidoc++ (don't know if it is in there though) | 14:21 |
| eins | scherand afaik - no | 14:21 |
| eins | but there is readme | 14:21 |
| eins | :) | 14:21 |
| eins | scherand I can send you some semi-working demo of zalchemy if you need it | 14:25 |
| scherand | eins: if you don't mind... that would be great. but i will look at the readme and tests (again) anyway. | 14:27 |
| scherand | eins: 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 rocky | 14:29 | |
| eins | http://users.esperonus.com/~baubasmail/zalchemy-demo.tar.gz | 14:30 |
| eins | i'm putting here some files from whole project, so keep in mind it won't work out of the box | 14:31 |
| eins | but it may help you:) | 14:31 |
| *** romanofski has quit IRC | 14:31 | |
| eins | you will probably be interested in mcontainer package | 14:32 |
| *** romanofski has joined #zope3-dev | 14:32 | |
| *** ktwilight has quit IRC | 14:34 | |
| scherand | eins: thank you! | 14:36 |
| eins | np;) | 14:39 |
| *** benji has quit IRC | 14:42 | |
| flox | eins: thanks, i am interesting too | 14:57 |
| *** projekt01 has joined #zope3-dev | 15:00 | |
| SmokeyD | eins, mind If I take a look as well | 15:03 |
| SmokeyD | :) | 15:03 |
| SmokeyD | at your code I mean | 15:03 |
| *** niemeyer has quit IRC | 15:04 | |
| scherand | eins: can i ask you something about your zalchemy-demo-code? | 15:08 |
| scherand | well, more about the concept, actually | 15:08 |
| eins | go ahead;) | 15:14 |
| scherand | do 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 |
| eins | m objects are table rows | 15:17 |
| *** stub has quit IRC | 15:18 | |
| scherand | yes, ok. so the "wiring" between sqlalchemy and zalchemy (= zope) happens in m.py? | 15:18 |
| eins | and yes, mcontainer acts as a container and contains m objects :) | 15:18 |
| eins | scherand the wiring happens in mcontainer (you can see subclassing from SQLAlchemyContainer class) and in configure.zcml | 15:22 |
| *** dobee has joined #zope3-dev | 15:29 | |
| *** jukart has joined #zope3-dev | 15:33 | |
| scherand | so i absolutely need a container that contains my zalchemy (or sqlalchemy) objects? i can not put them "anywhere"? | 15:35 |
| *** nathany has joined #zope3-dev | 15:35 | |
| eins | scherand you absolutely need a container that contains objects that will correspond some table rows | 15:36 |
| eins | and you can put these container anywhere | 15:37 |
| eins | you can easily create container that contains other containers and so on | 15:38 |
| eins | you can do with them everything you usually do with other z3 containers | 15:40 |
| scherand | ok, thanks. i think i have to *really* look at it first :) | 15:51 |
| scherand | oh, 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 IRC | 15:56 | |
| eins | scherand every table in a properly designated RDBMS database must have primary key | 15:58 |
| *** replicant has quit IRC | 15:58 | |
| *** vlado has quit IRC | 15:59 | |
| eins | I don't know if sqlalchemy requires existence of primary keys :) | 15:59 |
| scherand | eins: primary key, yes. but does it have to be a "single field integer"? | 15:59 |
| eins | I haven't tried multi-column primary keys on sqlalchemy yet | 16:00 |
| eins | but I'm almost sure sqlalchemy supports them | 16:01 |
| scherand | ok, thank you! | 16:01 |
| *** gumpa has joined #zope3-dev | 16:08 | |
| *** pcardune has joined #zope3-dev | 16:11 | |
| *** benji has joined #zope3-dev | 16:25 | |
| *** J1m has joined #zope3-dev | 16:28 | |
| *** stub has joined #zope3-dev | 16:39 | |
| *** niemeyer has joined #zope3-dev | 16:42 | |
| *** tonico has joined #zope3-dev | 16:45 | |
| *** eins has quit IRC | 17:15 | |
| *** hdima has quit IRC | 17:39 | |
| *** projekt01 has quit IRC | 17:58 | |
| scherand | can anyone tell me where i can get zalchemy from? i tried svn (svn co http://svn.zope.org/z3c.zalchemy/trunk) but this gives an error (svn: PROPFIND of '/z3c.zalchemy/trunk': 301 Moved (http://svn.zope.org)). then i googled for a .tar or similar, but no luck... | 18:09 |
| *** scherand has left #zope3-dev | 18:24 | |
| *** TresEquis has joined #zope3-dev | 18:49 | |
| SteveA | hi tres | 18:50 |
| TresEquis | Howdy! | 18:56 |
| TresEquis | how're things? | 18:56 |
| SteveA | pretty cool | 18:57 |
| SteveA | what brings you to the zope3 channel? | 18:57 |
| *** agroszer has joined #zope3-dev | 18:57 | |
| *** nathany has quit IRC | 19:00 | |
| TresEquis | I'm on the channel whenever I'm on IRC, which isn't as often as I would like ;) | 19:02 |
| TresEquis | BTW, major kudos for dapper -- I've been extremely pleased with it | 19:03 |
| TresEquis | Just installed it on a pair of laptops for my wife and son :) | 19:03 |
| *** MJ has quit IRC | 19:13 | |
| *** jukart has quit IRC | 19:15 | |
| *** scherand has joined #zope3-dev | 19:15 | |
| *** volvox has quit IRC | 19:17 | |
| *** romanofski has quit IRC | 19:19 | |
| *** alec has joined #zope3-dev | 19:23 | |
| *** alec is now known as alecm | 19:24 | |
| *** Aiste has quit IRC | 19:26 | |
| *** stub has quit IRC | 19:29 | |
| *** ktwilight has joined #zope3-dev | 19:35 | |
| *** projekt01 has joined #zope3-dev | 19:46 | |
| *** ignas has quit IRC | 19:49 | |
| *** Aiste has joined #zope3-dev | 19:52 | |
| *** stub has joined #zope3-dev | 20:00 | |
| *** reco has joined #zope3-dev | 20:06 | |
| *** RaFromBRC has joined #zope3-dev | 20:07 | |
| *** reco has quit IRC | 20:07 | |
| *** reco has joined #zope3-dev | 20:07 | |
| *** reco has joined #zope3-dev | 20:07 | |
| *** efge has joined #zope3-dev | 20:14 | |
| *** flox has quit IRC | 20:18 | |
| *** jukart has joined #zope3-dev | 20:19 | |
| *** efge has quit IRC | 20:20 | |
| *** dunny__ is now known as dunny | 20:43 | |
| *** philiKON has joined #zope3-dev | 20:43 | |
| *** jukart has quit IRC | 20:51 | |
| *** ktwilight has left #zope3-dev | 20:58 | |
| *** ktwilight has joined #zope3-dev | 20:59 | |
| *** dobee has joined #zope3-dev | 21:01 | |
| *** MJ has joined #zope3-dev | 21:04 | |
| SteveA | TresEquis: nice to hear you're having success with dapper. | 21:08 |
| SteveA | I'll pass it along to the distro team | 21:08 |
| *** peter_ has joined #zope3-dev | 21:17 | |
| *** peter_ has left #zope3-dev | 21:17 | |
| *** reco has quit IRC | 21:19 | |
| *** alecm has quit IRC | 21:23 | |
| *** alecm has joined #zope3-dev | 21:24 | |
| *** ktwilight has quit IRC | 21:24 | |
| *** batlogg has joined #zope3-dev | 21:26 | |
| dobee | projekt01: meet us at #lovely | 21:32 |
| *** scherand has left #zope3-dev | 21:37 | |
| *** gump1 has joined #zope3-dev | 21:41 | |
| *** gumpa has quit IRC | 21:41 | |
| *** ktwilight has joined #zope3-dev | 21:43 | |
| *** romanofski has joined #zope3-dev | 21:43 | |
| *** agroszer has quit IRC | 21:45 | |
| *** gump1 has left #zope3-dev | 21:47 | |
| *** mexiKON has joined #zope3-dev | 21:57 | |
| *** jukart has joined #zope3-dev | 22:02 | |
| *** philiKON has quit IRC | 22:07 | |
| *** stub has quit IRC | 22:13 | |
| *** henri_ has joined #zope3-dev | 22:17 | |
| *** mgedmin has quit IRC | 22:20 | |
| *** jukart has quit IRC | 22:21 | |
| *** xenru has joined #zope3-dev | 22:22 | |
| *** mexiKON has quit IRC | 22:31 | |
| *** hazmat has joined #zope3-dev | 22:35 | |
| *** ChanServ sets mode: +o hazmat | 22:35 | |
| *** flox has joined #zope3-dev | 22:37 | |
| *** niemeyer has quit IRC | 22:39 | |
| *** nathany has joined #zope3-dev | 22:50 | |
| *** henri_ has left #zope3-dev | 22:54 | |
| *** benji has quit IRC | 22:57 | |
| *** rocky is now known as rocky|away | 23:05 | |
| *** MJ has quit IRC | 23:20 | |
| *** MJ has joined #zope3-dev | 23:27 | |
| *** niemeyer has joined #zope3-dev | 23:32 | |
| *** stub has joined #zope3-dev | 23:47 | |
| *** xenru has quit IRC | 23:48 | |
Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!