edersqo

function endeca_remove_project {
        sh $ENDECA_ROOT/bin/eaccmd.sh remove-app --app $1
        sh $ENDECA_APPS/$1/control/runcommand.sh --remove-app
        sh $CAS_ROOT/bin/component-manager-cmd.sh delete-component -n $1-data
        sh $CAS_ROOT/bin/component-manager-cmd.sh delete-component -n $1-dimvals
        sh $CAS_ROOT/bin/component-manager-cmd.sh delete-component -n $1-dimens$
        sh $CAS_ROOT/bin/cas-cmd.sh deleteCrawl -id $1-last-mile-crawl
        sh $ENDECA_APPS/$1/control/runcommand.sh LockManager releaseLock update$
        rm -r $ENDECA_APPS/$1
}

edersqo

# Docker
ENV USER_INSTALL_DIR $ENDECA_HOME
ENV ENDECA_MDEX_INSTALL_DIR $ENDECA_HOME/endeca/MDEX/11.3.0

RUN echo USER_INSTALL_DIR=$USER_INSTALL_DIR > $TMP_FOLDER_ENDECA_INSTALLERS/mdex_response.properties

edersqo

SELECT PRICE_LIST, SKU_ID, COUNT(*)
    FROM WLM_PROD_CATA.DCS_PRICE
    GROUP BY 
      PRICE_LIST, SKU_ID
    HAVING 
      COUNT(*) > 1;

edersqo

SELECT COUNT(*)
  FROM
    (
      SELECT PRICE_LIST, SKU_ID, COUNT(*)
          FROM WLM_PROD_CATA.DCS_PRICE
          GROUP BY 
            PRICE_LIST, SKU_ID
          HAVING 
            COUNT(*) > 1
    ) DERIVED_TABLE;

edersqo

--- Number of items duplicated by locale.
SELECT DISTINCT(PRICE_LIST), COUNT(*)
  FROM 
    (
      SELECT PRICE_LIST, SKU_ID, COUNT(*)
          FROM WLM_PROD_CATA.DCS_PRICE
          GROUP BY 
            PRICE_LIST, SKU_ID
          HAVING 
            COUNT(*) > 1

edersqo

-- Count differences between DCS_PRICE in CATA, and CATB 
SELECT COUNT(*)
  FROM
    (
      SELECT * FROM WLM_PROD_CATA.DCS_PRICE
        MINUS
          SELECT * FROM WLM_PROD_CATB.DCS_PRICE
    );

edersqo

-- Compare VERSION column, CATA vs CATB    
SELECT
  COALESCE(CATA.PRICE_ID, CATB.PRICE_ID) AS PRICE_ID,
    CASE 
      WHEN CATA.VERSION = CATB.VERSION THEN 'Equal'
      WHEN CATA.VERSION <> CATB.VERSION THEN 'Changed'
    END AS STATUS,
    CATA.VERSION AS CATA_VERSION,
    CATB.VERSION AS CATB_VERSION
  FROM

edersqo

SELECT 
  *
    FROM
      (
        SELECT PRICE_LIST, SKU_ID, COUNT(*)
          FROM WLM_PROD_CATA.DCS_PRICE
            GROUP BY 
              PRICE_LIST, SKU_ID
            HAVING 
              COUNT(*) > 1

edersqo

SELECT 
  *
  FROM
    (
      SELECT 
        PRICE_ID AS CATA_PRICE_ID,
        VERSION AS CATA_VERSION,
        REGEXP_SUBSTR(PRICE_LIST, '[^;]+') AS CATA_STORE,
        REGEXP_SUBSTR(PRICE_LIST, '[a-zA-Z]+') AS CATA_PRICE_TYPE,
        SKU_ID AS CATA_SKU_ID,

edersqo

#!/bin/sh

sed -i 's/host=[^$]\+/host=localhost/' /u01/app/oracle_atg/product/oracle_gs/endeca/CAS/workspace/conf/commandline.properties
sed -i 's/DSTOP.KEY=[^$]\+/DSTOP.KEY=localhost/' /u01/app/oracle_atg/product/oracle_gs/endeca/CAS/11.3.0/bin/cas-service-wrapper.conf 
sed -i 's/DSTOP.KEY=[^$]\+/DSTOP.KEY=localhost/' /u01/app/oracle_atg/product/oracle_gs/endeca/CAS/11.3.0/bin/cas-service.sh
sed -i 's/host=[^$]\+/host=localhost/' /u01/app/oracle_atg/product/oracle_gs/endeca/PlatformServices/workspace/conf/eaccmd.properties
sed -i 's/cas.server=[^$]\+/cas.server=localhost/' /u01/app/oracle_atg/product/oracle_gs/endeca/ToolsAndFrameworks/11.3.0/server/workspace/conf/casconsole.properties