buggy behavior in %config SqlMagic.style

[edublancas]

I was testing the %config SqlMagic.style and realized it doesn't work well:

sometimes the text representation is empty, and changing the style does not affect it.

sample code:

%sql sqlite://

%%sql
CREATE TABLE languages (name, rating, change);
INSERT INTO languages VALUES ('Python', 14.44, 2.48);
INSERT INTO languages VALUES ('C', 13.13, 1.50);
INSERT INTO languages VALUES ('Java', 11.59, 0.40);
INSERT INTO languages VALUES ('C++', 10.00, 1.98);

%config SqlMagic.style = "PLAIN_COLUMNS"
%config SqlMagic.style = "RANDOM"
%config SqlMagic.style = "DEFAULT"
result = %sql SELECT * FROM languages LIMIT 2
print(result.pretty.get_string())

[edublancas]

note that this is code we inherited from ipython-sql so we don't even know what the purpose is or how it should work.

[AnirudhVIyer]

On it!