Rakefile

require 'pg'

task :setup do
  connection = PG.connect
  connection.exec('CREATE DATABASE country_data;')

  connection = PG.connect :dbname => 'country_data';
  connection.exec('CREATE TABLE countries (id SERIAL PRIMARY KEY, name VARCHAR(20), continent VARCHAR(20), population INT, density INT, gni INT);')
end

task :seed_db do
  connection = PG.connect :dbname => 'country_data';
  connection.exec ('TRUNCATE TABLE countries;')
  connection.exec ("INSERT INTO countries VALUES (1, 'United Kingdom', 'Europe', 86, 243, 40000);")
  connection.exec ("INSERT INTO countries VALUES (2, 'France', 'Europe', 67, 123, 38000);")
  connection.exec ("INSERT INTO countries VALUES (3, 'Spain', 'Europe', 47, 93, 27150);")
  connection.exec ("INSERT INTO countries VALUES (4, 'Germany', 'Europe', 83, 237, 43700);")
  connection.exec ("INSERT INTO countries VALUES (5, 'Austria', 'Europe', 9, 107, 45360);")
  connection.exec ("INSERT INTO countries VALUES (6, 'Switzerland', 'Europe', 9, 214, 81130);")
  connection.exec ("INSERT INTO countries VALUES (7, 'Kenya', 'Africa', 50, 87, 1460);")
  connection.exec ("INSERT INTO countries VALUES (8, 'South Africa', 'Africa', 57, 47, 5430);")
  connection.exec ("INSERT INTO countries VALUES (9, 'Tunisia', 'Africa', 12, 74, 3490);")
  connection.exec ("INSERT INTO countries VALUES (10, 'Uganda', 'Africa', 42, 214, 600);")
  connection.exec ("INSERT INTO countries VALUES (11, 'Brazil', 'South America', 209, 25, 8610);")
  connection.exec ("INSERT INTO countries VALUES (12, 'Uraguay', 'South America', 4, 20, 15250);")
  connection.exec ("INSERT INTO countries VALUES (13, 'Argentinia', 'South America', 44, 16, 13030);")
  connection.exec ("INSERT INTO countries VALUES (14, 'Chile', 'South America', 18, 24, 13610);")
  connection.exec ("INSERT INTO countries VALUES (15, 'Panama', 'South America', 4, 5, 13280);")
  connection.exec ("INSERT INTO countries VALUES (16, 'Japan', 'Asia', 127, 348, 38520);")
  connection.exec ("INSERT INTO countries VALUES (17, 'China', 'Asia', 1387, 148, 8690);")
  connection.exec ("INSERT INTO countries VALUES (18, 'India', 'Asia', 1339, 450, 1790);")
  connection.exec ("INSERT INTO countries VALUES (19, 'Afghanistan', 'Asia', 36, 54, 560);")
  connection.exec ("INSERT INTO countries VALUES (20, 'USA', 'North America', 325, 36, 59160);")
end