Package com.exasol.dbbuilder.dialects.mysql

Class MySqlImmediateDatabaseObjectWriter

java.lang.Object

com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

com.exasol.dbbuilder.dialects.mysql.MySqlImmediateDatabaseObjectWriter

All Implemented Interfaces:

DatabaseObjectWriter

public class MySqlImmediateDatabaseObjectWriter
extends AbstractImmediateDatabaseObjectWriter

Database object writer that writes objects to the database immediately.

Field Summary

Fields inherited from class com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

connection

Constructor Summary

Constructors

Constructor	Description
MySqlImmediateDatabaseObjectWriter(Connection connection)	Create a new instance of an MySqlImmediateDatabaseObjectWriter.

Method Summary

Modifier and Type	Method	Description
void	drop(Schema schema)	Drop a schema.
protected String	getQuotedColumnName(String columnName)	Get a quoted column name.
void	write(User user)	Create a user in the database.
void	write(User user, DatabaseObject object, ObjectPrivilege... privileges)	Grant privileges to a database object to a user.
void	write(User user, GlobalPrivilege... privileges)	Grant system privileges to a user.

Methods inherited from class com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

createCommaSeparatedObjectPrivilegeList, createCommaSeparatedSystemPrivilegeList, drop, drop, executeSqlFile, truncate, write, write, write, writeToObject

Methods inherited from class java.lang.Object

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

Constructor Detail

MySqlImmediateDatabaseObjectWriter

public MySqlImmediateDatabaseObjectWriter(Connection connection)

Create a new instance of an MySqlImmediateDatabaseObjectWriter.

Parameters:

connection - JDBC connection

Method Detail

write

public void write(User user)

Description copied from interface: DatabaseObjectWriter

Create a user in the database.

Parameters:

user - to be created

write

public void write(User user,
                  GlobalPrivilege... privileges)

Description copied from interface: DatabaseObjectWriter

Grant system privileges to a user.

Parameters:

user - user who gets the privileges

privileges - privileges to be assigned

getQuotedColumnName

protected String getQuotedColumnName(String columnName)

Description copied from class: AbstractImmediateDatabaseObjectWriter

Get a quoted column name.

Specified by:

getQuotedColumnName in class AbstractImmediateDatabaseObjectWriter

Parameters:

columnName - name of a column

Returns:

quoted column name

write

public void write(User user,
                  DatabaseObject object,
                  ObjectPrivilege... privileges)

Description copied from interface: DatabaseObjectWriter

Grant privileges to a database object to a user.

Specified by:

write in interface DatabaseObjectWriter

Overrides:

write in class AbstractImmediateDatabaseObjectWriter

Parameters:

user - user who gets the privileges

object - object the privileges apply to

privileges - privileges to be assigned

drop

public void drop(Schema schema)

Description copied from interface: DatabaseObjectWriter

Drop a schema.

Parameters:

schema - to drop