API tools faq
paste
Advertisement
seeker_dsr

Untitled

seeker_dsr
Jan 23rd, 2018
589
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.77 KB | None | 0 0
raw download clone embed print report
  1. mysql> select * from inputs where job_id=17555869\G
  2. *************************** 1. row ***************************
  3. id: 17652709
  4. job_id: 17555869
  5. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q3.mp4
  6. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":1475,"video_streams":[{"map":"0:0","video_codec":"h264","width":"704","height":"396","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"1340","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"127","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":1018123204,"format":"mp4","video_start_time":0.04}
  7. created_at: 2018-01-22 15:46:11
  8. updated_at: 2018-01-22 15:49:42
  9. *************************** 2. row ***************************
  10. id: 17652717
  11. job_id: 17555869
  12. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q2.mp4
  13. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":952,"video_streams":[{"map":"0:0","video_codec":"h264","width":"704","height":"396","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"817","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"127","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":657306206,"format":"mp4","video_start_time":0.04}
  14. created_at: 2018-01-22 15:46:11
  15. updated_at: 2018-01-22 15:51:52
  16. *************************** 3. row ***************************
  17. id: 17652725
  18. job_id: 17555869
  19. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q1.mp4
  20. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":491,"video_streams":[{"map":"0:0","video_codec":"h264","width":"704","height":"396","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"388","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"95","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":339189857,"format":"mp4","video_start_time":0.04}
  21. created_at: 2018-01-22 15:46:11
  22. updated_at: 2018-01-22 15:53:01
  23. *************************** 4. row ***************************
  24. id: 17652733
  25. job_id: 17555869
  26. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q0.mp4
  27. metadata: {"channels":1,"duration_in_ms":5520050,"total_bitrate_in_kbps":65,"video_streams":[],"audio_streams":[{"map":"0:0","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"64","duration":5520.0,"channels":2}],"rotate":null,"file_size_in_bytes":45112655,"format":"mp4","video_start_time":0.0}
  28. created_at: 2018-01-22 15:46:11
  29. updated_at: 2018-01-22 15:53:14
  30. *************************** 5. row ***************************
  31. id: 17652741
  32. job_id: 17555869
  33. url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-qx720.mp4
  34. metadata: {"channels":2,"duration_in_ms":5520070,"total_bitrate_in_kbps":3492,"video_streams":[{"map":"0:0","video_codec":"h264","width":"1280","height":"720","dar_width":"16","dar_height":"9","video_bitrate_in_kbps":"3358","frame_rate":25.0,"duration":5520.04}],"audio_streams":[{"map":"0:1","audio_codec":"aac","audio_sample_rate":"44100","audio_bitrate_in_kbps":"127","duration":5520.019002,"channels":2}],"rotate":null,"file_size_in_bytes":2410174200,"format":"mp4","video_start_time":0.04}
  35. created_at: 2018-01-22 15:46:11
  36. updated_at: 2018-01-22 16:00:57
  37. 5 rows in set (0.00 sec)
  38.  
  39. mysql> select * from outputs where job_id=17555869\G
  40. *************************** 1. row ***************************
  41. id: 136863989
  42. job_id: 17555869
  43. url: NULL
  44. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q3.mp4","mkdir_mode":"0777"}
  45. created_at: 2018-01-22 15:46:11
  46. updated_at: 2018-01-22 15:46:11
  47. metadata: NULL
  48. *************************** 2. row ***************************
  49. id: 136863997
  50. job_id: 17555869
  51. url: NULL
  52. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q2.mp4","thumbnails":{"number":100,"presets":{"norm":"-brightness-contrast 8x20"}},"mkdir_mode":"0777"}
  53. created_at: 2018-01-22 15:46:11
  54. updated_at: 2018-01-22 15:46:11
  55. metadata: NULL
  56. *************************** 3. row ***************************
  57. id: 136864005
  58. job_id: 17555869
  59. url: NULL
  60. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q1.mp4","sample":[{"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-preview.mp4","dir":"a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview/","from":30,"duration":4}],"mkdir_mode":"0777"}
  61. created_at: 2018-01-22 15:46:11
  62. updated_at: 2018-01-22 15:46:11
  63. metadata: NULL
  64. *************************** 4. row ***************************
  65. id: 136864013
  66. job_id: 17555869
  67. url: NULL
  68. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q0.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q0.mp4","mkdir_mode":"0777"}
  69. created_at: 2018-01-22 15:46:11
  70. updated_at: 2018-01-22 15:46:11
  71. metadata: NULL
  72. *************************** 5. row ***************************
  73. id: 136864021
  74. job_id: 17555869
  75. url: NULL
  76. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","one_pass":true,"video_codec":"copy","audio_codec":"copy","path":"scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-qx720.mp4","mkdir_mode":"0777"}
  77. created_at: 2018-01-22 15:46:11
  78. updated_at: 2018-01-22 15:46:11
  79. metadata: NULL
  80. *************************** 6. row ***************************
  81. id: 136864029
  82. job_id: 17555869
  83. url: NULL
  84. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b.f4m","type":"playlist","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","bandwidth":1528},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","bandwidth":978},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","bandwidth":496},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","bandwidth":3628}],"no_fragments":true,"drm":"adobe","fragment_duration":30,"mkdir_mode":"0777","pkg_config":"drm/inventos.xml","ls_url":"http://drm.videomore.ru:8080/flashaccessserver/sampletenant","policy_file":"/home/converter_api/releases/20171024122000/drm/default.pol"}
  85. created_at: 2018-01-22 15:46:11
  86. updated_at: 2018-01-22 15:46:11
  87. metadata: NULL
  88. *************************** 7. row ***************************
  89. id: 136864037
  90. job_id: 17555869
  91. url: NULL
  92. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b.wvm","type":"playlist","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","bandwidth":1528},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","bandwidth":978},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","bandwidth":496},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","bandwidth":3628}],"drm":"widevine","mkdir_mode":"0777","content_id":"videomore_production_job_17555869_a516e41590ea41ebddc3ff37fd9b5d1b-q3_a516e41590ea41ebddc3ff37fd9b5d1b-q2_a516e41590ea41ebddc3ff37fd9b5d1b-q1_a516e41590ea41ebddc3ff37fd9b5d1b-qx720","provider":"inventosvideomore","pkg_url":"http://wv-packagerk-1.videomore.ru","pkg_scp":"root@wv-packagerk-1.videomore.ru"}
  93. created_at: 2018-01-22 15:46:11
  94. updated_at: 2018-01-22 15:46:11
  95. metadata: NULL
  96. *************************** 8. row ***************************
  97. id: 136864045
  98. job_id: 17555869
  99. url: NULL
  100. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b.mpd","type":"playlist","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q3.mp4","bandwidth":1528},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q2.mp4","bandwidth":978},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1.mp4","bandwidth":496},{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-qx720.mp4","bandwidth":3628}],"drm":"widevine","mkdir_mode":"0777","content_id":"videomore_production_job_17555869_a516e41590ea41ebddc3ff37fd9b5d1b-q3_a516e41590ea41ebddc3ff37fd9b5d1b-q2_a516e41590ea41ebddc3ff37fd9b5d1b-q1_a516e41590ea41ebddc3ff37fd9b5d1b-qx720","provider":"inventosvideomore","iv":"39e4cde027ce6671c3b61795ec355f77","key":"9c019260bb4881303bccdde14dbece86b3ad77da55a725e1373c87343aafacd6","ls_url":"https://license.widevine.com/cenc/getcontentkey/inventosvideomore"}
  101. created_at: 2018-01-22 15:46:11
  102. updated_at: 2018-01-22 15:46:11
  103. metadata: NULL
  104. *************************** 9. row ***************************
  105. id: 136864053
  106. job_id: 17555869
  107. url: NULL
  108. options: {"filename":"a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview/a516e41590ea41ebddc3ff37fd9b5d1b-preview.f4m","no_fragments":true,"type":"playlist","index_directory":"/a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview","streams":[{"path":"a516e41590ea41ebddc3ff37fd9b5d1b-q1-preview/a516e41590ea41ebddc3ff37fd9b5d1b-preview.mp4","bandwidth":496}],"mkdir_mode":"0777"}
  109. created_at: 2018-01-22 15:46:11
  110. updated_at: 2018-01-22 15:46:11
  111. metadata: NULL
  112. 9 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!