[mythtv] [mythtv-commits] Ticket #5442: MythWeb "Scan Collection" does not set inetref

Michael T. Dean mtdean at thirdcontact.com
Mon Jun 16 22:42:59 UTC 2008


On 06/16/2008 03:31 PM, MythTV wrote:
> #5442: MythWeb "Scan Collection" does not set inetref
>
>  I noticed that when scanning for new or changed files via the Video Manger
>  new files found are given a default inetref value of '00000000'.  Using
>  the "Scan Collection" feature of MythWeb leaves this and other values in
>  the videometadata table blank.
>
>  Performing a select on this table for an inetref='00000000' should return
>  recently added and any entries without metadata.  However files added via
>  MythWeb will not be returned.  This has the potential to break some custom
>  scripts that may be in use.

If inetref is really supposed to default to '00000000', why isn't it
specified as the column default?  In other words, I think your scripts
may be relying on "undocumented" features.

Why not write your scripts to do something like:

SELECT inetref FROM videometadata
 WHERE inetref REGEXP '^0+$'
    OR inetref NOT REGEXP '^[[:digit:]]{1,8}$';

Mike


More information about the mythtv-dev mailing list