lsst.sims.ocs.database.tables.view_tables module

lsst.sims.ocs.database.tables.view_tables.create_summary_all_props(metadata, oh, sh, sfs, p, ph, f)[source]

Create the SummaryAllProps view (table).

Parameters:
  • metadata (sqlalchemy.MetaData) – The database object that collects the tables.
  • oh (sqlalchemy.Table) – The instance of the ObsHistory table.
  • sh (sqlalchemy.Table) – The instance of the SlewHistory table.
  • sfs (sqlalchemy.Table) – The instance of the SlewFinalState table.
  • p (sqlalchemy.Table) – The instance of the Proposal table.
  • ph (sqlalchemy.Table) – The instance of the ProposalHistory table.
  • f (sqlalchemy.Table) – The instance of the Field table.
Returns:

view – The instance of the SummaryAllProps view.