7^jDddlmZddlmZmZddlmZmZddlm Z ddl m Z ddl m Z ddlmZer ddlmZdd lmZ dd lZej2Zeej7d ZGd de ej:ZddZdgZ y #e$rZd Zeeed Z[wwxYw)) annotations) TYPE_CHECKINGLiteral)DeferredTimeZonenarwhals_to_native_dtype) LazyFrame)Schema) 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 W/var/www/ramen.bs-engineer-server.com/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)rrr r!_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 t|jDcic]%\}}|t|tjt '}}}dj d|jD}tjd|d|dttj|}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..as!Sjc53%r%)Ssz CREATE TABLE "z " (z ); r)r itemsrr MAINTZjoinCONNsqlr tabler_compliant_frame_level)nameschemar6r7column_mappingdtypeslfs rr?r?Es4!...0 C %eW\\2 >>NYYSNr;DuckDBPyRelationrr?__all__r4rrrTs")M("*"@*-v~~HH JK $Oy001$ON":J )s- 3 c ", -sB B BB