[Catalyst] Using Catalyst on MS SQL DB that has tables with no
primary keys
Derek W
derekwrobel at gmail.com
Fri Sep 14 19:53:27 GMT 2012
Ah, you meant just on Catalyst side, to tell it that the id column is
the primary. I didn't think of that. Thanks! I'll give that a shot.
On Fri, Sep 14, 2012 at 11:40 AM, Robert Wohlfarth
<rbwohlfarth at gmail.com> wrote:
> On Fri, Sep 14, 2012 at 1:31 PM, Derek W <derekwrobel at gmail.com> wrote:
>>
>> Thanks, I figured that would probably fix it, but the problem is I am
>> not allowed to make any changes to the DB structure itself. I suppose
>> I need to convince them why it's in the best interest to have a
>> primary key...
>>
>
> You can set the primary key in the schema file. For example, add a line like
> __PACKAGE__->set_primary_key( "id" ); to lib/MyApp/Schema/Result/MyTable.pm.
> You do not need to change the database. DBIx::Class will then use id
> whenever it wants a primary key.
>
> --
> Robert Wohlfarth
>
>
> _______________________________________________
> List: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
>
--
Derek Wrobel
425-243-3355
More information about the Catalyst
mailing list