Package io.github.projectunified.craftdatabase.client.sql.helper

Class CreateTableBuilder

java.lang.Object

io.github.projectunified.craftdatabase.client.sql.helper.CreateTableBuilder

public final class CreateTableBuilder
extends Object

A builder for CREATE TABLE queries

Method Summary

Modifier and Type	Method	Description
Query	build()	Build the query
CreateTableBuilder	column(String name, String definition)	Add a column
CreateTableBuilder	constraint(String constraint)	Add a table constraint
static CreateTableBuilder	create(String table)	Create a new builder
CreateTableBuilder	ifNotExists()	Add the IF NOT EXISTS option

Methods inherited from class java.lang.Object

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

Method Details

create

public static CreateTableBuilder create(String table)

Create a new builder

Parameters:

table - the table

Returns:

the builder

ifNotExists

public CreateTableBuilder ifNotExists()

Add the IF NOT EXISTS option

Returns:

this builder for chaining

column

public CreateTableBuilder column(String name,
 String definition)

Add a column

Parameters:

name - the column name

definition - the column definition, e.g. "INT PRIMARY KEY" or "VARCHAR(100) NOT NULL"

Returns:

this builder for chaining

constraint

public CreateTableBuilder constraint(String constraint)

Add a table constraint

Parameters:

constraint - the constraint, e.g. "PRIMARY KEY (a, b)"

Returns:

this builder for chaining

build

public Query build()

Build the query

Returns:

the query