Skip to main content

dataset2dbtable​

dataset2dbtable(
    @dataset ## llll (required)
    @labelset null
    @name 'name'
    @db null
    @datafield null
    @labelfield null
) -> null

Utility function for quickly converting a dataset into a SQL database table.

Arguments​

  • @dataset [llll]: Dataset to convert. (required)
  • @labelset [llll]: Optional labelset to match with each entry. (default: null).
  • @name [symbol]: SQL table name (default: 'name').
  • @db [symbol/null]: Optional SQL database name. If null the default "main" name is used. (default: null).
  • @datafield [symbol/null]: Field prefix to be used for the data key, as a symbol. If null, the default "x" prefix is used. (default: null).
  • @labelfield [symbol/null]: Field to be used for the label key, as a symbol. If null, the default "label" is used. (default: null).

Usage​

$data = null;
$labels = null;
for $i in 0...100 do (
    $x = ($i / 100) * pi * 10;
    $point = [
        $x * (cos($x) sin($x)) ## fun stuff
    ];
    $label = tosymbol(round($i / 25)); ## dummy label
    $data _= $point;
    $labels _= $label
);
$dataset = dataset($data);
$labelset = labelset($labels);
## quick way to convert a dataset/labelset into a SQL table
dataset2dbtable(
    @dataset $dataset
    @labelset $labelset
    @datafield 'val' ## prefix to use for columns in dataset entries 
    @labelfield 'ring' ## table field to use for labelset entries
);
## open SQL table browser
browsedbtable(
    @colorfield 'ring' @sizefield 'ring' 
)