felixonline/exporter

数据库导出工具

0.1.7 2016-03-11 22:41 UTC

This package is auto-updated.

Last update: 2024-09-26 01:50:44 UTC


README

一个程序化数据库导出工具。目前仅支持MySQL。

安装

将以下内容添加到您的 composer.json

{
    "require": {
        "felixonline/exporter": "0.1.*"
    }
}

然后运行

composer install

并将 require 'vendor/autoload.php' 添加到您的 PHP 文件中;

示例

class FooExporter extends \FelixOnline\Exporter\MySQLExporter
{
    function processTable($table)
    {
    	if ($table == 'table_to_skip') {
    		return false; // still outputs create table sql
    	}
    	return $table;
    }
    
    function processRow($row, $table)
    {
    	if ($table == 'users') {
    		$row['password'] = 'password';
    	}
    	
    	return $row;
    }
}

$exporter = new FooExporter(array(
    'db_name' => 'DB_NAME',
    'db_user' => 'DB_USER',
    'db_pass' => 'DB_PASS',
    'file' => 'foo-' . time() . '.sql',
));

$exporter->run();

许可证

MIT