Jessica McKellar jesstess

## music_through_dev_dsp.py
#!/usr/bin/python

# Play music without any external files (ie you create the notes yourself)
# through /dev/dsp! Inspired by
# http://www.tldp.org/LDP/abs/html/devref1.html#MUSICSCR

def generate_notes():
    # See http://www.phy.mtu.edu/~suits/NoteFreqCalcs.html for details on
    # calculating the frequencies

## growl_ticket_notifier
#!/usr/bin/python

import pycurl
import re
import urlparse
from StringIO import StringIO
from Growl import GrowlNotifier

"""
Check ticket trackers for new tickets and generate notifications for them

## cycle_bash_color
export colorvar=31; export PROMPT_COMMAND='export PS1="\e[""$colorvar"";40m\w> "; colorvar=$(((colorvar + 1) % 7 + 31));'

## wget_spider_https
http://addictivecode.org/FrequentlyAskedQuestions

To spider a site as a logged-in user:

1. post the form data (_every_ input with a name in the form, even if it doesn't have a value) required to log in (--post-data).
2. save the cookies that get generated (--save-cookies), including session cookies (--keep-session-cookies), which are not saved when --save-cookies alone is specified.
2. load the cookies, continue saving the session cookies, and recursively (-r) spider (--spider) the site, ignoring (-R) /logout.

# log in and save the cookies
wget --post-data='username=my_username&password=my_password&next=' --save-cookies=cookies.txt --keep-session-cookies https://foobar.com/login

## password_gen_dev_urandom
# alphanumeric
</dev/urandom tr -dc [:alnum:] | head -c10

# all printable characters, excluding whitespace
</dev/urandom tr -dc [:graph:] | head -c10

## DIY_bandwidth_summaries
DIY bandwidth summaries

1. ifconfig

ifconfig -a will give you transmitted and received bytes by interface since last boot.

Gets its info from /proc/net/dev

2. iptables

## mysql_time_frequency_tables
# date field is of type 'date'
mysql> SELECT YEAR(date) AS year, MONTH(date) AS month, count(*) AS count FROM my_table GROUP BY year, month ORDER BY year, month;
+------+-------+-------+
| year | month | count |
+------+-------+-------+
| 2008 |     6 |     1 |
| 2009 |     3 |     1 |
| 2009 |     5 |     2 |
| 2009 |     6 |     1 |
| 2009 |     7 |     1 |

## percentages_sql_having_case
I have a table of accounts and a table of transactions.	There's	a
one-to-many relationship between accounts and transactions;
transactions.account_id is a foreign key into accounts.	For all
accounts where < 50% of transactions are authorized, I want to
get the account id and that percentage:

SELECT a.id, SUM(t.authorized=1)/COUNT(*) AS percentage
FROM accounts a, transaction_info t
WHERE a.id=t.account_id
GROUP BY a.id

## genetic_rainbows.py
#!/usr/bin/env python

from Tkinter import *
import colorsys
import optparse
import random

"""
Use genetic algorithms to create graphical rainbows.

## flash_cards.py

#!/usr/bin/python

from Growl import GrowlNotifier
import time
import sys
import os
import optparse

"""
	#!/usr/bin/python

	# Play music without any external files (ie you create the notes yourself)
	# through /dev/dsp! Inspired by
	# http://www.tldp.org/LDP/abs/html/devref1.html#MUSICSCR

	def generate_notes():
	# See http://www.phy.mtu.edu/~suits/NoteFreqCalcs.html for details on
	# calculating the frequencies
	#!/usr/bin/python

	import pycurl
	import re
	import urlparse
	from StringIO import StringIO
	from Growl import GrowlNotifier

	"""
	Check ticket trackers for new tickets and generate notifications for them
	http://addictivecode.org/FrequentlyAskedQuestions

	To spider a site as a logged-in user:

	1. post the form data (_every_ input with a name in the form, even if it doesn't have a value) required to log in (--post-data).
	2. save the cookies that get generated (--save-cookies), including session cookies (--keep-session-cookies), which are not saved when --save-cookies alone is specified.
	2. load the cookies, continue saving the session cookies, and recursively (-r) spider (--spider) the site, ignoring (-R) /logout.

	# log in and save the cookies
	wget --post-data='username=my_username&password=my_password&next=' --save-cookies=cookies.txt --keep-session-cookies https://foobar.com/login
	# alphanumeric
	</dev/urandom tr -dc [:alnum:] \| head -c10

	# all printable characters, excluding whitespace
	</dev/urandom tr -dc [:graph:] \| head -c10
	DIY bandwidth summaries

	1. ifconfig

	ifconfig -a will give you transmitted and received bytes by interface since last boot.

	Gets its info from /proc/net/dev

	2. iptables
	# date field is of type 'date'
	mysql> SELECT YEAR(date) AS year, MONTH(date) AS month, count(*) AS count FROM my_table GROUP BY year, month ORDER BY year, month;
	+------+-------+-------+
	\| year \| month \| count \|
	+------+-------+-------+
	\| 2008 \| 6 \| 1 \|
	\| 2009 \| 3 \| 1 \|
	\| 2009 \| 5 \| 2 \|
	\| 2009 \| 6 \| 1 \|
	\| 2009 \| 7 \| 1 \|
	I have a table of accounts and a table of transactions. There's a
	one-to-many relationship between accounts and transactions;
	transactions.account_id is a foreign key into accounts. For all
	accounts where < 50% of transactions are authorized, I want to
	get the account id and that percentage:

	SELECT a.id, SUM(t.authorized=1)/COUNT(*) AS percentage
	FROM accounts a, transaction_info t
	WHERE a.id=t.account_id
	GROUP BY a.id
	#!/usr/bin/env python

	from Tkinter import *
	import colorsys
	import optparse
	import random

	"""
	Use genetic algorithms to create graphical rainbows.

	#!/usr/bin/python

	from Growl import GrowlNotifier
	import time
	import sys
	import os
	import optparse

	"""