Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select * from inputs where job_id=17555869\G
- *************************** 1. row ***************************
- id: 17652709
- job_id: 17555869
- url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q3.mp4
- 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}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:49:42
- *************************** 2. row ***************************
- id: 17652717
- job_id: 17555869
- url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q2.mp4
- 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}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:51:52
- *************************** 3. row ***************************
- id: 17652725
- job_id: 17555869
- url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q1.mp4
- 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}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:53:01
- *************************** 4. row ***************************
- id: 17652733
- job_id: 17555869
- url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-q0.mp4
- 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}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:53:14
- *************************** 5. row ***************************
- id: 17652741
- job_id: 17555869
- url: scp://videomore@v-239-10:/mnt/10/res/66/99/6699e61e1ac21aaea4714facddefa558/6699e61e1ac21aaea4714facddefa558-qx720.mp4
- 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}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 16:00:57
- 5 rows in set (0.00 sec)
- mysql> select * from outputs where job_id=17555869\G
- *************************** 1. row ***************************
- id: 136863989
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 2. row ***************************
- id: 136863997
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 3. row ***************************
- id: 136864005
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 4. row ***************************
- id: 136864013
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 5. row ***************************
- id: 136864021
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 6. row ***************************
- id: 136864029
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 7. row ***************************
- id: 136864037
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 8. row ***************************
- id: 136864045
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- *************************** 9. row ***************************
- id: 136864053
- job_id: 17555869
- url: NULL
- 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"}
- created_at: 2018-01-22 15:46:11
- updated_at: 2018-01-22 15:46:11
- metadata: NULL
- 9 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement