Re: [Dbix-class] Paging all re nested sets

2008-04-11 Thread Matt S Trout
On Thu, Apr 10, 2008 at 07:53:42PM +0200, Sebastian Willert wrote: > > Why locking support? SELECT FOR UPDATE should do the trick shouldn't it? > > In MySQL with InnoDB yes, in MySQL with MyISAM and SQLite no, even > crashing the process. No idea about all the other DBs out there. If > 'SELECT FOR

Re: [Dbix-class] Paging all re nested sets

2008-04-10 Thread Sebastian Willert
On Thu, 2008-04-10 at 18:41 +0100, Matt S Trout wrote: > On Mon, Apr 07, 2008 at 04:12:27PM +0200, Sebastian Willert wrote: > > > > On Sun, 2008-04-06 at 20:41 +0100, Matt S Trout wrote: > > > On Fri, Apr 04, 2008 at 04:56:57PM +0200, Sebastian Willert wrote: > > > > > > > > On Thu, 2008-03-27 at

Re: [Dbix-class] Paging all re nested sets

2008-04-10 Thread Matt S Trout
On Mon, Apr 07, 2008 at 04:12:27PM +0200, Sebastian Willert wrote: > > On Sun, 2008-04-06 at 20:41 +0100, Matt S Trout wrote: > > On Fri, Apr 04, 2008 at 04:56:57PM +0200, Sebastian Willert wrote: > > > > > > On Thu, 2008-03-27 at 21:53 +, Matt S Trout wrote: > > > > A bunch of you have aske

Re: [Dbix-class] Paging all re nested sets

2008-04-07 Thread Sebastian Willert
On Sun, 2008-04-06 at 20:41 +0100, Matt S Trout wrote: > On Fri, Apr 04, 2008 at 04:56:57PM +0200, Sebastian Willert wrote: > > > > On Thu, 2008-03-27 at 21:53 +, Matt S Trout wrote: > > > A bunch of you have asked about nested sets, tried to implement them > > > yourself, been told about th

Re: [Dbix-class] Paging all re nested sets

2008-04-07 Thread Charlie Garrison
Good evening, On 6/4/08 at 8:38 PM +0100, Matt S Trout <[EMAIL PROTECTED]> wrote: Except they're -written-. http://search.cpan.org/src/MRAMBERG/MojoMojo-0.999013/lib/MojoMojo/Schema/Page.pm I had seen that before, but I wasn't confident in taking that code and creating a generic class (eg

Re: [Dbix-class] Paging all re nested sets

2008-04-06 Thread Matt S Trout
On Fri, Apr 04, 2008 at 04:56:57PM +0200, Sebastian Willert wrote: > > On Thu, 2008-03-27 at 21:53 +, Matt S Trout wrote: > > MojoMojo has a complete nested set implementation in the Page DBIC class. > > > > DBIx::Class::Tree provides a suitable tree API. > > > > There is a nested set branc

Re: [Dbix-class] Paging all re nested sets

2008-04-06 Thread Matt S Trout
On Tue, Apr 01, 2008 at 05:56:17AM +1100, Charlie Garrison wrote: > Good morning, > > On 27/3/08 at 9:53 PM -, Matt S Trout > <[EMAIL PROTECTED]> wrote: > > >Anybody willing to doc, tweak, test, or whatever reply here please. > > I'm probably one of the people you are referring to. And I >

Re: [Dbix-class] Paging all re nested sets

2008-04-05 Thread Moritz Onken
Am 05.04.2008 um 18:00 schrieb Sebastian Willert: Unfortunately it's not as easy as this. Off the top of my head: transactional isolation just prevents dirty reads wrt. this problem, i.E. reading an inconsistent state. Understood. But the transaction could include a read which checks whether

Re: [Dbix-class] Paging all re nested sets

2008-04-05 Thread Sebastian Willert
On Sat, 2008-04-05 at 17:06 +0200, Moritz Onken wrote: > Am 04.04.2008 um 16:56 schrieb Sebastian Willert: > > > > Guilty as charged, your honor. I still have an half-backed > > implementation of DBIx::Class::Tree::NestedSet laying around, that > > I've > > almost forgotten about. In my defense,

Re: [Dbix-class] Paging all re nested sets

2008-04-05 Thread Moritz Onken
Am 04.04.2008 um 16:56 schrieb Sebastian Willert: Guilty as charged, your honor. I still have an half-backed implementation of DBIx::Class::Tree::NestedSet laying around, that I've almost forgotten about. In my defense, I'd stopped working on it because I believe we'd need a good RDBMS-ind

Re: [Dbix-class] Paging all re nested sets

2008-04-04 Thread Sebastian Willert
On Thu, 2008-03-27 at 21:53 +, Matt S Trout wrote: > MojoMojo has a complete nested set implementation in the Page DBIC class. > > DBIx::Class::Tree provides a suitable tree API. > > There is a nested set branch of DBIx::Class::Tree which I will happily > give out commits bits to on request

Re: [Dbix-class] Paging all re nested sets

2008-03-31 Thread Charlie Garrison
Good morning, On 27/3/08 at 9:53 PM -, Matt S Trout <[EMAIL PROTECTED]> wrote: Anybody willing to doc, tweak, test, or whatever reply here please. I'm probably one of the people you are referring to. And I haven't forgotten about it, but my time/skill is an issue. I'm currently using

[Dbix-class] Paging all re nested sets

2008-03-27 Thread Matt S Trout
MojoMojo has a complete nested set implementation in the Page DBIC class. DBIx::Class::Tree provides a suitable tree API. There is a nested set branch of DBIx::Class::Tree which I will happily give out commits bits to on request. A bunch of you have asked about nested sets, tried to implement th