====== Tabli - Connection Information ======


===== About =====
''info'' is an action of the [[docs:tabli:connection:start|connection module]] that shows the information of one or more connection in a form fashion.

<note tip>If you want to get the result in a tabular format, see the [[list|list]] action</note>

===== Example =====



==== Showing information about one database ====

This command will show the information of the [[docs:system:sqlite:howto|Sqlite HowTo Connection]]

<unit>
<code dos>
tabli connection info sqlite
</code>
<console>
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
</console>
</unit>
==== Selecting database with globbing ====

  * List only the database with ''sql'' in their name by using a [[docs:common:globbing|glob pattern]]

<unit>
<code dos>
tabli connection info *sql*
</code>
</unit>

==== Listing only  a set of databases ====

  * List only the databases with the database name [[docs:system:postgres:howto|postgres]] and [[docs:system:sqlite:howto|sqlite]]
<unit>
<code dos>
tabli connection info postgres sqlite
</code>
</unit>

===== Syntax =====
<unit>
<code dos>
tabli connection info --help
</code>
<console>
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
</console>
</unit>