Skip to content

Instantly share code, notes, and snippets.

Mark Biggers biggers

Block or report user

Report or block biggers

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@biggers
biggers / csvs_db_insert.py
Last active Mar 3, 2019
insert a set of CSVs (spreadsheets, "raw") into a MySQL DB - Python3 example (DB API; generators; PyMySQL)
View 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:
@biggers
biggers / bashrc.win.sh
Created Dec 27, 2018
"bootstrap" bashrc for a WSL (Windows 10) and Docker workflow
View 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
@biggers
biggers / peewee_pets_quickstart.py
Last active Aug 6, 2018
"pets" example from peewee "quickstart" / documentation
View 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,
@biggers
biggers / gosmacs.el
Created Jun 30, 2018
favorite Gosling Emacs keybindings, once shipped with GNU Emacs -- probably not any more
View gosmacs.el
;;; gosmacs.el --- rebindings to imitate Gosmacs.
;; Copyright (C) 1986 Free Software Foundation, Inc.
;; Maintainer: FSF
;; Keywords: emulations
;; This file is part of GNU Emacs.
;; GNU Emacs is free software; you can redistribute it and/or modify
@biggers
biggers / torpeewee_ex01.py
Last active May 18, 2018
torpeewee -- fixed example from torpeewee/README.rst -- async peewee for Tornado
View 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,
@biggers
biggers / .bashrc.macos
Created Jan 9, 2018
.bashrc additions, for virtualenvwrapper and Python3 from Python.org
View .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
@biggers
biggers / py_rotate_log_dict_config.py
Created Dec 19, 2017
Python3 rotating log-file configuration via "config.dictConfig"
View 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.
@biggers
biggers / tcpclient.py
Last active Jan 2, 2018
"continously-running" Tornado TCP client example -- sends to 'tornado/demos/tcpecho/server.py'
View 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")
@biggers
biggers / recipe-pyenv.sh
Created Sep 26, 2017
shell-recipe for pyenv install of Python 3.6.2 on CentOS / Redhat 6.7
View recipe-pyenv.sh
# REF: https://github.com/pyenv/pyenv/blob/master/README.md
# ... building Python 3.6.2 on Bastion, "locally"
# yum install [Python3 build pre-reqs, on CentOS 6.7]
curl -L https://raw.githubusercontent.com/pyenv/pyenv-installer/master/bin/pyenv-installer | bash
tee -a $HOME/.bash_profile <<EOF
export PATH="\$HOME/.pyenv/bin:\$PATH"
eval "\$(pyenv init -)"
@biggers
biggers / py_syslog_dict_config.py
Last active Dec 19, 2017
Python dictConfig logging example using SyslogHandler - modified from Stackoverflow answer
View py_syslog_dict_config.py
import logging
import sys
from logging import config
# REF, modified from:
# https://stackoverflow.com/a/19367225
if sys.platform == "darwin":
address = '/var/run/syslog'
facility = 'local1'
You can’t perform that action at this time.