yogo_sql_parser.rb

require 'yaml'
require 'pp'
module Yogo
  class SQLParser
    attr_accessor :script
    
    def initialize
      @script = "perl -e 'use SQL::Parser; use SQL::Statement; use YAML; use YAML::Dumper; $parser = SQL::Parser->new(); $parser->{RaiseError}=1; $dumper = YAML::Dumper->new; $dumper->indent_width(4); $stmt = SQL::Statement->new(\"%s\", $parser); delete $stmt->{\"opts\"}; print $dumper->dump($stmt);'"
    end
    
    def parse(sql_string)
      raise NotImplementedError
    end
    
    def convert(sql_string, to=:json_query)
      raise NotImplementedError if to != :json_query 
      json_query = nil
      job = @script % sql_string      
      yaml_query = `#{job}`
      puts "YAML: #{yaml_query}"
      yaml_obj = YAML.parse(yaml_query)
      pp yaml_obj
      json_query
    end
  end
end

$tsql = "SELECT id,name,age FROM users"
$test = Yogo::SQLParser.new
$test.convert($tsql)