Skip to content

Instantly share code, notes, and snippets.

View shofetim's full-sized avatar

Jordan Schatz shofetim

26 followers · 9 following
View GitHub Profile
@shofetim
shofetim / pg.rs
Last active October 15, 2025 18:05
Rust BB8
use std::net::IpAddr;
use std::sync::OnceLock;
use anyhow::{Context, Result};
use bb8_postgres::PostgresConnectionManager;
use bb8_postgres::bb8::{Pool, PooledConnection};
use tokio_postgres::types::ToSql;
use tokio_postgres::{NoTls, Row, ToStatement};
use postgres_native_tls::MakeTlsConnector;
use native_tls::TlsConnector;
@shofetim
shofetim / report.sql
Created February 17, 2020 21:11
Guild Report
with work_history as (
select
distinct on (profile_id)
profile_id,
created_at
from profiles_workhistory
where finalized = true
order by profile_id, created_at asc, id
), verification as (
select
@shofetim
shofetim / query.sql
Created January 31, 2020 14:01
CBP Clients
select
id,
casenumber,
client__r.firstname,
client__r.lastname
from case
where
status != 'Closed'
and client__c != null
and client__r.recordtypeid in ('01241000000yZEzAAM', '01241000001YbAWAA0')
@shofetim
shofetim / gist:18a9bcb366c36b4915470eb1d5d234dc
Created January 22, 2019 04:40
var Comment = {
oninit: function (vnode) {
this.comment = vnode.attrs;
},
view: function () {
var item, extra, that;
that = this;
item = this.comment;
if (item.children.length == 0) {
return m("li", {key: item.id}, [
@shofetim
shofetim / script.js
Created December 7, 2017 20:28
"use strict";
var log = function(msg) {
console.log(msg);
};
var SelectWidget = {},
App = {},
path = [],
data = {
phone: {
@shofetim
shofetim / boundary_scanner.md
Created July 3, 2017 22:17

My mappings:

{
  "abstract": {
    "type": "text",
    "term_vector": "with_positions_offsets"
  },
  "app_country": {
    "type": "text",
@shofetim
shofetim / result.js
Created June 23, 2017 19:52
function parseLabel(label, r) {
const res = r || [];
res.push(label.label_name.replace(/[,\s]+$/g, '').trim())
if (label.label_child) {
parseLabel(label.label_child, res)
}
return res.join(', ');
}
classifications = parseLabel(result._source.classifications[0])
@shofetim
shofetim / index.php
Created June 22, 2017 23:59
<?php
#exit;
#$ua=$_SERVER['HTTP_USER_AGENT'];
#if ($ua == 'GuzzleHttp/6.2.0 curl/7.35.0 PHP/5.5.9-1ubuntu4.17') {
#header($_SERVER["SERVER_PROTOCOL"]." 404 Not Found");
#header("Status: 404 Not Found");
#$_SERVER['REDIRECT_STATUS'] = 404;
#exit;
@shofetim
shofetim / index.js
Created March 30, 2017 06:46
var https = require('https'),
http = require('http'),
url = require('url'),
restify = require('restify'),
FeedParser = require('feedparser'),
log = console.log.bind(console);
var get = (str, callback) => {
var handler = res => callback(res),
endpoint = url.parse(str),
@shofetim
shofetim / bobosales-backup.sh
Created March 15, 2017 04:56
export PGPASSWORD=redacted
export AWS_ACCESS_KEY_ID=redacted
export AWS_DEFAULT_REGION=us-west-2
export AWS_SECRET_ACCESS_KEY=redacted
pg_dump -h shops-ksl-com.cxpx7kkpqtcv.us-west-2.rds.amazonaws.com -U redacted redacted | gzip | mpipe ~~/stor/bobosales/`date +%Y-%m-%d`-backup.sql.gz
easy_install-2.7 awscli
aws s3 sync s3://images.bobosales.com/ images/
tar -cf images.tar images
gzip images.tar
mput -f images.tar.gz ~~/stor/bobosales/images.tar.gz