Nested Set - for CMS with two versions (edit / publish) mode

Posted by Rick on Stack Overflow See other posts from Stack Overflow or by Rick
Published on 2010-04-02T13:18:04Z Indexed on 2010/04/02 13:23 UTC
Read the original article Hit count: 248

Filed under:

nested

|

set

|

doctrine

|

publish

Hi!

I'm looking for a solution (PHP/Symfony/Doctrine) for the following problem.

I'm creating a table called 'pages'. This table is a nested set. I also want to create a table called 'pages_published' which has ofcourse also a nested set.

Once i create a record in table 'pages' at some point i want to publish this to the 'pages_published)-table. How do make sure the sort order and the level in the structure keeps ok.

Is there some standard solution for my approach?

© Stack Overflow or respective owner

Related posts about nested

Nested class or not nested class?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have class A and list of A objects. A has a function f that should be executed every X seconds (for the first instance every 1 second, for the seconds instance every 5 seconds, etc.). I have a scheduler class that is responsible to execute the functions at the correct time. What i thought to do… >>> More
Nested class - calling the nested class from the parent class

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class whereby a method calls a nested class. I want to access the parent class properties from within the nested class. public class ParentClass { private x; private y; private z; something.something = new ChildClass public class ChildClass { need to get x, y and z; } } How do I… >>> More
How Do I Prevent Rails From Treating Updated Nested Attributes Differently From New Nested Attribute

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using rails3 beta3 and couchdb via couchrest. I am not using active record. I want to add multiple "Sections" to a "Guide" and add and remove sections dynamically via a little javascript. I have looked at all the screencasts by Ryan Bates and they have helped immensely. The only difference… >>> More
Created nested model setting a property on nested model before save

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two models a Company and a User the Company has_many :users and the User belongs_to :company. I have a form such as: <%= form_for @company, data: {toggle: :validator}, novalidate: "novalidate", html: {role: :form} do |f| %> company fields Then in there I have <%= f.fields_for… >>> More
Sorting deeply nested attributes in Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to be able to drag and drag App model which is nested under Category model. http://railscasts.com/episodes/196-nested-model-form-part-1 's the Railscast I've tried to follow. Category controller def move params[:apps].each_with_index do |id, index| Category.last.apps.update(['position=… >>> More

Related posts about set

Allowing connections initiated from outside

as seen on Server Fault - Search for 'Server Fault'
I've got an old Juniper SSG5 running ScreenOS 5.4.0r6.0. Once a day, more or less, it'll start randomly dropping packets at a rate of ~5-10%. We currently solve this issue by simply rebooting the unit, after which it resumes working in perfect condition. As this error has started appearing randomly… >>> More
Outbound traffic being blocked for MIP/VIPped servers (Juniper SSG5)

as seen on Server Fault - Search for 'Server Fault'
As we've been having some problems with sporadic packet loss, I've been preparing a replacement router (also an SSG5) for our current Juniper SSG5. I've setup the new SSG5 identically to the old one. We have a /29 IP range with a single IP setup as a MIP map to a server and two others being used… >>> More
dbus dependency with yum

as seen on Server Fault - Search for 'Server Fault'
Whenever, I try and run yum update I get the following error: [root@server ~]# yum update Loaded plugins: dellsysid, fastestmirror Loading mirror speeds from cached hostfile * base: mirror01.idc.hinet.net * extras: mirror01.idc.hinet.net * rpmforge: fr2.rpmfind.net * updates: mirror01.idc.hinet… >>> More
Juniper SSG-5 subinterface vlan routing to the internet

as seen on Server Fault - Search for 'Server Fault'
I'm unable to get a brand new Juniper SSG-5 with latest 6.3.0r05 firmware routing to the internet from a subinterface I created on bgroup0 setup as vlan2 (bgroup0.1 on "wifi" zone). When connected on the default vlan it gets on the internet just fine. When I switch to vlan2 I'm unable to get to the… >>> More
append set to another set

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Is there a better way of appending a set to another set than iterating through each element ? i have : set<string> foo ; set<string> bar ; ..... for (set<string>::const_iterator p = foo.begin( );p != foo.end( ); ++p) bar.insert(*p); Is there a more efficient way to… >>> More