Kyle Gobel KyleGobel

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

</style>

## packages.config
<?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" />

## zip_upload_logs.ps1
$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

## upsert.sql
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;

## something.json

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

## SqlQueryExtensions.cs
  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;

## stackedit_vim.js
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);
            });

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

## check_tracker_status_json.pl
#!/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";

## Index.cshtml
@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>
	<?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" />
	$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
	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;
	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;
	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);
	});
	function date(s) {
	return new Date(parseFloat(/Date\(([^)]+)\)/.exec(s)[1]));
	}
	#!/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";
	@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>