Uploaded image for project: '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
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.1.1
    • Component/s: Database
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

            Hide
            gtaylor 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
            gtaylor 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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: