Skip to content

Instantly share code, notes, and snippets.

View glittershark's full-sized avatar
🏳️‍⚧️

Aspen Smith glittershark

🏳️‍⚧️
View GitHub Profile

Keybase proof

I hereby claim:

  • I am glittershark on github.
  • I am glittershark (https://keybase.io/glittershark) on keybase.
  • I have a public key whose fingerprint is 0F11 A989 879E 8BBB FDC1 E236 44EF 5B5E 861C 09A7

To claim this, I am signing this object:

@glittershark
glittershark / mock_geocoder.rb
Last active April 12, 2019 09:04 — forked from paveltyk/mock_geocoder.rb
Mock geocoding in Rspec, using the new 'expect' syntax
# In spec_helper:
# RSpec.configure do |config|
# ...
# config.include(MockGeocoder)
# end
#
# In your tests:
# it 'mock geocoding' do
# # You may pass additional params to override defaults
# # (i.e. :coordinates => [10, 20])
@glittershark
glittershark / gist:7267851
Created November 1, 2013 16:21
500 points to the one who can figure out what this regex does
6,14s/^\s*'\(.\{-}\)'\s*=> ['"]\(.*\)['"]\(,\{,1}\)/\2 AS \1\3
@glittershark
glittershark / terrible.py
Created November 1, 2013 00:53
Intentionally terrible script made for an interview. The subject is asked to fix the script up, and add the functionality for the user to specify a specific file extension to copy.
import os
for index_variable in range(len(os.listdir('.'))):
if os.listdir('.')[index_variable][os.listdir('.')[index_variable].find('.'):] == '.txt':
print "found text file"
import shutil
import sys
shutil.copyfile('./' + os.listdir('.')[index_variable], sys.argv[1] + '/' + os.listdir('.')[index_variable])
for i in range(len(sys.argv) - 2):
if sys.argv[i + 2] == '--and':
shutil.copyfile('.' + os.listdir('.')[index_variable], sys.argv[i + 3])
@glittershark
glittershark / tsvector_agg.sql
Created August 20, 2013 19:42
Postgresql aggregate function for tsvectors
CREATE OR REPLACE FUNCTION concat_tsvectors(tsv1 tsvector, tsv2 tsvector)
RETURNS tsvector AS $$
BEGIN
RETURN coalesce(tsv1, to_tsvector('default', ''))
|| coalesce(tsv2, to_tsvector('default', ''));
END;
$$ LANGUAGE plpgsql;
CREATE AGGREGATE tsvector_agg (
BASETYPE = tsvector,