Package com.exasol.dbbuilder.dialects

Interface DatabaseObjectWriter

All Known Implementing Classes:

AbstractImmediateDatabaseObjectWriter, ExasolImmediateDatabaseObjectWriter, MySqlImmediateDatabaseObjectWriter, PostgreSqlImmediateDatabaseObjectWriter

public interface DatabaseObjectWriter

Interface for writers that persist database objects.

Method Summary

Modifier and Type	Method	Description
void	drop(Schema schema)	Drop a schema.
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.
void	truncate(Table table)	Truncate a table.
void	write(Schema schema)	Create a schema in the database.
void	write(Table table)	Create a table in the database.
void	write(Table table, Stream<List<Object>> rows)	Bulk write data to a database table.
void	write(User user)	Create a user in the database.
void	write(User user, DatabaseObject object, ObjectPrivilege... objectPrivileges)	Grant privileges to a database object to a user.
void	write(User user, GlobalPrivilege... privileges)	Grant system privileges to a user.

Method Detail

write

void write(Schema schema)

Create a schema in the database.

Parameters:

schema - schema to be written

write

void write(Table table)

Create a table in the database.

Parameters:

table - table to be written

write

void write(Table table,
           Stream<List<Object>> rows)

Bulk write data to a database table.

Parameters:

table - table to write to

rows - stream of rows to be written

truncate

void truncate(Table table)

Truncate a table.

Parameters:

table - table to truncate

write

void write(User user)

Create a user in the database.

Parameters:

user - to be created

write

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

Grant system privileges to a user.

Parameters:

user - user who gets the privileges

privileges - privileges to be assigned

write

void write(User user,
           DatabaseObject object,
           ObjectPrivilege... objectPrivileges)

Grant privileges to a database object to a user.

Parameters:

user - user who gets the privileges

object - object the privileges apply to

objectPrivileges - privileges to be assigned

executeSqlFile

void executeSqlFile(Path... sqlFiles)

Execute the contents of a SQL script file.

Parameters:

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

drop

void drop(Table table)

Drop a table.

Parameters:

table - table to drop

drop

void drop(User user)

Drop a user.

Parameters:

user - to drop

drop

void drop(Schema schema)

Drop a schema.

Parameters:

schema - to drop