Tabli - Connection Information
About
info is an action of the connection module that shows the information of one or more connection in a form fashion.
If you want to get the result in a tabular format, see the list action
Example
Showing information about one database
This command will show the information of the Sqlite HowTo Connection
tabli connection info sqlite
Information about the connection (sqlite)
Attribute Value Description
---------------------- ---------------------------------------------------------------- --------------------------------------------------------------------
Namespace / The namespace (schema for database, parent folder for file system)
DatabaseMajorVersion 3 The major version number of the database
DatabaseMinorVersion 30 The minor version number of the database
DatabaseProductName SQLite The name of the database
DatabaseProductVersion 3.30.1 The version of the database
Driver org.sqlite.JDBC The driver class
DriverName SQLite JDBC The driver name
DriverVersion 3.30.1 The driver version
JdbcMajorVersion 2 The major version number of JDBC
JdbcMinorVersion 1 The minor version number of JDBC
MaxConcurrentThread 1 The maximum number of threads that can be created against the system
MaxNameInPath 1 The maximum number of names in a path
Name sqlite The name of the connection
SupportBatchUpdates true If the system supports batch SQL updates
SupportNamedParameters true If the system supports named parameters in the SQL statement
TabBooleanDataType Binary Boolean data type used to store boolean values
TabDateDataType SqlLiteral Date data type used to store date values
TabTimeDataType SqlLiteral Time format data type to store time values
TabTimestampDataType SqlLiteral Timestamp data type used to store timestamp values
Url jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite.db The url of the connection
Selecting database with globbing
- List only the database with sql in their name by using a glob pattern
tabli connection info *sql*
Listing only a set of databases
tabli connection info postgres sqlite
Syntax
tabli connection info --help
Tabli connection info
=====================
Print connection attributes in a form fashion.
Examples
--------
1 - To output information about the connection `name`:
tabli connection info name
2 - To output information about all the connection with `sql` in their name:tabli connection info sql*
Syntax
------
tabli connection info [options|flags] <(NamePattern)...>
where:
Arguments:
<(NamePattern)...> one or more connection name
Options:
-ns,--not-strict If there is no connection found, no errors will be emitted
Global Options:
-cf,--conf <path> The path to a configuration file
-cv,--connection-vault <path> The path where a connection vault is located
-h,--help Print this help
-l,--log-level <error|warning|tip|info|fine> Set the log level
-odu,--output-data-uri <outputDataUri> defines the output data uri for the feedback data (default: console)
-oo,--output-operation <dataOperation> defines the data operations (replace, truncate) on an existing output resource before transfer.
-oop,--output-transfer-operation <transferOperation> defines the output transfer operation (insert, update, merge, copy). Default to `copy` for a file system and `insert` for a database.
-pp,--passphrase <passphrase> A passphrase (master password) to decrypt the encrypted values
-ph,--project-home <dataUri> A data uri to the project directory (ie a path)
-v,--version Print version information