Tabul - Data Print command

Undraw Windows

About

data print is a command that prints the whole content of a resource.

This command is useful to print content of data resource that have a small size. If your data resource is to big to be printed, you can use:

  • the head command to print the first content of a data resource
  • the tail command to print the last content of a data resource

Syntax

tabul data print -h
Tabul data print
================

Print the content of data resources.

This command will print all data.
To print in a limited fashion, you can use the following commands:
 * `head` :  print the head (the first pieces of content)
 * `tail` :  print the tail (the last pieces of content)



Examples
--------

 1 - Show all the records of the table `sales` from the data store `sqlite`:

    tabul data print sales@sqlite


 2 - Show the content of the file `request.log`:

    tabul data print request.log




Syntax
------


    tabul data print [options|flags] <data-selector...>


where:


  Arguments:

    <data-selector...>                                         One or more data or script selectors


  Data Definition Options:

    -a,--attribute <attributeName=value>                       Set specific data resource attributes


  Selection Options:

    --strict-selection                                         If set the selection will return an error if no data resources have been selected

    -wd,--with-dependencies                                    If set, the dependencies will be also selected


  Options:

    -t,--type <mediaType|mimeType|extensionFile>               The type of the resource

    -vc,--virtual-column <columnName=resourceAttributeName>    Add a virtual column with the value of a data resource attribute


  Global Options:

    -ah,--app-home <path>                                      The app home directory (default to the .tabul.yml file directory)

    -vf,--conf <path>                                          The path to a configuration file

    -ee,--exec-env <name>                                      The execution environment (prod or dev)

    -h,--help                                                  Print this help

    -l,--log-level <error|warning|tip|info|fine>               Set the log level

    -ns,--not-strict                                           A minor error will not stop the process.

    -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 vault values (Env: TABUL_PASSPHRASE)

    --pipe-mode                                                Use pipe mode if you want to pipe the output in a shell. Pipe mode will not print the headers (ie column name) and will not make the control character visible

    -v,--version                                               Print version information




Related HowTo
Undraw Windows
Database HowTo - How to load JSON documents in a database

This howto will show you how to load json document (files) into your relational database.
Undraw Windows
How to define an archive entry as data resource?

This howto will show you how to define an entry in an archive as data resource. In the world-db.tar.gz archive of the MySQL...
Undraw Windows
How to execute a bash script ?

This howto shows you how to execute a bash script against the local file system. The bash script that will be executed is: a simple hello world sample application that accepts optionally 1 argument...
Undraw Windows
How to execute a procedure in MySQL ?

This howto shows you how to create and execute a SQL Procedure in MySQL. This example has been taken from the official...
Undraw Windows
How to execute a procedure in Postgres?

This howto shows you how to create and execute a SQL Procedure in Postgres. This example has been taken from the official...
Undraw Windows
How to execute a procedure with an OUT parameter in Postgres?

This howto shows you how to create and execute a SQL Procedure with parameters in Postgres. This example has been taken from the official...
Undraw Windows
How to generate data with a data set?

This howto will show you how to generate data with an data set generator. In these examples, we use a predefined csv entity file but you could any data resource such as : a sql table a sql query...
Undraw Windows
How to generate data with an entity?

This howto will show you how to generate data with an entity generator. Example of a basic entity generator resource that uses the firstname entity to fill a firstname column You can see the output...
Undraw Windows
How to install the World MySQL Sample Schema

This howto will show you how to install the world sample schema of MySQL. The installation is done with the sql script world.sql This script is idempotent...
Undraw Windows
How to load and analyze YAML documents in a database?

This howto will show you how to load and analyze yaml document (files) into a relational database. sqlite howto databaserelational database At its core a YAML file is just a JSON file styled in...

Task Runner