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, @joins)=@_;
66 @outjoins = @joins = ("INNER");
68 my $left=$self->left();
69 my $right=$self->right();
70 return ("", @outjoins) unless($left || $right);
71 my ($leftstr, @leftjoins) = $self->node_to_sql($left, $parent, @joins);
72 push(@joins, @leftjoins);
73 push(@outjoins, @leftjoins);
77 if($op->{name} eq "AND")
79 push(@joins, "INNER");
80 push(@outjoins, "INNER");
82 elsif($op->{name} eq "NOT")
85 push(@outjoins, "LEFT");
88 my ($rightstr, @rightjoins) = $self->node_to_sql($right, $parent, @joins);
89 push(@outjoins, @rightjoins);
90 # print "LEFT (", scalar(@leftjoins), "): $leftstr\n";
91 # print "RIGHT (", scalar(@rightjoins), "): $rightstr\n";
93 $str .= (" " . $op->{name} . " ") if($op);
95 if($op || ($left && $right))
97 $str="(" . $str . ")";
99 # print "STR: $str\n";
100 return($str, @outjoins);
105 my($self, $node, $parent, @joins)=@_;
106 return ("", ()) unless(defined($node));
107 return $node->to_sql($parent, @joins) if(ref($node) eq "ID3FS::Path::Node");
109 my $cnt=scalar(@joins)+1;
110 if(defined($node->{parents_id}))
112 $sql= "(t" . scalar(@joins) . ".parents_id='$node->{parents_id}'";
113 $sql .= " AND fxt" . scalar(@joins) . ".tags_id='" . $node->{id} . "')";
117 $sql= "(t" . scalar(@joins) .".parents_id=''";
118 $sql .= " AND fxt" . scalar(@joins) . ".tags_id='" . $node->{id} . "')";
126 my @used=(grep { defined; } ($self->node_used_tags($self->left()),
127 $self->node_used_tags($self->right())));
134 return (undef) unless(defined($node));
135 return $node->used_tags() if(ref($node) eq "ID3FS::Path::Node");
136 if(defined($node->{parents_id}))
138 return([ $node->{parents_id}, $node->{id} ]);
146 my($self, $a, $b)=@_;
147 return(($a > $b) ? $a : $b);