sqlobject-discuss

[SQLObject] Use a column other than the primary key for a foreignkey...

[Sam's L. <sam...@gm...>]

I'd like to have a foreign key use a unique column in another table which is
not the primary key.  This works fine in Postgres, but I can't figure out
how to do it in SQLObject.  Any idea?

Thanks
Sam

Re: [SQLObject] Use a column other than the primary key for a foreignkey...

[Oleg B. <ph...@ph...>]

On Thu, Feb 10, 2011 at 10:24:43PM -0800, Sam's Lists wrote:
> I'd like to have a foreign key use a unique column in another table which is
> not the primary key.  This works fine in Postgres, but I can't figure out
> how to do it in SQLObject.  Any idea?

   SQLObject can only references an 'id' column. That's, probably, a
deficiency.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Use a column other than the primary key for a foreignkey...

[Sam's L. <sam...@gm...>]

I see.

Are there any plans to change that?

I assume it's a pretty complicated change, right?

-Sam

On Fri, Feb 11, 2011 at 1:05 AM, Oleg Broytman <ph...@ph...> wrote:

> On Thu, Feb 10, 2011 at 10:24:43PM -0800, Sam's Lists wrote:
> > I'd like to have a foreign key use a unique column in another table which
> is
> > not the primary key.  This works fine in Postgres, but I can't figure out
> > how to do it in SQLObject.  Any idea?
>
>    SQLObject can only references an 'id' column. That's, probably, a
> deficiency.
>
> Oleg.
> --
>     Oleg Broytman            http://phdru.name/            ph...@ph...
>           Programmers don't die, they just GOSUB without RETURN.
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>

Re: [SQLObject] Use a column other than the primary key for a foreignkey...

[Oleg B. <ph...@ph...>]

On Wed, Feb 16, 2011 at 02:10:41AM -0800, Sam's Lists wrote:
> Are there any plans to change that?

   There is no just because this is the first time the question is
raised. I've added it to the TODO list:
http://sourceforge.net/mailarchive/forum.php?thread_name=E1PnpY6-00009p-IX%40webwareforpython.org&forum_name=sqlobject-cvs

> I assume it's a pretty complicated change, right?

   At the first glance it seems one needs to change SOForeignKey (and
perhaps SOCol), sqlmeta.add/delColumn(); SQLObject._SO_foreignKey() must
take into account the id could be any column, not only an id; the
current code could be preserved as a shortcut in case otherColumn is id.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

Re: [SQLObject] Use a column other than the primary key for a foreignkey...

[Sam's L. <sam...@gm...>]

Cool. Well if it gets done I'll definitely use it. :)

I'll try and take a look myself at the parts you mentioned when I have some
free time in the next few weeks.

Thanks
Sam

On Wed, Feb 16, 2011 at 2:38 AM, Oleg Broytman <ph...@ph...> wrote:

> On Wed, Feb 16, 2011 at 02:10:41AM -0800, Sam's Lists wrote:
> > Are there any plans to change that?
>
>    There is no just because this is the first time the question is
> raised. I've added it to the TODO list:
>
> http://sourceforge.net/mailarchive/forum.php?thread_name=E1PnpY6-00009p-IX%40webwareforpython.org&forum_name=sqlobject-cvs
>
> > I assume it's a pretty complicated change, right?
>
>    At the first glance it seems one needs to change SOForeignKey (and
> perhaps SOCol), sqlmeta.add/delColumn(); SQLObject._SO_foreignKey() must
> take into account the id could be any column, not only an id; the
> current code could be preserved as a shortcut in case otherColumn is id.
>
> Oleg.
> --
>     Oleg Broytman            http://phdru.name/            ph...@ph...
>           Programmers don't die, they just GOSUB without RETURN.
>
>
> ------------------------------------------------------------------------------
> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE:
> Pinpoint memory and threading errors before they happen.
> Find and fix more than 250 security defects in the development cycle.
> Locate bottlenecks in serial and parallel code that limit performance.
> http://p.sf.net/sfu/intel-dev2devfeb
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>