Table of Contents

About

How to list connection with the tabli connection list command

Steps

Listing all connections

tabli connection list *

Name            Url
-------------   -----------------------------------------------------------------------
cd              file:///D:/code/bytle-mono/ansible/
entity          file:///D:/code/bytle-mono/db-gen-entities/src/main/resources/entity/
howto           file:///D:/code/bytle-mono/db-website/src/doc/howto/
memory          mem
mysql           jdbc:mysql://[host]:[port]/[database]
oracle          jdbc:oracle:thin:@[host]:[port]/[servicename]
postgres        jdbc:postgresql://localhost:5432/postgres
sqlite          jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite.db
sqlite_target   jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite_target.db
sqlserver       jdbc:sqlserver://localhost;databaseName=AdventureWorks;
temp            file:///C:/Users/GERARD~1/AppData/Local/Temp/
tpcds           tpcds
tpcds_query     file:///D:/code/bytle-mono/db-jdbc/src/main/sql/tpcds/

Listing a subset with globbing

  • List only the connections with sql in their name by using a glob pattern
tabli connection list *sql*

Name            Url
-------------   -----------------------------------------------------------------------
mysql           jdbc:mysql://[host]:[port]/[database]
sqlite          jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite.db
sqlite_target   jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite_target.db
sqlserver       jdbc:sqlserver://localhost;databaseName=AdventureWorks;

Listing only a set of connections

tabli connection list oracle sqlite

Name     Url
------   ----------------------------------------------------------------
oracle   jdbc:oracle:thin:@[host]:[port]/[servicename]
sqlite   jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite.db

Choosing the attributes to return

List the connections with the name, user and url connection attribute 

tabli connection list -a name -a user -a url *

name            user       url
-------------   --------   -----------------------------------------------------------------------
cd                         file:///D:/code/bytle-mono/ansible/
entity                     file:///D:/code/bytle-mono/db-gen-entities/src/main/resources/entity/
howto                      file:///D:/code/bytle-mono/db-website/src/doc/howto/
memory                     mem
mysql                      jdbc:mysql://[host]:[port]/[database]
oracle                     jdbc:oracle:thin:@[host]:[port]/[servicename]
postgres        postgres   jdbc:postgresql://localhost:5432/postgres
sqlite                     jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite.db
sqlite_target              jdbc:sqlite:///C:/Users/gerardnico/AppData/Local/tabli/sqlite_target.db
sqlserver       sa         jdbc:sqlserver://localhost;databaseName=AdventureWorks;
temp                       file:///C:/Users/GERARD~1/AppData/Local/Temp/
tpcds                      tpcds
tpcds_query                file:///D:/code/bytle-mono/db-jdbc/src/main/sql/tpcds/