About
A data selector is a data uri expression that permits to select:
- data resources (file, table,…)
- or container resources (directory, schema, …)
If you are new to the concept of data selector, we encourage you to take a look at this page: Learning Tabulify - Step 4 - How to select Data Resources
Syntax
This syntax select data resources listed in the connection
globPath[@connection]
where:
- connection is the name of a connection
- globPath is a path composed of glob pattern separated by a path separator
You can reference each wildcard character in a target data uri to define the target resources.
File System
For a file system, the following special character are supported in the path:
- / for the separator
- . to design the current working directory
- .. to design the parent directory of the current working directory
Example:
- Absolute
# Linux
/globPatternForDirectory/globPatternForFile@fileSystemConnection
# Windows
C:\globPatternForDirectory\globPatternForFile@fileSystemConnection
- Relative
# Linux (and Windows)
../globPatternForDirectory/globPatternForFile@fileSystemConnection
# Windows form works also but is not recommended
..\globPatternForDirectory\globPatternForFile@fileSystemConnection
Sql Database
For a sql database, the following characters are supported in the path:
- ., for the path name separator
- / to design the current schema
- // to design the parent (schema, catalog)
# an sql object pattern
[catalogueGlobPattern][.schemaNamePattern.]objectNamePattern@database
# a sql schema pattern
//.schemaNamePattern
# a sql catalog pattern
//.//.schemaNamePattern
Web
For a web system, Tabulify supports passing directly an URI/URL as a data selector.
Only in bash based terminal, see why
tabli data info "https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description"
Information about the data resource (https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description@https:--en.wikipedia.org-w)
attribute value
--------------- -----------------------------------------------------------------------------------------------------------------
AbsolutePath https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description
Characterset ISO-8859-1
Connection https:--en.wikipedia.org-w
Count 1
DataUri https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description@https:--en.wikipedia.org-w
LogicalName api
Md5 b61936451e935f25c7683ede9b26801b
Name api.php
Parent w
Path https://en.wikipedia.org/w/api.php?action=query&titles=SQL&format=xml&prop=description
Sha384 a27590cd933c93a9fd7dda31e0d20d5fab3ee0b952f6382c4d615d732df64347523e5368d007c6d4076a3d494b050acf
Sha384Integrity sha384-onWQzZM8k6n9fdox4NINX6s+4LlS9jgsTWFdcy32Q0dSPlNo0AfG1AdqPUlLBQrP
Size -1
Type application/xml