Kuali Rice Development
  1. Kuali Rice Development
  2. KULRICE-3700

Apply the modifications resulting from the addition of DataDictionarySearchableAttributeTest to the master databases

    Details

    • Type: Task Task
    • Status: Closed Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.1.1
    • Component/s: Database
    • Labels:
      None
    • Similar issues:
      KULRICE-3627Apply the XSD change resulting from the event-notification-related parent issue to the master databases
      KULRICE-8322Apply database updates for messages to master data source
      KULRICE-3773Apply the database changes resulting from the doc search date validation fixes to the master DBs
      KULRICE-8370Apply KULRICE-8300 database scripts to the 2.1.2 master database
      KULRICE-11623Implement additive dataset database structure
      KULRICE-8402Apply database scripts to the 2.1 and 2.2 master databases
      KULRICE-8411Apply database scripts to the 2.1 and 2.2 master databases
      KULRICE-8447Apply Backdoor Restriction database scripts to the 2.1 and 2.2 master databases
      KULRICE-8462Apply database scripts to the 2.1 and 2.2 mysql master databases
      KULRICE-6303Apply KRMS Master Database changes - compound proposition sequence number mods.

      Description

      Before KULRICE-3686 can be resolved, the following SQL needs to be executed against the master databases so that date parsing/formatting works properly with DD searchable attributes outside of the unit test context, and so that the @Ignore annotation on the DataDictionarySearchableAttributeTest class can be safely removed:

      UPDATE KRNS_PARM_T SET TXT='MM/dd/yyyy;MM/dd/yyyy HH:mm:ss;MM/dd/yy;MM-dd-yy;MMddyy;MMMM dd;yyyy;MM/dd/yy HH:mm:ss;MM-dd-yy HH:mm:ss;MMddyy HH:mm:ss;MMMM dd HH:mm:ss;yyyy HH:mm:ss' WHERE NMSPC_CD='KR-NS' AND PARM_DTL_TYP_CD='All' AND PARM_NM='STRING_TO_DATE_FORMATS' AND APPL_NMSPC_CD='KUALI'
      /
      UPDATE KRNS_PARM_T SET TXT='MM/dd/yyyy hh:mm a;MM/dd/yyyy;MM/dd/yyyy HH:mm:ss;MM/dd/yy;MM-dd-yy;MMddyy;MMMM dd;yyyy;MM/dd/yy HH:mm:ss;MM-dd-yy HH:mm:ss;MMddyy HH:mm:ss;MMMM dd HH:mm:ss;yyyy HH:mm:ss' WHERE NMSPC_CD='KR-NS' AND PARM_DTL_TYP_CD='All' AND PARM_NM='STRING_TO_TIMESTAMP_FORMATS' AND APPL_NMSPC_CD='KUALI'
      /
      CREATE TABLE ACCT_DD_ATTR_DOC (
      DOC_HDR_ID VARCHAR2(14),
      OBJ_ID VARCHAR2(36),
      VER_NBR NUMBER(14),
      ACCT_NUM NUMBER(14) NOT NULL,
      ACCT_OWNR VARCHAR2(50) NOT NULL,
      ACCT_BAL NUMBER(16,2) NOT NULL,
      ACCT_OPN_DAT DATE NOT NULL,
      ACCT_STAT VARCHAR2(30) NOT NULL,
      ACCT_UPDATE_DT_TM TIMESTAMP,
      ACCT_AWAKE VARCHAR2(1),
      CONSTRAINT ACCT_DD_ATTR_DOC_PK PRIMARY KEY (DOC_HDR_ID)
      )
      /

      Note that the new table shown above is only needed for unit tests, meaning that table may also have to be added to a cleanup script so that non-test databases can easily remove it.

        Issue Links

          Activity

          Chad Hagstrom made changes -
          Field Original Value New Value
          Link This issue is relied upon by KULRICE-3686 [ KULRICE-3686 ]
          Garey Taylor made changes -
          Assignee Garey Taylor [ gtaylor ]
          Hide
          Garey Taylor added a comment -

          Scripts have been run on the 1.0.1.1 master database.

          Files have been updated and committed:
          rice-1.0.1.1/scripts/dataset/bootstrap-server-dataset-cleanup.sql
          rice-1.0.1.1/scripts/upgrades/1.0.1 to 1.0.1.1/db-updates/12-07-2009.sql

          Show
          Garey Taylor added a comment - Scripts have been run on the 1.0.1.1 master database. Files have been updated and committed: rice-1.0.1.1/scripts/dataset/bootstrap-server-dataset-cleanup.sql rice-1.0.1.1/scripts/upgrades/1.0.1 to 1.0.1.1/db-updates/12-07-2009.sql
          Garey Taylor made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Jessica Coltrin (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Shem Patterson (Inactive) made changes -
          Workflow custom [ 77230 ] Copy of custom for rice [ 211521 ]
          Shem Patterson (Inactive) made changes -
          Workflow Copy of custom for rice [ 211521 ] custom [ 221269 ]
          Shem Patterson (Inactive) made changes -
          Workflow custom [ 221269 ] Rice Workflow [ 231017 ]

            People

            • Assignee:
              Garey Taylor
              Reporter:
              Chad Hagstrom
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Structure Helper Panel