[WP3] Type evolution announcement - Changes related to Astrometry

[D.R. Boxhoorn]

Dear Astro-Wise database maintainer,

In the very near future the astrometry will be detached from the rest of the 
Image Pipeline in Astro-Wise.

- This will make it possible to redo the astrometry without the need to
  de-bias and flat-field at the same time.
- This is the first step towards a more accurate astrometric solution that uses
  sources in overlapping areas of images/frames, like, for example, in a dither.

The modified classes - AstrometricParameters, PhotSrcCatalog,
ReducedScienceFrame, RegriddedFrame - are are now in opipe/Experimental.
The corresponding type evolution instructions appear below.

We expect to commit these changes to opipe/astro/main this week and we will
send you an e-mail when we are about to do so.
If you do not want to evolve the types, please do not forget to suspend your
automatic cvs updates.

Do not hesitate if you have any questions.

Cheers and good luck,

                                                   Danny, Ronald, Kor


1) -----------------------------------------------------------------------------

ALTER TYPE "ReducedScienceFrameParameters$" DROP ATTRIBUTE "RESTORE_BACKGROUND" CASCADE INCLUDING TABLE DATA;

2) -----------------------------------------------------------------------------

ALTER TYPE "ReducedScienceFrame$" ADD ATTRIBUTE ("is_valid" SMALLINT, "weight" REF "WeightFrame$") CASCADE INCLUDING TABLE DATA;
UPDATE "ReducedScienceFrame" SET "is_valid"=1;
UPDATE "ReducedScienceFrame" p SET "weight"=(SELECT TREAT("weight" AS REF "WeightFrame$") FROM "ScienceFrame" q WHERE "reduced"=REF(p));
UPDATE "ReducedScienceFrame" p SET "filename"=(SELECT "filename" FROM "ScienceFrame" q WHERE "reduced"=REF(p));
COMMIT;
--DELETE "Imstat" WHERE OBJECT_ID IN (SELECT "backstat" FROM "ReducedScienceFrame")
ALTER TYPE "ReducedScienceFrame$" DROP ATTRIBUTE ("backstat", "saturated") CASCADE INCLUDING TABLE DATA;

3) -----------------------------------------------------------------------------

ALTER TYPE "AstrometricParameters$" ADD ATTRIBUTE (
"process_status" SMALLINT,
"quality_flags" SMALLINT,
"SEEING" DOUBLE PRECISION,
"CTYPE1" VARCHAR2(297),
"CRPIX1" DOUBLE PRECISION,
"CRVAL1" DOUBLE PRECISION,
"CTYPE2" VARCHAR2(297),
"CRPIX2" DOUBLE PRECISION,
"CRVAL2" DOUBLE PRECISION,
"CD1_1" DOUBLE PRECISION,
"CD1_2" DOUBLE PRECISION,
"CD2_1" DOUBLE PRECISION,
"CD2_2" DOUBLE PRECISION,
"PV1_0" DOUBLE PRECISION,
"PV1_1" DOUBLE PRECISION,
"PV1_2" DOUBLE PRECISION,
"PV1_3" DOUBLE PRECISION,
"PV1_4" DOUBLE PRECISION,
"PV1_5" DOUBLE PRECISION,
"PV1_6" DOUBLE PRECISION,
"PV1_7" DOUBLE PRECISION,
"PV1_8" DOUBLE PRECISION,
"PV1_9" DOUBLE PRECISION,
"PV2_0" DOUBLE PRECISION,
"PV2_1" DOUBLE PRECISION,
"PV2_2" DOUBLE PRECISION,
"PV2_3" DOUBLE PRECISION,
"PV2_4" DOUBLE PRECISION,
"PV2_5" DOUBLE PRECISION,
"PV2_6" DOUBLE PRECISION,
"PV2_7" DOUBLE PRECISION,
"PV2_8" DOUBLE PRECISION,
"PV2_9" DOUBLE PRECISION,
"NREF" SMALLINT,
"MEAN_DDEC" DOUBLE PRECISION,
"MEAN_DRA" DOUBLE PRECISION,
"SIG_DDEC" DOUBLE PRECISION,
"SIG_DRA" DOUBLE PRECISION,
"field_err" DOUBLE PRECISION,
"x_err" DOUBLE PRECISION,
"y_err" DOUBLE PRECISION,
"xx_err" DOUBLE PRECISION,
"xy_err" DOUBLE PRECISION,
"yy_err" DOUBLE PRECISION
) CASCADE INCLUDING TABLE DATA;

