List columns of a table
Usage
hb_list_columns(x, table, ...)
# S3 method for class 'harbour_client'
hb_list_columns(x, table, ..., refresh = FALSE)
# S3 method for class 'harbour_dtable'
hb_list_columns(x, table, ...)
# Default S3 method
hb_list_columns(x, table, ...)Value
A tibble with one row per column and columns name (chr),
type (chr), key (chr), editable (lgl) and data (list).
editable says whether harbouR writes the column: it is FALSE for
the types hb_column_types() marks read_only. SeaTable's own
editable flag is not used, since it is set for formula columns too.
The
data list-column holds the column's type-specific configuration -
for a select column, its options.
Examples
# a .dtable file needs no server
path <- system.file("extdata", "example.dtable", package = "harbouR")
hb_list_columns(hb_read_dtable(path), "Samples")
#> # A tibble: 27 × 5
#> name type key editable data
#> <chr> <chr> <chr> <lgl> <list>
#> 1 Name text 0000 TRUE <list [0]>
#> 2 Notes long-text Lt01 TRUE <list [0]>
#> 3 Concentration number Nm01 TRUE <list [0]>
#> 4 Share percent Pc01 TRUE <list [0]>
#> 5 Cost dollar Dl01 TRUE <list [0]>
#> 6 Preis euro Eu01 TRUE <list [0]>
#> 7 Runtime duration Du01 TRUE <named list [1]>
#> 8 Rating rate Rt01 TRUE <list [0]>
#> 9 Consented checkbox Cb01 TRUE <list [0]>
#> 10 Collected date Dt01 TRUE <named list [1]>
#> # ℹ 17 more rows
# a live base needs a SeaTable server and an API token
if (FALSE) { # \dontrun{
client <- hb_client()
hb_list_columns(client, "Samples")
} # }