Generate Live Site QA Report

OVERVIEW:

Generate Report: Live Site QA Report

• Manually check if SWXL links are displaying on live site as intended – All Languages
• Set up automated script to check SWXL links on live site monthly – All Languages

PROCESS:

1. Check the Expedia SWXL Production endpoint and verify the correct SWXL package is listed.

https://s3-us-west-2.amazonaws.com/swxl-us-west-2/prod.properties

1. Browse to a page which is in the SWXL and note the SWXL section. Run something like:

   select u.url, k.keyword from s_swxl_relation r
   join s_swxl_keyword k on k.keyword_id = r.keyword_id
   join s_swxl_url u on u.url_id = r.current_url_id
   join (select top 10 * from s_swxl_url) t on t.url_id = r.current_url_id
   order by u.url, k.keyword

2. Compare the results with the links rendered.
    
3. From https://dev.myersmediagroup.com/mmgsvn/KMS/trunk/ILG/trunk/qa

• Run 01-insert_swxl_qa_list.sql manually.
• For new SWXLs, create “test_swxl_{pos}” as a Jenkins job on builds.mmg, using an existing job as a template.