macool’s gists

macool / eicar-std-av-test.txt

Created June 25, 2022 06:23

X5O!P%@AP[4\PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H*

macool / users_list.txt

Last active November 29, 2017 00:40

	Apellido1 Apellido2 Nombre1
	Apellido1 Apellido3 Nombre2
	Apellido1 Apellido4 Nombre1
	Peter González Parker
	Peter González Parker

macool / test.csv

Last active May 17, 2017 05:05

	descripcion	tags
	prueba uno	tag1,tag2

macool / psql_encoding.sql

Created November 16, 2015 00:46 — forked from turboladen/psql_encoding.sql

Script for dealing with creating Postgres databases that complain with: ``` PG::InvalidParameterValue: ERROR: encoding UTF8 does not match locale en_US DETAIL: The chosen LC_CTYPE setting requires encoding LATIN1. ``` ...when trying to create the production DB. Taken from: http://stackoverflow.com/questions/13115692/encoding-utf8-does-not-match-…

	sudo su postgres

	psql

	update pg_database set datistemplate=false where datname='template1';
	drop database Template1;
	create database template1 with owner=postgres encoding='UTF-8'
	lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;

	update pg_database set datistemplate=true where datname='template1';

macool / gauges-with-turbolinks.js

Created September 5, 2015 18:08

gauges to work with turbolinks on rails

	var _gauges = _gauges \|\| [];
	$(document).on("ready", function() {
	var SITE_ID = '****';

	var t = document.createElement('script');
	t.type = 'text/javascript';
	t.async = true;
	t.id = 'gauges-tracker';
	t.setAttribute('data-site-id', SITE_ID);
	t.setAttribute('data-track-path', 'https://track.gaug.es/track.gif');

macool / facebook_sdk.js.coffee

Created August 23, 2015 19:17

make facebook sdk work with turbolinks on rails 4

	appId = *******

	$ ->
	loadFacebookSDK()
	bindFacebookEvents() unless window.fbEventsBound

	bindFacebookEvents = ->
	$(document)
	.on('page:fetch', saveFacebookRoot)
	.on('page:change', restoreFacebookRoot)

macool / queries.sql

Last active August 29, 2015 14:14

Foodbank vouchers query results

	/* Original query */
	SELECT CONCAT(clientFirstName, clientLastName) AS fullName, count(*) AS ocurrences
	FROM vouchers
	WHERE vouchers.date BETWEEN "2011-01-01" AND "2011-12-31"
	GROUP BY fullName
	HAVING count() >= 2 AND count() <= 20
	/* taking ~457ms */
	/* for 2012: ~1.79s */
	/* for 2013: ~5.24s */
	/* for 2014: ~2.63s */

macool / terminal output

Created February 4, 2015 21:48

travis vm debugging sxt specs

	travis@debug-hs-12736-matthewford-ruby-1423060806:~/bitzesty/sxt$ bundle install --without development deployment --jobs=3 --retry=3
	Fetching source index from https://rubygems.org/
	Fetching git://github.com/joshk/bitly.git
	Fetching git://github.com/bitzesty/clickatell.git
	Fetching https://github.com/dmgarland/jcarousel-rails.git
	Fetching https://github.com/getsentry/raven-ruby.git
	Installing Platform 0.4.0
	Installing rake 10.3.2
	Installing i18n 0.7.0
	Installing multi_json 1.10.1

macool / base.rb

Created November 27, 2014 20:23

	def material_pictograms_for_region(region)
	return "" unless material.pictograms_of(region).present?
	hazard_pictograms = []
	pictograms_path = Rails.root.join("app/assets/images/hazard-pictograms/")
	image_names = Dir[pictograms_path + "*.png"].map { \|f\| f.split("/").last }
	image_names.map! {\|n\| File.basename(n,File.extname(n)) } # remove png extension
	image_names = image_names.sort.reverse # so that we select latest coincidence
	material.pictograms_of(region).map { \|pic\|
	pic.image_name if pic.image_name.present?
	}.compact.map { \|pictogram_name\|

macool / gist:cb80c634b8a5ce37208f

Last active August 29, 2015 14:00

spec

	describe 'If a geographical area has a parent geographical area group then the
	validity period of the parent geographical area group must span the validity
	period of the geographical area' do
	describe "GA5" do
	let(:geographical_area) {
	build(:geographical_area,
	validity_end_date: Date.today,
	parent_geographical_area_group_sid: parent_id)
	}

Mario Andrés macool