Skip to content

Instantly share code, notes, and snippets.

View mrjman's full-sized avatar

Jesse mrjman

6 followers · 1 following
  • Mondo Robot
  • Boulder
View GitHub Profile
@mrjman
mrjman / statistics.sql
Last active April 1, 2020 14:50 — forked from ruckus/statistics.sql
Postgres statistics queries
** Find commmonly accessed tables and their use of indexes:
SELECT relname,seq_tup_read,idx_tup_fetch,cast(idx_tup_fetch AS numeric) / (idx_tup_fetch + seq_tup_read) AS idx_tup_pct FROM pg_stat_user_tables WHERE (idx_tup_fetch + seq_tup_read)>0 ORDER BY idx_tup_pct;
Returns output like:
relname | seq_tup_read | idx_tup_fetch | idx_tup_pct
----------------------+--------------+---------------+------------------------
schema_migrations | 817 | 0 | 0.00000000000000000000
user_device_photos | 349 | 0 | 0.00000000000000000000
@mrjman
mrjman / array_validator.rb
Last active December 21, 2016 20:46
Validator for Rails array columns
# Usage:
#
# validates :array_column, array: { length: { is: 20 }, allow_blank: true }
# validates :array_column, array: { numericality: true }
#
# It also supports sliced validation
#
# validates :array_column, array: { presence: true, slice: 0..2 }
class ArrayValidator < ActiveModel::EachValidator
@mrjman
mrjman / gist:22a27208b89b2ef2bc7e
Last active August 29, 2015 14:06
SELECT motor_symptoms.description, profiles_motor_symptoms.id FROM motor_symptoms LEFT OUTER JOIN profiles_motor_symptoms ON motor_symptoms.id=profiles_motor_symptoms.motor_symptom_id WHERE profiles_motor_symptoms.profile_id=11;
SELECT description, profiles_motor_symptoms.id FROM motor_symptoms LEFT OUTER JOIN profiles_motor_symptoms ON profiles_motor_symptoms.motor_symptom_id=motor_symptoms.id;
@mrjman
mrjman / index.html
Last active August 29, 2015 14:05
jquery.scroll-nav plugin - scrolls to anchor on page and keeps track of active nav link
<!doctype html>
<html class="no-js">
<head>
<style>
a:hover {
color: green;
}
li.active {
color: red;
@mrjman
mrjman / simple_form_extensions.rb
Created August 26, 2014 14:50
module Builder
def collection_otherable_check_boxes(method, collection, value_method, text_method, options = {}, html_options = {}, &block)
SimpleForm::Tags::CollectionCheckBoxes.new(@object_name, method, @template, collection, value_method, text_method, objectify_options(options), @default_options.merge(html_options)).render(&block)
end
def collection_nested_versionable(method, collection, value_method, text_method, options = {}, html_options = {}, &block)
SimpleForm::Tags::CollectionCheckBoxes.new(@object_name, method, @template, collection, value_method, text_method, objectify_options(options), @default_options.merge(html_options)).render(&block)
end
end
@mrjman
mrjman / gist:5abea699d143c26c0520
Last active August 29, 2015 14:05
Export database from heroku and import locally
curl -o `date +"%Y%m%d%H%M%S"_BACKUPFILENAME.dump `heroku pgbackups:url --app APPNAME`
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U PGUSERNAME -d LOCALDBNAME BACKUPFILENAME.dump
@mrjman
mrjman / gist:7afaf0e20d8768782c82
Last active August 29, 2015 14:05 — forked from kalmbach/gist:4471560
Rake migration tasks for Sequel
namespace :db do
require "sequel"
Sequel.extension :migration
DB = Sequel.connect(ENV['DATABASE_URL'])
desc "Prints current schema version"
task :version do
version = if DB.tables.include?(:schema_info)
DB[:schema_info].first[:version]
end || 0
@mrjman
mrjman / test.rb
Last active August 29, 2015 14:04
require "net/http"
require "openssl"
cert_store = OpenSSL::X509::Store.new
cert_store.add_file 'certs/AddTrustExternalCARoot.crt'
cert_store.add_file 'certs/COMODORSAAddTrustCA.crt'
http = Net::HTTP.new('ume.michaeljfox.org', 8097)
#http = Net::HTTP.new('173.193.29.12', 11121)
@mrjman
mrjman / reset_sequences.rake
Created July 2, 2014 15:53
Reset PK sequences in Rails
ActiveRecord::Base.connection.tables.each do |table|
ActiveRecord::Base.connection.reset_pk_sequence!(table)
end
@mrjman
mrjman / font.scss
Last active August 29, 2015 14:03
Generic font handling in SASS
//
// mixin for bullet proof font declaration syntax
// pulled from: http://pivotallabs.com/bulletproof-font-face-syntax-with-sass/
//
// font-path is a rails helper which can be replaced with your font directory path
// when not using rails
//
@mixin declare-font-face($font-family, $font-filename, $font-weight: normal, $font-style: normal, $font-stretch: normal) {
@font-face {
font-family: '#{$font-family}';