Hi,

Sometimes there is need to know is actor male or a female.

And only way to detect is by looking at cast_info role_id which is very un-handful. I added column sex for name table, however following SQL update runs for a very long time while at import level it would cost almost anything.

update name set sex=2 where id in
    (select person_id from cast_info where role_id=2 group by 1 order by 1)

-- role_id=2 (actress) role_id=1 (actor)

So i was wondering would it be hard to add gender based on cast_info role_id already at import level in imdbpy2sql script?

I think it could be useful also for others.
What do you think?

Thanks.

darklow.
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here 
http://p.sf.net/sfu/sfd2d-msazure
_______________________________________________
Imdbpy-devel mailing list
Imdbpy-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/imdbpy-devel

Reply via email to