#!/usr/bin/php -q
<?php
require (dirname(__FILE__)."/../../appcore/app.php");
$app = new AppApp( dirname(__FILE__)."/../app.config.php");

$t = app()->select("show tables");
$fn = array_keys($t[0])[0];


$dataTables = "
appprofileapps
appprofiles
categories
channelscodes
channelstatus
channelstretchcodes
channeltypes
costmarkets
langs
marketlangs
packagetypes
progbdulangs
pvrprofiles
pvrservers
status
substatus
taxrates
timeshiftprofiles
timezones
";

$dts = explode("\n", $dataTables);
$dtr = [];



/*
$app->dbUser = "root";
$app->dbPass = "128i72j34";
$app->dbHost = "localhost";
$app->dbName = "xmltv";
$app->attachPath = "/opt/ep
*/

$odir = dirname(__FILE__);


`rm -f '$odir/dbschema.sql'`;
foreach($t as $r) { 
	$tn = $r[$fn];
	if ( preg_match("/^progsnap_/", $tn)) { 
		continue;
	}
	$cmd = "mysqldump -h{$app->dbHost} -u {$app->dbUser} -p{$app->dbPass} --no-data --single-transaction --quick --lock-tables=false {$app->dbName} '$tn' | sed 's/ AUTO_INCREMENT=[0-9]*\b//g' >> '$odir/dbschema.sql'";
	print "exec:$cmd\n";
	passthru($cmd);
}


file_put_contents("$odir/dbbasedata.sql","");
$tf = dirname(__FILE__)."/./epgdatabasedata.tar";
`rm -f '$tf'`;
`rm -f '$tf.gz'`;
foreach($dts as $dt ) { 
	$dt = trim($dt);
	if ( strlen($dt) < 1 ) { continue;}
	$cmd = "mysqldump -h{$app->dbHost} -u {$app->dbUser} -p{$app->dbPass}  --single-transaction --quick --lock-tables=false {$app->dbName} \"{$dt}\">> '$odir/dbbasedata.sql'";
	print "exec:$cmd\n";
	passthru($cmd);

	$idir = "/opt/epgdata/$dt";
	print "$idir\n";
	if ( is_dir($idir) ) { 
		$cmd = "tar -rvf '$tf' \"$idir\" ";
		print "exec:$cmd\n";
		passthru($cmd);
	}
}

`gzip '$tf'`;







?>