X-Git-Url: https://erislabs.net/gitweb/?p=id3fs.git;a=blobdiff_plain;f=lib%2FID3FS%2FDB.pm;fp=lib%2FID3FS%2FDB.pm;h=99728646fcab5283a1ac85eb9fa701ef54408bc9;hp=5821b538cb6e8633c406abe2896b2391ca5f700d;hb=96226f1036a7c15539fe93b355361f878ff5c2dd;hpb=a88e7ff8c0d20c928dbe6ea52c779454779d2366 diff --git a/lib/ID3FS/DB.pm b/lib/ID3FS/DB.pm index 5821b53..9972864 100644 --- a/lib/ID3FS/DB.pm +++ b/lib/ID3FS/DB.pm @@ -71,7 +71,8 @@ sub find_db my $base=undef; for my $dir (@dirs) { - my $path=Cwd::abs_path($dir); +# my $path=Cwd::abs_path($dir); + my $path=$dir; do { $base=$path; @@ -254,6 +255,8 @@ sub add { "artists_id" => $artist_id, "albums_id" => $albums_id, "paths_id" => $path_id }); + + $self->remove_tag_refs($file_id); if(@tags) { for my $tag (@tags) @@ -376,6 +379,14 @@ sub add_relation $self->cmd($sql, map { $fields->{$_}; } sort keys(%$fields)); } +# remove existing files_x_tags relations before reindexing +sub remove_tag_refs +{ + my ($self, $id)=@_; + my $sql="DELETE FROM files_x_tags WHERE files_id=?\n"; + return($self->cmd($sql, $id)); +} + sub files_in { my ($self, $dir)=@_; @@ -398,13 +409,15 @@ sub unindex sub prune_directories { - my($self)=@_; + my($self,@includepaths)=@_; my $sql=("SELECT name, id FROM paths\n"); my $pathsref=$self->cmd_rows($sql); my @ids=(); for my $pathpair (@$pathsref) { my($path, $id)=@$pathpair; + my $relpath = $self->{base} . "/" . $path; + next unless(grep { $relpath =~ /^$_/; } @includepaths); my $fullpath="$self->{absbase}/$path"; unless(-d $fullpath) {