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

Class SQLDelete

java.lang.Object

ece.ing3.java.projet.database.sql.queries.SQLWhereQuery<SQLDelete>

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

All Implemented Interfaces:

SQLRequest

public class SQLDelete
extends SQLWhereQuery<SQLDelete>

SQL delete helper.

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

Author:

Virgile, Nicolas, Louis-Félix

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method	Description
int	delete()	Deletes the requested lines of a model's table from the database.
Class<? extends Model>	getModelClass()
String	toString()	Generate the SQL query for this insert helper.

Methods inherited from class ece.ing3.java.projet.database.sql.queries.SQLWhereQuery

andWhere, andWhere, andWhere, getParameters, orWhere, orWhere, orWhere, where, where, where

Methods inherited from class java.lang.Object

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

Constructor Details

SQLDelete

public SQLDelete(Class<? extends Model> modelClass)

Creates a new helper for a model class.

Parameters:

modelClass - Model class

Method Details

getModelClass

public Class<? extends Model> getModelClass()

delete

public int delete()
           throws IllegalArgumentException,
DatabaseException

Deletes the requested lines of a model's table from 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 set

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