Jordan Schatz shofetim

Software engineer, several times CTO, DevOps consultant, writer, and building something new.

shofetim / azure.md

Created May 13, 2015 17:33

shofetim / Dockerfile.txt

Created April 13, 2015 23:13

	# ┌────────────────────────────────────────────────────────────────────┐
	# │ Docker container with node, npm, grunt, and bower. │
	# └────────────────────────────────────────────────────────────────────┘

	FROM node:0.10

	ENV DEBIAN_FRONTEND noninteractive

	RUN apt-get update

shofetim / error.html

Created April 8, 2015 22:58

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
	<head>
	<script src="//ajax.googleapis.com/ajax/libs/jquery/1.6.2/jquery.min.js"></script>
	<script>window.jQuery \|\| document.write('<script src="https://static.azurestandard.com/better500s/js/jquery-1.6.2.min.js"><\/script>')</script>
	<script type="text/javascript" charset="utf-8">
	$(function() {

	$.ajax({

shofetim / fig.yml

Created March 24, 2015 00:13

	bhv:
	image: azurestandard/beehive
	command: /srv/beehive/manage.py runserver 0.0.0.0:8000 --settings=env.bh_dev
	links:
	- redis
	- postgres
	- es
	# - memcached
	environment:
	- "REDIS_PORT=tcp://redis_1:6379"

shofetim / tmp.sql

Created March 20, 2015 20:35

	SELECT
	DISTINCT(au.email) AS "Email",
	CONCAT('C', c.customer_number) AS "Customer Number",
	INITCAP(c.full_name) AS "Full Name",
	d.postal_code AS "ZIP",
	r.code AS "Route",
	max(o.invoice_date) AS "Last Order Date",
	CONCAT('<a href="https://beehive.azurestandard.com/customer/', c.id, '">View in Beehive</a>') AS "Link To Customer"
	FROM customers_customer AS c
	LEFT JOIN auth_user au ON c.user_id = au.id

shofetim / tmp.sql

Created March 13, 2015 22:00

	Unique (cost=116492999.88..116496326.61 rows=39138 width=399) (actual time=241672.003..241719.254 rows=2515 loops=1)
	-> Sort (cost=116492999.88..116493097.73 rows=39138 width=399) (actual time=241671.998..241703.397 rows=11561 loops=1)
	Sort Key: products_product.cached_name, products_product.id, products_product.created_at, products_product.created_by, products_product.updated_at, products_product.updated_by, products_product._aggregate_searchable_field, products_product.bargain_bin_location_id, products_product.piece_id, products_product.allow_partial_sale, products_product.code, products_product.is_active, products_product.quantity, products_product.bargain_bin_notes, products_product.cached_brand_id, products_product.cached_primary_imagefield, products_product.name_recalculation_needed, products_product.cached_size, products_product.size_recalculation_needed, products_product.cached_retail_price_display, products_product.retail_price_display_recalculation_needed, products_product.retail_pric

shofetim / tmp.sql

Created March 7, 2015 02:10

	SELECT
	product.code AS "Product Code",
	product.cached_name AS "Product Name",
	floor(piece.cached_stock_available_count) AS "Current Inventory",
	floor(piece.cached_possible_stock_available_count) AS "Current Inventory including case breakdown",
	floor(piece.cached_stock_on_orders_count) AS "Inventory in Transit",

	CASE
	WHEN sales.custom_percent_off > 0 THEN 'Y'
	WHEN sales.custom_amount_off > 0 THEN 'Y'

shofetim / tmp.sql

Created March 6, 2015 16:10

	SELECT
	stock.lot_number AS "Lot Number",
	p.cached_name AS "Product Name",
	p.code,
	count(stock.piece_id) AS "Inventory in Azure Warehouse",
	wp.cached_purchased_but_not_arrived_stock_count AS "Inventory in Transit",
	CASE
	WHEN wp.breakdown_level_id = 1 --When piece is bulk
	Then wp.cached_stock_committed_count-(SELECT
	piece.cached_stock_committed_count / breakdown.child_quantity

shofetim / azurestandard.github.io.har

Created February 14, 2015 20:05

shofetim / *scratch*.sql

Created January 30, 2015 18:10


	SELECT
	p.*
	FROM warehouse_pieces_piece AS wp
	JOIN warehouse_pieces_piecemeta AS pm ON pm.id = wp.piece_meta_id
	JOIN products_product AS p ON wp.id = p.piece_id
	LEFT JOIN products_productstatus AS pstatus ON pstatus.product_id = p.id
	LEFT JOIN vendor_vendorpiece vp ON vp.piece_id=wp.id
	JOIN vendor_vendor v ON v.id=vp.vendor_id
	LEFT JOIN beekeeper_beehiveuser AS b ON v.buyer_id = b.id

Onboarding