Rails - Dec 2012 - Writing test cases for mysql errors

Hi,

I just encountered a MySql error for ambiguous columns. I fixed it but I 
need to write test cases for such happenings to avoid any such instance in 
future.

Regards,
Sumit 

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/Yp8uLrk5M_MJ.
For more options, visit https://groups.google.com/groups/opt_out.

On 7 December 2012 06:02, Sumit Srivastava
<sumit.theinvincible-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:
> Hi,
>
> I just encountered a MySql error for ambiguous columns. I fixed it but I
> need to write test cases for such happenings to avoid any such instance in
> future.
You question is, ironically, ambiguous.  Can you give us a specific
example of the problem you want to test for.

Colin

-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.

On 7 December 2012 14:59, Colin Law
<clanlaw-gM/Ye1E23mwN+BqQ9rBEUg@public.gmane.org> wrote:
> On 7 December 2012 06:02, Sumit Srivastava
> <sumit.theinvincible-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote:
> > Hi,
> >
> > I just encountered a MySql error for ambiguous columns. I fixed it but
I
> > need to write test cases for such happenings to avoid any such
instance
> in
> > future.
>
> You question is, ironically, ambiguous.  Can you give us a specific
> example of the problem you want to test for.
>
I joined two tables. I missed to specify the table name for some columns in
the controller. I am using Jquery dataTables. This error arises only when
one searches for something on this table and then tries to sort it using
some specific column. So, if this column doesn''t have table name
specified
with it in the controller, it throws error.

Seems improbable to write a universal test case for this. Its more like a
syntactical error.

> Colin
>
> --
> You received this message because you are subscribed to the Google Groups
> "Ruby on Rails: Talk" group.
> To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> To unsubscribe from this group, send email to
>
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
-- 
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit https://groups.google.com/groups/opt_out.