o 8D©i¨ã@sddlmZmZdd„ZdS)é)ÚScopeÚ build_scopec Csªt|ƒ}|rS| ¡}tt| ¡ƒƒD]@}|jrR|t|ƒ}|dkrR|jj}|j}|  ¡|r9t |j ƒdkr9|  ¡|j   ¡D]\}}t|tƒrQ|t|ƒd8<q>q|S)a™ Remove unused CTEs from an expression. Example: >>> import sqlglot >>> sql = "WITH y AS (SELECT a FROM x) SELECT a FROM z" >>> expression = sqlglot.parse_one(sql) >>> eliminate_ctes(expression).sql() 'SELECT a FROM z' Args: expression (sqlglot.Expression): expression to optimize Returns: sqlglot.Expression: optimized expression ré)rÚ ref_countÚreversedÚlistÚtraverseÚis_cteÚidÚ expressionÚparentÚpopÚlenÚ expressionsÚselected_sourcesÚvaluesÚ isinstancer) r ÚrootrÚscopeÚcountÚcte_nodeÚ with_nodeÚ_Úsource©rúY/var/www/Datamplify/venv/lib/python3.10/site-packages/sqlglot/optimizer/eliminate_ctes.pyÚeliminate_ctess"  €rN)Úsqlglot.optimizer.scoperrrrrrrÚs