Skip to content

Instantly share code, notes, and snippets.

View kickingvegas's full-sized avatar

Charles Choi kickingvegas

View GitHub Profile
@kickingvegas
kickingvegas / cc-org-table-to-sql.org
Last active March 28, 2024 22:33
Org Code Block cc/org-table-to-sqlite

cc/org-table-to-sqlite

Org Babel code block to import an Org table into an in-memory SQLite DB to enable SQL queries on aforementioned table.

Parameters

  • table : Org table object The Org table object is referenced via the #+NAME value assigned to the table. The table must have a header row identifying each column. This name value must be a SQL-legal name.
  • table-name : string Name of table in string form. It must be identical to the name of the table parameter above.
@kickingvegas
kickingvegas / cc-timestamp.el
Created November 30, 2022 19:50
Posix / Human Timestamp Elisp (quick and dirty)
(defun cc/posix-timestamp-to-human (start end)
(interactive "r")
(if (use-region-p)
(let ((regionp (buffer-substring start end)))
(set 'inputTime (time-convert (string-to-number regionp)))
(set 'inputBuf (number-to-string (string-to-number regionp)))
(set 'rfcBuf (format-time-string "%a, %e %b %Y %H:%M:%S %z" inputTime))
(set 'isoBuf (format-time-string "%Y-%m-%dT%H:%M:%S%z" inputTime))
(with-output-to-temp-buffer "*timestamps*"
(princ (concat "| POSIX | " inputBuf " |\n"))
(cl-defun chance (&key (win "You win.") &key (lose "You lose."))
(interactive)
(message (if (<= (* 100 (cl-random 1.0)) (read-number "Chance (%): ")) win lose))
)
@kickingvegas
kickingvegas / apollo11milestones.py
Created July 19, 2019 06:44
Apollo 11 in Real-TIme Mission Milestones in Local Time Python3 Script
#!/usr/bin/env python3
# Copyright 2019 Charles Choi
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
@kickingvegas
kickingvegas / gist:5250677
Created March 27, 2013 00:54
pelican feed settings.
FEED_DOMAIN = u'http://yummymelon.com/devnull'
FEED_ATOM = u'feeds/main.xml'
FEED_ALL_ATOM = u'feeds/all.atom.xml'
@kickingvegas
kickingvegas / parsePosterous.py
Created February 22, 2013 20:30
Python script to parse Posterous API JSON for user posts which generates a Markdown entry with Pelican metadata tags and downloads all media image assets associated with the post. This is functional yet nowhere near production/release level code.
#!/usr/bin/env python
# Copyright 2012 Yummy Melon Software LLC
# Author: Charles Y. Choi
#
import os
import sys
import getopt
import subprocess
import shutil
#!/bin/bash
echo '**' `date` >> $HOME/Documents/journal/journal.txt
emacs -nw +10000000 $HOME/Documents/journal/journal.txt
- (UITextRange *)rangeForWordAtPoint:(CGPoint p) {
UITextPosition *position = [_textView closestPositionToPoint:p];
UITextRange *range =
[_textView rangeEnclosingPosition:position
withGranularity:UITextGranularityWord
inDirection:UITextLayoutDirectionForward];
// UITextStorageDirectionForward, not UITextStorageDirectionRight!
return range;
}
- (NSArray *)allKeys {
NSMutableArray *result;
NSMutableArray *classList;
classList = [[NSMutableArray alloc] init];
result = [[NSMutableArray alloc] init];
Class cls = [self class];
Class nsObjectClass = [NSObject class];
@kickingvegas
kickingvegas / gist:1930417
Created February 28, 2012 07:39
UI Automation Example Comments
Please note any comments about the UI Automation Example.
https://github.com/kickingvegas/UI-Automation-Example/blob/gh-pages/uiautomation.md