edersqo

Keybase proof

I hereby claim:

• I am edersqo on github.
• I am equinones (https://keybase.io/equinones) on keybase.
• I have a public key ASBXH9AxDzlTpCepGQ0yuOccuNl1s11Sq1Mj5U1C2Sa6Kwo

To claim this, I am signing this object:

edersqo

#!/bin/sh

/u01/app/oracle_atg/product/oracle_gs/endeca/ToolsAndFrameworks/11.3.0/deployment_template/bin/deploy.sh \
    --app /u01/app/oracle_atg/product/oracle_gs/endeca/ToolsAndFrameworks/11.3.0/reference/discover-data-cas/deploy.xml \
	--install-config /home/endeca/conf/cas_app_install_config.xml --no-prompt

/u01/app/oracle_atg/product/oracle_gs/endeca/apps/Discover/control/initialize_services.sh
/u01/app/oracle_atg/product/oracle_gs/endeca/apps/Discover/control/load_baseline_test_data.sh
/u01/app/oracle_atg/product/oracle_gs/endeca/apps/Discover/control/baseline_update.sh
/u01/app/oracle_atg/product/oracle_gs/endeca/apps/Discover/control/promote_content.sh

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

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

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

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

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

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

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

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