Our cmd is based on sqlline, and the sqlline is based on jline.

package

mvn package -pl start-db-cmd -am -DskipTests=true -Dcheckstyle.skip

usage

D:\workspace\git\start-db\cmd\target>java -jar start-db-cmd.jar -u start_db -p start-db -r jdbc:start-db:url=http://127.0.0.1:8000
sqlline version 1.12.0
Transaction isolation level TRANSACTION_REPEATABLE_READ is not supported. Default (TRANSACTION_NONE) will be used instead.
start-db> select count(1) from citibike_tripdata;
+--------+
| EXPR$0 |
+--------+
| 0      |
+--------+
1 row selected (0.252 seconds)
start-db> !exit

source

execute multi insert from a file.

0: jdbc:start-db:url=http://127.0.0.1:8000> !source D:\workspace\git\start-db\start-db-cmd\src\test\resources\t_test_update.sql
Have inserted 64 lines.
insert finished.