import: episodes 4 & 5 de CNTM

[syndr0m]

// to import new contents from PF, duplicate this script & increment manualImportId
var manualImportId = "06";

// import script
var liste = JSON.parse(document.querySelector('pre').innerHTML).filter(function (o) {
  return  o.contentId === 12420 || o.contentId === 12422;
});
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]

INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0600-000000000000','104_CNTM_EPISODE_4_h264', true, null, '7da42351-c5ec-4186-97a8-fae4fe34390f', false, '2706', '198787a91b1223530fe1154ce5fdc899');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0601-000000000000', 'https://hw.cdn.afrostream.net/vod/104_CNTM_EPISODE_4_h264/7da42351-c5ec-4186-97a8-fae4fe34390f.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0600-000000000000');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0602-000000000000', 'https://hw.cdn.afrostream.net/vod/104_CNTM_EPISODE_4_h264/7da42351-c5ec-4186-97a8-fae4fe34390f.ism/7da42351-c5ec-4186-97a8-fae4fe34390f.mpd', 'application/dash+xml', '01234567-89ab-cdef-0600-000000000000');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0603-000000000000', 'http://hw.cdn.afrostream.net/vod/104_CNTM_EPISODE_4_h264/7da42351-c5ec-4186-97a8-fae4fe34390f.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0600-000000000000');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0600-000000000001','105_CNTM_EPISODE_5_h264', true, null, '35a8ec54-ac74-454d-b53a-24ae76e1c444', false, '2805', 'a1356633064fc5b604cefacd1aa05a06');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0601-000000000001', 'https://hw.cdn.afrostream.net/vod/105_CNTM_EPISODE_5_h264/35a8ec54-ac74-454d-b53a-24ae76e1c444.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0600-000000000001');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0602-000000000001', 'https://hw.cdn.afrostream.net/vod/105_CNTM_EPISODE_5_h264/35a8ec54-ac74-454d-b53a-24ae76e1c444.ism/35a8ec54-ac74-454d-b53a-24ae76e1c444.mpd', 'application/dash+xml', '01234567-89ab-cdef-0600-000000000001');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0603-000000000001', 'http://hw.cdn.afrostream.net/vod/105_CNTM_EPISODE_5_h264/35a8ec54-ac74-454d-b53a-24ae76e1c444.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0600-000000000001');

[syndr0m]

done