Add QuerySetRow, Query.setRow() and allow returning an array from QueryRowData

Description

as discussed on the mailing list
https://dev.lucee.org/t/add-querysetrow-query-setrow/3791

Basically it's QueryAddRow, but allowing it to update an existing row with data
http://docs.lucee.org/reference/objects/query/addrow.html

This will allow developers to avoid using QuerySetCell for every column when manipulating
an existing query row.

QueryRowData currently only returns a struct, add an option to return an array, which can
then be passed into QuerySetRow()
http://docs.lucee.org/reference/objects/query/rowdata.html

Activity

Show:
Dave Merrill
May 13, 2018, 10:29 AM

Adding querySetRow() makes perfect sense, but the struct syntax for adding a row makes more sense to me, so I don't see the need for queryRowData() to return an array.

Zac Spitzer
May 13, 2018, 10:46 AM

Adding a row via array is way more efficient that via a struct which requires name matching for each column

Dave Merrill
May 14, 2018, 10:28 AM

Point taken, so I suppose the array version would be preferable when highest performance is required. Absent that priority though, the struct version is way more readable IMO, especially in a query with many columns, or where you only want to set a few columns.

Zac Spitzer
October 22, 2020, 7:27 AM

initial cut (doesn’t quite compile yet, notes in PR)

Sebastian Zartner
October 23, 2020, 5:19 PM

Just to have the reference, the PR is .

Sebastian

Assignee

Zac Spitzer

Reporter

Zac Spitzer

Labels

Priority

New
Configure