3 ms·

I gave it a spin. Seems pretty useful. Is there a way to view the last result again without re-running the query? Also the keybindings are missing from the doc

by Grue3 11y ago

I gave it a spin. Seems pretty useful. Is there a way to view the last result again without re-running the query? Also the keybindings are missing from the docs. For example on http://mycli.net/multi-line http://mycli.net/multi-line it says "You can enable multi-line mode by pressing key" but doesn't say which key to press. And on http://mycli.net/history http://mycli.net/history it says "So press and then start typing your search term to see the queries", again doesn't say what to press.

amjith 11y ago
Thank you for reporting the missing keys. I had them as <C-r> and <F3> but it was misinterpreted as html tags. It is fixed now. I'm not sure what you mean by view the results without re-running the query. Does scrolling not work? or do you mean if you launch a new session and want to see the results? If you want to keep the results you can use audit logging feature (http://mycli.net/logging http://mycli.net/logging) which records every query and it's output into a file.
- Grue3 11y ago
  If the resulting table is large and opens up a less-like mode where I can scroll and pan around, but if I quit this mode, the terminal is cleared and there seems to be no way to take a second look at the data.
  - amjith 11y ago
    Can you tell me which OS you're using? In Linux and OS X the less command should keep the output in the screen after you press 'q'.
    - chx 11y ago
      I am on Linux too and it doesn't. Not just this tool: in general.
      - amjith 11y ago
        If you have 'less' on your system then it should work because I'm manipulating the options that are passed into less. I'm setting the less options here: https://github.com/dbcli/mycli/blob/master/mycli/main.py#L426 https://github.com/dbcli/mycli/blob/master/mycli/main.py#L42... You can try that from the command line yourself. Try: less -SRXF <filename.txt> That should print the file and not clear the screen when you press 'q'. You can also override the pager to change from less to something else right from inside mycli. For example: amjith@localhost:(none)> pager cat That will use cat instead of less for paging the output and that should keep the output in the screen but it won't page them like less.

by Grue3 11y ago

amjith 11y ago

Thank you for reporting the missing keys. I had them as <C-r> and <F3> but it was misinterpreted as html tags. It is fixed now. I'm not sure what you mean by view the results without re-running the query. Does scrolling not work? or do you mean if you launch a new session and want to see the results? If you want to keep the results you can use audit logging feature (http://mycli.net/logging http://mycli.net/logging) which records every query and it's output into a file.

Grue3 11y ago
If the resulting table is large and opens up a less-like mode where I can scroll and pan around, but if I quit this mode, the terminal is cleared and there seems to be no way to take a second look at the data.
- amjith 11y ago
  Can you tell me which OS you're using? In Linux and OS X the less command should keep the output in the screen after you press 'q'.
  - chx 11y ago
    I am on Linux too and it doesn't. Not just this tool: in general.
    - amjith 11y ago
      If you have 'less' on your system then it should work because I'm manipulating the options that are passed into less. I'm setting the less options here: https://github.com/dbcli/mycli/blob/master/mycli/main.py#L426 https://github.com/dbcli/mycli/blob/master/mycli/main.py#L42... You can try that from the command line yourself. Try: less -SRXF <filename.txt> That should print the file and not clear the screen when you press 'q'. You can also override the pager to change from less to something else right from inside mycli. For example: amjith@localhost:(none)> pager cat That will use cat instead of less for paging the output and that should keep the output in the screen but it won't page them like less.