[IPython-User] %sql magic released

Alan alanwilter@gmail....
Tue Apr 9 11:21:38 CDT 2013


Thanks Matthias,

Indeed,

% config SqlMagic.style = 'PLAIN_COLUMNS'

works,

But

%config SqlMagic.autolimit = 10

seems not, since when I do a query in oracle:

aa = %sql select * from dbentry where rownum < 100 -- (I have millions of
rows in dbentry)
len(aa)
99

Alan


On 9 April 2013 15:30, Matthias BUSSONNIER <bussonniermatthias@gmail.com>wrote:

> Hi,
>
> Shot in the dark based on previous discussion on the ML.
>
> Try :
>
> %config SqlMagic.autolimit = 1000
>
> or at least, see if
>
> %config SqlMagic
>
> Tell you something.
>
> This is because in config files, `c` represent the current config "dict"
> which your current session does not now about.
>
> Will not, of course,  persist across sessions.
> --
> Matthias
>
>
> Le 9 avr. 2013 à 16:24, Alan a écrit :
>
> Dear Catherine,
>
> %sql magic is fantastic to say the minimum. I am testing with oracle db
> and it seems to work just fine. However,
>
> c.SqlMagic.autolimit = 1000
>
> seems to not be working for me. Is there a way of setting this limit in a
> already started ipython session?
>
> Thanks,
>
> Alan
>
>
> On 29 March 2013 18:45, Catherine Devlin <catherine.devlin@gmail.com>wrote:
>
>> https://pypi.python.org/pypi/ipython-sql
>>
>> Works with any database SQLAlchemy can see.  Renders query results as
>> HTML tables in the Notebook, or pretty text at the text console.
>>
>> Enjoy & give feedback!
>>
>> I suggest just installing with ``pip install ipython-sql``.  I haven't
>> been able to figure out how to use %load_ext successfully, since it's not a
>> single .py file, and using %load_ext for the whole .zip file from
>> https://github.com/catherinedevlin/ipython-sql/archive/master.zipdoesn't seem to work... but if you know how to fix that, do tell...
>>
>> Thanks,
>> --
>> - Catherine
>> http://catherinedevlin.blogspot.com
>>
>> _______________________________________________
>> IPython-User mailing list
>> IPython-User@scipy.org
>> http://mail.scipy.org/mailman/listinfo/ipython-user
>>
>>
>
>
> --
> Alan Wilter SOUSA da SILVA, DSc
> Bioinformatician, UniProt - PANDA, EMBL-EBI
> CB10 1SD, Hinxton, Cambridge, UK
> +44 1223 49 4588
>  _______________________________________________
> IPython-User mailing list
> IPython-User@scipy.org
> http://mail.scipy.org/mailman/listinfo/ipython-user
>
>
>
> _______________________________________________
> IPython-User mailing list
> IPython-User@scipy.org
> http://mail.scipy.org/mailman/listinfo/ipython-user
>
>


-- 
Alan Wilter SOUSA da SILVA, DSc
Bioinformatician, UniProt - PANDA, EMBL-EBI
CB10 1SD, Hinxton, Cambridge, UK
+44 1223 49 4588
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.scipy.org/pipermail/ipython-user/attachments/20130409/cc70ea0c/attachment.html 


More information about the IPython-User mailing list