search

crate / crate-python

Python DB API client library for CrateDB, using HTTP.
https://cratedb.com/docs/python/
Apache License 2.0
79 stars 30 forks source link

Documentation: Use more specific queries for landing page examples, and remove idiomatic REPL prompt #540

Closed amotl closed 1 year ago

amotl commented 1 year ago

As suggested by @hlcianfagna, 84f29fc0f6 brings in more specific queries on the sys.summits table, in order to produce more pleasant output. Thanks! Other than this, the patch also removes idiomatic Python-REPL prompts with 30b06e563.

DB API

[['AT', 'Großglockner', [12.69444, 47.07417], 3798],
 ['AT', 'Wildspitze', [10.86722, 46.88528], 3770],
 ['AT', 'Großvenediger', [12.34639, 47.10917], 3666],
 ['AT', 'Großes Wiesbachhorn', [12.75528, 47.15639], 3564],
 ['AT', 'Großer Ramolkogel', [10.95889, 46.84667], 3550],
 ['AT', 'Schalfkogel', [10.95917, 46.80167], 3540],
 ['AT', 'Hochvernagtspitze', [10.79611, 46.88139], 3535],
[...]

SQLAlchemy

[{'country': 'AT', 'mountain': 'Großglockner', 'coordinates': [12.69444, 47.07417], 'height': 3798},
 {'country': 'AT', 'mountain': 'Wildspitze', 'coordinates': [10.86722, 46.88528], 'height': 3770},
 {'country': 'AT', 'mountain': 'Großvenediger', 'coordinates': [12.34639, 47.10917], 'height': 3666},
 {'country': 'AT', 'mountain': 'Großes Wiesbachhorn', 'coordinates': [12.75528, 47.15639], 'height': 3564},
 {'country': 'AT', 'mountain': 'Großer Ramolkogel', 'coordinates': [10.95889, 46.84667], 'height': 3550},
 {'country': 'AT', 'mountain': 'Schalfkogel', 'coordinates': [10.95917, 46.80167], 'height': 3540},
 {'country': 'AT', 'mountain': 'Hochvernagtspitze', 'coordinates': [10.79611, 46.88139], 'height': 3535},
[...]
amotl commented 1 year ago

Dear Hernan. I've just added another commit to this patch, 30b06e5634f. So, I am asking for another review. Thanks already!