notifier-general

SQL code

2010-04-30T06:18:00.000-07:00

Added SQL code to grab_debt and grab_lotto_results. Also pushed the temporary schema to the repo, as well as query_DB.pl

query_DB takes a command line option -n, the name of the notification, currently only "Lotto" and "USdebt" work.

NHL Standings grabber

2010-03-16T16:50:00.000-07:00

Pushed another program to pull down the NHL conference standings. Uses the TableExtract module.

Better nhlscore grabber

2010-03-13T19:05:00.000-08:00

Improved commandline switch. Handles comma separated team names. Though they have to coincide with the name used on yahoo sports for each team(eg. Jersey works while Devils would not). Will probably write in some logic to lookup by short names since the team names won't change anytime soon.

Sample:
./nhlScores.pl -t rangers,jersey,dallas,montreal
NY Rangers:5 Atlanta:2
Pittsburgh:1 New Jersey:3
New Jersey:2 NY Islanders:4
Los Angeles:2 Dallas:1
Boston:2 Montreal:3

Aimbot!

2010-03-10T18:48:00.000-08:00

Got an aimbot working, pretty SICK! This serves two purposes, one is IM and two is SMS, because if you use the ten digits syntax "+1XXXYYYZZZZ" for your phone number(XXX: area code YYY: prefix ZZZZ:number) AIM has had the ability to send IMs to regular cell phones for years. This is also sick because it works just like google text alerts(you text google at:466453 a request and it gives you back a result) albeit with far fewer options at the moment.

Code is in the repo, at http://code.google.com/p/notifier-general/source/browse/notifier-general-aimbot.pl

Data Source updates

2010-03-09T01:48:00.001-08:00

Significantly improved the lotto grabber, and added an nhl scores grabber that's pretty decent.

Data Sources: Web Scraping

2010-03-06T01:20:00.001-08:00

Pushed a couple of perl programs to the repository that do a little webscraping to get some data sources. They require the WWW::Mechanize and HTML::TableExtract modules to run. One gets the NY Lotto results(don't need the convoluted command anymore) and the other grabs the U.S. national debt numbers from the treasury department.

Sample output: $ ./grab_lotto_results.pl

Mega Millions: Mar 5:

11, 31, 34, 44, 52
Megaball: 32
Past Year's Numbers
Next Jackpot: Check back later.
Next Drawing: Tues, Mar 9
Mar 3:

LOTTO: Mar 3:

2, 17, 30, 38, 43, 53
Bonus: 27
Extra: 15
Past Year's Numbers
Next Jackpot: $19.5 million
Next Drawing: Sat, Mar 6

$ ./grab_debt.pl
Current: 03/04/2010
Debt Held by the Public: 8,061,072,722,591.94
Intragovernmental Holdings: 4,484,417,290,440.35
Total Public Debt Outstanding: 12,545,490,013,032.29

Progress

2010-03-02T20:06:00.000-08:00

We've made some good progress so far, we are working on a perl progran and a python program that will send emails through gmail. We are also working with a couple programs(perl & python) for using the twitter API.

In terms of getting data to send so far this hacked together string of commands works pretty well at getting the New York Lottery results:

lynx -dump http://nylottery.org/index.php| grep -A 33 "Mega Millions"|grep -B 34 "\-\-" | sed 's/\[.*\]//g'| sed s/"Past Year's Numbers"//g | sed s/"Payout Info"//g | sed 's/^[ \t]*//;s/[ \t]*$//' | sed '/^$/d'

We're working on doing this in pure perl and python to lessen the dependency on outside programs being installed and hackishness of the solution.

First Post

2010-02-18T20:58:00.000-08:00

This is the blog for notifier-general, a project to create a general purpose and customizable notification system for various data sources. Other systems like this exist(google text alerts, yahoo sports alerts) but they are not customizable, one has to choose from the alerts that are provided. With notifier-general we hope to provide a robust framework so that almost any (almost)arbitrary data source can be used- Sports scores, lotto numbers, international space station fly-bys etc. Besides just alerting on data sources we will incorporate a way for the system to set conditions on when to send a notification, such as over/under thresholds for numbers or some kind of string matching.