Skip to content

Instantly share code, notes, and snippets.

View bdcravens's full-sized avatar

Billy Cravens bdcravens

14 followers · 4 following
View GitHub Profile
@bdcravens
bdcravens / split-csv-save-header.sh
Created January 2, 2012 05:44
Splits a folder of CSV files into smaller CSV files, retaining header row
#!/bin/bash
if [ ! -d "./backup" ]; then
mkdir backup
fi
lines=1024
for i in *.csv; do
split -l ${1:-$lines} $i ${i%.csv}-
for j in ${i%.csv}-a*; do
if [[ "$j" != *-aa ]]
@bdcravens
bdcravens / hack.sh
Created March 31, 2012 13:43 — forked from erikh/hack.sh
OSX For Hackers
#!/usr/bin/env sh
##
# This is script with usefull tips taken from:
# https://github.com/mathiasbynens/dotfiles/blob/master/.osx
#
# install it:
# curl -sL https://raw.github.com/gist/2108403/hack.sh | sh
#
@bdcravens
bdcravens / SQSWatcher.cfc
Created September 2, 2012 04:59
Railo event gateway using ID
<cfset id = form['_id']>
<cfset variables.fields = array(field("Queue name", "queuename", "#id#", true, "The queue to listen to", "text"),
field("Interval (seconds)","interval","60",true,"The interval between checks, in seconds","text")
) />
@bdcravens
bdcravens / SQSWatcher.cfc
Created September 2, 2012 05:28
Railo event gateway with defaults
<cfset id="???"><!--- a dummy value - never used --->
<cfif structKeyExists(form,'_id')>
<cfset id = form['_id']>
</cfif>
<cfset variables.fields = array(
field("Queue name", "queuename", "#id#", true, "The queue to listen to", "text"),
field("Interval (seconds)","interval","60",true,"The interval between checks, in seconds","text")
) />
@bdcravens
bdcravens / delete-dupes.sql
Created December 19, 2012 17:49
SQL Server: DELETE duplicates in table, keeping oldest record
; with cte
as (select *, ROW_NUMBER() over (PARTITION by invoiceNumber order by created desc) rn
from invoices
where accountId in (select accountId from accounts where carrierId=2))
delete from cte where rn<>1
@bdcravens
bdcravens / add-timestamps.sql
Created December 19, 2012 21:32
SQL Server - add createdAt and updatedAt columns, automatically updates
ALTER TABLE myTable
add createdAt datetime
CONSTRAINT DF_myTable_createdat DEFAULT GETDATE()
ALTER TABLE myTable
add updatedAt datetime
CONSTRAINT DF_myTable_updatedAt DEFAULT GETDATE()
go
@bdcravens
bdcravens / sqlserver2000-cfqueryparam-create.cfm
Created February 3, 2013 17:28
SQL Server 2000 <cfqueryparam> conversion
<cftry>
<cfset colList = "col1,col2,col3">
<cfquery name="cols" datasource="#datasource#">
SELECT column_name, data_type
FROM INFORMATION_SCHEMA.COLUMNS
where table_name = '#table_name#'
@bdcravens
bdcravens / search-text-columns-mssql2000.sql
Last active December 12, 2015 04:28
Generates SQL (SQL Server 2000) for searching all text columns for a given string. (Need to remove last UNION) Good for catching SQL injection results.
SELECT
'select ' + column_name + ' as txt,
''' + column_name + ''' as [column_name],
id from applications where ' + column_name + ' like ''%payday%'' union '
FROM INFORMATION_SCHEMA.COLUMNS
where table_name = 'applications'
and data_type in ('nvarchar','varchar','char','nchar')
@bdcravens
bdcravens / invoice-filename-change.sh
Created February 16, 2013 16:41
was: Invoice_000000ABCDEF012_010113.csv changeto: ABCDEF012.csv (leading zeros may change)
#!/bin/bash
FILES=Invoice_*_*.csv
for f in $FILES
do
newname=`echo $f| cut -d'_' -f 2`
newnamelen=${#newname}
leading=$[newnamelen-9]
invnum=${newname:leading}
mv $f $invnum.csv
done
@bdcravens
bdcravens / gist:5843297
Created June 23, 2013 00:59
Nokogiri global search
doc.search("[text()*='b']").size