search_index.rb

#!/usr/bin/env ruby

require 'json'
require 'pg'
require 'sequel'

def database
  @db ||= Sequel.connect(adapter: 'postgres',
                         host: 'db.snichaos.com',
                         user: 'postgres',
                         database: 'dbname')
end

pois = database[:poi]

pois.order(:poi_id).each do |r|
  index_data = "#{r[:type]}, #{r[:subtype]}, #{r[:category]}"
  r.update(:type_index => index_data)
  puts "#{r[:poi_id]} updated."
end