KyleGobel’s gists

KyleGobel / index.html

Created February 19, 2015 16:15

	<!DOCTYPE html>
	<meta charset='utf-8'>
	<style>

	</style>

KyleGobel / packages.config

Last active August 29, 2015 14:14

Chocolatey Setup Server Script

	<?xml version="1.0" encoding="utf-8"?>
	<packages>
	<package id="GoogleChrome" />
	<package id="SublimeText3" />
	<package id="SublimeText3.PowershellAlias" />
	<package id="SpaceSniffer" />
	<package id="Powershell" />
	<package id="pscx" />
	<package id="Putty" />
	<package id="7zip.commandline" />

KyleGobel / zip_upload_logs.ps1

Created January 29, 2015 22:07

Zip and upload logs to S3 - Powershell

	$scriptPath = split-path -parent $MyInvocation.MyCommand.Definition
	$logFile = Join-Path "C:\inetpub\logs\LogFiles\W3SVC2" "upload_logs.logFile"
	Try
	{
	$files = Get-ChildItem -Filter *.log \| where-object {$_.lastwritetime -lt (Get-Date).AddHours(-1)}
	$processedDir = Join-Path $scriptPath "uploaded_to_s3"

	if ($files.count -gt 0) {

	Write-Output "Starting Uploads to S3" \| Out-File $logFile -Append

KyleGobel / upsert.sql

Last active June 27, 2016 16:37

Insert/Update Upsert Trigger in Postgres

	CREATE OR REPLACE FUNCTION upsert_user()
	RETURNS trigger AS
	$upsert_user$
	declare
	existing record;
	begin
	if (select EXISTS(select 1 from users where user_id = NEW.user_id)) then

	select user_name, user_class, user_age into strict existing from users where user_id = new.user_id;

KyleGobel / something.json

Created September 2, 2014 18:37

exampledata

window.data = {"startDate":"2014-08-01T00:00:00.0000000-04:00","endDate":"2014-09-02T18:07:51.8644829Z","data":[{"date":"2014-09-02T00:00:00.0000000","revenue":105.4000},{"date":"2014-09-01T00:00:00.0000000","revenue":142.4100},{"date":"2014-08-31T00:00:00.0000000","revenue":133.3000},{"date":"2014-08-30T00:00:00.0000000","revenue":144.8600},{"date":"2014-08-29T00:00:00.0000000","revenue":87.5900},{"date":"2014-08-28T00:00:00.0000000","revenue":112.9100},{"date":"2014-08-27T00:00:00.0000000","revenue":144.5700},{"date":"2014-08-26T00:00:00.0000000","revenue":182.9400},{"date":"2014-08-25T00:00:00.0000000","revenue":124.4300},{"date":"2014-08-24T00:00:00.0000000","revenue":120.4000},{"date":"2014-08-23T00:00:00.0000000","revenue":112.2500},{"date":"2014-08-22T00:00:00.0000000","revenue":131.1500},{"date":"2014-08-21T00:00:00.0000000","revenue":119.6500},{"date":"2014-08-20T00:00:00.0000000","revenue":152.2900},{"date":"2014-08-19T00:00:00.0000000","revenue":106.5800},{"date":"2014-08-18T00:00:00.0000000","rev

KyleGobel / SqlQueryExtensions.cs

Last active August 29, 2015 14:05

This will take an embedded .sql resource file and return it's string contents. Auto mapping dtos to sql queries that can be easily run

	public static class SqlQueryExtensions
	{
	public static string GetSqlQuery<T>(this T requestDto, Action<string> queryFilter = null, string queryNamespace = null, string filename = null) where T : class
	{
	const string delimiter = "--start";
	var sqlStatement = string.Empty;

	//expects the namespace of this file to be the same namespace as the sql query file
	var namespacePart = queryNamespace ?? typeof(SqlQueryExtensions).Namespace;

KyleGobel / stackedit_vim.js

Created August 15, 2014 00:30

VI StackEdit.io plugin

	userCustom.onReady = function() {
	var ace = {}
	ace.require = require
	ace.define = define
	ace.require(["ace/lib/net"], function(acenet) {
	acenet.loadScript("//cdnjs.cloudflare.com/ajax/libs/ace/1.1.01/keybinding-vim.js", function() {
	e = document.querySelector(".ace_editor").env.editor
	ace.require(["ace/keyboard/vim"], function(acevim) {
	e.setKeyboardHandler(acevim.handler);
	});

KyleGobel / date.js

Created August 11, 2014 04:46

.Net Dates to Javascript Dates

	function date(s) {
	return new Date(parseFloat(/Date$([^)]+)$/.exec(s)[1]));
	}

KyleGobel / check_tracker_status_json.pl

Created July 8, 2014 08:38

	#!/usr/bin/env perl

	use warnings;
	use strict;
	use Getopt::Std;
	use LWP::UserAgent;
	use JSON 'decode_json';

	my $plugin_name = "Tracker Status check_tracker_status_json";
	my $VERSION = "1.00";

KyleGobel / Index.cshtml

Created June 26, 2014 16:00

	@model List<User>


	<!-- loop through all the users in our model, and display their name and age -->
	@foreach(var user in Model)
	{
	<div>
	<p>Users Name: @user.Name</p>
	<p>Users Age: @user.Age</p>
	</div>

	function date(s) {
	return new Date(parseFloat(/Date\(([^)]+)\)/.exec(s)[1]));
	}

Kyle Gobel KyleGobel