ipython-sql

ipython-sql copied to clipboard

Hi, Is there a way to sponsor this project? This is the kind of project I use for a work project for a few months and then have a good...

stuaxo

comments are not properly parsed

2

Example that fails: ``` qry="""SELECT * FROM INFORMATION_SCHEMA.TABLES -- look at this WHERE table_name LIKE '%condition%' -- what a query!""" %sql {qry} ``` Quick fix (at line 88 of magic.py):...

DSLituiev

PostgreSQL meta commands not working. Getting `pgspecial not installed' even though it is installed

1

I have set up an environment in Anaconda and everything (SQLAlchemy, ipython-sql, pgspecial etc) is installed in this environment except for PostgreSQL. I am able to do everything SQL related...

mayankkaizen

dangshazi

Variable substitution error when using cell magic

1

I am using ipython-sql 0.4.0 in a Google Colaboratory notebook. Variable substitution using `$` or `{}` when using the `%%sql` cell magic results in an error, e.g. ```sql %%sql GRANT...

duncandewhurst

Use variables as table names

1

Hi! I would like to use a variable as table name. However, just doing something like ```python table_name = 'my_table' %sql select count() from :table_name ``` does not work because...

ghost

%%sql vs %sql

1

Excuse me for probably an obvious question, but still I have to ask. What is the difference between `%sql` and `%%sql` commands?

techtonik

%sql charindex issue

1

When trying to find index of a space between words in a string, CHARINDEX returns wrong result with '%sql' command, but yields the correct result with '%%sql' command: **`%sql SELECT...

mlkshclk

Maybe the close issue %sql -x sqlite:// comes from this code?

2

Please see #169 https://github.com/catherinedevlin/ipython-sql/blob/b24ac6e9410416eafde86ae22fd8d6f34acbe05d/src/sql/connection.py#L105 I suggest to replace it with (it must be a @classmethod I assume) ``` @classmethod def _close(cls, descriptor): if isinstance(descriptor, Connection): conn = descriptor else: conn...

gbrault

please see comments in the cockroach issue: https://github.com/cockroachdb/cockroach/issues/46481 The problem seems to be this if-statement in ipython-sql: if first_word.startswith('\\') and 'postgres' in str(conn.dialect): if not PGSpecial: raise ImportError('pgspecial not installed')...

dbist