Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I don't know about the console, but this is possible with <a href="https://github.com/wuub/SublimeREPL" rel="noreferrer">SublimeREPL</a>.</p> <p>As long as you have a REPL and a file of the same language open at the same time, you can send a line (or a selection or file) to your open REPL via the SublimeREPL <a href="http://sublimerepl.readthedocs.org/en/latest/#source-buffer-keys" rel="noreferrer">Source Buffer Keys</a>. By default, <code>Ctrl+,</code> followed by <code>l</code> sends the current line to the REPL, but you can change the hotkey to <code>Ctrl+Enter</code> (in Python only, to protect other languages' default <code>Ctrl+Enter</code> functionality) by adding these lines to the top of your <code>Preferences -&gt; Key Bindings – User</code> file:</p> <pre><code>{ "keys": ["ctrl+enter"], "command": "repl_transfer_current", "args": {"scope": "lines"}, "context": [ { "key": "selector", "operator": "equal", "operand": "source.python", "match_all": true } ] }, </code></pre> <p>Other available scopes (from <code>Preferences -&gt; Browse Packages -&gt; SublimeREPL/Default (Windows).sublime-keymap</code>) are <code>selection</code>, <code>file</code>, and <code>block</code> (Clojure only). If you want to send a line to your REPL but <strong>not</strong> parse it immediately, you can add <code>"action":"view_write"</code> to the <code>args</code> object, like so:</p> <pre><code>{ "keys": ["ctrl+enter"], "command": "repl_transfer_current", "args": {"scope": "lines", "action": "view_write"}, "context": [ { "key": "selector", "operator": "equal", "operand": "source.python", "match_all": true } ] }, </code></pre> <p>See the <a href="https://sublime-text-unofficial-documentation.readthedocs.org/en/latest/reference/key_bindings.html" rel="noreferrer">Unofficial Sublime Text 2 Docs</a> for more information on key bindings. </p> <p>In the case that the REPL is open in a different tab than your source (rather than a separate view), the source buffer hotkeys will <strong>not</strong> focus the REPL. I'm sure it's possible to implement some sort of tab-swapping toggle key, but that sounds like a problem for another question.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to pass a line to the console in sublime text 2 editor
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USangerson
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to pass a line to the console in sublime text 2 editor
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThat is terrific. Thank you @ProtractorNinja. A quick follow on question - is it possible to get both functions. So I'd like to send the line to the console and see it before it is executed. Thanks -- Sorry by console I mean REPL
      singulars
      1. PO
      1. USTahnoon Pasha
    2. CO@TahnoonPasha Yes! Add the second larger code snippet to your `Key Bindings – User` file alongside the first and adjust the `"keys"` value to whatever you want the send-but-don't-evaluate key to be, say, `ctrl+shift+enter`. Then `ctrl+enter` will send *and* evaluate the line, whereas `ctrl+shift+enter` will send and *not* evaluate the line. If you aren't interested in custom keypresses, the default send-but-don't-evaluate key combination is `ctrl+shift+,` followed by `l`.
      singulars
      1. PO
      1. USangerson
    3. COThanks @ProtractorNinja I think I must be doing something wrong. When I do the send-and-evaluate it doesn't echo in the REPL terminal, it just evaluates and returns an extra `>>>` when its done. What I was hoping was if I had e.g `import imaplib` and I did `ctrl+enter` I would see `>>>import imaplib` which would evaluate and then a new `>>>`. Is your code expected to have that effect? Thanks again for your help with this.
      singulars
      1. PO
      1. USTahnoon Pasha
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload