Changeset 288 for wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Database.pm

Timestamp:

05/17/06 23:03:01 (6 years ago)

Author:

dom

Message:

Use bind variables directly in execute call.

Files:

• wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Database.pm (modified) (3 diffs)

wiki-toolkit/trunk/lib/Wiki/Toolkit/Setup/Database.pm

@@ -191 +191 @@
         foreach my $name (keys %$nodesref) {
                 my %node = %{$nodesref->{$name}};
-                $sth->bind_param(1, $node{'id'});
-                $sth->bind_param(2, $node{'name'});
-                $sth->bind_param(3, $node{'version'});
-                $sth->bind_param(4, $node{'text'});
-                $sth->bind_param(5, $node{'modified'});
-                $sth->bind_param(6, $node{'moderate'});
-                $sth->execute;
+                $sth->execute($node{'id'},
+                      $node{'name'},
+                      $node{'version'},
+                      $node{'text'},
+                      $node{'modified'},
+                      $node{'moderate'});
         }
         print "added ".(scalar keys %$nodesref)." nodes...  ";
@@ -205 +204 @@
         foreach my $key (keys %$contentsref) {
                 my %content = %{$contentsref->{$key}};
-                $sth->bind_param(1, $content{'node_id'});
-                $sth->bind_param(2, $content{'version'});
-                $sth->bind_param(3, $content{'text'});
-                $sth->bind_param(4, $content{'modified'});
-                $sth->bind_param(5, $content{'comment'});
-                $sth->bind_param(6, $content{'moderated'});
-                $sth->execute;
+                $sth->execute($content{'node_id'},
+                      $content{'version'},
+                      $content{'text'},
+                      $content{'modified'},
+                      $content{'comment'},
+                      $content{'moderated'});
         }
 
@@ -218 +216 @@
         foreach my $key (keys %$metadataref) {
                 my %metadata = %{$metadataref->{$key}};
-                $sth->bind_param(1, $metadata{'node_id'});
-                $sth->bind_param(2, $metadata{'version'});
-                $sth->bind_param(3, $metadata{'metadata_type'});
-                $sth->bind_param(4, $metadata{'metadata_value'});
-                $sth->execute;
+                $sth->execute($metadata{'node_id'},
+                      $metadata{'version'},
+                      $metadata{'metadata_type'},
+                      $metadata{'metadata_value'});
         }