Zum Hauptinhalt springen

DeleteBuilder

Class for building ANSI-SQL DELETE Statements.

Param​

the table name you want to delete data

context.returnValue = DeleteBuilder.from("costcenter")
    .where("costcenter = 'K30101'")
    .toSQL();

// DELETE FROM costcenter WHERE costcenter = 'K30101'

Implements​

Constructors​

Constructor​

new DeleteBuilder(table?): DeleteBuilder

Parameters​

table?​

string

Returns​

DeleteBuilder

Properties​

toString()​

toString: () => string

Generates the SQL Query

Returns​

string

  • returns a sql query

Member Of​

DeleteBuilder

Implementation of​

StatementBuilder.toString

Methods​

from()​

from(table): DeleteBuilder

Specifies the table you want to delete data.

Parameters​

table​

string

the table name

Returns​

DeleteBuilder

Member Of​

DeleteBuilder

where()​

where(condition): DeleteBuilder

Adds a where condition to the query

Parameters​

condition​

string

the where condition like "[ID] = 4"

Returns​

DeleteBuilder

Example​

builder.where("[ID] = 4");

Member Of​

DeleteBuilder

setWhere()​

setWhere(range, surroundWithBrackets?): DeleteBuilder

Adds a range of where conditions

Parameters​

range​

[string, string | number | Date][]

a range of where conditions

surroundWithBrackets?​

boolean

(optional) Should surround names with brackets: column -> [column]

Returns​

DeleteBuilder

  • this instance

Examples​

const deleteBuilder = DeleteBuilder.from("tbl_Kunden");
deleteBuilder.setWhere([["Kundenname", "Gersthofen Ballonmuseum"], ["Kundennummer", 123]]);
// DELETE FROM tbl_Kunden WHERE [Kundenname] = 'Gersthofen Ballonmuseum' AND [Kundennummer] = 123
const deleteBuilder = DeleteBuilder.from("tbl_Kunden");
deleteBuilder.setWhere([["Kundenname", "Gersthofen Ballonmuseum"], ["Kundennummer", 123]], false);
// DELETE FROM tbl_Kunden WHERE Kundenname = 'Gersthofen Ballonmuseum' AND Kundennummer = 123

Member Of​

DeleteBuilder

toSQL()​

toSQL(): string

Generates the SQL Query

Returns​

string

  • returns a sql query.

Member Of​

DeleteBuilder

Implementation of​

StatementBuilder.toSQL

from()​

static from(table): DeleteBuilder

Specifies the table you want to delete data

Parameters​

table​

string

the specified table name

Returns​

DeleteBuilder

  • returns a new Instance

Static​

Member Of​

DeleteBuilder