Re: [GUSDEV] Re: [Bug 257] The rules had not been created

[Angel P. <an...@ma...>]

Hi Ricardo,

The error did not stem from my patch, but rather from another class that 
failed to add the none-default columns to the version view objects. I 
have edited a few files, so you will need to revert to current SVN 
version of the repository for this patch to work:
<copy attached file to project home>
cd $PROJECT_HOME
svn revert GUS/DBAdmin
patch -p0 <DBAdmin.diff

Then you should be able to rebuild GUS/DBAdmin and run dbaDump schema as 
before.

An example of the output view and rule follows
-angel


CREATE VIEW DoTSVer.AAFeatureVer AS
SELECT AA_FEATURE_ID, AA_SEQUENCE_ID, FEATURE_NAME_ID, PARENT_ID, 
NA_FEATURE_ID, SUBCLASS_VIEW, SEQUENCE_ONTOLOGY_ID, DESCRIPTION, 
PFAM_ENTRY_ID, MOTIF_AA_SEQUENCE_ID, REPEAT_TYPE_ID, 
EXTERNAL_DATABASE_RELEASE_ID, SOURCE_ID, PREDICTION_ALGORITHM_ID, 
IS_PREDICTED, REVIEW_STATUS_ID , MODIFICATION_DATE, USER_READ, 
USER_WRITE, GROUP_READ, GROUP_WRITE, OTHER_READ, OTHER_WRITE, 
ROW_USER_ID, ROW_GROUP_ID, ROW_PROJECT_ID, ROW_ALG_INVOCATION_ID, 
VERSION_ALG_INVOCATION_ID, VERSION_DATE, VERSION_TRANSACTION_ID FROM 
DoTSVer.AAFeatureImpVer;

CREATE RULE AAFeatureVer_32675 AS ON INSERT TO DoTSVer.AAFeatureVer DO 
INSTEAD INSERT INTO  DoTSVer.AAFeatureImpVer ( AA_FEATURE_ID, 
AA_SEQUENCE_ID, FEATURE_NAME_ID, PARENT_ID, NA_FEATURE_ID, 
SUBCLASS_VIEW, SEQUENCE_ONTOLOGY_ID, DESCRIPTION, PFAM_ENTRY_ID, 
MOTIF_AA_SEQUENCE_ID, REPEAT_TYPE_ID, EXTERNAL_DATABASE_RELEASE_ID, 
SOURCE_ID, PREDICTION_ALGORITHM_ID, IS_PREDICTED, REVIEW_STATUS_ID, 
MODIFICATION_DATE, USER_READ, USER_WRITE, GROUP_READ, GROUP_WRITE, 
OTHER_READ, OTHER_WRITE, ROW_USER_ID, ROW_GROUP_ID, ROW_PROJECT_ID, 
ROW_ALG_INVOCATION_ID, VERSION_ALG_INVOCATION_ID, VERSION_DATE, 
VERSION_TRANSACTION_ID ) VALUES ( new.AA_FEATURE_ID, new.AA_SEQUENCE_ID, 
new.FEATURE_NAME_ID, new.PARENT_ID, new.NA_FEATURE_ID, 
new.SUBCLASS_VIEW, new.SEQUENCE_ONTOLOGY_ID, new.DESCRIPTION, 
new.PFAM_ENTRY_ID, new.MOTIF_AA_SEQUENCE_ID, new.REPEAT_TYPE_ID, 
new.EXTERNAL_DATABASE_RELEASE_ID, new.SOURCE_ID, 
new.PREDICTION_ALGORITHM_ID, new.IS_PREDICTED, new.REVIEW_STATUS_ID, 
new.MODIFICATION_DATE, new.USER_READ, new.USER_WRITE, new.GROUP_READ, 
new.GROUP_WRITE, new.OTHER_READ, new.OTHER_WRITE, new.ROW_USER_ID, 
new.ROW_GROUP_ID, new.ROW_PROJECT_ID, new.ROW_ALG_INVOCATION_ID, 
new.VERSION_ALG_INVOCATION_ID, new.VERSION_DATE, 
new.VERSION_TRANSACTION_ID );

Angel Pizarro wrote:

> Yes, I have an idea of what is going on ... sloppy copy-paste coding 
> on my part :(
>
> I'll add the other columns to the method and get you another patch.
>
> -angel
>