<?php

/**
 * Controller to be called from CLI only
 * Reference: http://www.codeigniter.com/user_guide/general/cli.html
 */
class Cli extends MX_Controller {

	// Constructor
	public function __construct()
	{
		parent::__construct();

		// allow execution from CLI only
		if (!is_cli())
		{
			show_404();
		}
	}
	
	// Run daily cron job
	// Command: php index.php cli daily
	public function daily()
	{
		echo 'Starting daily cron job'.PHP_EOL;
		$this->backup_db();
		echo 'End of daily cron job.'.PHP_EOL;
	}

	// Run backup operation of database
	// Command: php index.php cli backup_db
	public function backup_db()
	{
		$this->load->dbutil();
		$this->load->helper('file');

		// Options: http://www.codeigniter.com/user_guide/database/utilities.html?highlight=csv#setting-backup-preferences
		$prefs = array('format' => 'txt');

		echo '====== Task: Backup database'.PHP_EOL;
		$backup = $this->dbutil->backup($prefs);
		$file_path_1 = FCPATH.'sql/backup/'.date('Y-m-d_H-i-s').'.sql';
		$file_path_2 = FCPATH.'sql/latest.sql';
		write_file($file_path_1, $backup);
		write_file($file_path_2, $backup);

		echo 'Database saved to these files: '.PHP_EOL;
		echo ' - '.$file_path_1.PHP_EOL;
		echo ' - '.$file_path_2.PHP_EOL;
		echo '====== Task: Backup database (Completed)'.PHP_EOL;
	}

	// Empty all database tables except "admin_users"
	// Command: php index.php cli clean_db
	public function clean_db()
	{
		$this->load->database();

		echo '====== Task: Empty database'.PHP_EOL;
		$this->db->truncate('cover_photos');
		$this->db->truncate('blog_categories');
		$this->db->truncate('blog_tags');
		$this->db->truncate('blog_post_tag_rel');
		$this->db->truncate('blog_posts');
		echo '====== Task: Empty database (Completed)'.PHP_EOL;
	}

	// Backup only the default tables (from CI Bootstrap)
	public function save_default_db()
	{
		$this->load->dbutil();
		$this->load->helper('file');
		$prefs = array('format' => 'txt');
		
		// Ion Auth
		$prefs['tables'] = array('groups', 'login_attempts', 'users', 'users_groups');
		$backup = $this->dbutil->backup($prefs);
		$file_path = FCPATH.'sql/core/ion_auth.sql';
		write_file($file_path, $backup);
		echo 'Database saved to: '.$file_path.PHP_EOL;
		
		// Ion Auth (for Admin Panel)
		$prefs['tables'] = array('admin_groups', 'admin_login_attempts', 'admin_users', 'admin_users_groups');
		$backup = $this->dbutil->backup($prefs);
		$file_path = FCPATH.'sql/core/ion_auth_admin.sql';
		write_file($file_path, $backup);
		echo 'Database saved to: '.$file_path.PHP_EOL;

		// Demo - Cover Photos
		$prefs['tables'] = array('demo_cover_photos');
		$backup = $this->dbutil->backup($prefs);
		$file_path = FCPATH.'sql/demo/cover_photos.sql';
		write_file($file_path, $backup);
		echo 'Database saved to: '.$file_path.PHP_EOL;

		// Demo - Blog
		$prefs['tables'] = array('demo_blog_posts', 'demo_blog_categories', 'demo_blog_tags', 'demo_blog_posts_tags');
		$backup = $this->dbutil->backup($prefs);
		$file_path = FCPATH.'sql/demo/blog.sql';
		write_file($file_path, $backup);
		echo 'Database saved to: '.$file_path.PHP_EOL;
	}
	
	// Reset database to default (i.e. from /sql/latest.sql)
	// Command: php index.php cli reset_db
	public function reset_db()
	{
		echo '====== Task: Reset database'.PHP_EOL;
		echo 'To be implemented'.PHP_EOL;
	}

	// Migrate database
	// Command: php index.php cli migrate
	public function migrate()
	{
		echo '====== Task: Migrate database'.PHP_EOL;
		echo 'To be implemented'.PHP_EOL;
	}
}