print result in console if in notebook mode

[litaotao]

I think should print result in the output cell in notebook if "ipython notebook " and load this extension in the opened notebook.

screenshots: [ Please do not mind the mask on the screenshots, for I use some data of our company, just for security reasons, thanks a lot ]

input on notebook cell

#### output result in console

#### code related is here

https://github.com/jaysw/ipydb/blob/master/ipydb/plugin.py

def render_result(self, cursor, paginate=True,
                      filepath=None, sqlformat=None):
        """Render a result set and pipe through less.
        Args:
            cursor: iterable of tuples, with one special method:
                    cursor.keys() which returns a list of string columns
                    headings for the tuples.
        """
        if not sqlformat:
            sqlformat = self.sqlformat
        if filepath:
            out = open(filepath, 'w')
            sqlformat = 'csv'
        else:
            out = pager()
        with out as stdout:
            if sqlformat == 'csv':
                self.format_result_csv(cursor, out=stdout)
            else:
                asciitable.draw(cursor, out=stdout,
                                paginate=paginate,
                                max_fieldsize=self.max_fieldsize)

Will PR a fix if you guys agree with this advice

[jaysw]

Hi there,

Thanks for the very detailed description!
This issue is covered by the comments in #10. Closing as a duplicate.