Hooray Python

I love Python, because it lets me add 15 fields to a MySQL database in about 5 minutes, which is a lot less time than it would have taken to add them manually via the command-line client or PhpMyAdmin:

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

for i in range(1,6):
print "ALTER TABLE `items` ADD `img%d_title` VARCHAR(255);" % i;
print "ALTER TABLE `items` ADD `img%d_url` VARCHAR(255);" % i;
print "ALTER TABLE `items` ADD `img%d_caption` TEXT;" % i;

Save as `altertable.py` and run it from the shell:

`python altertable.py | mysql -u andy -pmyPassw0rd -h localhost mydatabase`

Not that it would have taken much longer to write in PHP, Perl, or even Java, but it's so *clean* in Python.

Syndicate content

Twitter

  • Nothing says "this crappy joke that's been forwarded 27 times is not nearly as funny as the subject line says" like Comic Sans. #fb — 5 years 18 weeks ago
  • Ah, southwestern New Hampshire, where it's hard to tell whether or not a guy's mullet is ironic. #fb — 5 years 19 weeks ago
  • Pancake making hack: put the syrup in The oven at 200F along w/pancakes to keep everything nice and hot. #fb — 5 years 19 weeks ago
  • Just finished cooking one of those meals that somehow completely destroys the kitchen. I'll be more organized next time. #fb — 5 years 20 weeks ago
  • I wish the TSA would get on with it and just ban passengers from flights altogether. That will make us all safe. — 5 years 20 weeks ago

Older

Contact

Andy Chase
(978) 297-6402
andychase [at] gmail.com
GPG/PGP Public Key