Re: [fw-db] compound primary key

awesome...so when using MySQL, Zend_Db_Table_Abstract will auto discover the
primary key without declaring the $_primary property in the overriding
class?

Bill Karwin wrote:
>
>
>
> spaceage wrote:
>>
>> Is this approach (compound PK) supported in Zend_Table_Db, and if so, how
>> does one declare the PK in a class def?
>>
>> Also, in general, does using this compound key approach present other
>> issues with using Zend_Db down the road?
>>
>
> Yes, Zend_Db_Table supports compound primary keys (unlike many
> frameworks). If your database reports primary keys clearly, Zend_Db_Table
> should be able to discover it automatically. You can verify that it's
> done the right thing like this:
>
> class Prints extends Zend_Db_Table_Abstract { }
> $table = new Prints($db);
> $info = $table->info();
> print_r($info['primary']);
>
> When you insert a row, just omit the auto_increment field from your row,
> and that field will be populated by the database automatically:
>
> $row = $table->createRow();
> $row->image_id = 1234;
> $row->save();
>
> After you call save() for the new row, the auto-generated id should be
> filled in the appropriate column.
>
> print_r($row->toArray());
> Array
> (
> [image_id] => 1234
> [sequence] => 1
> )
>
> Regards,
> Bill Karwin
>

--
View this message in context: http://www.nabble.com/compound-primary-key-tp19052927p19054497.html
Sent from the Zend DB mailing list archive at Nabble.com.