class Pman_Admin_Dump extends Pman {
+ static $cli_desc = "Dump database ?/ needs more info...";
+
+
function getAuth()
{
var $deps = array(); // list of dependants
var $out = array(); // list of created sql/shell scripts.
- function get($path )
+ function get($path, $opts = Array() )
{
+ ini_set('memory_limit', '256M'); // we need alot of memory
+ set_time_limit(0);
+
$argv = $_SERVER['argv'];
array_shift($argv);
array_shift($argv);
- $opts = explode(',', 'table==,where==,dump-dir==');
+ $opts = explode(',', 'table==,where==,dump-dir==,debug=');
require_once 'Console/Getopt.php';
$go = Console_Getopt::getopt2($argv, '', $opts );
if (is_object($go)) {
}
$errs = array();
foreach($opts as $req) {
+ if (substr($req,-2, 2) != '==') { // skip optional arguments
+ continue;
+ }
if (empty($args[substr($req,0, -2)])) {
$errs[] = "--".substr($req,0, -2) . ' is required';
}
if (!empty($errs)) {
die(print_R($errs,true));
}
-
+ if (!empty($args['debug'])) {
+ DB_DataObject::debugLevel($args['debug']);
+ }
$this->args = $args;
$this->out = array();
$this->discoverChildren($this->args['table'], $this->args['where'], true);
if (empty($ar)) { continue; }
echo " " .$tbl . ' -> ' . count(array_keys($ar)) . " Records\n";
}
+ echo "FILES:\n";
+ echo " Total : " . $this->filetotal . " files using " . floor($this->filesize/1000000) . "Mb\n";
+
echo "GENERATED FILES:\n";
// summary
echo " ". implode("\n ", $this->out). "\n";
var $deletes = array(); // TABLE => [key] => TRUE|FALSE
var $dumps = array(); // TABLE => [key] => TRUE|FALSE - if it's been scanned..
var $dscan = array(); // TABLE:COL => [value => TRUE|FALSE] - if its been scanned..
- var $childfiles = array(); // array of [ 'sourcedirectory' , 'subdirectory with filename' ]
+ var $childfiles = array(); // array of [ 'sourcedirectory' , 'subdirectory(s) and filename' ]
var $childthumbs = array(); // array of [ 'filename', 'filename' ,......]
+ var $filesize = 0; // size of files to be saved. (not total deletd..)
+ var $filetotal = 0; // number of distinct files to be saved (not total deleted)
/**
* scan table for
* a) what depends on it (eg. child elements) - which will be deleted.
}
}
+ $x->free();
// flag as checked if we where given an array.. - as some links might have been broken.
if (is_array($where)) {
foreach($where as $k) {
function discoverChildren($table, $where, $col=false )
{
+ echo "discoverChildren:$table:$col:". (is_array($where) ? (count($where) . " children" ): $where ). "\n";
global $_DB_DATAOBJECT;
$do = DB_DataObject::factory($table);
if (PEAR::isError($do)) {
if (isset($this->dumps[$table])) {
unset($this->dumps[$table]); // links to non-existant tables..
}
+ echo "SKIPPING invalid table $table\n";
return;
}
if (!isset($this->dumps[$table])) {
static $children = array();
if (!isset($children[$table])) {
-
+ $children[$table] = array();
// force load of linsk
$do->links();
foreach($_DB_DATAOBJECT['LINKS'][$do->database()] as $tbl => $links) {
}
}
+ print_R($children);
}
- if (empty($children[$table])) {
- // BLANK deletes???
- return;
- }
- // DB_DataObject::debugLevel(1);
+
$do->selectAdd();
$key = $keys[0];
$do->selectAdd($key);
- $do->find();
+ echo "GOT ". $do->find() ." results\n";
+ //DB_DataObject::debugLevel(0);
while ($do->fetch()) {
$this->dumps[$table][$do->$key] = 0;
if (!isset($this->deletes[$table][$do->$key])) {
$this->deletes[$table][$do->$key] = 0;
}
-
+
foreach($children[$table] as $kv=>$t) {
if (!isset($this->dscan[$kv])) {
$this->dscan[$kv] = array();
}
}
}
-
-
+ $do->free();
+
// now iterate throught dependants. and scan them.
$this->childthumbs[] = $ct;
}
}
-
+ $id = $do->$key;
fwrite($fh, "DELETE FROM `$tbl` WHERE `$key` = $id;\n"); // we assume id's and nice column names...
}
+ $do->free();
}
fclose($fh);
}
$this->out[] = $target;
$fh3 = fopen($target, 'w');
-
+
+ $done = array();
+ $donedir = array();
foreach($this->childfiles as $v) {
- fwrite($fh,"mkdir -p " . escapeshellarg(dirname($args['dump-dir'] .'/'.$v[1])) ."\n" );
- fwrite($fh,"cp " . escapeshellarg($v[0].'/'.$v[1]) . ' ' . escapeshellarg($args['dump-dir'] .'/'.$v[1]) ."\n" );
- fwrite($fh3,"mkdir -p " . escapeshellarg(dirname($v[0].'/'.$v[1])) ."\n" );
- fwrite($fh3,"cp " . escapeshellarg($args['dump-dir'] .'/'.$v[1]) . ' ' . escapeshellarg($v[0].'/'.$v[1]) . "\n" );
+ if (isset($done[$v[1]])) {
+ continue;
+ }
+
+ $done[$v[1]] = true;
+
+ $this->filesize += filesize($v[0].'/'.$v[1]);
+ $this->filetotal++;
+ $fdir = dirname($this->args['dump-dir'] .'/'.$v[1]);
+ if (!isset($donedir[$fdir])) {
+ fwrite($fh,"mkdir -p " . escapeshellarg(dirname($this->args['dump-dir'] .'/'.$v[1])) ."\n" );
+ }
+ fwrite($fh,"cp " . escapeshellarg($v[0].'/'.$v[1]) . ' ' . escapeshellarg($this->args['dump-dir'] .'/'.$v[1]) ."\n" );
+ if (!isset($donedir[$fdir])) {
+ fwrite($fh3,"mkdir -p " . escapeshellarg(dirname($v[0].'/'.$v[1])) ."\n" );
+ }
+ $donedir[$fdir] = true;
+ fwrite($fh3,"cp " . escapeshellarg($this->args['dump-dir'] .'/'.$v[1]) . ' ' . escapeshellarg($v[0].'/'.$v[1]) . "\n" );
fwrite($fh2,"rm " . escapeshellarg($v[0].'/'.$v[1]) ."\n" );
}
fclose($fh);
fclose($fh3); // restore does not need to bother with thumbnails.
-
+
foreach($this->childthumbs as $v) {
while ($do->fetch()) {
fwrite($fh,$this->toInsert($do));
}
-
+ $do->free();
}
fclose($fh);
projects / Pman.Admin / blobdiff