Zena zena → public beta

Originally posted on Trac by gaspard Original Trac Ticket

 Description

Make it possible to use DynamicAttributes? when opening contexts in zafu :

...

To do this we would have to make a join with versions and dyn_attributes :

nodes --- versions --- dyn_attributes

Here is an SQL example on how this could work:

SELECT * FROM nodes INNER JOIN versions ON versions.node_id = nodes.id INNER JOIN dyn_attributes AS da1 ON da1.owner_id = versions.id AND da1.owner_table = 'versions' INNER JOIN dyn_attributes AS da2 ON da2.owner_id = versions.id AND da2.owner_table = 'versions' WHERE da1.key = 'assigned' AND da1.value = 'gaspard' AND da2.key = 'priority' AND da2.value = 'major'

Remarks:

we have to make an inner join for each dynamic attribute in the query ==> reason for using content tables: max 2 joins.

Trac Attachments

Trac Comments

2007-08-13 12:51:02 changed by gaspard

status changed from new to assigned.

milestone changed from 1.0 to 0.8.

status changed from new to assigned.

milestone changed from 1.0 to 0.8.

2007-08-14 16:07:22 changed by gaspard

(In [699]) More work on relations. Implemented dynamic attributes query with parameters. Refs #39. Fixes #43 and #44.

2007-08-14 17:25:54 changed by gaspard

(In [701]) More work on relations. Need to write the proxy, link edit stuff and it will be nearly done. Refs #39.

2007-08-17 09:03:41 changed by gaspard

(In [HEAD]) Finished rewriting relations/links. Fixes #1 and #39.

status changed from assigned to closed.

resolution set to fixed.

(In [HEAD]) Finished rewriting relations/links. Fixes #1 and #39.

status changed from assigned to closed.

resolution set to fixed.