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.