Rob Parham Pamblam

Note: This is posted as an answer to a StackOverflow question. Keeping it here for my own convenience.

I wanted a safer, more robust solution that didn't involve fully tokenizing query. Based on my experience writing SQL parsers (here, and here), I can say this solution is pretty bulletproof without having to use a full-featured query parser.

This is the best answer because:

It does not require a new SQL user with limited permissions
It does not require a new DB connection with limited permissions
It does not break if the query contains a string or a comment with the word "delete"
It allows complex queries with nested queries

Switching a repo from http to ssh

Check for existing keys

ls -al ~/.ssh

Generate new key (substitute email)

ssh-keygen -t rsa -b 4096 -C "[email protected]"

	# Converting Audible AAX files to M4B Audiobook files, split into chapters and decrypted
	# Get activation bits here for now: https://audible-converter.ml

	SHORTNAME='BeautifulYou'
	AAXFILE='/Users/rob/Downloads/BeautifulYou_ep6.aax'
	ACTIVATION_BYTES='2758110a'

	# These files don'e exist yet, we just need to tell the script where to create them.
	DATAFILE='/Users/rob/Desktop/audible-conv/data.json'
	METADATAFILE='/Users/rob/Desktop/audible-conv/data.tmp'

	[
	{
	"class": "fab fa-500px",
	"text": "500px"
	},
	{
	"class": "fab fa-accessible-icon",
	"text": "Accessible Icon"
	},
	{

	class fpParser{

	public $path;
	public $basename;
	public $basename_noext;
	public $basename_noext_noiteration;
	public $extention;
	public $directory_sep;
	public $dir_tree;
	public $iteration;


	var img = document.getElementById('guage');
	var percentDisplay = 73;
	makeAnimatedGuage(img, percentDisplay);

	function makeAnimatedGuage(img, percentDisplay, line_width = 10, guage_width = 500, font_size = 20, font_face = 'Arial'){

	var current_pct = 0;
	var target_pct = 65;
	img.src = makeGuage(current_pct);

	/**
	* Given a URL for a JS or CSS file, this function will
	* load the asset and return a Promise which will reject
	* on error or resolve when the asset is loaded.
	*/
	function loadAsset(url){
	return new Promise(async (resolve, reject)=>{
	var asset;
	if(url.trim().substr(-3).toLowerCase() === '.js'){
	asset = document.createElement('script');

	/**
	* Generate an image of text
	* @param {String} text - The text to convert to an image
	* @param {Object} options - The rendering options of the text and image
	* @property {String} options.color - The color of the text
	* @property {Number} options.font_size - The size of the text in pixels
	* @property {String} options.font_face - The font face to use
	* @property {String} options.font_style - The font style (normal\|italic\|oblique\|initial\|inherit)
	* @property {String} options.font_variant - The font variant (normal\|small-caps\|initial\|inherit)
	* @property {String\|Number} options.font_weight - The font weight (normal\|bold\|bolder\|lighter\|number\|initial\|inherit)

	(async function(d){
	console.clear();
	const styles = [];
	const stylesheets = d.querySelectorAll("link[rel='stylesheet'][href]");
	// get all stylesheet urls
	const stylesheet_urls = [...stylesheets].map(s=>s.href);
	// fetch the contents of the stylesheets
	const ss_promises = stylesheet_urls.map(href=>{
	return fetch(href).then(s=>s.text()).then(s=>{
	return {