Foreign key references key in same table?

[lumsden]

Can a foreign key reference a key in the same table with POG?

destination_id (PK)
destination_parent_id (FK ??? as it must take a value from
destination_id)
destination_name
destination_description

Cheers

Lumsden

[Joel]

Not inherently.

i.e a child class in POG cannot have a parent equal to itself and vice-
versa, although, I know Mark and I were talking about a simple and
elegant workaround he came up with while working on a project... He
may elaborate if he finds a minute or two.

But the short answer, from the generator's point of view, is no.

[lumsden]

I will look forward to when Mark can spend a minute or two.

Cheers

Lumsden

[Joel]

>From Mark's email:

<--snip-->

Hi Joel
yes - it is kind of simple...

objectA
-objectaId
-name
-MyParentObjectAId

when you need all the children:
$children = $objectA->GetList("MyParentObjectAId","=",$this-
>objectaId);

when you need the parent:
$parent = $objectA->-MyParentObjectAId;

that's it.

-Mark

<--snip-->

[lumsden]

Does he mean:
$parent = $objectA->MyParentObjectAId;

instead of:
$parent = $objectA->-MyParentObjectAId;

Unless you reply, I will assume that minus sign before
MyParentObjectAId is just a typo.

Cheers

Lumsden

[lumsden]

Forgot to say thanks very much again.

Cheers

Lumsden

[Crispy]

oh - my bad,
typo - plus logical error. It's always so obvious when you read it
again... ;-)

$parent = $objectA->Get($objectA->MyParentObjectAId);

I missed the getting of the actual object... Sorry about that -
-Mark