Ticket #527 (closed enhancement: fixed)

Opened 11 years ago

Last modified 7 years ago

Persisting policies

Reported by: jbecla Owned by: ktl
Priority: minor Milestone:
Component: database Keywords:
Cc: smm Blocked By:
Blocking: Project: LSST
Version Number:
How to repeat:

not applicable

Description

We need to persist information from policies. It is mostly done by now, but we still need to:

  • add type to PolicyKey?
  • provide example how to use it

Change History

comment:1 Changed 11 years ago by ktl

  • Status changed from new to assigned

Will be included as part of #315.

comment:2 Changed 11 years ago by ktl

  • Owner changed from ktl to jbecla

For DC3a provenance, tables have been created in a separate provenance database, as I thought it would be more useful to have these available outside the per-run databases. These tables could be merged with the global DC3a database, if desired (in which case, assign this ticket back to me to modify the ctrl_orca provenance code). The table definitions have been inserted into EA, in the "DC3 Logical Model/DC3aSchema/Provenance" package but have not been exported into SVN or the schema browser.

comment:3 Changed 11 years ago by jbecla

  • Status changed from assigned to closed
  • Resolution set to fixed

I've done the rest: applied the changed in DC3b schema in EA, exported both schemas to SVN and upgrades schema browser.

comment:4 Changed 11 years ago by jbecla

  • Status changed from closed to new
  • Resolution fixed deleted

Per discussion (KT, Jacek, Daniel) the provenance related information will be written to local (per-run) database AND into one central database. It has been implemented, the central database will be called <dcVersion>_DB (eg DC3a_DB) and it will have the same schema as the per-run database plus a schema defined in source:DMS/cat/trunk/sql/setup_DB_dataChallenge.sql. KT: back to you, please change the provenance formatter(s).

comment:5 Changed 11 years ago by jbecla

  • Status changed from new to assigned
  • Owner changed from jbecla to ktl

comment:6 Changed 11 years ago by ktl

  • Status changed from assigned to closed
  • Resolution set to fixed

Trunk updated in [7650]. Run table in central database later added to schema.

comment:7 Changed 7 years ago by robyn

  • Milestone DC3a MW DB deleted

Milestone DC3a MW DB deleted

Note: See TracTickets for help on using tickets.