<?php
	include_once '../lib/lib.php';
	
	function logit($str){
		Utils::prline("{$str}");
	}
	
	/*
	 * Check if schema_info exists
	 */
	logit("<pre>");
	if (!DBUtils::tableExists("schema_info")){
		logit("running init script 'init.mysql' ...");
		DBUtils::execute_script("init.mysql");
		schemaInfo::setVersion(0);
	}else{
		logit("database has alreay been initialized.");
	}
	
	$curVersion = schemaInfo::getVersion();	
	$files = glob("*_migrate.mysql");
	$scriptFiles = array();	
	foreach ($files as $key => $file) {
		$parts=explode("_", $file);
		$fd = (double)$parts[0];
		$scriptFiles[] = array("name" => $file, "version" => $fd);
	}
	$files = Utils::array_sort($scriptFiles, "version");
	//var_dump($files);
	$actioncounter = 0;
	foreach ($files as $key => $file) {
		$filename = $file["name"];
		$version = $file["version"];
		$curVersion = schemaInfo::getVersion();
		if ($version > $curVersion){
			$actioncounter += 1;
			logit("running migration script '{$filename}' ...");
			$res = DBUtils::execute_script($filename);
			var_dump($res);
			schemaInfo::setVersion($version);
		}
	}
	if ($actioncounter == 0){
		logit("no available migration found.");
	}
	
	logit("</pre>");
	
?>