db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain Leroux (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-1447) add command line history to ij
Date Mon, 22 Feb 2010 11:26:28 GMT

    [ https://issues.apache.org/jira/browse/DERBY-1447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12836580#action_12836580
] 

Sylvain Leroux commented on DERBY-1447:
---------------------------------------

The total lack of editing capabilities in ij is really annoying.

To come back with a suggestion by John H. Embretsen above:
> I know that implementing this functionality in ij requires some more work, 
> but just adding a command line history should be easier than implementing 
> all the features provided by JLine

We could have just an history of the last few (all?) entered statements - and some kind of
command to edit (and re-send) one of these statements using an external editor.

Something like that:
  ij> HISTORY;      -- display the history
     1   CONNECT 'jdbc:derby:dummy';
     2   CREATE TABLE T(A INT, B int);
     3   INSERT INTO T(a,b) VALUE (1, 2),
                    (3,4),
                    (5,6);
  ij> EDIT 2;       -- edit the second statement using an external editor.
                    -- Re-runs the statement after successfull edit


I'm not sure HISTORY and EDIT have to really  be "statements". I think they should be handled
before reaching the ij parser.

Some command line utilities distinguish between "real" commands and pseudo-commands like that
by using a special notation, like backslash-letter. It's a little bit esoteric, but could
be an option to help the user remember those are "interactive commands", and such, couldn't/shouldn't
appear in a batch script:
  ij> \h 
    1   CONNECT 'jdbc:derby:dummy';
     2   CREATE TABLE T(A INT, B int);
     3   INSERT INTO T(a,b) VALUE (1, 2),
                    (3,4),
                    (5,6);
  ij> \e 2


> add command line history to ij
> ------------------------------
>
>                 Key: DERBY-1447
>                 URL: https://issues.apache.org/jira/browse/DERBY-1447
>             Project: Derby
>          Issue Type: Improvement
>          Components: Tools
>            Reporter: Gary Orser
>            Priority: Minor
>         Attachments: jline-0_9_5.jar, jline.diff
>
>
> Using the command line tool 
> org.apache.derby.tools.ij
> is user unfriendly.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message