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, $not, @joins)=@_;
62 $not=0 unless(defined($not));
67 @outjoins = @joins = ("INNER");
69 my $left=$self->left();
70 my $right=$self->right();
71 return ("", @outjoins) unless($left || $right);
72 my ($leftstr, @leftjoins) = $self->node_to_sql($left, $not, @joins);
73 push(@joins, @leftjoins);
74 push(@outjoins, @leftjoins);
78 if($op->{name} eq "AND")
80 push(@joins, "INNER");
81 push(@outjoins, "INNER");
83 elsif($op->{name} eq "NOT")
87 push(@outjoins, "LEFT");
88 print("LEFT: ", $left->print(), "\n") if ($left);
89 print("RIGHT: ", $right->print(), "\n") if($right);
92 my ($rightstr, @rightjoins) = $self->node_to_sql($right, $not, @joins);
93 push(@outjoins, @rightjoins);
94 # print "LEFT (", scalar(@leftjoins), "): $leftstr\n";
95 # print "RIGHT (", scalar(@rightjoins), "): $rightstr\n";
97 $str .= (" " . $op->{name} . " ") if($op && !$not);
99 if($op || ($left && $right))
101 $str="(" . $str . ")";
103 # print "STR: $str\n";
104 return($str, @outjoins);
109 my($self, $node, $not, @joins)=@_;
110 return ("", ()) unless(defined($node));
111 return $node->to_sql($not, @joins) if(ref($node) eq "ID3FS::Path::Node");
113 my $cnt=scalar(@joins)+1;
114 if(defined($node->{parents_id}))
116 $sql= "(t" . scalar(@joins) . ".parents_id='$node->{parents_id}'";
117 $sql .= " AND fxt" . scalar(@joins) . ".tags_id='" . $node->{id} . "'";
121 $sql= "(t" . scalar(@joins) .".parents_id=''";
122 $sql .= " AND fxt" . scalar(@joins) . ".tags_id='" . $node->{id} . "'";
126 $sql .= " AND fxt" . scalar(@joins) . ".files_id IS NULL";
135 my @used=(grep { defined; } ($self->node_used_tags($self->left()),
136 $self->node_used_tags($self->right())));
143 return (undef) unless(defined($node));
144 return $node->used_tags() if(ref($node) eq "ID3FS::Path::Node");
145 if(defined($node->{parents_id}))
147 return([ $node->{parents_id}, $node->{id} ]);
155 my($self, $a, $b)=@_;
156 return(($a > $b) ? $a : $b);