Обсуждение: SQL scipts parser

Поиск
Список
Период
Сортировка

SQL scipts parser

От
Maciej Gawinecki
Дата:
I'm looking for Java open-source SQL script reader/parser.

That would allow me to find SQL comments about tables and columns,
usually given in the neighbourhood of CREATE TABLE, ALTER TABLE commands.

I suppose there's something like this in JDBC for PostgreSQL. Can you
point me the sources/classes containing such a parser?

Best,
Maciej

Re: SQL scipts parser

От
Dave Cramer
Дата:
The driver doesn't have anything like that in it. However check out antlr for SQL parsing.

Dave

On Fri, Feb 27, 2009 at 10:06 AM, Maciej Gawinecki <mgawinecki@gmail.com> wrote:
I'm looking for Java open-source SQL script reader/parser.

That would allow me to find SQL comments about tables and columns, usually given in the neighbourhood of CREATE TABLE, ALTER TABLE commands.

I suppose there's something like this in JDBC for PostgreSQL. Can you point me the sources/classes containing such a parser?

Best,
Maciej

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

Re: SQL scipts parser

От
"DGPickett"
Дата:
Maybe if you find an SQL style normalizer/beautifier, the comments will be very easy to find.  I should look for myself, as I have a favorite style of line breaks and indentation that I manually employ, over and over (one predicate per line, one column per line, one table name per line, etc.). 
The driver doesn't have anything like that in it. However check out antlr for SQL parsing.

Dave

On Fri, Feb 27, 2009 at 10:06 AM, Maciej Gawinecki <mgawinecki@gmail.com> wrote:
I'm looking for Java open-source SQL script reader/parser.

That would allow me to find SQL comments about tables and columns, usually given in the neighbourhood of CREATE TABLE, ALTER TABLE commands.

I suppose there's something like this in JDBC for PostgreSQL. Can you point me the sources/classes containing such a parser?

Best,
Maciej

--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc