o 8Di2@stddlmZddlZddlmZddlmZmZej r!ddl m Z ej ddd d Z ej dddd Z ddd Z dS)) annotationsN)exp)Dialect DialectType)E expressionrdialectrreturncCdSNrrr r `/var/www/Datamplify/venv/lib/python3.10/site-packages/sqlglot/optimizer/normalize_identifiers.pynormalize_identifiers rstrexp.IdentifiercCr r r r r r rrrcCsRt|}t|trtj||d}|jdddD] }|jds&| |q|S)a Normalize identifiers by converting them to either lower or upper case, ensuring the semantics are preserved in each case (e.g. by respecting case-sensitivity). This transformation reflects how identifiers would be resolved by the engine corresponding to each SQL dialect, and plays a very important role in the standardization of the AST. It's possible to make this a no-op by adding a special comment next to the identifier of interest: SELECT a /* sqlglot.meta case_sensitive */ FROM table In this example, the identifier `a` will not be normalized. Note: Some dialects (e.g. DuckDB) treat all identifiers as case-insensitive even when they're quoted, so in these cases all identifiers are normalized. Example: >>> import sqlglot >>> expression = sqlglot.parse_one('SELECT Bar.A AS A FROM "Foo".Bar') >>> normalize_identifiers(expression).sql() 'SELECT bar.a AS a FROM "Foo".bar' >>> normalize_identifiers("foo", dialect="snowflake").sql(dialect="snowflake") 'FOO' Args: expression: The expression to transform. dialect: The dialect to use in order to decide how to normalize identifiers. Returns: The transformed expression. )rcSs |jdS)Ncase_sensitive)metaget)nr r r<s z'normalize_identifiers..)pruner) r get_or_raise isinstancerrparse_identifierwalkrrnormalize_identifier)rrnoder r rrs #   r )rrrrr r)rrrrr r) __future__rtypingtsqlglotrsqlglot.dialects.dialectrr TYPE_CHECKINGsqlglot._typingroverloadrr r r rs