search

Afrostream / afrostream-back-end

Simple backo for afrostream
1 stars 0 forks source link

import: episodes 6 à 10 de CNTM #357

Closed syndr0m closed 7 years ago

syndr0m commented 7 years ago 
// to import new contents from PF, duplicate this script & increment manualImportId
var manualImportId = "08";

// import script
var liste = JSON.parse(document.querySelector('pre').innerHTML).filter(function (o) {
 // 12421, 12482, 12483, 12484, 12485
  return  o.contentId === 12421 || o.contentId === 12482 || o.contentId === 12483 || o.contentId === 12484 || o.contentId === 12485;
});
liste.sort(function(a, b) {
   if (a.filename === b.filename) return 0;
   return (a.filename < b.filename) ? -1 : 1;
});
function pad(n, width, z) {
  z = z || '0';
  n = n + '';
  return n.length >= width ? n : new Array(width - n.length + 1).join(z) + n;
}
liste.map(function (o,i) { 
  var d = o.duration.split(':'); 
  var duration = parseInt(d[2], 10) + parseInt(d[1], 10)*60 + parseInt(d[0], 0) * 3600; 
  var name = o.filename.split('/').pop().replace('.mp4', '').replace('.mov', '').replace('.mxf', '');
  var encodingId = o.uuid;
  var pfMd5Hash = o.md5Hash;
  var id = "01234567-89ab-cdef-"+manualImportId+"00-000000000"+pad(i, 3);
  var assetId1 = "01234567-89ab-cdef-"+manualImportId+"01-000000000"+pad(i, 3);
  var assetId2 = "01234567-89ab-cdef-"+manualImportId+"02-000000000"+pad(i, 3);
  var assetId3 = "01234567-89ab-cdef-"+manualImportId+"03-000000000"+pad(i, 3);

  return 'INSERT INTO "Videos" ' +
         '("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")' +
         'VALUES ' +
         "('"+id+"','"+name+"', true, null, '"+encodingId+"', false, '"+duration+"', '"+pfMd5Hash+"');"+
         'INSERT INTO "Assets" (_id, src, type, "videoId") ' + "VALUES ('"+assetId1+"', '"+ 'https://hw.cdn.afrostream.net/vod/'+name+'/'+encodingId+'.ism/master.m3u8' + "', 'application/vnd.apple.mpegurl', '"+id+"');"+
         'INSERT INTO "Assets" (_id, src, type, "videoId") ' + "VALUES ('"+assetId2+"', '"+ 'https://hw.cdn.afrostream.net/vod/'+name+'/'+encodingId+'.ism/'+encodingId+'.mpd' + "', 'application/dash+xml', '"+id+"');"+
         'INSERT INTO "Assets" (_id, src, type, "videoId") ' + "VALUES ('"+assetId3+"', '"+ 'http://hw.cdn.afrostream.net/vod/'+name+'/'+encodingId+'.ism/MANIFEST' + "', 'application/vnd.ms-sstr+xml', '"+id+"');";
}).join("\n")
syndr0m commented 7 years ago 
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0800-000000000000','106_CNTM_EPISODE_6_h264', true, null, '4d3c73fb-e430-4ad8-b45c-8dd96fe4d426', false, '2905', '691c737aefa032cd1017de48294ac490');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0801-000000000000', 'https://hw.cdn.afrostream.net/vod/106_CNTM_EPISODE_6_h264/4d3c73fb-e430-4ad8-b45c-8dd96fe4d426.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0800-000000000000');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0802-000000000000', 'https://hw.cdn.afrostream.net/vod/106_CNTM_EPISODE_6_h264/4d3c73fb-e430-4ad8-b45c-8dd96fe4d426.ism/4d3c73fb-e430-4ad8-b45c-8dd96fe4d426.mpd', 'application/dash+xml', '01234567-89ab-cdef-0800-000000000000');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0803-000000000000', 'http://hw.cdn.afrostream.net/vod/106_CNTM_EPISODE_6_h264/4d3c73fb-e430-4ad8-b45c-8dd96fe4d426.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0800-000000000000');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0800-000000000001','EP_107_CNTM_EPISODE_7_h264', true, null, '5d8ff6c5-1660-4c76-bbff-4a63694f2c22', false, '2839', '31f0226aedad62b6b0aae9b4207a0df3');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0801-000000000001', 'https://hw.cdn.afrostream.net/vod/EP_107_CNTM_EPISODE_7_h264/5d8ff6c5-1660-4c76-bbff-4a63694f2c22.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0800-000000000001');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0802-000000000001', 'https://hw.cdn.afrostream.net/vod/EP_107_CNTM_EPISODE_7_h264/5d8ff6c5-1660-4c76-bbff-4a63694f2c22.ism/5d8ff6c5-1660-4c76-bbff-4a63694f2c22.mpd', 'application/dash+xml', '01234567-89ab-cdef-0800-000000000001');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0803-000000000001', 'http://hw.cdn.afrostream.net/vod/EP_107_CNTM_EPISODE_7_h264/5d8ff6c5-1660-4c76-bbff-4a63694f2c22.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0800-000000000001');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0800-000000000002','EP_108_CNTM_EPISODE_8_h264', true, null, 'fa78cad9-242f-4658-819f-406e0f2e690b', false, '2874', '85766fa84022bee77b93b9f4857c8c47');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0801-000000000002', 'https://hw.cdn.afrostream.net/vod/EP_108_CNTM_EPISODE_8_h264/fa78cad9-242f-4658-819f-406e0f2e690b.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0800-000000000002');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0802-000000000002', 'https://hw.cdn.afrostream.net/vod/EP_108_CNTM_EPISODE_8_h264/fa78cad9-242f-4658-819f-406e0f2e690b.ism/fa78cad9-242f-4658-819f-406e0f2e690b.mpd', 'application/dash+xml', '01234567-89ab-cdef-0800-000000000002');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0803-000000000002', 'http://hw.cdn.afrostream.net/vod/EP_108_CNTM_EPISODE_8_h264/fa78cad9-242f-4658-819f-406e0f2e690b.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0800-000000000002');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0800-000000000003','EP_109_CNTM_EPISODE_9_h264', true, null, 'd3eb395b-6f2e-47cd-b222-82640f663aeb', false, '2807', '86818468decd30f2e54e9d4e91cd082b');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0801-000000000003', 'https://hw.cdn.afrostream.net/vod/EP_109_CNTM_EPISODE_9_h264/d3eb395b-6f2e-47cd-b222-82640f663aeb.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0800-000000000003');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0802-000000000003', 'https://hw.cdn.afrostream.net/vod/EP_109_CNTM_EPISODE_9_h264/d3eb395b-6f2e-47cd-b222-82640f663aeb.ism/d3eb395b-6f2e-47cd-b222-82640f663aeb.mpd', 'application/dash+xml', '01234567-89ab-cdef-0800-000000000003');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0803-000000000003', 'http://hw.cdn.afrostream.net/vod/EP_109_CNTM_EPISODE_9_h264/d3eb395b-6f2e-47cd-b222-82640f663aeb.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0800-000000000003');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0800-000000000004','EP_110_CNTM_EPISODE_10_h264', true, null, 'd76f5a71-cb05-4db1-a684-716903206c39', false, '2919', '9fb610b2731f0343f5e898061435f42e');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0801-000000000004', 'https://hw.cdn.afrostream.net/vod/EP_110_CNTM_EPISODE_10_h264/d76f5a71-cb05-4db1-a684-716903206c39.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0800-000000000004');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0802-000000000004', 'https://hw.cdn.afrostream.net/vod/EP_110_CNTM_EPISODE_10_h264/d76f5a71-cb05-4db1-a684-716903206c39.ism/d76f5a71-cb05-4db1-a684-716903206c39.mpd', 'application/dash+xml', '01234567-89ab-cdef-0800-000000000004');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0803-000000000004', 'http://hw.cdn.afrostream.net/vod/EP_110_CNTM_EPISODE_10_h264/d76f5a71-cb05-4db1-a684-716903206c39.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0800-000000000004');
syndr0m commented 7 years ago

done