UPDATE "AstrometricParameters" p SET
"CD1_1"=p."astrom"."CD1_1",
"CD1_2"=p."astrom"."CD1_2",
"CD2_1"=p."astrom"."CD2_1",
"CD2_2"=p."astrom"."CD2_2",
"CRPIX1"=p."astrom"."CRPIX1",
"CRPIX2"=p."astrom"."CRPIX2",
"CRVAL1"=p."astrom"."CRVAL1",
"CRVAL2"=p."astrom"."CRVAL2",
"CTYPE1"=p."astrom"."CTYPE1",
"CTYPE2"=p."astrom"."CTYPE2",
"MEAN_DDEC"=p."astrom"."MEAN_DDEC",
"MEAN_DRA"=p."astrom"."MEAN_DRA",
"NREF"=p."astrom"."NREF",
"PV1_0"=p."astrom"."PV1_0",
"PV1_1"=p."astrom"."PV1_1",
"PV1_2"=p."astrom"."PV1_2",
"PV1_3"=p."astrom"."PV1_3",
"PV1_4"=p."astrom"."PV1_4",
"PV1_5"=p."astrom"."PV1_5",
"PV1_6"=p."astrom"."PV1_6",
"PV1_7"=p."astrom"."PV1_7",
"PV1_8"=p."astrom"."PV1_8",
"PV1_9"=p."astrom"."PV1_9",
"PV2_0"=p."astrom"."PV2_0",
"PV2_1"=p."astrom"."PV2_1",
"PV2_2"=p."astrom"."PV2_2",
"PV2_3"=p."astrom"."PV2_3",
"PV2_4"=p."astrom"."PV2_4",
"PV2_5"=p."astrom"."PV2_5",
"PV2_6"=p."astrom"."PV2_6",
"PV2_7"=p."astrom"."PV2_7",
"PV2_8"=p."astrom"."PV2_8",
"PV2_9"=p."astrom"."PV2_9",
"SIG_DDEC"=p."astrom"."SIG_DDEC",
"SIG_DRA"=p."astrom"."SIG_DRA",
"field_err"=p."astrom"."field_err",
"x_err"=p."astrom"."x_err",
"xx_err"=p."astrom"."xx_err",
"xy_err"=p."astrom"."xy_err",
"y_err"=p."astrom"."y_err",
"yy_err"=p."astrom"."yy_err";
UPDATE "AstrometricParameters" p SET "SEEING"=(SELECT "SEEING" FROM "ScienceFrame" q WHERE p."reduced"=q."reduced");
UPDATE "AstrometricParameters" SET "SEEING"=0.0 WHERE "SEEING" IS NULL;
COMMIT;

ALTER TYPE "AstrometricParameters$" DROP ATTRIBUTE "astrom" CASCADE INCLUDING TABLE DATA;

ALTER TYPE "AstrometricParameters$" ADD ATTRIBUTE "tmpreduced" REF "BaseFrame$"
CASCADE INCLUDING TABLE DATA;
UPDATE "AstrometricParameters" SET "tmpreduced"="reduced";
COMMIT;
ALTER TYPE "AstrometricParameters$" DROP ATTRIBUTE "reduced" CASCADE INCLUDING TABLE DATA;
-- DISCONNECT & CONNECT
ALTER TYPE "AstrometricParameters$" ADD ATTRIBUTE "reduced" REF "BaseFrame$" CASCADE INCLUDING TABLE DATA;
UPDATE "AstrometricParameters" SET "reduced"="tmpreduced";
COMMIT;
ALTER TYPE "AstrometricParameters$" DROP ATTRIBUTE "tmpreduced" CASCADE INCLUDING TABLE DATA;

4) -----------------------------------------------------------------------------

ALTER TYPE "PhotSrcCatalog$" ADD ATTRIBUTE "astrom_params" REF "AstrometricParameters$" CASCADE INCLUDING TABLE DATA;

5) -----------------------------------------------------------------------------

ALTER TYPE "RegriddedFrame$" ADD ATTRIBUTE ("photom_params" REF "PhotometricParameters$", "gain" REF "GainLinearity$", "reduced" REF "ReducedScienceFrame$") CASCADE INCLUDING TABLE DATA;
UPDATE "RegriddedFrame" p SET "photom_params"=p."science_frame"."photom", "gain"=p."science_frame"."gainlin", "reduced"=p."science_frame"."reduced";
COMMIT;
ALTER TYPE "RegriddedFrame$" DROP ATTRIBUTE "science_frame" CASCADE INCLUDING TABLE DATA;


F) -----------------------------------------------------------------------------

In the `oemapp console' or from the SQL*Plus prompt.

. Recompile invalid VIEWs
. Recompile invalid TRIGGERs