Lotto

Rewrote my MS-Access programs that process the lotto data to use Python/PostgreSQL.

1) import.py - read lotto text file (containing all lotto numbers) and insert into PostgreSQL database.

2) summerize.py - read PostgreSQL lotto database and create summary database of all lotto numbers with number of times lotto number chosen.

3) summerize2.py - like above program except creates two summary databases for before/after lottery added numbers 50-53

4) FreqHTML.py - read the above databases and create the frequency HTML report.

5) lotto_batch.py - execute the above four programs in sequence. Takes < 5 seconds.

2004-04-14 14:18:28
Index