..and just to be clear: my modifications basically back out some of the
changes that Andy had made to Genre.pm.
The behavior I'm changing with this code is this:
After a full scan or scan for new, my PostScan plugin fixes up
GENRE.name records with this (and other) modification queries:
Code:
--------------------
UPDATE genres
set name = psreplace(name, 's/^(?i)([[:alpha:]])\1*?[_|\s](.*)$/"$2"/')
WHERE namesort = psmatch(namesort, 'm/^([[:alpha:]])\1* .*$/');
--------------------
(psreplace & psmatch are user-defined SQLite functions that my plugin
makes available via $dbh->sqlite_create_function.)
With Andy's (i.e. the current) code, a subsequent scan for new results
in the creation of a 2nd (3rd, 4th, etc.) "Medieval" etc. genre records
when my PostScan plugin runs.
------------------------------------------------------------------------
gharris999's Profile: http://forums.slimdevices.com/member.php?userid=115
View this thread: http://forums.slimdevices.com/showthread.php?t=102190
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
