+ if($self->ok($v1genre))
+ {
+ $self->add_tag($file_id, "v1genre", $v1genre);
+ }
+
+ if($haspic)
+ {
+ $self->add_tag($file_id, "haspic", undef);
+ }
+
+ $self->add_relation("files_x_artists",
+ { "files_id" => $file_id,
+ "artists_id" => $artists_id });
+
+ $self->add_relation("artists_x_albums",
+ { "artists_id" => $artists_id,
+ "albums_id" => $albums_id});
+}
+
+sub add_tag
+{
+ my($self, $file_id, $tag, $val)=@_;
+ my $tag_id=$self->add_to_table("tags", $tag);
+ $self->add_relation("files_x_tags",
+ { "files_id" => $file_id,
+ "tags_id" => $tag_id });
+ if(defined($val))
+ {
+ my $val_id=$self->add_to_table("tagvals", $val);
+ $self->add_relation("tags_x_tagvals",
+ { "tags_id" => $tag_id,
+ "tagvals_id" => $val_id });
+ }
+}
+
+sub add_to_table
+{
+ my($self, $table, $name, $extradata)=@_;
+ my $id=$self->lookup_id($table, $name);
+ unless(defined($id))
+ {
+ my $sql="INSERT INTO $table (";
+ my @fields=qw(name);
+ if(defined($extradata))
+ {
+ push(@fields, sort keys(%$extradata));
+ }
+ $sql .= join(", ", @fields);
+ $sql .=") VALUES (";
+ $sql .= join(", ", map { "?"; } @fields);
+ $sql .= ");";
+ $id=$self->cmd_id($sql, $name, map { $extradata->{$_} || ""; } sort keys %$extradata);
+ }
+ return $id;
+}
+
+sub add_relation
+{
+ my ($self, $relname, $fields)=@_;
+ return if($self->relation_exists($relname, $fields));
+ my $sql="INSERT INTO $relname (";
+ $sql .= join(", ", sort keys(%$fields));
+ $sql .= ") VALUES (";
+ $sql .= join(", ", map { "?"; } sort keys(%$fields));
+ $sql .= ");";
+ $self->cmd($sql, map { $fields->{$_}; } sort keys(%$fields));
+}
+
+sub lookup_id
+{
+ my($self, $table, $name)=@_;
+ my($id)=$self->cmd_onerow("SELECT id FROM $table where name=?", $name);
+ return $id;
+}
+
+sub relation_exists
+{
+ my ($self, $relname, $fields)=@_;
+ my $sql="SELECT count(1) FROM $relname WHERE ";
+ my @exprs=();
+ my @vals=();
+ for my $field (keys %$fields)
+ {
+ push(@exprs,$field);
+ push(@vals,$fields->{$field});
+ }
+ $sql .= join(' AND ', map { "$_=?"; } @exprs);
+ my ($ret)=$self->cmd_onerow($sql, @vals);
+ return $ret;
+}
+
+sub ok
+{
+ my($self, $thing)=@_;
+ return(defined($thing) && length($thing));