From: Shashank Date <sdate@...>
Date: 2005-04-10T06:34:40+09:00
Subject: [ANN] Shallow Parser for t-SQL

Shallow Parser for t-SQL
------------------------

   A library to shallow parse t-SQL statements and generate a simple
   data-structure (array of TSQLStmt objects) for further consumption.
   t-SQL is the procedural language for Microsoft SQL Server 2000.

Version
-------

   0.0.1 (2005/04/09)  *** alpha ***

Installation
------------

   Download and unzip the zip file in any temporary directory.
   Execute the included "install.rb" script:

      C:\temp\release\> ruby install.rb

License
-------

   Ruby's

Dependencies
------------

   None

URL
---

   http://rubyforge.org/projects/tsql-analyzer/

Example Usage
-------------

   require 'tsql_shparser'

     shp = TSQL_ShParser.new.parse("select col1, col2, col3 from Table1")

     p shp[0].all_columns.to_arr  #-> ['COL1','COL2','COL3']
     p shp[0].all_tables.to_arr   #-> ['TABLE1']

     shp[0].list_select_expressions.map{|e| p e.to_arr}
        #-> [["COL1", ","], ["COL2", ","], ["COL3"]]

Warning
-------

   This is an alpha release. Plenty of bugs !

BUG REPORTS
-----------

   Please make sure that the t-SQL script that exposes a bug, parses
   correctly under Query Analyzer before submitting a report.

Author
------

   Shashank Date
   shanko_date@yahoo.com