Skip to content

Instantly share code, notes, and snippets.

@mweppler
mweppler / drop_tables.sh
Created November 29, 2012 00:54
Drop mysql tables in given database
#!/bin/bash
USER="$1"
PASS="$2"
DB="$3"
if [ $# -ne 3 ]
then
echo "Usage: $0 {MySQL-User-Name} {MySQL-User-Password} {MySQL-Database-Name}"
echo "Drops all tables from a MySQL"
exit 1
<?php
$field = "field";
$hasField = false;
$table = "table";
$connect = @mysql_connect("host","username","password");
if (!$connect) echo "Server error: CONN";
$select_db = mysql_select_db("database");
if (!$select_db) echo "Server error: DB";
$result = mysql_query("SHOW COLUMNS FROM $table");
while ($row = mysql_fetch_array($result))
@mweppler
mweppler / rm_svn_dirs.rb
Created October 6, 2012 21:34
Recursively remove .svn directories for given path
#!/usr/bin/env ruby
%w{fileutils}.each { |lib| require lib }
Dir.glob((ARGV[0][-1] == '/') ? ARGV[0] + '**/*' : ARGV[0] + '/**/*', File::FNM_DOTMATCH) { |node| FileUtils.rm_rf node if File.directory?(node) && File.basename(node) =~ /\.svn$/ }
@mweppler
mweppler / mv_videos_and_source.rb
Created October 4, 2012 05:22
Move files sorted by video/source into same directory
#!/usr/bin/env ruby
require 'fileutils'
Dir.glob('/Volumes/Share/Media/Videos/Software\ Training/video/*').each do |file|
fn = File.basename file, File.extname(file)
sd = File.dirname(file) + '/../' + 'source/'
sf = sd + fn + '.zip'
nd = File.dirname(file) + '/../' + fn
(File.exists? nd) ? next : Dir.mkdir(nd)
@mweppler
mweppler / flat_file.rb
Created September 12, 2012 20:46
Incomplete implementation of a flat file storage system.
module FlatFileProperties
def properties(*attributes)
@file_properties = attributes
end
def file_properties
@file_properties
end
end
#!/usr/bin/env ruby
require 'open-uri'
require 'nokogiri'
def get_anchors_from_html_doc html_doc
# Returns a Nokogiri::XML::NodeSet
html_doc.css('a')
end
var modal = {
modalWindow : $('#modalWindow'),
windowMask : $('#mask'),
config: {
// maskEffect : 'fadeToggle',
// maskSpeed : 'fast',
// modalEffect : 'fadeToggle',
// modalSpeed : 'fast'
},
init: function(config) {
@mweppler
mweppler / remove_new_lines.rb
Created January 16, 2012 19:30
Remove newlines from files
out_file = File.new("/Users/username/column_names-new.csv", "w")
File.open("/Users/username/column_names.csv", "r") do |in_file|
while line = in_file.gets
out_file.write line.tr("\n","")
end
end
@mweppler
mweppler / compare_repo.rb
Last active September 28, 2015 03:08
Compares file hashes
#!/usr/bin/env ruby
require 'digest/md5'
require 'optparse'
class RepositoryFile
attr_accessor :obj_hash, :file_hash, :file_mtime, :file_name, :file_path
def initialize(obj_hash, file_hash, file_mtime, file_name, file_path)
@obj_hash = obj_hash
@file_hash = file_hash