Ivan Lawrence ivanlawrence

## loop_load_from_infile.sh
#!/usr/bin/bash
set -e

# Loops through a hardcoded list of dbs
# The hard coded parts are the db names since they need to exist, and the create table command is taken manually from the mysqldump

transform_files () {
        if ! [ -f ${file_src} ]
        then
                echo "file ${file_src} not found"

## gist:fd5363364db887f6e1cd33c385ba1a61
# But Why Though
A good article on how to do it with builtins
(https://www.roboleary.net/2021/11/06/vscode-you-dont-need-that-extension2.html)

# VSCode
## Default
Name: Dev Containers
Id: ms-vscode-remote.remote-containers
Description: Open any folder or repository inside a Docker container and take advantage of Visual Studio Code's full feature set.
Version: 0.327.0

## fooUtil.js
Object.defineProperty(window, 'foo', {
    enumerable: false,
    configurable: false,
    writable: false,
    value: (function() {
      function FooUtility() {};
        // a Pseudo constructor which makes some protected methods which protect things
          Object.defineProperties(FooUtility.prototype, {
            'version': { value: 2.0 },
            // The following allows us to build-up a function/object and control if the properties are overwrite-able or not

## jsPubSubObj.js
const jsPubSub = {

	subscriptions: {
		clearTopicSubscriptions(topic) {
			if (!this[topic]) return;
			return delete this[topic];
		},
	},


## JsPubSubClass.js
class JsPubSub {

	constructor() {
		this.subscriptions = {
			clearTopicSubscriptions(topic) {
				if (!this[topic]) return;
				delete this[topic];
			},
		};


## gist:5edd8a5fc49c10f7a7f6573f9607b4a1
javascript:(function(){
  let csv = []
  // loop through each row
  $('#tableform').find('tr').each(function() {
    let row = [];
    // loop through each cell in a row
    $(this).find('th,td').each(function() {
      // add to the row array
      row.push( '"' + $(this).text().trim() + '"' );
    });

## gist:57deb49a10a04c44fda2df0b298d1eb9
javascript:(function(){
  let csv = []
  // loop through each row
  $('#tableform').find('tr').each(function() {
    let row = [];
    // loop through each cell in a row
    $(this).find('th,td').each(function() {
      // add to the row array
      row.push( '"' + $(this).text().trim() + '"' );
    });

## joinObjs()
function joinObjs() {
    // loops through all arguments and joins them together
    const result = {};

    for (var i = 0, j = arguments.length; i < j; i++){
        Object.keys(arguments[i])
            .forEach(key => result[key] = arguments[i][key]);
    }

    return result;

## online local JS IDE
<!DOCTYPE html>
<html>
<head>
<title>Local JS IDE</title>
<script src="https://cdnjs.cloudflare.com/ajax/libs/ace/1.4.4/ace.js"></script>
<style>
html,body { margin:0; padding:0; height:100%; width:100%; overflow: hidden;}

#editor {
    height: 100%;

## gist:1c58be0fe64cad319b3ad5956f66715b
... and the next one... its me.
	#!/usr/bin/bash
	set -e

	# Loops through a hardcoded list of dbs
	# The hard coded parts are the db names since they need to exist, and the create table command is taken manually from the mysqldump

	transform_files () {
	if ! [ -f ${file_src} ]
	then
	echo "file ${file_src} not found"
	# But Why Though
	A good article on how to do it with builtins
	(https://www.roboleary.net/2021/11/06/vscode-you-dont-need-that-extension2.html)

	# VSCode
	## Default
	Name: Dev Containers
	Id: ms-vscode-remote.remote-containers
	Description: Open any folder or repository inside a Docker container and take advantage of Visual Studio Code's full feature set.
	Version: 0.327.0
	Object.defineProperty(window, 'foo', {
	enumerable: false,
	configurable: false,
	writable: false,
	value: (function() {
	function FooUtility() {};
	// a Pseudo constructor which makes some protected methods which protect things
	Object.defineProperties(FooUtility.prototype, {
	'version': { value: 2.0 },
	// The following allows us to build-up a function/object and control if the properties are overwrite-able or not
	const jsPubSub = {

	subscriptions: {
	clearTopicSubscriptions(topic) {
	if (!this[topic]) return;
	return delete this[topic];
	},
	},
	class JsPubSub {

	constructor() {
	this.subscriptions = {
	clearTopicSubscriptions(topic) {
	if (!this[topic]) return;
	delete this[topic];
	},
	};
	javascript:(function(){
	let csv = []
	// loop through each row
	$('#tableform').find('tr').each(function() {
	let row = [];
	// loop through each cell in a row
	$(this).find('th,td').each(function() {
	// add to the row array
	row.push( '"' + $(this).text().trim() + '"' );
	});
	function joinObjs() {
	// loops through all arguments and joins them together
	const result = {};

	for (var i = 0, j = arguments.length; i < j; i++){
	Object.keys(arguments[i])
	.forEach(key => result[key] = arguments[i][key]);
	}

	return result;
	<!DOCTYPE html>
	<html>
	<head>
	<title>Local JS IDE</title>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/ace/1.4.4/ace.js"></script>
	<style>
	html,body { margin:0; padding:0; height:100%; width:100%; overflow: hidden;}

	#editor {
	height: 100%;