Trying to access Places.SQLite database with SQLite.jsm

... from within FireFox Browser Console

by SSRRDD

JavaScript

(async function()
{
Components.utils.import("resource://gre/modules/Sqlite.jsm");
try
{
	const conn = await Sqlite.openConnection({ path: "places.sqlite", sharedMemoryCache: false });
	let names = [], name,
		statement = "SELECT name FROM moz_anno_attributes";
	try
	{
	  const result = await conn.executeCached(statement, null, function(row, cancel)
	  {
		name = row.getResultByName("name");
		names.push({name: name});
	  });
	}
	catch (err)
	{
	  console.log('TEST inner error', err);
	  if (callbackError)
	  {
		callbackError(err);
	  }
	}

	console.log(result);
	if (callback)
	{
	  callback(null, names);
	}
	
	await conn.close();  
}
catch (error)
{
  console.log('TEST error', error);
}
})()