sexta-feira, 24 de julho de 2015

MetaSQL Init

The code below show how to create your own SQL Parser.



       public enum TDBLinkType {ltInnerJoin, ltLeftJoin, ltRightJoin};
       public enum TatSQLSyntax {ssCustom, ssBdeLocal, ssAccess, ssOracle, ssInterbase, ssMSSQL, ssDBISAM, ssFlashFiler, ssMySQL, ssNexus};
       public enum TatSQLGroupFunction {agfNone, agfCount, agfSum, agfMax, agfMin, agfAvg};
       public enum TatSQLFunction {sfMonth, sfYear, sfDay };
       public enum TatSortType {ortAscending, ortDescending};
       public enum TatSQLFieldExprType {etStandard, etCustomExpr};
       public enum TatLogicalOper {lgAnd,lgOr};
       public enum TatSQLJoinType {altInnerJoin, altLeftJoin, altRightJoin};
       public enum TatConditionType {ctValueCompare, ctFieldCompare, ctSubConditions, ctCustomExpr, ctParamCompare, ctTrueExpr, ctFalseExpr};
       public enum TatSQLJoinSyntax {alsFrom, alsWhere};

       public enum TatSQLSyntaxItem {sqlIDOpenDelim, sqlIDCloseDelim, sqlAsFieldOperator, sqlAsTableOperator, sqlMaskChar};


The complete project was stored in:

https://github.com/lapuinka/dbutils/blob/master/MetaSql.cs


Postar um comentário