sqlite3 multiple rows to a more formatted object.

organizedSqlite3Results.js

/// PLEASE NOTE THIS WORKS ONLY FOR TABLES WITH 2 COLUMNS

/**
* Lets say you have a database table that has some settings for a web application,
* that has two columns: option, and value, and you need to retrieve those settings.
* The way node-sqlite3 returns them is like the following
* QUERY: SELECT * FROM users WHERE option IN ('servername', 'serveradmincontact', 'loginenabled')
**/
results = [
  { option: 'servername', value: 'BlogApp' },
  { option: 'serveradmincontact', value: '[email protected]' },
  { option: 'loginenabled', value: '1' }
]

/**
* What the following code snippet does, is loop over each row, and take the
* first column and second column, and make that a new pair, then adds it to a new object.
* to put it in better words, it takes the option and value, and makes that a new pair
**/

let formattedResults = {}
results.forEach(row => {
  a = row.option;
  b = row.value;
  newvalues[a] = b
});

// The formatted results now look like the following

formattedResults = {
  'servername': 'BlogApp',
  'serveradmincontact': '[email protected]`,
  'loginenabled': '1'
}