cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vin01 (JIRA)" <>
Subject [jira] [Created] (CASSANDRA-12349) Adding some new features to cqlsh
Date Sat, 30 Jul 2016 03:54:20 GMT
vin01 created CASSANDRA-12349:

             Summary: Adding some new features to cqlsh
                 Key: CASSANDRA-12349
             Project: Cassandra
          Issue Type: New Feature
         Environment: All
            Reporter: vin01
            Priority: Minor

I will like to have following features in in cqlsh, I have made a patch to enable them as

1. Aliases.
2. Safe mode (prompt on delete,update,truncate,drop if safe_mode is true).
3. Press q to exit.

Its also shared here ->

Example for aliases :-

cassandra@cqlsh> show 
         ;        <enter>  ALIASES  HOST     SESSION  VERSION  
cassandra@cqlsh> show ALIASES ;
Aliases :> {'dk': 'desc keyspaces;', 'sl': 'select * from'}

now if you type dk and press <tab> it will auto complete it to "desc keyspace".

Adding an alias from shell :-

cassandra@cqlsh> alias slu=select * from login.user ;
Alias added successfully - sle:select * login.user ;
cassandra@cqlsh> show ALIASES ;
Aliases :> {'slu': 'select * from login.user ;', 'dk': 'desc keyspaces;', 'sl': 'select
* from'}
cassandra@cqlsh> sle
Expanded alias to> select * from login.user ;
 username                 | blacklisted | lastlogin | password   

Adding an alias directly in file :-

aliases will be kept in same cqlshrc file.
dk = desc keyspaces;
sl = select * from
sle = select * from login.user ;

now if we type just "sle" it will autocomplete rest of it and show next options.

Example of safe mode :-

cassandra@cqlsh> truncate login.user ;
Are you sure you want to do this? (y/n) > n
Not performing any action.

cassandra@cqlsh> updatee login.user set password=null;
Are you sure you want to do this? (y/n) > 
Not performing any action.

Initial commit :-

Current version :-

Please review and suggest any improvements.

This message was sent by Atlassian JIRA

View raw message