oddgen / bitemp

Code generator to switch between non-temporal, uni-temporal and bi-temporal models while preserving data.
Apache License 2.0
4 stars 1 forks source link

Hidden, non-virtual columns must not be considered for types, views and derived objects #5

Closed PhilippSalvisberg closed 7 years ago

PhilippSalvisberg commented 7 years ago

The following type is generated with v0.2.0 for PM.ONLINE_MEDIA (in this case all SYS...columns must not be considered):

CREATE OR REPLACE TYPE online_media_ot FORCE AS OBJECT (
   product_id NUMBER(6, 0),
   product_photo ORDIMAGE,
   sys_nc00003$ BLOB,
   sys_nc00004$ VARCHAR2(4000),
   sys_nc00005$ VARCHAR2(4000),
   sys_nc00006$ VARCHAR2(4000),
   sys_nc00007$ DATE,
   sys_nc00008$ NUMBER(38),
   sys_nc00009$ NUMBER(38, 0),
   sys_nc00010$ NUMBER(38, 0),
   sys_nc00011$ NUMBER(38, 0),
   sys_nc00012$ VARCHAR2(4000),
   sys_nc00013$ VARCHAR2(4000),
   sys_nc00014$ VARCHAR2(4000),
   sys_nc00015$ VARCHAR2(4000),
   product_photo_signature ORDIMAGESIGNATURE,
   sys_nc00017$ BLOB,
   product_thumbnail ORDIMAGE,
   sys_nc00019$ BLOB,
   sys_nc00020$ VARCHAR2(4000),
   sys_nc00021$ VARCHAR2(4000),
   sys_nc00022$ VARCHAR2(4000),
   sys_nc00023$ DATE,
   sys_nc00024$ NUMBER(38),
   sys_nc00025$ NUMBER(38, 0),
   sys_nc00026$ NUMBER(38, 0),
   sys_nc00027$ NUMBER(38, 0),
   sys_nc00028$ VARCHAR2(4000),
   sys_nc00029$ VARCHAR2(4000),
   sys_nc00030$ VARCHAR2(4000),
   sys_nc00031$ VARCHAR2(4000),
   product_video ORDVIDEO,
   sys_nc00033$ VARCHAR2(4000),
   sys_nc00034$ BLOB,
   sys_nc00035$ VARCHAR2(4000),
   sys_nc00036$ VARCHAR2(4000),
   sys_nc00037$ VARCHAR2(4000),
   sys_nc00038$ DATE,
   sys_nc00039$ NUMBER(38),
   sys_nc00040$ VARCHAR2(31),
   sys_nc00041$ VARCHAR2(4000),
   sys_nc00042$ CLOB,
   sys_nc00043$ NUMBER(38, 0),
   sys_nc00044$ NUMBER(38, 0),
   sys_nc00045$ NUMBER(38, 0),
   sys_nc00046$ NUMBER(38, 0),
   sys_nc00047$ NUMBER(38, 0),
   sys_nc00048$ NUMBER(38, 0),
   sys_nc00049$ VARCHAR2(4000),
   sys_nc00050$ NUMBER(38, 0),
   sys_nc00051$ NUMBER(38, 0),
   product_audio ORDAUDIO,
   sys_nc00053$ VARCHAR2(4000),
   sys_nc00054$ BLOB,
   sys_nc00055$ VARCHAR2(4000),
   sys_nc00056$ VARCHAR2(4000),
   sys_nc00057$ VARCHAR2(4000),
   sys_nc00058$ DATE,
   sys_nc00059$ NUMBER(38),
   sys_nc00060$ VARCHAR2(31),
   sys_nc00061$ VARCHAR2(4000),
   sys_nc00062$ CLOB,
   sys_nc00063$ VARCHAR2(256),
   sys_nc00064$ NUMBER(38, 0),
   sys_nc00065$ NUMBER(38, 0),
   sys_nc00066$ NUMBER(38, 0),
   sys_nc00067$ VARCHAR2(4000),
   sys_nc00068$ NUMBER(38, 0),
   product_text CLOB,
   product_testimonials ORDDOC,
   sys_nc00071$ BLOB,
   sys_nc00072$ VARCHAR2(4000),
   sys_nc00073$ VARCHAR2(4000),
   sys_nc00074$ VARCHAR2(4000),
   sys_nc00075$ DATE,
   sys_nc00076$ NUMBER(38),
   sys_nc00077$ VARCHAR2(80),
   sys_nc00078$ VARCHAR2(80),
   sys_nc00079$ NUMBER(38, 0),
   sys_nc00080$ CLOB,
   CONSTRUCTOR FUNCTION online_media_ot RETURN SELF AS RESULT
);
/
PhilippSalvisberg commented 7 years ago

Consider USER_GENERATED columns only