Comments (4)
erezsh
commented on May 26, 2024
Pushed a fix to the schemas branch. The code you gave should work now.
Right now the support for dates needs improvement. I will try to straighten it out in the coming weeks. If you get any more errors let me know!
from preql.
dimitri-b
commented on May 26, 2024
Tried the same code, got a new error, traceback below.
I checked in BigQuery UI - the dataset with that name exists, has tables inside.
Traceback (most recent call last):
File "/PyCharmVenv/PreQL/bin/preql", line 8, in <module>
sys.exit(main())
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/__main__.py", line 76, in main
p('import ' + args.module)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/api.py", line 25, in inner
return f(*args, **kwargs)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/api.py", line 197, in __call__
res = self._run_code(code, '<inline>', args)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/api.py", line 193, in _run_code
return self._interp.execute_code(code + "\n", source_name, pql_args)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/interpreter.py", line 36, in inner
return f(interp, *args, **kwargs)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/interpreter.py", line 86, in _execute_code
last = execute(stmt)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/evaluate.py", line 384, in execute
return stmt._execute() or objects.null
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/evaluate.py", line 365, in _execute
module = import_module(context.state, r)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/evaluate.py", line 349, in import_module
i.include(module_path)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/interpreter.py", line 36, in inner
return f(interp, *args, **kwargs)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/interpreter.py", line 96, in _include
self._execute_code(f.read(), fn)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/interpreter.py", line 86, in _execute_code
last = execute(stmt)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/evaluate.py", line 384, in execute
return stmt._execute() or objects.null
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/evaluate.py", line 168, in _execute
set_var(table_def.name, t)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/state.py", line 220, in set_var
return context.state.set_var(name, value)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/state.py", line 203, in set_var
return self.ns.set_var(name, value)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/state.py", line 43, in set_var
ns = ns.get_var(p)
File "/PyCharmVenv/PreQL/lib/python3.9/site-packages/preql/core/state.py", line 36, in get_var
raise NameNotFound(name)
preql.core.state.NameNotFound: test_data
from preql.
erezsh
commented on May 26, 2024
Yes, I understand why this is happening. I will fix it soon.
Sorry for the hick-ups, and thank you for your patience!
from preql.
erezsh
commented on May 26, 2024
Okay, so I misunderstood your problem, sorry! I now realize you're running a script with -m or -f, in which case the tables aren't automatically available. (the reasoning is that querying the schema each time you run a script will cause an unnecessary lag)
One solution (requires latest master), is to declare each table at the top:
table test_data {...}
Another solution which should already work, is to use connect():
connect("bigquery:///...", load_all_tables: true)
I'm also thinking of adding a command-line switch to always load all tables
from preql.
Related Issues (19)
- Add Automatic joins via attribute access
- Add support for VSCode
- Automatically generate GraphQL interface
- Documentation for "..." in projection HOT 1
- Grammar railroad diagram HOT 2
- Incorrect SQL code generated HOT 6
- Add support for BigQuery
- Error on saving table to BigQuery - required field id cannot be null HOT 1
- Assertion error with BigQuery when running .pql scripts but not REPL HOT 1
- Add support for RedShift
- create conda package HOT 3
- ModuleNotFoundError: No module named 'preql.core' HOT 1
- Add support for JSON functions and operators in queries
- OracleInterface not working with TNSNAMES HOT 3
- Implement multiple-dispatch for functions
- `random()` is evaluated multiple times HOT 2
- Provide a way to specify data when executing a script directly HOT 4
- whitespace in table name HOT 12
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from preql.