#!/usr/bin/env ruby

require '../squish'
require '../../basicrdf'
require 'dbi'

DBI_DRIVER = 'DBI:Pg:test1'
DBI_USER = 'danbri'
DBI_PASS=''

# todo: hashCode stuff need to decide whether to wrap literals in "

service = DBIDataService.new(DBI_DRIVER,DBI_USER,DBI_PASS)
service.defrag
service.addAllSuperProperties 

query = SquishQuery.new()

sq = 'SELECT ?name, ?mbox, WHERE 
	(foaf::mbox ?x ?mbox) 
	(foaf::name ?x ?name) 
	using       foaf for http://xmlns.com/foaf/0.1/ '

  DBI.connect( DBI_DRIVER, DBI_USER, DBI_PASS) do | dbh |

  dbh.select_all( query.parseFromText(sq).toSQLQuery  ) do | row |  
    r = ResultRow.new(row) # a convenience class, methods map to fields
    puts "\n\n ******** answer: #{row.inspect} \n\n"
   end

end