Mark Biggers biggers

## sshfs_ubuntu_fsys.sh
#!/bin/bash

# MacOS *specific*, 'sshfs' remote-mounts
# - tested on MacOS catalina; latest MacOS Fuse & sshfs
# - 10-02-2021 Sat

# NOTE:
# sudo mkdir -p /private/ssh  # and do a 'chmod, chgrp'...
#   drwxrwsr-x  5 root  admin  160 Oct  2 08:32 /private/ssh/
# - install, MacOS FUSE, sshfs from https://osxfuse.github.io/

## git-fetchall.sh
#!/bin/sh

# "git fetch all branches" -- to your local-repo

## to RUN-ME:

## git branch -r | sed -r -e 's:origin/::g' -e '/^\s+HEAD/d' | egrep -v gerrit/ > /tmp/foo
# ... gives you a chance, to change the "temp list of Branches to fetch"

## cat /tmp/foo ## hand-edit, if needed

## csvs_db_insert.py
import pymysql.cursors
import os
from attrdict import AttrDict
import sys
from datetime import datetime as dt

# Insert all /var/tmp/*/"CSV summary-reports" into MySQL - using Py DB-API
# NOTE: schema for the table must have been already created!
#
# INSTALL:

## bashrc.win.sh
# /home/mabigger/.bashrc.win   -*-sh-*-

# ---- References
# https://nickjanetakis.com/blog/setting-up-docker-for-windows-and-wsl-to-work-flawlessly
# https://sourceforge.net/projects/vcxsrv/

CEC=mabigger

sudo mount --bind /mnt/c /c

## peewee_pets_quickstart.py
# Refs:
#   (primary) http://peewee.readthedocs.io/en/latest/peewee/quickstart.html
#   https://peewee.readthedocs.io/en/2.0.2/peewee/cookbook.html

from datetime import date
import peewee
from peewee import (  # noqa: F401
    MySQLDatabase,
    Model,
    BooleanField,

## torpeewee_ex01.py
# -*- coding: utf-8 -*-
# REWORKED by biggers@utsl.com, from:
# 16/7/7
# create by: snower

import datetime
from tornado import gen
from tornado.ioloop import IOLoop
from torpeewee import (
    Model,

## .bashrc.macos
# you can omit the first (2) entries...

export PATH="$HOME/bin:/usr/local/bin:/usr/local/sbin:/usr/sbin::/sbin:/usr/bin:/bin"

export PATH=/Applications/Emacs.app/Contents/MacOS:$PATH

# 'virtualenvwrapper' support
export WORKON_HOME=$HOME/.virtualenvs
export VIRTUALENVWRAPPER_SCRIPT=/usr/local/bin/virtualenvwrapper.sh
source /usr/local/bin/virtualenvwrapper.sh

## py_rotate_log_dict_config.py
import sys
import logging
import logging.config
import random
import string


# "thank you" to folks on StackOverflow.com for various ideas,
# for this example.  Works with Python3.

## sqlalchemy_mysql_insert_performance.py
# CREATE USER 'example'@'localhost' IDENTIFIED BY 'example_password';
# GRANT ALL PRIVILEGES ON *.* TO 'example'@'localhost' IDENTIFIED BY 'example_password';
# CREATE DATABASE example;
import sys
import os
import time
from datetime import date, timedelta
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String,  create_engine
from sqlalchemy.dialects.mysql import DATETIME, DATE

## tcpclient.py
import time
import logging
from tornado.options import options, define
from tornado import gen
from tornado.tcpclient import TCPClient
from tornado.iostream import StreamClosedError
from tornado.ioloop import IOLoop

define("host", default="127.0.0.1", help="TCP server host")
define("port", default=9888, help="TCP port to connect to")
	#!/bin/bash

	# MacOS specific, 'sshfs' remote-mounts
	# - tested on MacOS catalina; latest MacOS Fuse & sshfs
	# - 10-02-2021 Sat

	# NOTE:
	# sudo mkdir -p /private/ssh # and do a 'chmod, chgrp'...
	# drwxrwsr-x 5 root admin 160 Oct 2 08:32 /private/ssh/
	# - install, MacOS FUSE, sshfs from https://osxfuse.github.io/
	#!/bin/sh

	# "git fetch all branches" -- to your local-repo

	## to RUN-ME:

	## git branch -r \| sed -r -e 's:origin/::g' -e '/^\s+HEAD/d' \| egrep -v gerrit/ > /tmp/foo
	# ... gives you a chance, to change the "temp list of Branches to fetch"

	## cat /tmp/foo ## hand-edit, if needed
	import pymysql.cursors
	import os
	from attrdict import AttrDict
	import sys
	from datetime import datetime as dt

	# Insert all /var/tmp/*/"CSV summary-reports" into MySQL - using Py DB-API
	# NOTE: schema for the table must have been already created!
	#
	# INSTALL:
	# /home/mabigger/.bashrc.win --sh--

	# ---- References
	# https://nickjanetakis.com/blog/setting-up-docker-for-windows-and-wsl-to-work-flawlessly
	# https://sourceforge.net/projects/vcxsrv/

	CEC=mabigger

	sudo mount --bind /mnt/c /c
	# Refs:
	# (primary) http://peewee.readthedocs.io/en/latest/peewee/quickstart.html
	# https://peewee.readthedocs.io/en/2.0.2/peewee/cookbook.html

	from datetime import date
	import peewee
	from peewee import ( # noqa: F401
	MySQLDatabase,
	Model,
	BooleanField,
	# -- coding: utf-8 --
	# REWORKED by biggers@utsl.com, from:
	# 16/7/7
	# create by: snower

	import datetime
	from tornado import gen
	from tornado.ioloop import IOLoop
	from torpeewee import (
	Model,
	# you can omit the first (2) entries...

	export PATH="$HOME/bin:/usr/local/bin:/usr/local/sbin:/usr/sbin::/sbin:/usr/bin:/bin"

	export PATH=/Applications/Emacs.app/Contents/MacOS:$PATH

	# 'virtualenvwrapper' support
	export WORKON_HOME=$HOME/.virtualenvs
	export VIRTUALENVWRAPPER_SCRIPT=/usr/local/bin/virtualenvwrapper.sh
	source /usr/local/bin/virtualenvwrapper.sh
	import sys
	import logging
	import logging.config
	import random
	import string


	# "thank you" to folks on StackOverflow.com for various ideas,
	# for this example. Works with Python3.
	# CREATE USER 'example'@'localhost' IDENTIFIED BY 'example_password';
	# GRANT ALL PRIVILEGES ON . TO 'example'@'localhost' IDENTIFIED BY 'example_password';
	# CREATE DATABASE example;
	import sys
	import os
	import time
	from datetime import date, timedelta
	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy import Column, Integer, String, create_engine
	from sqlalchemy.dialects.mysql import DATETIME, DATE
	import time
	import logging
	from tornado.options import options, define
	from tornado import gen
	from tornado.tcpclient import TCPClient
	from tornado.iostream import StreamClosedError
	from tornado.ioloop import IOLoop

	define("host", default="127.0.0.1", help="TCP server host")
	define("port", default=9888, help="TCP port to connect to")