Sixth Column

Dev notes:

OSI / SIXTH GENERAL INFORMATION

   OSI Sharepoint:
       https:// members.osii.com/oms_library/Shared%20Documents/Forms/AllItems.aspx?RootFolder=%2fOMS_Library%2fShared%20Documents%2fFunctional%20Specifications&View={ABBEC452-F029-421B-B6B8-4B03E433AB3C}

   JIRA project task management
       https:// sixthcolumn.atlassian.net/secure/MyJiraHome.jspa

   SVN active branches
       https:// svn.osii.com/svn/OMS/trunk/
       https:// svn.osii.com/svn/OMS/tags/Rel_0_1_0_35e_Apr202014

       pullmoa					- pulls trunk
       pullmoa_full_rebuild	- pulls trunk, kills cs, runs sbt, restarts cs+ui

   osi ftp
       sftp.osii.com

SoapUI test harness
Stop SoapUI OMSInterface_vx mockup service Restart server side as needed for the target model (see below) Start IM and OP Start SoapUI mockup for the target model The model updates will stream in, one every 6 seconds.

Update WSDL (currently v4)

   gsoap
   -----
   run and follow instructions (typically requires a couple reruns):
       C:\Michael's Data\development\sixth_column\svn\OMS\trunk\oms-oa-app-cpp\config\gsoap
           build_OMSInterface_code.bat

   SoapUI
   ------
   either
       create new SOAP project
       select wsdl
       put version in name (currently on v4)
       MAKE SURE YOU CLICK RELATIVE PATHS box and save after initial creation!  
       it might prompt you to save right away
       WHEN SAVING MAKE SURE YOU GO UP OUT OF GSOAP AND DOWN INTO SOAPUI folder! pita
   or
       right-click OMSInterfaceSoap12Binding -> Update Defintion (that was easy)
       the mockup wont change tho
       rename it to [OMSInterfaceSoap12Binding MockService old]
   right-click OMSInterfaceSoap12Binding -> Generate MockService
       set to port 9750
       use default name of [OMSInterfaceSoap12Binding MockService]
   OMSInterfaceSoap12Binding MockService -> 
       getLatestModelInfo -> 
           Response 1 -> 
               change [?] into fields:
                   <timestamp>2014-01-01T12:34:56</timestamp>
                   <sequence>1</sequence>
                   <filename>model_export.zip</filename>
       getModelUpdates
           copy over previous responses
   run the mockups!

scripts
general pullmoa pullmoa_full_rebuild pushmoa linux server scripts/linux/ run_cs.sh [osi\|tiny] start_solr.sh [purge] start_cassandra.sh start_cqlsh.sh import_customers.sh

DB schema RESET

m@melange cd ~/development/sixth_column/OMSLib/cassandraApi
java -cp OMSLib.jar:lib/* com.osii.oms.utilities.DatabaseUtility localhost initialize
# a bunch of cassandra stuff should happen :-)
java -cp OMSLib.jar:lib/* com.osii.oms.utilities.DatabaseUtility localhost schemapopulate ../../svn/OMS/trunk/oms-core-services-play/modules/osiCassandra/scripts/osi_schema.json

Core application.conf resync
Check this stupid file if things go wrong, it's one of the common ways that core gets broken. To fix, update teh model-specific conf files to match the base.

Core + UI + Solr + Cassandra RESET

stop oa apps, core, solr
start_solr.sh purge
start_cqlsh.sh
 use osi_oms;
 truncate premise; truncate activejobs; truncate activecontacts; truncate activecrewassignments;
run_cs.sh [tiny|osi]
import_customers.sh [tiny|osi]

Manual details:

   stop oa apps, core, solar
   m@melange ~/development/sixth_column/solr-1.1 $ rm solr/customer/data -rf
   m@melange ~/development/sixth_column/solr-1.1 $ ./mdm_start_solr.sh 
   m@melange ~/development/sixth_column/OMSLib/cassandraApi $ ../../apache-cassandra-2.0.6/bin/cqlsh
       use osi_oms;
       truncate premise; truncate activejobs; truncate activecontacts; truncate activecrewassignments;
   make sure you are using a model-specific SystemSettings.json to get the right value for CUSTOMER_XFMR_PREFIX
       manual details:
       fix up CUSTOMER_XFMR_PREFIX - enable ONLY WHEN RUNNING POWERCO data, otherwise disable it with rename to "__CUSTOMER_XFMR_PREFIX"
       cd ~/development/sixth_column/svn/OMS/trunk/oms-core-services-play/conf/startupData
       emacs SystemSetting.json 
           # see id 701 at end of file
           # bill also adjusts model export file - no need if using soapui
   run_cs.sh [osi|tiny]
   cd ~/development/sixth_column/oms-customer-import-java/bin
        NOTE that i had to add a bogus space before localhost to keep mediawiki from failing, weird!
        REMOVE IT
        FOR TINY:
           ./import cust3 http:// localhost:9101/v1
           select count(*) from premise limit 4000000;
           count = 42
       FOR POWERCO:
           ./import cust3 http:// localhost:9101/v1
           select count(*) from premise limit 4000000;
           count = 339850
   run_ui.sh (if needed - i dont think you even have to stop it?!)
   good to run oa again!