Method deleteQuery

src/pg.ts:428–450

(
        table: SqlTable,
        where?: SqlCondition,
        returning?: SqlResultColumnSelector | undefined,
    )

    }

    deleteQuery(
        table: SqlTable,
        where?: SqlCondition,
        returning?: SqlResultColumnSelector | undefined,
    ): ExecutableSqlQuery {
        let line = `DELETE FROM "${table.name}"`

        let values: any[] = []
        if (where && Object.keys(where).length > 0) {
            let i: [number] = [1]
            const whereData = this.createSqlWhereCondition(table.name, where, i)
            line += ` WHERE ${whereData[0]}`
            values = whereData.slice(1)
        }

        if (typeof returning != "undefined") {
            line += ` RETURNING ${this.createSelectQuery(returning)}`
        }
        return [
            line,
            ...values
        ]
    }
}

export class PostgresConnection implements AbstractSqlConnection {