Method updateQuery

src/pg.ts:371–394

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

    }

    updateQuery(
        table: SqlTable,
        set: SqlSetValueMap,
        where?: SqlCondition,
        returning?: SqlResultColumnSelector | undefined,
    ): ExecutableSqlQuery {
        let i: [number] = [1]
        let line = `UPDATE "${table.name}"`
        line += ` SET ${Object.keys(set).map((k) => k + "=$" + (i[0]++)).join(", ")}`
        let values: any[] = []
        if (where && Object.keys(where).length > 0) {
            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,
            ...Object.values(set),
            ...values
        ]
    }

    selectQuery(
        table: SqlTable,