Re^2: Append JSON (from hashref)

So the existing JSON looks like

[{"DESCRIPTION":"Description of record","RECNO":"RECORDNumber"}, ... m
+ore records here ...]
[download]

the database query is

SELECT RECNO, DESCRIPTION
FROM RECORDS_TABLE
WHERE RECNO LIKE ?
[download]

Called with

$dbh->selectall_arrayref($query, { Slice => {} }, $SearchWord );
[download]

Is there a way I can change the query to return a structure required by this plugin, while including the additional field

"inputPhrase": $SearchWord
[download]

Comment on Re^2: Append JSON (from hashref) Select or Download Code

Replies are listed 'Best First'.
Re^3: Append JSON (from hashref) by Corion (Patriarch) on Apr 06, 2017 at 11:39 UTC
Yes. See perldsc on how to manipulate Perl data structures. You could either add your entry to the result directly, in your Perl code: `$tmp->[0]->{ 'inputPhrase' } = $SearchWord;` [download] ... or simply select the search phrase as another column: `SELECT RECNO, DESCRIPTION, ? as inputPhrase FROM RECORDS_TABLE WHERE RECNO LIKE ?` [download] `... $sth->execute( $SearchWord, $recno ); ...` [download]	[reply] [d/l] [select]
Re^4: Append JSON (from hashref) by Anonymous Monk on Apr 06, 2017 at 13:29 UTC
Thanks, but this first solution means inputPhrase is added in with the details of the first result `[{"DESCRIPTION":"Description of record","RECNO":"RECORDNumber", "input +Phrase":"RECORDNumber}, ... more records here` [download] and not outside of the list of results like in the json linked above (won't let me post with the URL here)	[reply] [d/l]
Re^5: Append JSON (from hashref) by Corion (Patriarch) on Apr 06, 2017 at 13:32 UTC
Ah, if you want a different structure, just create that structure. Consider writing your data structure in Perl - Perl looks very much like JSON, except that `:` is spelled `=>` in Perl.	[reply] [d/l] [select]
Re^6: Append JSON (from hashref) by Anonymous Monk on Apr 06, 2017 at 15:36 UTC
Re^7: Append JSON (from hashref) by Corion (Patriarch) on Apr 07, 2017 at 06:12 UTC
Re^7: Append JSON (from hashref) by huck (Prior) on Apr 06, 2017 at 15:51 UTC
Some notes below your chosen depth have not been shown here
Re^7: Append JSON (from hashref) by AnomalousMonk (Archbishop) on Apr 06, 2017 at 19:41 UTC
Re^3: Append JSON (from hashref) by huck (Prior) on Apr 06, 2017 at 11:37 UTC
like Corion said, add it to $tmp ~~`$tmp->{inputPhrase}=$SearchWord;`~~ ~~[download]~~ Then it will be converted to json just fine. Edit: Now im not paying enough attention, The hash is inside an array at `$tmp->[0]` See Re^3: Append JSON (from hashref)	[reply] [d/l] [select]