:j8ddlmZddlmZmZddlmZmZddlm Z ddl m Z ddl m Z er ddlmZddlmZ dd lZej.Zeej3d ZGd d e ej6ZddZdgZy #e$rZd Zeeed Z[wwxYw)) annotations) TYPE_CHECKINGLiteral)DeferredTimeZonenarwhals_to_native_dtype) LazyFrame) from_native)Version)CompliantLazyFrameAny) IntoSchemaNzY`narwhals.sql` requires DuckDB to be installed. Hint: run `pip install -U narwhals[sql]`z;select value from duckdb_settings() where name = 'TimeZone'c>eZdZdZ dfd ZddddZxZS)SQLTablez/A LazyFrame with an additional `to_sql` method.c(t|||y)Nlevel)super__init__)selfdfr __class__s a/home/mcse/projects/srt_converter/srt-converter-venv/lib/python3.12/site-packages/narwhals/sql.pyrzSQLTable.__init__ s 5)F)prettyc|jj}|s|S ddl}|j |ddS#t$r}d}t ||d}~wwxYw)a4Convert to SQL query. Arguments: pretty: Whether to pretty-print SQL query. If `True`, requires `sqlparse` to be installed. Examples: >>> import narwhals as nw >>> from narwhals.sql import table >>> schema = {"date": nw.Date, "price": nw.Int64, "symbol": nw.String} >>> assets = table("assets", schema) >>> result = assets.filter(nw.col("price") > 100) >>> print(result.to_sql()) SELECT * FROM main.assets WHERE (price > 100) rNzr`SQLTable.to_sql` with `pretty=True`requires `sqlparse` to be installed. Hint: run `pip install -U narwhals[sql]`Tupper)reindent keyword_case) to_native sql_querysqlparse ImportErrorModuleNotFoundErrorformat)rrrr _excmsgs rto_sqlzSQLTable.to_sql%sl NN$..0   5 y4gNN 5;  &c* 4  5s< AAA)rr rz&Literal['full', 'interchange', 'lazy']returnNone)rboolr'str)__name__ __module__ __qualname____doc__rr& __classcell__)rs@rrrs49*'*0V* * (-OOrrc |jDcic]%\}}|t|tjt'}}}dj d|jD}t jd|d|dtt j|}t|j|jScc}}w)uGenerate standalone LazyFrame which you can use to generate SQL. Note that this requires DuckDB to be installed. Parameters: name: Table name. schema: Table schema. Examples: >>> import narwhals as nw >>> from narwhals.sql import table >>> schema = {"date": nw.Date, "price": nw.List(nw.Int64), "symbol": nw.String} >>> table("t", schema) ┌────────────────────────────┐ | Narwhals LazyFrame | |----------------------------| |┌──────┬─────────┬─────────┐| |│ date │ price │ symbol │| |│ date │ int64[] │ varchar │| |└──────┴─────────┴─────────┘| | 0 rows | └────────────────────────────┘ z, c32K|]\}}d|d|yw)"z" N).0coldtypes r ztable..`s!Sjc53%r%)Ssz CREATE TABLE "z " (z ); r) itemsrr MAINTZjoinCONNsqlr tabler_compliant_frame_level)nameschemar5r6column_mappingdtypeslfs rr>r>Ds4!,,. C %eW\\2 >>NYYSN)rAr*rBr r'r) __future__rtypingrrnarwhals._duckdb.utilsrrnarwhals.dataframernarwhals.translater narwhals.utilsr narwhals._compliant.typingr narwhals.typingr duckdbr!r$r%r"connectr<r=r:DuckDBPyRelationrr>__all__r3rrrRs")M(*"@*-v~~HH JK $Oy001$ON":J )s- 3 c ", -sBB BB