export_license_ref.php

Go to the documentation of this file.

#!/usr/bin/php -q

<?php
/***********************************************************
  Copyright (C) 2013 Hewlett-Packard Development Company, L.P.

  This program is free software; you can redistribute it and/or
  modify it under the terms of the GNU General Public License
  version 2 as published by the Free Software Foundation.

  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License along
  with this program; if not, write to the Free Software Foundation, Inc.,
  51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
 ***********************************************************/

$Usage = "Usage: " . basename($argv[0]) . "
  -h     help, this message
  -f     {output file}
  --help help, this message (Note: the user postgres should have write permission on the output file.)
  ";

$Options = getopt("hf:", array("help"));

/* command-line options */
$SchemaFilePath = "";
foreach($Options as $Option => $OptVal)
{
  switch($Option)
  {
    case 'f': /* schema file */
      $SchemaFilePath = $OptVal;
      break;
    case 'h': /* help */
      print $Usage;
      exit (0);
    case 'help': /* help */
      print $Usage;
      exit (0);
    default:
      echo "Invalid Option \"$Option\".\n";
      print $Usage;
      exit (1);
  }
}

# dump license_ref table into a temp file
if (empty($SchemaFilePath)) $SchemaFilePath = "licenseref.sql";
$dump_command = "sudo su postgres -c 'pg_dump -f $SchemaFilePath -a -t license_ref --column-inserts fossology'";
system($dump_command, $return_var);

if(!$return_var) exit (0);
else exit (1);
?>