Code and Whatnot

This post is mostly for my own benefit, and may be edited in the future. Since I’m a shell guy stuck (at least for now) in a Windows world, I find myself installing Cygwin on machines on a regular basis. I still don’t really understand how anyone gets anything done on Windows machines…
Digression: […]

Gives a simple list of tables and the FOREIGN KEY constraints on them. Worked for me, anyway:
mysql -u [user] -p[password] -h [host] [database] <<< “SHOW TABLES;” | \
while read table; do
  mysql -u [user] -p[password] -h [host] [database] <<< “SHOW CREATE TABLE $table;”;
  echo “^M^M^M”;
done | \
grep ‘CONSTRAINT’ | \
sed ’s/$/\n/’ | \
sed ’s/\(.*\)\(CREATE […]

At the end of this article, I’ve pasted the contents of my ~/.vimrc file - this is the file I’m searching in all demonstrations.
You’ll notice I’m searching only one file with cat .vimrc — if you want more grep-like behavior, you may want to do:
find . -type f -exec cat {} \; //recursively output […]

A friend came to me with an interesting problem today: he wanted to determine the disk usage (in kilobytes) of text files only (recursively, in his current directory).
This is what I came up with:
find . -exec file {} \; \
| awk -F : ‘{ if ($2 ~ /text/) print $1 }’ \
| while read filename; […]

When rename is an alias of mv, you have no ability to batch rename or use patterns in your rename. When rename is Linux rename, you have certain limited capabilities to do batch renaming with patterns. When you have perl rename, you can pretty much do anything. If you don’t, though (check […]

The Command
I’ve been thinking about turning this into a stored script that takes the revision number as an argument. For now, my motivation leaves it like this:
vim `svn log -v -r 6406:HEAD | egrep “^ *[AM].*task_[0-9]{4,}/” | sed ’s~^.*task_[0-9]\{4,\}/~~’ | uniq`
UPDATE:
uniq doesn’t work without sort. Here’s the version I’m using these days:
vim `svn […]

This works if all of the files that `svn info` lists as ‘?’ are files you actually want to add:
svn st | grep “^?” | awk ‘{ print $2}’ | while read f; do svn add $f; done
If you want to see what’s going on there, start by running svn st and add new sections […]

In Fall of 2004, I quit my stable, unexciting job as a secretary. Afterwards, the first job I had was as a bike messenger. While that job was extremely fun, it did not meet my financial expectations at all, so I quit after 6 weeks. After that, I started working as […]

Out of curiousity, I decided to ‘weigh’ our core application code. First, I just counted the bytes and number of files (line breaks added for readability - beware copy & pasters):
find . -name ‘*.php’ -ls | egrep -v
“wiki|brands|import|rbar10|pear|helpdesk|soap_lib|languages
|HTML_ToPDF|cms_files” | awk ‘{
sum += $7
++filenum
print $7, “\t”, $11
}
END { print “Total: “, sum, “bytes (” filenum […]

This is so much more elegant than my first attempt to write a search and replace script.