net.moznion.mysql.diff

Class SchemaDumper

java.lang.Object

net.moznion.mysql.diff.SchemaDumper

public class SchemaDumper
extends Object

Dumper for SQL table definition.

Author:

moznion

Constructor Summary

Constructors

Constructor and Description
SchemaDumper() Instantiate SchemaDumper.
SchemaDumper(MySqlConnectionInfo localMySqlConnectionInfo) Instantiate SchemaDumper.
SchemaDumper(MySqlConnectionInfo localMySqlConnectionInfo, String mysqldumpPath) Instantiate SchemaDumper.
SchemaDumper(String mysqldumpPath) Instantiate SchemaDumper.

Method Summary

Modifier and Type	Method and Description
String	dump(File sqlFile) Dump schema from SQL file which is written by UTF-8.
String	dump(File sqlFile, Charset charset) Dump schema from SQL file.
String	dump(String sql) Dump schema from SQL string.
String	dumpFromLocalDb(String dbName) Dump schema from DB name which is in local MySQL.
String	dumpFromRemoteDb(String dbName, MySqlConnectionInfo mysqlConnectionInfo) Dump schema from DB name which is in remote MySQL.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SchemaDumper

public SchemaDumper(MySqlConnectionInfo localMySqlConnectionInfo,
                    String mysqldumpPath)

Instantiate SchemaDumper.

Parameters:

localMySqlConnectionInfo - Connection information of MySQL which is on your local environment.

mysqldumpPath - Path for mysqldump command.

SchemaDumper

public SchemaDumper(MySqlConnectionInfo localMySqlConnectionInfo)

Instantiate SchemaDumper.

Path of mysqldump will be used default as "mysqldump".

Parameters:

localMySqlConnectionInfo - Connection information of MySQL which is on your local environment.

SchemaDumper

public SchemaDumper(String mysqldumpPath)

Instantiate SchemaDumper.

Connection information of local MySQL will be used default as "-h localhost -u root".

Parameters:

mysqldumpPath - Path for mysqldump command.

SchemaDumper

public SchemaDumper()

Instantiate SchemaDumper.

Path of mysqldump will be used default as "mysqldump".
Connection information of local MySQL will be used default as "-h localhost -u root".

Method Detail

dump

public String dump(String sql)
            throws SQLException,
                   IOException,
                   InterruptedException

Dump schema from SQL string.

Parameters:

sql - SQL string which is a target to dump.

Returns:

Result of dumping.

Throws:

SQLException - Throw if invalid SQL is given.

IOException - Throw if mysqldump command is failed.

InterruptedException - Throw if mysqldump command is failed.

dump

public String dump(File sqlFile,
                   Charset charset)
            throws IOException,
                   SQLException,
                   InterruptedException

Dump schema from SQL file.

Parameters:

sqlFile - SQL file.

charset - Character set of SQL file.

Returns:

Result of dumping.

Throws:

SQLException - Throw if invalid SQL is given.

IOException - Throw if mysqldump command is failed.

InterruptedException - Throw if mysqldump command is failed.

dump

public String dump(File sqlFile)
            throws IOException,
                   SQLException,
                   InterruptedException

Dump schema from SQL file which is written by UTF-8.

Parameters:

sqlFile - SQL file (written by UTF-8).

Returns:

Result of dumping.

Throws:

SQLException - Throw if invalid SQL is given.

IOException - Throw if mysqldump command is failed.

InterruptedException - Throw if mysqldump command is failed.

dumpFromLocalDb

public String dumpFromLocalDb(String dbName)
                       throws IOException,
                              InterruptedException,
                              SQLException

Dump schema from DB name which is in local MySQL.

Parameters:

dbName - DB name which is in local MySQL.

Returns:

Result of dumping.

Throws:

SQLException - Throw if invalid SQL is given.

IOException - Throw if mysqldump command is failed.

InterruptedException - Throw if mysqldump command is failed.

dumpFromRemoteDb

public String dumpFromRemoteDb(String dbName,
                               MySqlConnectionInfo mysqlConnectionInfo)
                        throws IOException,
                               InterruptedException,
                               SQLException

Dump schema from DB name which is in remote MySQL.

Parameters:

dbName - DB name which is in remote MySQL.

mysqlConnectionInfo - Connection information of remote MySQL.

Returns:

Result of dumping.

Throws:

SQLException - Throw if invalid SQL is given.

IOException - Throw if mysqldump command is failed.

InterruptedException - Throw if mysqldump command is failed.