ipython-sql

ipython-sql copied to clipboard

%sql fails when query contains a Negative number

2

When running a valid sql comment that has a negative integer as an argument: %sql SELECT DATEADD(month, -2, SYSDATE) It returns an error: UsageError: unrecognized arguments: -2, SYSDATE) If you...

feverittm

0.4 pip package is broken on Linux

3

''' 16:23:03 Complete output (5 lines): 16:23:03 Traceback (most recent call last): 16:23:03 File "", line 1, in 16:23:03 File "/tmp/pip-install-8eqKva/ipython-sql/setup.py", line 7, in 16:23:03 NEWS = open(os.path.join(here, 'NEWS.rst'), encoding='utf-8').read()...

mcsquaredjr

Handle SQL statements without rows returned

1

Currently, if you run a SQL query that doesn't return rows (set, inserts, updates, etc), you got an exception, as reported [here](https://github.com/open-contracting/kingfisher-colab/issues/39), because this line expects to get a result...

yolile

Support syntax highlighting

7

ipython-sql looks like a very valuable resource, but it would be easier to use (especially for teaching) if it supported syntax highlighting of SQL code. As per a conversation on...

mdekstrand

Hi! This seems like a really awesome and useful magic pack, but I'm getting a "Memory Error" even going the most simple tests. Version info: python 3.7.3 ipython 7.20.0 (originally...

ScriptPup

Variable not being substituted in cell magic with $ or {}

1

Sometimes the same query passed to the line magic, %sql, won't work in the cell magic, %%sql, specifically when using a variable substitution with a dollar sign $. MWE show...

cab938

KeyError: 'DEFAULT'

2

* mysql+pymysql://dbuser:***@localhost/mydb 1 rows affected. I am able to connect to the database but unable to see results. get_ipython().run_line_magic('sql', 'select 2+3') KeyError: 'DEFAULT'

ShivaliGoel

```python --------------------------------------------------------------------------- ImportError Traceback (most recent call last) In [3]: Line 1: %load_ext sql File C:\Users\PML286\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone2\lib\site-packages\IPython\core\interactiveshell.py, in run_line_magic: Line 2326: result = fn(*args, **kwargs) File , in load_ext: Line 2:...

grootstebozewolf

Output of the query is returning empty result

2

Hi there, I have installed sqlalchemy-vertica vertica_python, and I am using it in the JupyterNotebook with sql magic function %sql. (ipython-sql) The connection is successfully made and the query runs...

ghost

Large results can lockup the notebook

1

When you return a large number of results it can lock everything up. The first line returns, saying something along the lines of 655,244 lines affected, but then everything locks...

stuaxo