Package ece.ing3.java.projet.database.sql.queries

Class SQLInsert

java.lang.Object

ece.ing3.java.projet.database.sql.queries.SQLInsert

All Implemented Interfaces:

SQLRequest

public class SQLInsert
extends Object
implements SQLRequest

SQL insert helper.

Provides a convenient way to build insert SQL queries, reactive-style, for a provided model class.

Author:

Virgile, Nicolas, Louis-Félix

Constructor Summary

Constructors

Constructor	Description
SQLInsert(Class<? extends Model> modelClass)	Creates a new helper for a model class.

Method Summary

Modifier and Type	Method	Description
SQLInsert	add(String column, Object value)	Add a new value to the request.
Class<? extends Model>	getModelClass()
List<Object>	getParameters()	Gets all the request's parameters
int	insert()	Inserts the built row in the database.
String	toString()	Generate the SQL query for this insert helper.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Details

SQLInsert

public SQLInsert(Class<? extends Model> modelClass)

Creates a new helper for a model class.

Parameters:

modelClass - Model class

Method Details

getModelClass

public Class<? extends Model> getModelClass()

Specified by:

getModelClass in interface SQLRequest

add

public SQLInsert add(String column,
 Object value)

Add a new value to the request.

Parameters:

column - Column to target

value - Value to add

Returns:

This SQL insert helper

insert

public int insert()
           throws IllegalArgumentException,
DatabaseException

Inserts the built row in the database.

Returns:

Either (1) the row count for SQL Data Manipulation Language (DML) statements or (2) 0 for SQL statements that return nothing

Throws:

IllegalArgumentException - No values where added

DatabaseException - Database error

toString

public String toString()
                throws IllegalArgumentException

Generate the SQL query for this insert helper.

Specified by:

toString in interface SQLRequest

Overrides:

toString in class Object

Returns:

Generated SQL query

Throws:

IllegalArgumentException - No values where added

getParameters

public List<Object> getParameters()

Description copied from interface: SQLRequest

Gets all the request's parameters

Specified by:

getParameters in interface SQLRequest

Returns:

Request parameters