Question

我试图用餐厅建造一个小小块不公的教区(我没有条款,我没有加入任何行列等等)。我今天的工作以简单的SQL为基础。典型例子包括假肢。我试图将“按类别分列的清单”和“按类别分列的清单”条款添加到教区,但试图与这些条款相匹配。

采用每个班级的Im,似乎与他们相配,但并没有从每个班级中确定结果名称。我要么没有做一些事情,要么正在出现我不清楚的情况。

同样,从简单的SQL来看。举例来说,我从Token中删除了,因此,我选定的Stmt现在认为:

# define the grammar
selectStmt      << ( selectToken + 
                     columnNameList.setResultsName( columns ) + 
                     Optional( CaselessKeyword( where ) + whereExpression, "" ).setResultsName( where ) + 
                     Each( [ Optional( CaselessKeyword( group by ) + columnNameList, "" ).setResultsName( group ),
                             Optional( CaselessKeyword( order by ) + columnNameList, "" ).setResultsName( order ) ] ) )

我得出以下结果:

SELECT a WHERE a=b  and c = d GROUP BY c, e ORDER By d ->
tokens =  [ select , [ a ],  where , [ a ,  = ,  b ],  and , [ c ,  = ,  d ],  group by , [ c ,  e ],  order by , [ d ]]

SELECT a WHERE a=b and c =d ORDER BY z, y GROUP BY c ->
tokens =  [ select , [ a ],  where , [ a ,  = ,  b ],  and , [ c ,  = ,  d ],  order by , [ z ,  y ],  group by , [ c ]]

因此,它想把集团和秩序条款按顺序排列,但并不分配结果名称(顺序和组)。我可以看到,这完全是umb,我没有东西,或者我可以看到,我正在以任何命令(以及今后更多的条款,如利比里亚武装部队)找到这些条款。

Any help would be greatly appreciated! LOVING pyparsing so far.

Answer 1

Give this a shot:

Stmt      << ( selectToken +
                columnNameList( columns ) + 
                Optional( CaselessKeyword( where ) + whereExpression( where ), "" ) +
                Each( [ Optional( CaselessKeyword( group by ) + columnNameList( group ), "" ).setDebug(),
                        Optional( CaselessKeyword( order by ) + columnNameList( order ), "" ).setDebug() ] 
                    ) 
            )

友情链接