S C P s-c-p

Hobbyist python programmer. Mechanical engineer.

s-c-p / 2-way-py-sqlite

Last active July 15, 2017 15:11

2 way binding for codec-like behavior connecting python and sqlite

	import time
	import sqlite3
	import datetime

	sqlite3.register_adapter(float, py2sql)
	sqlite3.register_converter("pyTS", sql2py)

	py2sql = lambda unix_epoch: str(datetime.datetime.fromtimestamp(unix_epoch))

	sql2py = lambda strTime: datetime.datetime.timestamp(

s-c-p / reducedDateRepresentation.py

Created March 26, 2017 11:52

An algorithm that assigns unique (values) hashes to all dates in an year.

	import time, json

	big = ["January", "March", "May", "July", "August", "October", "December"]
	small = ["April", "June", "September", "November"]


	class DateHasher(object):
	""" duh... """
	def __init__(self, dayMultiplier=12, monthMultiplier=31):
	self.dayMultiplier = dayMultiplier