Changeset 23952

Timestamp:

Apr 22, 2009, 2:16:55 PM (17 years ago)

Author:

jhoblitt

Message:

counter update

File:

• trunk/Nebulous-Server/scripts/dirize.pl (modified) (2 diffs)

trunk/Nebulous-Server/scripts/dirize.pl

@@ -23 +23 @@
 my $db = $neb->_db_for_index(0);
 
-my $query = $db->prepare_cached("SELECT * FROM storage_object AS so WHERE so.dir_id = 0 LIMIT 1000");
+my $n;
+{
+    my $query = $db->prepare("SELECT COUNT(*) as n FROM storage_object");
+    $query->execute;
+    $n = $query->fetchrow_hashref->{'n'};
+}
+
+my $query = $db->prepare_cached("SELECT so_id, ext_id, dir_id FROM storage_object AS so WHERE so.dir_id = 0 LIMIT 1000");
 
 my $i = 0;
@@ -34 +41 @@
 
 #printf("dirizing %20s basename: %20s parent_id %10d\n", $key, basename($row->{'ext_id'}), $parent_id);
-        printf("$i dirizing %s\n", $key->path);
+        printf("$i/$n dirizing %s\n", $key->path);
 
         my $q = $db->prepare_cached("UPDATE storage_object SET ext_id_basename = ?, dir_id = ? WHERE so_id = ?");