This test is designed to ensure that we can export all the previously-rejected (and new) TV programs. 

  1. Create dumps of current prod data for both BTA and LDE.
    1. On develro@phoebe run 

      pg_dump -h phoebe -U bta-ro -f bta.dump.txt --data-only bta-prod
      p: hwSvaL1e
      ##pg_dump --data-only -h phoebe -U lde-ro -f lde.dump.txt lde-prod
      pg_dump -F custom -h phoebe -U lde-ro -f lde.dump.custom lde-prod
      p: 7WVEBTTfIvuh
    2. Copy the files over to the test server via your home machine:

      scp develro@phoebe:*dump* .
      scp *dump* bta@iapetus:
    3. On bta@iapetus, delete contents of the two databases and restore from the dumps. 

      [bta@iapetus ~]$ psql -d bta-devel
      delete from broadcasttranscodingrecord ;
      delete from programmediainfo ;
      delete from reklamefilmtranscodingrecord ;
      DELETE FROM thumbnailextractionrecord ;
      [bta@iapetus ~]$ psql -d bta-devel -f bta.dump.txt 
      [bta@iapetus ~]$ psql -d larm-doms-exporter-devel -U larmde -h iapetus -W
      p: LVf0lLbb
      larm-doms-exporter-devel=> delete from domsexportrecord ;
      [bta@iapetus ~]$ pg_restore -d larm-doms-exporter-devel -U larmde -h iapetus --data-only -W  lde.dump.custom
      p: LVf0lLbb  
  2. Install LDE on lde@iapetus

  3. Set REJECTED exports to PENDING 

    larm-doms-exporter-devel=> update domsexportrecord set state='PENDING' where state='REJECTED';
  4. Run the consumer.
  5. Get new programs by running the producer.
  6. Run the consumer again.




  • No labels