Overview sqlline tool

Bellow you can find overview internal commands of command line tool [1] that can send some sql queries to Apache Ignite grid via JDBC Thin client.

1 - GitHub link https://github.com/julianhyde/sqlline

command	note	status	comment
!all	Execute the specified SQL against all the current connections.	OK	---
!autocommit	Enable or disable automatic transaction commit mode	FAILED	Impossible to disable autocommit
!batch	Start or execute a batch of SQL statements	OK	---
!brief	Enable terse output mode	OK	---
!verbose	Enable verbose output mode	OK	---
!call	Execute a callable statement	N/A	Doesn't support from our side.
!close	Close the active connection	FAILED	Error message: Ambiguous command: [close, closeall]
!closeall	Close all current open connections	OK	---
!columns	Display columns of a table	OK	Display int instead of type of field e.g. -5 = java.lang.Long, 12 = java.lang.String
!commit	Commit the current transaction, if autocommit is off.	FAILED	autocommit always true so commit doesn't make sense
!connect	Connect to a database	OK	---
!dbinfo	List metadata information about the current connection.	OK	---
!describe	Synonym for columns (if an argument is specified) or tables (if no argument is specified).	FAILED	Doesn't work without parameter. so now !describe =!columns
!dropall	Drop all tables in the database	OK	---
!exportedkeys	List exported foreign keys for a database	N/A	Doesn't support from our side.
!go	Change to a different active connection	OK	---
!help	Display help information	OK	Help shows not all commands that there are in manual.
!history	Display the command history	OK	---
!importedkeys	List imported foreign keys for a database	N/A	Doesn't support from our side.
!indexes	Display indexes for a table	OK	---
!isolation	Set the transaction isolation mode for the active connection	FAILED	autocommit always equals true so I can't to test this parameter
!list	Display all active connections	OK	---
!manual	Display sqlline manual	OK	---
!metadata	Invoke arbitrary metadata commands	OK	---
!nickname	Create a friendly name for the connection (updates command prompt)	OK	---
!outputformat	Change the method for displaying SQL results	OK	---
!primarykeys	Display the primary key columns for a table	OK	---
!procedures	List stored procedures	N/A	Doesn't support from our side.
!properties	Connect to the database defined in the specified properties file.	OK	---
!quit	Exit SQLLine	OK	---
!reconnect	Reconnect to the current database	OK	---
!record	Begin recording all output from SQL commands	OK	---
!rehash	Get a list of all tables and columns from the database in order to include them in the list for tab-completion of SQL statements. This is done automatically on connect when the fastconnect option is enabled.	FAILED - with and without fastconnect	NPE from sqlline side
!rollback	Roll back the current transaction (if autocommit is off)	FAILED	autocommit always true so rollback doesn't make sense
!run	Execute a command script	OK	---
!save	Save the current preferences to some file	FAILED	Doesn't override current parameters in ~/.sqlline/sqlline.properties
!scan	Scan class path for JDBC drivers	FAILED	Output - Compliant Compliant Version Compliant Compliant Version Driver Class Compliant Compliant Version Compliant Compliant Version Driver Classno 1.0 org.apache.ignite.IgniteJdbcDriverCompliant Compliant Version Compliant Compliant Version Driver Classno
!script	Save executed commands to a file	OK	---
!set	Set a sqlline variable	FAILED	Values of parameters wasn't changed
!sql	Execute a SQL against a database	OK	---
!tables	List all the tables in the database	OK	---

Page tree

Overview sqlline tool