<?php
/**
* Migration Class
*
* Created on 2011. 11. 16.
* @author 불의회상 <hoksi2k@hanmail.net>
* @package library
* @subpackage controllers
* @version 1.0
*/
class Migration_lib extends CI_Controller {
function __construct() {
parent::__construct();
}
function index($mode = NULL) {
$this->load->library('migration');
$data = array(
'migration_error' => '',
'blog' => '',
'migration_config' => $this->load->file('sample/migrations/migration_config.txt', TRUE),
'migration_file' => $this->load->file('sample/migrations/001_add_blog.txt', TRUE),
'mode' => $mode
);
if($mode == 'migration') {
// Migration
if (!$this->migration->current()) {
$data['migration_error'] = $this->migration->error_string();
} else {
if($this->db->table_exists('blog')) {
$data['blog'] = $this->db->list_fields('blog');
}
}
} elseif($mode == 'migration_latest') {
// Migration latest
if (!$this->migration->latest()) {
$data['migration_error'] = $this->migration->error_string();
} else {
if($this->db->table_exists('blog')) {
$data['blog'] = $this->db->list_fields('blog');
}
}
} elseif($mode == 'rollback') {
// Rollback
if (!$this->migration->version(0)) {
$data['migration_error'] = $this->migration->error_string();
}
}
$this->load->view('migration_lib_sample', $data);
}
}
<?php $this->load->view('inc/header')?>
<a class="btn btn-primary" href="<?=site_url('migration_lib/index/migration')?>">Migration</a>
<a class="btn btn-warning" href="<?=site_url('migration_lib/index/migration_latest')?>">Migration Latest</a>
<a class="btn" href="<?=site_url('migration_lib/index/rollback')?>">Rollback</a>
<hr/>
<table class="tablesorter" border="0" cellpadding="0" cellspacing="1">
<?php if($mode != NULL):?>
<thead>
<tr>
<th style="text-align:center" colspan="2">
<?=($mode == 'migration' ? 'Migration' : ($mode == 'migration_latest' ? 'Migration Latest' : 'Migratioin Rollback'))?> 결과
</th>
</tr>
</thead>
<tr>
<td width="20%">$this->db->list_fields('blog')</td>
<td><pre><?php print_r($blog)?></pre></td>
</tr>
<tr>
<td>에러 여부</td>
<td><?php echo $migration_error?></td>
</tr>
<?php endif;?>
<thead>
<tr>
<th style="text-align:center" colspan="2">application/config/migration.php</th>
</tr>
</thead>
<tr>
<td colspan="2"><pre><?=$migration_config?></pre></td>
</tr>
<thead>
<tr>
<th style="text-align:center" colspan="2">application/migrations/001_add_blog.php</th>
</tr>
</thead>
<tr>
<td colspan="2"><pre><?=$migration_file?></pre></td>
</tr>
</table>
<?php $this->load->view('inc/footer')?>
© Copyright by hoksi(Page rendered in 0.0071 seconds)