Method: FreeZipcodeData::CountyTable#build

Defined in:
lib/free_zipcode_data/county_table.rb

#build ⇒ Object 



7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/free_zipcode_data/county_table.rb', line 7

def build
  schema = <<-SQL
    create table #{tablename} (
      id integer not null primary key,
      state_id integer,
      abbr varchar(255),
      name varchar(255),
      county_seat varchar(255)
    )
  SQL
  database.execute_batch(schema)

  ndx = <<-SQL
    CREATE UNIQUE INDEX "main"."unique_county"
    ON #{tablename} (state_id, abbr, name COLLATE NOCASE ASC);
  SQL
  database.execute_batch(ndx)
end