1 package ID3FS::Path::Node;
9 my $class=ref($proto) || $proto;
22 my($self, $name, $val)=@_;
27 return $self->{$name};
30 sub left { return shift->set("left", shift); }
31 sub right { return shift->set("right", shift); }
32 sub op { return shift->set("op", shift); }
38 my $left=$self->left();
39 my $right=$self->right();
40 return "" unless($left || $right);
41 my $str .= $self->print_node($left);
42 $str .= (" " . $op->{name} . " ") if($op);
43 $str .= $self->print_node($right);
44 if($op || ($left && $right))
46 $str="(" . $str . ")";
54 return "" unless(defined($node));
55 return $node->print() if(ref($node) eq "ID3FS::Path::Node");
61 my($self, $parent, $andlevel)=@_;
62 $andlevel=1 unless(defined($andlevel));
63 my ($leftandlevel, $rightandlevel);
64 my ($leftstr, $rightstr);
66 my $left=$self->left();
67 my $right=$self->right();
68 return ("", $andlevel) unless($left || $right);
69 ($leftstr, $leftandlevel) = $self->node_to_sql($left, $parent, $andlevel);
70 $andlevel=$self->max($andlevel, $leftandlevel);
71 if(defined($op) && (($op->{name} eq "AND") || ($op->{name} eq "NOT")))
75 ($rightstr, $rightandlevel) = $self->node_to_sql($right, $parent, $andlevel);
77 $str .= (" " . $op->{name} . " ") if($op);
79 if($op || ($left && $right))
81 $str="(" . $str . ")";
83 return($str, $self->max($leftandlevel, $rightandlevel));
88 my($self, $node, $parent, $andlevel)=@_;
89 return ("", $andlevel) unless(defined($node));
90 return $node->to_sql($parent, $andlevel) if(ref($node) eq "ID3FS::Path::Node");
92 if(defined($node->{parents_id}))
94 print "HIT PARENTS_ID: $node->{parents_id}\n";
95 $sql= "(t$andlevel.parents_id='$node->{parents_id}'";
96 $sql .= " AND fxt${andlevel}.tags_id='" . $node->{id} . "')";
100 # print "HIT \$parent\n";
101 # $sql= "(t$andlevel.parents_id='$parent')";
105 $sql= "(t$andlevel.parents_id=''";
106 $sql .= " AND fxt${andlevel}.tags_id='" . $node->{id} . "')";
108 return ($sql, $andlevel);
114 my @used=(grep { defined; } ($self->node_used_tags($self->left()),
115 $self->node_used_tags($self->right())));
116 print "used_tags: ", join(", ", @used), "\n";
123 return (undef) unless(defined($node));
124 return $node->used_tags() if(ref($node) eq "ID3FS::Path::Node");
125 if(defined($node->{parents_id}))
127 return([ $node->{parents_id}, $node->{id} ]);
135 my($self, $a, $b)=@_;
136 return(($a > $b) ? $a : $b);