Ticket #443 (closed new functionality: fixed)

Opened 10 years ago

Last modified 7 years ago

Schema browser

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

not applicable

Description

This was alluded to in ticket #319: "An ancillary procedure might be provided to assist developers interacting directly with a DB table generated during a pipeline run-- provide a scenario (or package a query) to report all table fields and their descriptive 'comment'. This would remove some of the guesswork when trying to identify a particular variable."

Change History

comment:1 Changed 10 years ago by jbecla

  • Status changed from new to assigned

comment:2 Changed 10 years ago by jbecla

  • Milestone changed from DC3a MW DB to DC3b MW DB

comment:3 Changed 10 years ago by jbecla

  • Owner changed from jbecla to ktl

It'd be good to preserve a version number, similarly to what we do in checkinSchema.py

comment:4 Changed 10 years ago by ktl

  • Owner changed from ktl to jbecla

Script to generate table metadata based on EA has been written: DMS/cat/trunk/scripts/EA_to_metadata_sql.py. A version number is included in the metadata (as a table name). Jacek is writing an initial implementation in PHP of a browser for this metadata: DMS/cat/trunk/schemaBrowser/.

comment:5 Changed 10 years ago by jbecla

  • Owner changed from jbecla to dgehrig

It is in David's hands: he is arranging setting up the browser at NCSA

comment:6 Changed 10 years ago by dgehrig

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

The browser is now set up at dev.lsstcorp.org/schema, a proxy for lsstbook.ncsa.uiuc.edu/schema.

comment:7 Changed 7 years ago by robyn

  • Milestone DC3b MW DB deleted

Milestone DC3b MW DB deleted

Note: See TracTickets for help on using tickets.