Populate Database Table for States

A common database table is one that contains a country's states, it might look something like this:

+--------+------------------+------+-----+---------+----------------+
| Field  | Type             | Null | Key | Default | Extra          |
+--------+------------------+------+-----+---------+----------------+
| id     | int(4)  unsigned |      | PRI | NULL    | auto_increment |
| name   | varchar(64)      |      |     |         |                |
| abbrev | char(2)          |      |     |         |                |
+--------+------------------+------+-----+---------+----------------+

The following code uses Geography::States to populate such a table with the 50+ states of the USA:

use DBI;
use Geography::States;

my $dbh = DBI->connect( ... );
my $sth = $dbh->prepare('INSERT INTO state(abbrev,name) VALUES(?,?)');
my $usa = Geography::States->new('USA');

$sth->execute(@$_) for $usa->state;
[download]

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

Comment on Populate Database Table for States Download Code

Replies are listed 'Best First'.
Re: Populate Database Table for States by princepawn (Parson) on Jan 03, 2004 at 10:39 UTC
Geography::States is much more useable in this case than my own Locale::US Carter's compass: I know I'm on the right track when by deleting something, I'm adding functionality	[reply]