Skip to content

Instantly share code, notes, and snippets.

View Hootis's full-sized avatar

Nate Boyd Hootis

  • Reynoldsburg, OH
View GitHub Profile
@Hootis
Hootis / gist:3e690272c15e907cf1d5310e623b307e
Last active October 21, 2024 16:40
Parse SQL files, Return Schema, Table, Column
import os
import re
import pandas as pd
def remove_comments(sql_text):
"""
Removes SQL comments from the input text.
Args:
sql_text (str): The SQL text from which comments are to be removed.
@Hootis
Hootis / gon.c
Created June 7, 2017 04:31
Usage of varargs and Switch
varargs void sloop_message( int i, object initiator, object target ) {
switch ( i ) {
case SLOOPER_ADD:
ansi_tell( initiator, "Wubba Lubba Dub Dub! It's a sloop-a-doop, "
"scoobily-doop-dup.", BOLD_PURPLE );
break;
case SLOOPEE_ADD:
ansi_tell( target, sprintf( "%s has taken a special interest in "
"you.",initiator->query_name() ), BOLD_PURPLE );
break;
@Hootis
Hootis / gist:b68194c33d1cc3697d71
Created January 21, 2015 19:51
Backup PST files and Log
# PowerShell Script to Backup .PST files to specific network drive.
# Script will attempt to close Outlook.exe, backup Personal Folder and
# Archive PSTs (if they exist) and reopen Outlook after copy is complete.
# Nboyd 01-13-15
# Allow Unrestricted execution for this process
Set-ExecutionPolicy -Scope Process -ExecutionPolicy Unrestricted -Force
# Set Variables
$src = "C:\Users\" + $env:UserName
@Hootis
Hootis / MovePSTs.ps1
Last active August 29, 2015 14:11
Locate PST Backup Files and move them
# PowerShell Script to Search User Shares for PST files, then
# move those PST files to a new Share drive, creating a new folder
# in the root of the new share drive and copying the PST backup folder.
Clear-Host
#Source of PST File(s)
$src = "\\CEISERVER\Users\"
#Destination for PST File(s)
$dest = "\\VCENTER\Users\"
#Set Increment Variable
$i = 1
@Hootis
Hootis / 0_reuse_code.js
Last active August 29, 2015 14:11
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@Hootis
Hootis / test2.ps1
Last active August 29, 2015 14:11
PowerShell Loop
# PowerShell Script to Search User Shares for PST files, then
# move those PST files to a new Share drive, creating a new folder
# in the root of the new share drive and copying the PST backup folder.
Clear-Host
#Source of PST File(s)
$src = "C:\Users\nboyd.ESI\Desktop\TestUsers\"
#Destination for PST File(s)
$dest = "C:\Users\nboyd.ESI\Desktop\TestIOSafe\"
#Set Increment Variable
$i = 1
/* Nate Boyd
* Client-Server
* Professor Christian Roberson
* Lab 3 - Simple Calculator
*/
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.border.TitledBorder;
public class ExtendedTriangle extends GeometricObject {
// values for each side of a triangle
double side1 = 1.0;
double side2 = 1.0;
double side3 = 1.0;
// Default constructor
public ExtendedTriangle() {
@Hootis
Hootis / PigLatin.java
Created July 8, 2011 01:11
igPay atinLay Translator
/* Nate Boyd
* Programming in Java
* Professor Christian Roberson
* Lab 6
*/
import java.util.Scanner;
public class PigLatin {
// Static Variables
import java.util.Random;
public class Character {
// Character attributes
public String name = "";
public int level = 1;
public int health = 0;
public int gold = 0;
public int experience = 0;