TNPM/resmgr automated

From neil.tappsville.com
Revision as of 09:53, 3 September 2019 by Gonzo (talk | contribs) (Created page with "===A bunch of wrappers for the resmgr command=== Out of the box, resmgr will allow you to do some pretty stupid things to the database. These are logical wrappers that take t...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

A bunch of wrappers for the resmgr command

Out of the box, resmgr will allow you to do some pretty stupid things to the database. These are logical wrappers that take the hurt out of doing development / syncing environments

Sorry the actual perl scripts are locked away, the format of the files they produce is listed here for reference however


export_agp_appS_chart_group_links.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export agp -colNames "dbIndex npath appS.dbIndex appS.name"
 -filter "dbIndex($agplevelhash{"$npath"}->{"dbindex"})" -order appS.dbIndex | sort
 > data/agp_appS/$agplevelhash{"$npath"}->{"dbindex"}.rmgr

export_agp_app_report_group_links.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export agp -colNames "dbIndex npath app.dbIndex app.name"
 -filter "dbIndex($agplevelhash{"$npath"}->{"dbindex"})" -order app.dbIndex | sort >
 data/agp_app/$agplevelhash{"$npath"}->{"dbindex"}.rmgr

export_agp_report_groups.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export agp -colNames "dbIndex npath"
-filter "dbIndex($agplevelhash{"$npath"}->{"dbindex"})" -file data/agp/$agplevelhash{"$npath"}->{"dbindex"}.rmgr

export_appS_charts.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export appS -colNames "dbIndex name type comment definition"
 -filter "appS.dbIndex($dbIndex)" -file data/appS/$dbIndex.rmgr

export_app_reports.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export app -colNames "dbIndex name comment url type data"
 -filter "app.dbIndex($dbIndex)" -file data/app/$dbIndex.rmgr

export_fgp_formula_groups.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export fgp -colNames "dbIndex npath"
 -filter "dbIndex($fgplevelhash{"$npath"}->{"dbindex"})" -file data/fgp/$fgplevelhash{"$npath"}->{"dbindex"}.rmgr

export_frm_formulas.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export fgp -colNames "fgp.npath frm.dbIndex frm.name frm.comment frm.type
 frm.subType frm.data frm.dataType frm.defValue frm.state frm.domaine frm.exprType frm.invariant frm.curve frm.origin
 frm.user"  -filter "frm.dbIndex($dbIndex)" -file data/fgp_frm/$dbIndex.FRM.rmgr

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export fgp -colNames "fgp.npath frm.dbIndex frm.name frm.mibPath
 frm.mibOrigin frm.mibUser frm.origin frm.user" -filter "frm.dbIndex($dbIndex)" -file data/fgp_frm/$dbIndex.MIB.rmgr

export_linkGroupSE_report_links.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export segp -colNames "npath app.dbIndex app.name"
 -filter "npath($npath)" | sort > data/linkGroupSE/$safename.rmgr

export_pctile_aggregation_requests.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export pctile -colNames "fgp.nName segp.npath ttype status storage period
 state instance value type user origin" -filter "segp.dbIndex($pctilelevelhash{"$npath"}->{"dbindex"})"
 -order fgp.nName | sort > data/pctile/$safename.rmgr

export_segpreq_collection_requests.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export segpreq -colNames "fgp.nName segp.npath ttype status storage period instance
state user origin" -filter "segp.dbIndex($segpreqlevelhash{"$npath"}->{"dbindex"})" -order fgp.nName
| sort > data/segpreq/$safename.rmgr

==export_segp_rules.pl== - Note this doesnt track dbIndexes, but it should (be warned when using with AP delivered groups)

resmgr -sepRec "<REC>" -sep "|_|" -noHead -export segp -colNames "npath name type cond state origin user"
-filter "segp.dbIndex($segplevelhash{"$npath"}->{"dbIndex"})" -file data/segp/$safename.rmgr

export_seprp_properties.pl

resmgr -sepRec "<REC>" -sep "|_|" -export seprp -noHead -colNames "dbIndex name type defValue origin comment"
 -filter "dbIndex($dbIndex)" -file data/seprp/$dbIndex.rmgr

export_thrdv_thresholds.pl

import_agp_appS_chart_group_links.pl

import_agp_app_report_group_links.pl

resmgr -sepRec "<REC>" -sep "|_|" -noHead -import agp -colNames "dbIndex npath app.dbIndex app.name" -line "$line"


import_agp_report_groups.pl

import_appS_charts.pl

import_appS_charts_real.pl

import_app_reports.pl

import_fgp_formula_groups.pl

import_fgp_frm_formulas.pl

import_linkGroupSE_report_links.pl

import_pctile_aggregation_requests.pl

import_segpreq_requests.pl

import_segp_rules.pl

import_seprp_properties.pl

import_thrdv_gen_grp_thresholds.pl

import_thrdv_thresholds.pl

CompareFilesinDirs.pl