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

          No work has yet been logged on this issue.

            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