How to execute ccm cqlsh commands like INSERT ,CREATE and SEELCT inside shell script?

Question

Wanted to execute few commands independently like CREATE, INSERT and SELECT inside shell script i.e., makefile.sh. Example:-

cqlsh "CREATE <SOME QUERY>;"
cqlsh "INSERT <SOME QUERY>;"
cqlsh "SELECT <SOME QUERY>;"

Is there any way to do so??

Answer 1

You could use the -e option and specify a cql statement or -f and specify a file. More details here.