is there any possiblity to add stream result on "connection.transaction" ?

[behroozshafiabadi]

i use multi select query to get data. now i want to use streams to pipe results...i must to use stream result in any sub query or i can use it with whole transaction?

[sagiegurari]

multi select? can you show me a small code snippet so i'll understand what you mean?

[behroozshafiabadi]

some code like your code sample transaction that execute queries in pharallel! connection.transaction([ function insertSomeRows(callback) { connection.insert(...., function (error, results) { //some more inserts.... connection.insert(...., callback); }); }, function insertSomeMoreRows(callback) { connection.insert(...., callback); }, function doSomeUpdates(callback) { connection.update(...., callback); }, function runBatchUpdates(callback) { connection.batchUpdate(...., callback); } ], function onTransactionResults(error, output) { //continue flow... });

[sagiegurari]

please format it using github markdown, because I can't read it.

[sagiegurari]

wait... so you mean multiple connection.query? if so, there is no stream for connection.transaction/connection.run only to connection.query. so multiple streams. also if you are not doing any update/insert so you don't need a transaction, you can use connection.run instead of connection.transaction