danielfone

StandardError
  SQLite3::Exception
    SQLite3::MemoryException
    SQLite3::LockedException
    SQLite3::BusyException
    SQLite3::AbortException
    SQLite3::PermissionException
    SQLite3::InternalException
    SQLite3::SQLException
    SQLite3::NotADatabaseException

danielfone

# Get the file from https://datafinder.stats.govt.nz/layer/105158-urban-rural-2021-generalised/
# USAGE: ruby kml2geoguessr.rb urban-rural-2021-generalised.kml > rural-nz.geoguesser.json
require "nokogiri"
require "json"

TYPES = [
  # "Major urban area",
  # "Large urban area",
  "Medium urban area",
  "Small urban area",

danielfone

In order to get Rails to reload when you change a sql file in development, you need to add the query directory to the watchable_dirs hash.

# watchable_dirs is keyed by path with an array of extensions as the value
config.watchable_dirs['db/queries'] = [:sql]

Rails automatically adds the autoload paths to watchable dirs with an extension of [:rb]. This includes all the directories in app/. This will override any matching paths you add to watchable_dirs.

danielfone

reqTx = new Date();
await fetch("/now")
  .then((response) => {
    respRx = new Date();
    return response.text();
  })
  .then((d) => {
    rtt = respRx - reqTx;
    expected = new Date(respRx - rtt / 2);
    serverTime = new Date(d);

danielfone

# ruby 2.2.2
# activerecord 4.2.3
# aasm 4.2.0

require 'active_record'
require 'aasm'

# Setup a mock AR table
ActiveRecord::Migration.verbose = false
ActiveRecord::Base.establish_connection(:adapter => "sqlite3", :database => ":memory:")

danielfone

# config/initializers/devise_safe_store_location.rb
module SafeStoreLocation

  MAX_LOCATION_SIZE = ActionDispatch::Cookies::MAX_COOKIE_SIZE / 2

  def store_location_for(resource_or_scope, location)
    super unless location && location.size > MAX_LOCATION_SIZE
  end

end

danielfone

create table enrolments (
  id serial PRIMARY KEY,
  organisation_name text
)

-- Let's say we want to partition our table into pages of 50 rows
-- and sorted alphabetically.
with
dist as (
  select

danielfone

with recursive

  -- extract all the messages as rows from the several `conversations.history`
  -- API responses in the `slack_history` table
  messages as (
    select jsonb_array_elements(response->'messages') as message from markov.slack_history
  ),
  
  -- remove @heres, @names, exclude bot messages, etc
  cleaned_messages as (

danielfone

#!/usr/bin/env ruby -w

require 'time'
require 'json'

#
# Helper methods
#
module Enumerable
  def mean(method=:self)

danielfone

-- This is a constant time query for authenticating password-based credentials
-- The key is that the bcrypt work is done whether or not the user key (email)
-- matches so the query takes the same time whether or not there was a matching
-- record. In this example, the supplied credentials are:
-- `admin@example.com` / `password`

-- This was written for postgres with pgcrypto

with