Skip to content

README.md

Latest commit

 

History

History
37 lines (30 loc) · 1.82 KB

README.md

File metadata and controls

37 lines (30 loc) · 1.82 KB
Raw

MetaSql.Parser

.NET

Overview

MetaSql.Parser is a C# .NET Standard 2.0 library designed to extend the SQL language from its grammar. The primary purpose of this parser is to read SQL queries and extract ANSI SQL metadata (tables, columns) along with extended metadata (filter statements, etc.).

Usage

To get started with MetaSql.Parser, follow these simple steps:

  1. Installation 
    dotnet add package MetaSql.Parser
  2. Examples
IQueryParser parser = new QueryParser();
var query = @"EFILTER &filtroOntem DATE DEFAULT ontem;
              EFILTER &filtroHoje DATE DEFAULT hoje;
                SELECT m.maquina AS maquina,
                       o.nome AS operador,
                       t.inicio AS inicio,
                       t.os AS os,
                       procs.referencia AS processo
                FROM apontamento t
                JOIN eventos e ON (e.codseq = t.codevento)
                JOIN operadores o ON (o.codseq = t.codoperador)
                JOIN maquinas m ON (m.codseq = t.codmaquina)
                JOIN operacoes ON (processos.codseq = t.codproc)
                WHERE (1=1)
                  AND t.inicio BETWEEN &filtroOntem AND &filtroHoje;";
var metadata = parser.ExtractQueryMetadata(query);
// metadata.Tables => [{TableName: 'apontamento'},{TableName: 'operadores'},{TableName: 'maquinas'},{TableName: 'operacoes'}]
// metadata.Relations => [{LeftTable: 'EVENTOS.CODSEQ', RightTable: 'APONTAMENTO.CODEVENTO'},{LeftTable: 'OPERADORES.CODSEQ', RightTable: 'APONTAMENTO.CODEVENTO'}...]
// metadata.Filters => [{Name: 'filtroOntem', Type: FilterType.Date, ...},{Name: 'filtroHoje', Type: FilterType.Date, ...} ]