Data Resource - Attribute (Property)

Undraw Environment

About

An attribute is a property metadata 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

Attribute name are case-insensitive meaning that you can type them as you wish in:

  • UPPERCASE,
  • lowercase
  • or CamelCase.

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.

Task Runner