How to change max items to show on Pycharm

Answered
Avatar
Permanently deleted user
Created

Hi, 

I am begginer on pycharm and I have imported an table from SQL Server. I have used the pymsslq libray for it.

Well, I have got my rows but I only can see on my console the first 300 rows.

How can I do to see a larger number of rows??

Thanks

Angel

Votes

0

Share

7 comments
Avatar
Permanently deleted user
Created
0
Avatar
Paul Everitt
Created

The debugger isn't really designed to efficiently show large amounts of data. If you're using PyCharm Professional, you can use the "Database" tool for that.

If not, I would suggest iterating in batches of several hundred and use debugger stepping to go forwards, batch at a time.

0
Avatar
Permanently deleted user
Created

Thanks for your reply Paul.

 

Where can I read about Database tool on Pycharm Professional??

0
Avatar
Paul Everitt
Created

Here are some links:

0
Avatar
Permanently deleted user
Created

Thanks very much Paul.

0
Avatar
Permanently deleted user
Created

I see on this documentation that sql statements dont accept parameters on pycharm. Then cant I execute a sql execute procedure with parameters??

What about dinamic sql? Can I use it? 

0
Avatar
Paul Everitt
Created

I believe that parameterized queries might be possible. But I haven't tried myself.

0

Please sign in to leave a comment.