ipython-sql

ipython-sql copied to clipboard

Pull request for the issue 357

1

Pull request for the issue 357

kewaljani

Not compatible with SQLAlchemy 2

1

Connect throws MetaData.__init__() got an unexpected keyword argument 'bind' For now specifying SQLAlchemy version better, but should actually fix

catherinedevlin

Using a list or tuple as a bind variable in Where statement

1

I'm trying to query a table where the ID's are in a list of select id's. I've tried passing this bind variable as both a list and tuple but nothing...

import-fola

Connection info needed in SQLalchemy format for ibm_db_sa

4

Hello, I am trying to connect to IBM db2 from the notebook in IBM watson studio itself. I am connecting with the proper format: (%sql ibm_db_sa://my-username:my-password@my-hostname:my-port/my-db-name?security=SSL) %sql ibm_db_sa://jl*****9:ReG**********kk*z@ea286ace-****-4d5b-8**************************od8lcg.data bases.appdomain.cloud:3***5/bludb?security=SSL Still...

swaroop-k

In Colab: Connecting fails: "got an unexpected keyword argument 'bind'"

6

Connecting like ``` %sql mysql+pymysql://{user}:{password}@{host}/shared ``` now produces: ``` __init__() got an unexpected keyword argument 'bind' Connection info needed in SQLAlchemy format, example: postgresql://username:password@hostname/dbname or an existing connection: dict_keys([]) ```...

jsmorph

SqlMagic.autocommit=True vs conn.autocommit = True

1

Using ipython-sql 0.3.9 installed via conda together with postgres and I'm not sure if the SqlMagic.autocommit=True option is working. This code ``` %load_ext sql ``` ``` %config SqlMagic.autocommit=True ``` ```...

jameshowison

connection hangs randomly

5

Hi, At random times during my notebook session, a sql statement like `%sql select count(*) from table` will just hang even though the calculation should be fast. This hang cannot...

princesscrypto1337

allow passing an engine directly to Connection

2

Hello--I've really enjoyed using ipython-sql! One challenge I have is that it requires creating a new engine, rather than using an existing one. I can work around this by having...

machow

Question: Support for SQLite UDFs?

1

Hello, first off I absolutely love your work here. But is there any existing support for creating custom SQLite functions or could it be added? **Example:** ``` from sqlalchemy import...

jonnickerson

How to use magic sql function when connecting using psycopg2?

1

Here is my code to connect to database: ``` import pandas as pd import psycopg2 import matplotlib.pyplot as plt import numpy as np %matplotlib inline import matplotlib as mpl import...

pratikchhapolika