You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

Reason for Change

Database table changes are required to support web application interfaces to RSP results for point sources. These changes force substantial modifications of the SQL used by ASP to access point source information from the db tables.

Test Procedure

Tested in dev using data in /ASP/TestSims2.

Rollback procedure

Revert to ASP v2r8p4. POINTSOURCES db table content must be restored to its previous state.

CCB JIRA

ssc-127@jira

Details

  • POINTSOURCES db table changes
    • Roberto modified the dev tables with these SQL queries:
      Roberto's SQL for changing POINTSOURCES table
      insert into POINTSOURCETYPESET  select ptsrc_name,'DRP' from PointSources where source_type = 'DRP'
update PointSources set source_type = 'Blazar' where ptsrc_name != 'LSI +61 303' and source_type = 'DRP'
update PointSources set source_type = 'MQ' where ptsrc_name = 'LSI +61 303'
    • The SOURCESUBTYPES table was modified using 
      insert into SOURCESUBTYPES (sourcesub_type) values ('BLZRGRPSRC')
insert into SOURCESUBTYPES (sourcesub_type) values ('KNOWNPSR')
insert into SOURCESUBTYPES (sourcesub_type) values ('PGWAVE')
    • The blazar group sources and known pulsars were added to the POINTSOURCETYPESET table using this script. Similar code will need to be implemented to insert the existing pgwave sources into this table.
  • ASP v2r8p4
    • AspHealPix v0r0p1
    • AspLauncher v1r3p3
    • AspPolicy v0r6
    • BayesianBlocks v0r2
    • asp_pgwave v1r7p7*
      • insert new source into pointsourcetypeset table with PGWAVE sourcesub_type
      • set emax=3e5 for gtselect filtering prior to counts map creation
    • drpMonitoring v1r5*
      • set emax=3e5 for gtselect prefiltering
      • read eband_ids from db tables instead of using hard-coded dictionary
      • modify SQL to perform inner join with pointsourcetypeset to find relocated source types
      • updates to template file for light curve export to GSSC
    • grbASP v4r5p6*
      • Add code to clean up png figures of log-probabilities that are sent to balist
      • enable automatic mailing of ASP alerts to balist
    • pyASP v3r5p5
  • No labels