Preql

Preql copied to clipboard

OracleInterface not working with TNSNAMES

3

Hi, when a connection uri specify just the TNSNAMES.ORA entry name (e.g. oracle://:@), PREQL generates the root error: **cx_Oracle.DatabaseError: ORA-12154: TNS:could not resolve the connect identifier specified** The problem is...

maxfratini

erezsh

ModuleNotFoundError: No module named 'preql.core'

1

trying to run `pipx run preql` or in venv pip install preql and running preql throws this same error. ``` Traceback (most recent call last): File "C:\Users\j\scoop\apps\python\current\lib\runpy.py", line 196, in...

Kreijstal

create conda package

3

...to better target an intended community.

majidaldo

Adding pre-commit actions for local repository editing

2

To streamline local development, several developer tools were added to the pyproject.toml `dev-dependencies` section: pre-commit isort black pylint Pre-commit is not triggered by default and must be enabled with the...

otherJL0

Error on saving table to BigQuery - type mismatch

4

Given this schema in a source table in BigQuery: attempting to persist a table as a subset of the source table throws an error: ```javascript connect("bigquery:///gcp-project-id-here") calendar = import_table("eCom_US.calendar") temp...

dimitri-b

Assertion error with BigQuery when running .pql scripts but not REPL

1

Running the following (or any other) script with `preql -m foo` command: ```javascript connect("bigquery:///gcp-project-id-here") cal = import_table("test_data.temp_cal") print(cal) ``` Results in the correct execution (judging by the output) but an...

dimitri-b

Error on saving table to BigQuery - required field id cannot be null

1

Givent this schema in a source table: attempting to persist a table in BigQuery thows an error: ```javascript connect("bigquery:///gcp-project-name-here") calendar = import_table("eCom_US.calendar") temp = calendar{ Fin_Year, // INTEGER Fin_Year_Label //...

dimitri-b

Incorrect SQL code generated

6

Came to this from the HN discusson 'against SQL'. In The translation of this... print Continent { ... // Include existing fields density: population / area // Create new a...

SimonSntPeter

Documentation for "..." in projection

1

I get why this: ` join(c: Country.name, n:["Palau", "Nauru"].item) {...c} ` returns this:  and even why this: ` join(c: Country.name, n:["Palau", "Nauru"].item) {...n} ` returns this:  but what...

manor