PHP Doctrine: Custom nested set?

Posted by ropstah on Stack Overflow See other posts from Stack Overflow or by ropstah
Published on 2010-04-03T22:12:39Z Indexed on 2010/04/03 22:13 UTC
Read the original article Hit count: 377

Filed under:

php

|

doctrine

|

hierarchical-data

Is it possible to have nested set capabilities in this somewhat custom setup?

Consider these 4 tables:

Object: (oid, name) contains: [1, 'Licence'] and [2, 'Exemption']

Licence: (lid, name)

Exemption: (eid, name)

Cost: (oid, oid_ref, cost_oid, cost_oid_ref)

For:
P = Licence with lid [1]
R = Exemption with eid [2]

i can say "object P is a parent to object R" if the following Cost record exists:

[oid: 2 oid_ref: 2 cost_oid: 1 cost_oid_ref: 1]

I understand that this creates somesort of 'conditional foreign key' relation which I need to define in code. Is it possible to have the nested set loaded with these conditions?

© Stack Overflow or respective owner

Related posts about php

Magento, NGINX, PHP-FPM, APC, MEMCACHED, 16gb Ram CentOS, Spiking PHP-FPM to 100% CPU

as seen on Server Fault - Search for 'Server Fault'
I have been trying to resolve my issue of spiking cpu caused by php-fpm processes. I've reduced the php-fpm config settings to: pm = ondemand pm.max_children = 12 pm.start_servers = 2 pm.min_spare_servers = 2 pm.max_spare_servers = 10 pm.max_requests = 500 php_admin_value[memory_limit] = 128M Problem… >>> More
PHP Pear Installation on CentOS

as seen on Server Fault - Search for 'Server Fault'
[root@ip ~]# yum install php-pear* Reducing CentOS-5 Testing to included packages only Finished Setting up Install Process Package 1:php-pear-1.8.1-2.el5.centos.noarch already installed and latest versio … >>> More
Apache configurations for php "AddType text/html php" or "AddType application/x-httpd-php php .php"

as seen on Server Fault - Search for 'Server Fault'
I am taking over an application server and discover that it contain the following settings: AddType text/html php Although it works, but my understanding is that it should set as following: AddType application/x-httpd-php php .php What are the key differences between the two settings?… >>> More
mod_rewrite settings causes server to throw HTTP 500 errors instead of 404

as seen on Server Fault - Search for 'Server Fault'
Hello. I have a server with VBulletin forum (working under Apache 2.2, CentOS). The default settings for it in .htaccess are as follows: RewriteEngine on RewriteCond %{HTTP_HOST} ^gsmforum\.ru RewriteRule (.*) http://www.gsmforum.ru/$1 [R=301,L] # If you are having problems or are using VirtualDocumentRoot… >>> More
Problems installing Memcache (PECL extension)

as seen on Server Fault - Search for 'Server Fault'
I have installed memcached fine, and now I will need to install PECL extension memcache. Im running RedHat x86_64 es5. The installation gives me this: downloading memcache-2.2.6.tgz ... Starting to download memcache-2.2.6.tgz (35,957 bytes) ..........done: 35,957 bytes 11 source files, building running:… >>> More

Related posts about doctrine

Doctrine::Windows::How generate Doctrine Models on windows?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, How generate Doctrine Models from database on windows? (I working with zend studio and zend framework) >>> More
Dotrine::Zend::How generate new doctrine models without delete doctrine models classes with my code

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I build zend app with doctrine. The problem is when i add new tables to database and I should generate doctrine models, because I add my own code to Doctine generated classes- I dont wont to delete them. I solve this problem like that: 1. copy old generated doctine models classes to other folder 2… >>> More
(Doctrine-Ubuntu) Get error: doctrine-cli.php: command not found

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, (Doctrine-Ubuntu) I run $ doctrine-cli.php command and get doctrine-cli.php: command not found. P >>> More
Doctrine 2 Cannot find entites

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Kohana 3 and have a /doctrine/Entites folder with my entities inside. When executing the code $product = Doctrine::em()->find('Entities\Product', 1); in my controller, I get the error class_parents(): Class Entities\Product does not exist and could not be loaded Below is the Controller… >>> More
php doctrine last identifier issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm running in to the issue below when trying to run the following: $store = new Store(); $store->url =$this->form_validation->set_value('website'); $store->save(); $store_id = $store->identifier(); Fatal error: Uncaught exception 'Doctrine_Connection_Exception' with message 'Couldn't… >>> More