dbget

Documentation

Overview

dbget is command line tool to export OpenM++ model metadata, input parameters and run results.

Get list of the models from database:

dbget -db modelOne.sqlite -do model-list

Aggregate microdata run values:

dbget -db test\modelOne.sqlite -do microdata-aggregate
  -m modelOne
  -dbget.WithRunIds 219,221
  -dbget.Entity Other
  -dbget.GroupBy AgeGroup
  -dbget.Calc OM_AVG(Income)

Compare microdata run values:

dbget -db modelOne.sqlite -do microdata-compare
  -m modelOne
  -dbget.RunId 219
  -dbget.WithRunIds 221
  -dbget.Entity Person
  -dbget.GroupBy AgeGroup
  -dbget.Calc OM_AVG(Income[base]-Income[variant])

Aggregate and compare microdata run values:

dbget -db test\modelOne.sqlite -do microdata-aggregate
  -m modelOne
  -dbget.RunId 219
  -dbget.WithRunIds 221
  -dbget.Entity Other
  -dbget.GroupBy AgeGroup
  -dbget.Calc OM_AVG(Income),OM_AVG(Income[base]-Income[variant])