Package com.exasol.dbbuilder.dialects

Interface Schema

All Superinterfaces:

AutoCloseable, DatabaseObject

All Known Implementing Classes:

AbstractSchema, ExasolSchema, MySqlSchema, OracleSchema, PostgreSqlSchema

public interface Schema
extends DatabaseObject

Database schema.

Method Summary

Modifier and Type	Method	Description
Table	createTable(String name, String column1Name, String column1Type)	Create a table with one column.
Table	createTable(String name, String column1Name, String column1Type, String column2Name, String column2Type)	Create a table with two columns.
Table	createTable(String name, String column1Name, String column1Type, String column2Name, String column2Type, String column3Name, String column3Type)	Create a table with three columns.
Table	createTable(String name, List<String> columnNames, List<String> columnTypes)	Create a table with an arbitrary number of columns.
Table.Builder	createTableBuilder(String name)	Create a builder for a table.
default DatabaseObject	getParent()	Get the parent object.
List<Table>	getTables()	Get the tables inside this schema.
default String	getType()	Get the type of the database object.
default boolean	hasParent()	Check if this object has a parent object that sets the scope within the database

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

close, drop, getFullyQualifiedName, getName, isOwned

Method Detail

getTables

List<Table> getTables()

Get the tables inside this schema.

Returns:

list of tables in this schema

createTable

Table createTable(String name,
                  List<String> columnNames,
                  List<String> columnTypes)

Create a table with an arbitrary number of columns.

Parameters:

name - name of the table

columnNames - list of column names

columnTypes - list of column types

Returns:

table

createTable

Table createTable(String name,
                  String column1Name,
                  String column1Type)

Create a table with one column.

Parameters:

name - name of the table

column1Name - name of the first column

column1Type - type of the first column

Returns:

table

createTable

Table createTable(String name,
                  String column1Name,
                  String column1Type,
                  String column2Name,
                  String column2Type)

Create a table with two columns.

Parameters:

name - name of the table

column1Name - name of the first column

column1Type - type of the first column

column2Name - name of the second column

column2Type - type of the second column

Returns:

table

createTable

Table createTable(String name,
                  String column1Name,
                  String column1Type,
                  String column2Name,
                  String column2Type,
                  String column3Name,
                  String column3Type)

Create a table with three columns.

Parameters:

name - name of the table

column1Name - name of the first column

column1Type - type of the first column

column2Name - name of the second column

column2Type - type of the second column

column3Name - name of the third column

column3Type - type of the third column

Returns:

table

createTableBuilder

Table.Builder createTableBuilder(String name)

Create a builder for a table.

In cases where you need a more complex table that can be created by the convenience methods createTable, this method provides a builder.

Parameters:

name - table name

Returns:

builder for the table

getType

default String getType()

Description copied from interface: DatabaseObject

Get the type of the database object.

Specified by:

getType in interface DatabaseObject

Returns:

type of the database object

hasParent

default boolean hasParent()

Description copied from interface: DatabaseObject

Check if this object has a parent object that sets the scope within the database

Specified by:

hasParent in interface DatabaseObject

Returns:

true if the object has a parent

getParent

default DatabaseObject getParent()

Description copied from interface: DatabaseObject

Get the parent object.

Specified by:

getParent in interface DatabaseObject

Returns:

parent object