[storm] Invalid enum value on find

[Jamu Kakar]

Hi Oscar,

On Wed, Apr 3, 2013 at 3:17 PM, Oscar Campos
<oscar.campos at open-phoenix.com> wrote:
> El 03/04/13 22:09, Jamu Kakar escribió:
> Your Enum definition looks correct.  What datatype are you using on
> the MySQL type?  Is it possible there's some issue there with the
> loaded value not matching the values in your map?
>
> I'm using Enum -> http://dev.mysql.com/doc/refman/5.1/en/enum.html
>
> The problem is MySQL returns 'VISA' or 'LASER' instead of 1 or 3 and the
> _get_map variable contains a reversed dict as:
>
>     {1: 'VISA', 2: 'MC': 3: 'LASER' .... }
>
> So obviously u'VISA' raises a KeyError exception because Storm is waiting
> for an int 1 as key.

Right, so you need to use an INTEGER column not an ENUM.  That's how
the Enum type is intended to be used.

Thanks,
J.