Data Resource - Attribute (Property)

Undraw Environment

About

A resource attribute is a attribute for a data resources.

They may be:

  • derived attributes such as the size
  • data definition attributes that describes:
    • their structure (for instance, the headerRowId attribute for a csv determines if there is or not a header row).
    • and eventually request attributes that are used as request attribute (for instance, a HTTP header for a HTTP resource).

Management

See

You can see this attributes with the tabli data info command

tabli data info characters.csv@howto
Information about the data resource (characters.csv@howto)
ATTRIBUTE      VALUE
------------   ----------------------------------------------------------
AbsolutePath   D:\code\bytle-mono\db-website\src\doc\howto\characters.csv
Characterset   ISO-8859-2
Connection     howto
Count          4
DataUri        characters.csv@howto
LogicalName    characters
Name           characters.csv
Path           characters.csv
Size           346
Type           text/csv

List

You can get them in a tabular format with the tabli data list command

tabli data list -a count -a size *@howto
count   size
-------------------   ----
                  6    132
                  4    346
                  3    268
                  5     70
         2147483647   1446
9223372036854775807    479
         2147483647    227
                 30    501
                 10    623
                 30   1512
                  1      0
                 30    313
                 10    589
                  5   1031
               1000   1027
                 30    601
                 30    321
                  1     17
                  4     65
                  1    301
                  7    230
                  2    420

Set

You can set the attributes via:

Add as virtual column

You can add the data resource attribute as extra-column via the virtual columns.

Type

Common

Common attributes are attributes that you will find on every data resources.

The following attributes are common:

  • name - the name of the data resource
  • logicalName - the name of the data resource without any extension
  • count - the number of children (Records for a table, File or Directory for a directory, ..)
  • size - the size in byte on disk (may be blank if not yet supported)
  • path - the relative (if possible) path in the connection
  • absolutePath - the absolute path in the connection
  • connection - the connection name
  • dataUri - the unique identifier of this data resource
  • type - the resource media type (ie “text/html”)
  • subtype - the resource media subtype (ie “html”)
  • parent - the parent logical name
  • md5 - the MD5 digest
  • sha384 - the SHA384 digest
  • sha384_integrity - the SHA384 integrity digest used in a integrity HTML attribute.

Specific

Specific attributes are attributes that are available only for specific type of data resource.

For instance, for a text file, you would have its characterSet.




Related HowTo
Undraw Environment
How to load a JSON documents in a database

This howto will show you how to load json document (files) into your relational database.
Undraw Environment
How to read and write an Excel file?

This howto will demonstrate you how to read and write to an Excel resource. To following this howto, you should have followed the getting started guide to have knowledge of: Resource creation...

Task Runner