NAME

benchmarkanything-storage - BenchmarkAnything storage cmdline tool

SYNOPSIS

Default data format (in and out) is JSON, other formats can be specified.

• Initialize BenchmarkAnything:

  $ benchmarkanything-storage init

• OPTIONAL: Configure MySQL

  Iff you want to use MySQL instead of the default SQLite, then edit the just created ~/.benchmarkanything/default.cfg and in the section

  benchmarkanything:
   backend: local
   storage:
     backend:
       sql:
         dsn: dbi:SQLite:...
         #dsn: DBI:mysql:database=benchmarkanything
         #user: benchmarker
         #password: secret
         ...

  comment out the dsn:dbi:SQLite... line and uncomment the dsn:DBI:mysql... and corresponding user: and password: lines, so it now looks like:

  benchmarkanything:
   backend: local
   storage:
     backend:
       sql:
         #dsn: dbi:SQLite:...
         dsn: DBI:mysql:database=benchmarkanything
         user: benchmarker
         password: secret
         ...

  And yes, choose a better password!

  Then initialize you MySQL like this:

  $ sudo apt-get install mysql-server-5.6 mysql-client-5.6
  $ mysql -u root -p
    mysql> create database if not exists benchmarkanything;
    mysql> create user 'benchmarker'@'localhost' identified by 'secret';
    mysql> grant all privileges on benchmarkanything.* to 'benchmarker'@'localhost';
    mysql> flush privileges;
    mysql> quit;

• Create BenchmarkAnything storage database:

  $ benchmarkanything-storage createdb

  This will ask if you are sure before it creates the actual db with tables.

• Add data to backend storage:

  $ benchmarkanything-storage add         data.json
  $ benchmarkanything-storage add -i yaml data.yaml

• Query backend storage for data:

  $ echo 'json_search_query' | benchmarkanything-storage search -

Input formats

The following input formats are allowed, with their according modules used to convert the input into a data structure:

yaml   - YAML::Any (default)
json   - JSON
dumper - Data::Dumper (including the leading $VAR1 variable assignment)

Output formats

The following output formats are allowed:

yaml   - YAML::Any
json   - JSON (default)
xml    - XML::Simple
ini    - Config::INI::Serializer
dumper - Data::Dumper (including the leading $VAR1 variable assignment)
flat   - pragmatic flat output for typical unixish cmdline usage

See "Output formats" in BenchmarkAnything::Storage::Frontend::Lib for more details, especially about the flat output format.

_read_in

This function reads in a data structure. The meaning of the data depends on the sub command: for search it is a search query, for add it is an array of BenchmarkAnything data points.

_write_out

This function writes a data structure in requested output format.

ABOUT

Cmdline tool to handle BenchmarkAnything data, see http://benchmarkanything.org

SEE ALSO

For more information about the BenchmarkAnything schema, see http://www.benchmarkanything.org/.

AUTHOR

Steffen Schwigon <ss5@renormalist.net>

COPYRIGHT AND LICENSE

This software is copyright (c) 2020 by Steffen Schwigon.

This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.