Larry Staton Jr. statonjr

statonjr / app.rb

Created February 11, 2025 20:58 — forked from bbonamin/app.rb

Rails CSV report streaming

	# From https://shift.infinite.red/fast-csv-report-generation-with-postgres-in-rails-d444d9b915ab
	# Storing here in case the original post ever goes down.

	# concern
	module DatabaseQueryStreaming

	def stream_query_rows(sql_query, options="WITH CSV HEADER")
	conn = ActiveRecord::Base.connection.raw_connection
	conn.copy_data "COPY (#{sql_query}) TO STDOUT #{options};" do
	while row = conn.get_copy_data

statonjr / machine.js

Created December 4, 2020 14:36

Generated by XState Viz: https://xstate.js.org/viz

statonjr / SketchSystems.spec

Created September 24, 2020 21:26

Mode

	Mode
	appOffline*
	checkingAPI
	apiOnline -> online
	apiOffline -> checkingInternet
	checkingInternet
	internetOnline -> online
	internetOffline -> offline
	online
	offline

statonjr / machine.js

Last active September 24, 2020 19:52

Generated by XState Viz: https://xstate.js.org/viz

	const checkGlobalAPI = (context, event) => {
	return new Promise((resolve, reject) => {
	let condition = Math.round(Math.random() * 10) > 8;
	console.log(condition);
	if (condition) {
	resolve(42)
	} else {
	reject('foo')
	}
	});

statonjr / SketchSystems.spec

Created November 20, 2019 20:44 — forked from lynaghk/SketchSystems.spec

Search Bar*

statonjr / 1_initial_migration.rb

Created September 8, 2019 20:29 — forked from wrburgess/1_initial_migration.rb

Setting up UUID columns for Rails 5+ models utilizing Postgres 9.4+

	class InitialMigration < ActiveRecord::Migration[5.0]
	def change
	enable_extension "pgcrypto" unless extension_enabled?("pgcrypto")
	end
	end

statonjr / SketchSystems.spec

Last active November 20, 2019 20:39

Onboarding*

statonjr / SketchSystems.spec

Last active December 23, 2018 13:51

statonjr / SketchSystems.spec

Last active September 19, 2018 12:31

Darcie*

statonjr / SketchSystems.spec

Created July 18, 2018 20:58

Client Registration