Aaron Mulder on 1 Mar 2006 16:29:56 -0000


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PhillyOnRails] Foreign Key Constraint war stories?


The only problem I really had with foreign keys was that the rake task
to load fixtures didn't load them in the right order.  So I just
created a custom rake task that listed all the fixtures in a sensible
order and called the framework load method(s) on that.  Then each test
needed to list the fixtures in pretty much the same order, but that's
not such a big deal.

Have you guys had more extensive problems with foreign keys?

Thanks,
    Aaron

On 3/1/06, Aaron Blohowiak <aaron@aaronblohowiak.com> wrote:
> Changing your database structure to fit your development framework is
> not usually a good idea. Since your database is responsible for your
> data's integrity, you should put as much validation and safeguards as
> you can into it. Learn to work around (or, hopefully, fix and submit
> your upgrades to) rails' fkc rough spots.
>
> OR
>
> Dude, rails and FKC don't jive. Having them in your database is
> really repeating yourself which you shouldnt want to do -- your tests
> should be validating all of your code anyway. the only time it would
> be super necessary is if you have multiple apps hitting the same db
> and you doubt their ability to respect your data.
>
> OR,
>
> Check out:
>
>   http://www.robbyonrails.com/articles/2005/08/18/active-record-i-3-u-
> but-i-still-trust-my-database-server-a-tiny-bit-more
>
>
> Aaron Blohowiak
>
>
>
> On Feb 28, 2006, at 11:37 PM, Mike Zornek wrote:
>
> > Anyone here have any war stories about using FCK and Rails. I think
> > I'm
> > writing a few of my own tonight and my boss (who really likes FKC) is
> > suggesting we drop them since Rails (via DHH) doesn't support them
> > very
> > well.
> >
> > Support in this context is probably not the right word -- depending
> > on you
> > model relationships it feels more like Rails is punishing you for
> > using FKC.
> >
> > Anyways, I'm curious.
> >
> > ~ Mike
> > --
> > Work: http://ClickableBliss.com
> > Play: http://MikeZornek.com
> >
> >
> > _______________________________________________
> > talk mailing list
> > talk@phillyonrails.org
> > http://lists.phillyonrails.org/mailman/listinfo/talk
> >
>
> _______________________________________________
> talk mailing list
> talk@phillyonrails.org
> http://lists.phillyonrails.org/mailman/listinfo/talk
>
_______________________________________________
talk mailing list
talk@phillyonrails.org
http://lists.phillyonrails.org/mailman/listinfo/talk