Sha256: 49d5bca140f6e4967d0c9abc07dcee1088be52bb31772fa1bced7d87d37d68b1
Contents?: true
Size: 356 Bytes
Versions: 53
Compression:
Stored size: 356 Bytes
Contents
#!/bin/sh
DB="iso-3166.db"
SCHEMA="iso-3166-schema.sql"
rm -f ${DB}
sqlite3 ${DB} < ${SCHEMA}
echo ".import iso-3166-country.txt country" | sqlite3 ${DB}
echo ".import iso-3166-subcountry.txt subcountry" | sqlite3 ${DB}
sqlite3 ${DB} "select 'country_count', count(1) from country"
sqlite3 ${DB} "select 'subcountry_count', count(1) from subcountry"
Version data entries
53 entries across 53 versions & 3 rubygems