#!/usr/bin/env ruby require 'dbi' require './squish' dbdriver = 'Mysql' query=< 1 }) sql.gsub!( /\.key/ , ".keyhash" ) # also we want to put '' around user-supplied field names # in our SELECT clause, eg. ...AS 'desc', but lets # see if postgres is happy with that. puts "\n#{sql}\n\n" h= '' h += "\n" h += '' h += "RDFWeb: RSS Channel Directory\n\n" h += " \n" h += "

RSS 1.0 Channels:

\n\n" h += "

#{channel.title} #{channel.desc}

" h += "\n\n\n\n\n" res['Content-Type'] = "text/html; charset=utf-8" puts h