<?php
   /*
    * pgBackupRestore PHP Class Benchmark Example
    * for php-cli
    *
    * usage:
    * php -q example.php - Perform both backup and restore
    * php -q example.php backup - Perform backup
    * php -q example.php restore - Perform restore
    *
    */

   require("pgBackupRestore.class.php");

   // POSTGRESQL AUTH INFO
   $db_host = "localhost";
   $db_user = "postgres";
   $db_pass = "secret";
   // SOURCE DATABASE (Backup)
   $source_db="my_database";
   // SQL FILE TO BE CREATED
   $sql_file="my_database.sql";
   // DESTINATION DATABASE (Restore)
   $dest_db="testing";

   function timer()
   {
      $time = microtime();
      $time = explode(" ", $time);
      $time = $time[1] + $time[0];
      return($time);
   }

   switch( strtolower($argv[1]) )
   {
      case 'backup':
         $Backup = true;
         $Restore = false;
      break;

      case 'restore':
         $Backup = false;
         $Restore = true;
      break;

      default:
         $Backup = true;
         $Restore = true;
      break;
   }
   printf ("--[ Current Memory Limit: %s\n\n", ini_get('memory_limit'));

   if ($Backup)
   {
      printf ("[+] Backup of database '$source_db' in progress\n");
      $s = timer();
      $pgBackup = new pgBackupRestore($db_host, $db_user, $db_pass, $source_db);
      $pgBackup->UseDropTable = false;
      $pgBackup->Backup($sql_file);
      $e = timer();
      printf("[+] Backup took %d seconds to terminate\n\n", ($e - $s));
   }

   if ($Restore)
   {
      printf ("[+] Restore to database '$dest_db' in progress\n");
      $s = timer();
      $pgRestore = new pgBackupRestore($db_host, $db_user, $db_pass, $dest_db);
      $pgRestore->Restore($sql_file);
      $e = timer();
      printf("[+] Restore took %d seconds to terminate\n\n", ($e - $s));
   }
?>