add packagist table for upstream monitoring

1 files changed, 29 insertions, 1 deletions

diff --git a/testdb.php b/testdb.php
index 263a0c9..4ee4879 100644
--- a/testdb.php
+++ b/testdb.php
@@ -105,4 +105,32 @@ echo "PECL owner:";
 print_r($acl->getOwners('php-pecl-%'));
 echo "PEAR channels:";
 print_r($up->getChannels('pear'));
-?>
+
+$pkg = new TablePackagist($db);
+$nb = $pkg->getCount();
+echo "Pkgs number : $nb\n";
+if ($nb) {
+    $i=0;
+    foreach($pkg->request(array('ORDER'=>'rpmname')) as $rec) {
+        printf("%3d  %-30s %s\n", $rec['id'], $rec['pkgname'], $rec['rpmname']);
+        if ($i++ > 10) {
+            echo ("...etc...\n");
+            break;
+        }
+    }
+/*
+} else {
+    $f = '/home/rpmbuild/SPECS/remirepo/tools/checkpkgist/checkpkgist.json';
+    $f = file_get_contents($f);
+    $pkgs = json_decode($f, true, 5, JSON_PARSER_NOTSTRICT);
+    foreach ($pkgs as $p => $q) {
+        $data = array(
+            'pkgname' => $p,
+            'rpmname' => $q,
+        );
+        $pkg->add($data);
+    }
+    $nb = $pkg->getCount();
+    echo "Pkgs number : $nb\n";
+*/
+}