Package com.exasol.dbbuilder.dialects

Class AbstractImmediateDatabaseObjectWriter

java.lang.Object

com.exasol.dbbuilder.dialects.AbstractImmediateDatabaseObjectWriter

All Implemented Interfaces:

DatabaseObjectWriter

Direct Known Subclasses:

ExasolImmediateDatabaseObjectWriter, MySqlImmediateDatabaseObjectWriter

public abstract class AbstractImmediateDatabaseObjectWriter
extends Object
implements DatabaseObjectWriter

This class contains common logic for writers that persist database objects.

Field Summary

Fields

Modifier and Type	Field	Description
protected Connection	connection

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
protected String	createCommaSeparatedObjectPrivilegeList(ObjectPrivilege[] privileges)
protected String	createCommaSeparatedSystemPrivilegeList(GlobalPrivilege[] privileges)
void	drop(Table table)	Drop a table.
void	drop(User user)	Drop a user.
void	executeSqlFile(Path... sqlFiles)	Execute the contents of a SQL script file.
protected abstract String	getQuotedColumnName(String columnName)	Get a quoted column name.
void	write(Schema schema)	Create a schema in the database.
void	write(Table table)	Create a table in the database.
void	write(Table table, Object... values)	Write data to a database table.
void	write(User user, DatabaseObject object, ObjectPrivilege... privileges)	Grant privileges to a database object to a user.
protected void	writeToObject(DatabaseObject object, String sql, Object... parameters)

Methods inherited from class java.lang.Object

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

Methods inherited from interface com.exasol.dbbuilder.dialects.DatabaseObjectWriter

drop, write, write

Field Detail

connection

protected final Connection connection

Constructor Detail

AbstractImmediateDatabaseObjectWriter

public AbstractImmediateDatabaseObjectWriter(Connection connection)

Create a new instance of an AbstractImmediateDatabaseObjectWriter.

Parameters:

connection - JDBC connection

Method Detail

writeToObject

protected void writeToObject(DatabaseObject object,
                             String sql,
                             Object... parameters)

write

public void write(Schema schema)

Description copied from interface: DatabaseObjectWriter

Create a schema in the database.

Specified by:

write in interface DatabaseObjectWriter

Parameters:

schema - schema to be written

write

public void write(Table table)

Description copied from interface: DatabaseObjectWriter

Create a table in the database.

Specified by:

write in interface DatabaseObjectWriter

Parameters:

table - table to be written

getQuotedColumnName

protected abstract String getQuotedColumnName(String columnName)

Get a quoted column name.

Parameters:

columnName - name of a column

Returns:

quoted column name

write

public void write(Table table,
                  Object... values)

Description copied from interface: DatabaseObjectWriter

Write data to a database table.

Specified by:

write in interface DatabaseObjectWriter

Parameters:

table - table to write to

values - values to be written

createCommaSeparatedSystemPrivilegeList

protected String createCommaSeparatedSystemPrivilegeList(GlobalPrivilege[] privileges)

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

Parameters:

user - user who gets the privileges

object - object the privileges apply to

privileges - privileges to be assigned

createCommaSeparatedObjectPrivilegeList

protected String createCommaSeparatedObjectPrivilegeList(ObjectPrivilege[] privileges)

executeSqlFile

public void executeSqlFile(Path... sqlFiles)

Description copied from interface: DatabaseObjectWriter

Execute the contents of a SQL script file.

Specified by:

executeSqlFile in interface DatabaseObjectWriter

Parameters:

sqlFiles - path(s) to the script file(s)

drop

public void drop(Table table)

Description copied from interface: DatabaseObjectWriter

Drop a table.

Specified by:

drop in interface DatabaseObjectWriter

Parameters:

table - table to drop

drop

public void drop(User user)

Description copied from interface: DatabaseObjectWriter

Drop a user.

Specified by:

drop in interface DatabaseObjectWriter

Parameters:

user - to drop