ipython-sql

ipython-sql copied to clipboard

I went to see about adding this and saw that there was already some code to do this. It was commented out, and a comment suggests that this was related...

rschroll

mssql+pyodbc Error: Connection is busy with results for another command

17

Hello, this project seems really useful, but sadly, I can't get it to work with MSSql over odbc. SqlAlchemy itself works fine with this setup, but I cannot execute a...

ablepharus

support multi line statements

12

ipython-sql is a great tool for exploring databases, thanks! Complex sql statements occur to my quite often, it is convenient to split a statement in multiple lines. I couldn't figure...

christophlingg

Small patch to enable DSN query string for Oracle DBs and others

1

Does not seem worth a pull request however I will if that is preferred ``` --- /home/wkv/anaconda3/lib/python3.7/site-packages/sql/parse.py.orig 2020-09-19 01:41:43.191856384 -0600 +++ /home/wkv/anaconda3/lib/python3.7/site-packages/sql/parse.py 2020-11-19 10:42:20.759017035 -0700 @@ -11,10 +11,12 @@ parser...

wkvolkman

(question) sqlite - path with spaces or r-strings

1

how do I connect to sqlite db (on win) if the path contains spaces? `%sql sqlite:///c:\\tmp tmp\\db.db3` does not work - (sqlite3.OperationalError) near "tmp": syntax error can I somehow use...

mglatz

TypeError: Error when calling the metaclass bases on %load_ext sql

1

I installed this module using pip, but I couldn't get the %load_ext sql line to work. I then uninstalled the module, checked that it was gone, and tried to load...

davidthewatson

Closing the sql magic connection

8

Is there a way of closing a sql magic initiated connection?

psychemedia

Refreshable credentials for Aurora (PostgreSQL-compatible) with IAM

1

Hello, first of all many thanks for this awesome extension! I'm making a prototype using it and stumbled upon one problem that I haven't solved yet. Can somebody point me...

zzFluke

How can I handle exceptions under %%sql ? Below statement works: ``` try: %sql DROP INDEX index_name; %sql CREATE INDEX index_name ON table_name(column1, column2); except: %sql CREATE INDEX index_name ON...

NimJ

I'm running `%sql --connection_arguments '{"schema": "omop"}' {connection_str} ` and getting "No transaction in progress" error: ``` --------------------------------------------------------------------------- DatabaseError Traceback (most recent call last) /opt/conda/lib/python3.7/site-packages/sqlalchemy/engine/base.py in _execute_context(self, dialect, constructor, statement, parameters,...

DSLituiev