Himalaya New Environment/Subscriber SMB DB Setup Test (no elastic search sync)


1. CREATE database `smb`;

2. $ java -jar aml-data-tool-2.6.1-20140627.172304-2.jar migrate
Enter the DB username: spike
Enter the DB password: ******
Enter the target DB server: aq-dev2-mysql1
Enter the version to migrate to: 2.6.1

<observed output should be similar to following>
[INFO] Creating Metadata table: `smb`.`schema_version`
[INFO] Current version of schema `smb`: << Empty Schema >>
[INFO] Migrating schema `smb` to version 2.0.1.01
[INFO] Migrating schema `smb` to version 2.0.1.02
[INFO] Migrating schema `smb` to version 2.0.1.03
[INFO] Migrating schema `smb` to version 2.0.1.04
[INFO] Migrating schema `smb` to version 2.0.1.05
[INFO] Migrating schema `smb` to version 2.0.1.06
[INFO] Migrating schema `smb` to version 2.0.1.07
[INFO] Migrating schema `smb` to version 2.0.1.08
[INFO] Migrating schema `smb` to version 2.0.1.09
[INFO] Migrating schema `smb` to version 2.0.1.11
[INFO] Migrating schema `smb` to version 2.0.1.12
[INFO] Migrating schema `smb` to version 2.0.1.13
[INFO] Migrating schema `smb` to version 2.0.1.14
[INFO] Migrating schema `smb` to version 2.0.1.15
[INFO] Migrating schema `smb` to version 2.0.1.16
[INFO] Migrating schema `smb` to version 2.0.1.17
[INFO] Migrating schema `smb` to version 2.0.1.50
[INFO] Migrating schema `smb` to version 2.0.1.51
[INFO] Migrating schema `smb` to version 2.0.1.52
[INFO] Migrating schema `smb` to version 2.0.1.53
[INFO] Migrating schema `smb` to version 2.0.1.54
[INFO] Migrating schema `smb` to version 2.0.1.55
[INFO] Migrating schema `smb` to version 2.0.1.56
[INFO] Migrating schema `smb` to version 2.0.1.57
[INFO] Migrating schema `smb` to version 2.0.99.00
[INFO] Migrating schema `smb` to version 2.0.99.01
[INFO] Migrating schema `smb` to version 2.0.99.02
[INFO] Migrating schema `smb` to version 2.0.99.03
[INFO] Migrating schema `smb` to version 2.0.99.04
[INFO] Migrating schema `smb` to version 2.0.99.05
[INFO] Migrating schema `smb` to version 2.0.99.06
[INFO] Migrating schema `smb` to version 2.0.99.07
[INFO] Migrating schema `smb` to version 2.0.99.08
[INFO] Migrating schema `smb` to version 2.0.99.09
[INFO] Migrating schema `smb` to version 2.0.99.10
[INFO] Migrating schema `smb` to version 2.0.99.11
[INFO] Migrating schema `smb` to version 2.0.99.24
[INFO] Migrating schema `smb` to version 2.0.99.25
[INFO] Migrating schema `smb` to version 2.0.99.26
[INFO] Migrating schema `smb` to version 2.0.99.27
[INFO] Migrating schema `smb` to version 2.0.99.28
[INFO] Migrating schema `smb` to version 2.0.99.49
[INFO] Migrating schema `smb` to version 2.1.99.01
[INFO] Migrating schema `smb` to version 2.1.99.53
[INFO] Creating index on table smb.merchants for column reseller_id
[INFO] Creating index on table warehouse_1.whMonthlyGroupPerf for column accountID
[INFO] Creating index on table warehouse_1.whMonthlyGroupPerf for column startTime
[INFO] Creating index on table warehouse_1.whDailyGroupPerf for column accountID
[INFO] Creating index on table warehouse_1.whDailyGroupPerf for column startTime
[INFO] Creating index on table smb.realms for column id
[INFO] Migrating schema `smb` to version 2.3.99.01
[INFO] Migrating schema `smb` to version 2.3.99.02
[INFO] Migrating schema `smb` to version 2.3.99.03
[INFO] Migrating schema `smb` to version 2.3.99.04
[INFO] Migrating schema `smb` to version 2.3.99.05
[INFO] Migrating schema `smb` to version 2.5.99.01
[INFO] Migrating schema `smb` to version 2.5.99.02
[INFO] Migrating schema `smb` to version 2.5.99.03
[INFO] Successfully applied 52 migrations to schema `smb` (execution time 00:07.508s).


3. Execute on-boarding to create a new reseller (v2.6.0 ops-scripts):
groovy onboard.groovy -d DEBUG -h aq-dev2-front1 -l 8080 -p admin -r thesearchagency -u admin+tsa@thesearchagency.com -rr s3 -rcd US -rtz America/New_York -rg en -rcc USD -rl en_US -rcd US -rdn "S3 Demo" -rp 4445556666 -rcp 7778889999 -rcn "S3 Reseller Demo User" -ru http://www.S3.com -rpn "S3 Test" -rbu http://S3.aq-dev2-front1/reseller/ -rsp 1800USAHELP -mde true -mdt "S3 Dashboard" -rce patrick.wynne@thesearchagency.com -tu "tos.html" -pu "privacy.html" -rm 0.0 -rmin 0.00

4. Activate reseller User

5. Login

6. Create a new merchants

7. Create a new order

8. Confirm successful deployment of order