search

Afrostream / afrostream-back-end

Simple backo for afrostream
1 stars 0 forks source link

import: national security #354

Closed syndr0m closed 7 years ago

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

// import script
var liste = JSON.parse(document.querySelector('pre').innerHTML).filter(function (o) {
  return o.filename.indexOf(name) !== -1;
});
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-0700-000000000000','national_security_ep01', true, null, '1685d976-9125-4e68-bada-f6476f1c4730', false, '1679', '11d7c23a031257d077a04794c43a27aa');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000000', 'https://hw.cdn.afrostream.net/vod/national_security_ep01/1685d976-9125-4e68-bada-f6476f1c4730.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000000');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000000', 'https://hw.cdn.afrostream.net/vod/national_security_ep01/1685d976-9125-4e68-bada-f6476f1c4730.ism/1685d976-9125-4e68-bada-f6476f1c4730.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000000');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000000', 'http://hw.cdn.afrostream.net/vod/national_security_ep01/1685d976-9125-4e68-bada-f6476f1c4730.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000000');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000001','national_security_ep02', true, null, '7dc66472-2f2e-4c34-8929-7eb693603519', false, '1528', '28d8d54618ac8cf52f86754b742fa6c7');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000001', 'https://hw.cdn.afrostream.net/vod/national_security_ep02/7dc66472-2f2e-4c34-8929-7eb693603519.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000001');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000001', 'https://hw.cdn.afrostream.net/vod/national_security_ep02/7dc66472-2f2e-4c34-8929-7eb693603519.ism/7dc66472-2f2e-4c34-8929-7eb693603519.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000001');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000001', 'http://hw.cdn.afrostream.net/vod/national_security_ep02/7dc66472-2f2e-4c34-8929-7eb693603519.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000001');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000002','national_security_ep03', true, null, 'e21552a6-ed56-403d-bdd9-6814941f3e87', false, '1545', '351dd33b9bd5bad3b76690b443a7c731');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000002', 'https://hw.cdn.afrostream.net/vod/national_security_ep03/e21552a6-ed56-403d-bdd9-6814941f3e87.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000002');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000002', 'https://hw.cdn.afrostream.net/vod/national_security_ep03/e21552a6-ed56-403d-bdd9-6814941f3e87.ism/e21552a6-ed56-403d-bdd9-6814941f3e87.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000002');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000002', 'http://hw.cdn.afrostream.net/vod/national_security_ep03/e21552a6-ed56-403d-bdd9-6814941f3e87.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000002');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000003','national_security_ep04', true, null, '80eb0313-f963-48fa-8437-7394aeef1605', false, '1708', 'fc44e54783aff8e6197ed76ab4258a06');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000003', 'https://hw.cdn.afrostream.net/vod/national_security_ep04/80eb0313-f963-48fa-8437-7394aeef1605.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000003');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000003', 'https://hw.cdn.afrostream.net/vod/national_security_ep04/80eb0313-f963-48fa-8437-7394aeef1605.ism/80eb0313-f963-48fa-8437-7394aeef1605.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000003');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000003', 'http://hw.cdn.afrostream.net/vod/national_security_ep04/80eb0313-f963-48fa-8437-7394aeef1605.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000003');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000004','national_security_ep05', true, null, '437dec94-30e1-438a-81c2-ef4f7e9e2d4c', false, '1594', '05846a4cae43cf00a6e5ad48f6a7c5f0');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000004', 'https://hw.cdn.afrostream.net/vod/national_security_ep05/437dec94-30e1-438a-81c2-ef4f7e9e2d4c.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000004');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000004', 'https://hw.cdn.afrostream.net/vod/national_security_ep05/437dec94-30e1-438a-81c2-ef4f7e9e2d4c.ism/437dec94-30e1-438a-81c2-ef4f7e9e2d4c.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000004');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000004', 'http://hw.cdn.afrostream.net/vod/national_security_ep05/437dec94-30e1-438a-81c2-ef4f7e9e2d4c.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000004');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000005','national_security_ep06', true, null, 'be21ffea-6260-4bfc-a804-4119ffa3899a', false, '1504', '821d3f978c5f4c7f154bcb256aa81982');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000005', 'https://hw.cdn.afrostream.net/vod/national_security_ep06/be21ffea-6260-4bfc-a804-4119ffa3899a.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000005');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000005', 'https://hw.cdn.afrostream.net/vod/national_security_ep06/be21ffea-6260-4bfc-a804-4119ffa3899a.ism/be21ffea-6260-4bfc-a804-4119ffa3899a.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000005');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000005', 'http://hw.cdn.afrostream.net/vod/national_security_ep06/be21ffea-6260-4bfc-a804-4119ffa3899a.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000005');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000006','national_security_ep07', true, null, '34c6568c-cf23-40b8-9671-10669d41e37c', false, '1602', '827aba7f526aa98d374df48daecf817c');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000006', 'https://hw.cdn.afrostream.net/vod/national_security_ep07/34c6568c-cf23-40b8-9671-10669d41e37c.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000006');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000006', 'https://hw.cdn.afrostream.net/vod/national_security_ep07/34c6568c-cf23-40b8-9671-10669d41e37c.ism/34c6568c-cf23-40b8-9671-10669d41e37c.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000006');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000006', 'http://hw.cdn.afrostream.net/vod/national_security_ep07/34c6568c-cf23-40b8-9671-10669d41e37c.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000006');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000007','national_security_ep08', true, null, '4825d3b0-bf4d-4323-a878-f20f16a145a9', false, '1631', 'fa0c9849985f717191a366840474ba99');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000007', 'https://hw.cdn.afrostream.net/vod/national_security_ep08/4825d3b0-bf4d-4323-a878-f20f16a145a9.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000007');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000007', 'https://hw.cdn.afrostream.net/vod/national_security_ep08/4825d3b0-bf4d-4323-a878-f20f16a145a9.ism/4825d3b0-bf4d-4323-a878-f20f16a145a9.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000007');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000007', 'http://hw.cdn.afrostream.net/vod/national_security_ep08/4825d3b0-bf4d-4323-a878-f20f16a145a9.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000007');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000008','national_security_ep09', true, null, 'bb75a9a2-efee-4aa2-8a47-47bee90a8b53', false, '1636', '68411b83770d61fdfcd69da5902ebe79');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000008', 'https://hw.cdn.afrostream.net/vod/national_security_ep09/bb75a9a2-efee-4aa2-8a47-47bee90a8b53.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000008');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000008', 'https://hw.cdn.afrostream.net/vod/national_security_ep09/bb75a9a2-efee-4aa2-8a47-47bee90a8b53.ism/bb75a9a2-efee-4aa2-8a47-47bee90a8b53.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000008');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000008', 'http://hw.cdn.afrostream.net/vod/national_security_ep09/bb75a9a2-efee-4aa2-8a47-47bee90a8b53.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000008');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000009','national_security_ep10', true, null, 'c6a76b3c-f083-476e-a79f-48170090aeb9', false, '1373', 'fc8b961ea2f42268e57ed79e5120bb71');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000009', 'https://hw.cdn.afrostream.net/vod/national_security_ep10/c6a76b3c-f083-476e-a79f-48170090aeb9.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000009');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000009', 'https://hw.cdn.afrostream.net/vod/national_security_ep10/c6a76b3c-f083-476e-a79f-48170090aeb9.ism/c6a76b3c-f083-476e-a79f-48170090aeb9.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000009');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000009', 'http://hw.cdn.afrostream.net/vod/national_security_ep10/c6a76b3c-f083-476e-a79f-48170090aeb9.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000009');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000010','national_security_ep11', true, null, 'd0cff75b-10c4-45e8-8c68-79f97fb1bcb1', false, '1373', '48241bdbef7406fd4b1ebf5020a70e0f');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000010', 'https://hw.cdn.afrostream.net/vod/national_security_ep11/d0cff75b-10c4-45e8-8c68-79f97fb1bcb1.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000010');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000010', 'https://hw.cdn.afrostream.net/vod/national_security_ep11/d0cff75b-10c4-45e8-8c68-79f97fb1bcb1.ism/d0cff75b-10c4-45e8-8c68-79f97fb1bcb1.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000010');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000010', 'http://hw.cdn.afrostream.net/vod/national_security_ep11/d0cff75b-10c4-45e8-8c68-79f97fb1bcb1.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000010');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000011','national_security_ep12', true, null, '78a678d6-d452-46fd-9e27-10446ff91e01', false, '1341', '7cc8b265d5f25567e56f6fd69d1d554b');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000011', 'https://hw.cdn.afrostream.net/vod/national_security_ep12/78a678d6-d452-46fd-9e27-10446ff91e01.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000011');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000011', 'https://hw.cdn.afrostream.net/vod/national_security_ep12/78a678d6-d452-46fd-9e27-10446ff91e01.ism/78a678d6-d452-46fd-9e27-10446ff91e01.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000011');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000011', 'http://hw.cdn.afrostream.net/vod/national_security_ep12/78a678d6-d452-46fd-9e27-10446ff91e01.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000011');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000012','national_security_ep13', true, null, 'cd55be05-35b9-4ae2-adf7-67e7a2d9f5f8', false, '1383', '7e1bda304065bdd3126120ad8d288241');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000012', 'https://hw.cdn.afrostream.net/vod/national_security_ep13/cd55be05-35b9-4ae2-adf7-67e7a2d9f5f8.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000012');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000012', 'https://hw.cdn.afrostream.net/vod/national_security_ep13/cd55be05-35b9-4ae2-adf7-67e7a2d9f5f8.ism/cd55be05-35b9-4ae2-adf7-67e7a2d9f5f8.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000012');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000012', 'http://hw.cdn.afrostream.net/vod/national_security_ep13/cd55be05-35b9-4ae2-adf7-67e7a2d9f5f8.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000012');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000013','national_security_ep14', true, null, 'fef50d49-5810-4819-9886-de8c16b3883c', false, '1532', '60a5a1766c69eea82153d2e1ae390a69');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000013', 'https://hw.cdn.afrostream.net/vod/national_security_ep14/fef50d49-5810-4819-9886-de8c16b3883c.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000013');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000013', 'https://hw.cdn.afrostream.net/vod/national_security_ep14/fef50d49-5810-4819-9886-de8c16b3883c.ism/fef50d49-5810-4819-9886-de8c16b3883c.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000013');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000013', 'http://hw.cdn.afrostream.net/vod/national_security_ep14/fef50d49-5810-4819-9886-de8c16b3883c.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000013');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000014','national_security_ep15', true, null, 'c28a38a8-f190-457f-a7a2-560edec837bb', false, '1495', '5ea4f37b872f8269a5a94d42f80b122d');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000014', 'https://hw.cdn.afrostream.net/vod/national_security_ep15/c28a38a8-f190-457f-a7a2-560edec837bb.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000014');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000014', 'https://hw.cdn.afrostream.net/vod/national_security_ep15/c28a38a8-f190-457f-a7a2-560edec837bb.ism/c28a38a8-f190-457f-a7a2-560edec837bb.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000014');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000014', 'http://hw.cdn.afrostream.net/vod/national_security_ep15/c28a38a8-f190-457f-a7a2-560edec837bb.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000014');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000015','national_security_ep16', true, null, '39d11712-ffa3-44eb-a23f-246e632684bf', false, '1628', '1f4fec9f8a2cdcc289e9d5054ae8fbe0');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000015', 'https://hw.cdn.afrostream.net/vod/national_security_ep16/39d11712-ffa3-44eb-a23f-246e632684bf.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000015');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000015', 'https://hw.cdn.afrostream.net/vod/national_security_ep16/39d11712-ffa3-44eb-a23f-246e632684bf.ism/39d11712-ffa3-44eb-a23f-246e632684bf.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000015');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000015', 'http://hw.cdn.afrostream.net/vod/national_security_ep16/39d11712-ffa3-44eb-a23f-246e632684bf.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000015');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000016','national_security_ep17', true, null, '614bd06e-f1e5-421d-a4d0-8f630aec2040', false, '1496', '057c6e0dcb97c75695246ddceed627ad');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000016', 'https://hw.cdn.afrostream.net/vod/national_security_ep17/614bd06e-f1e5-421d-a4d0-8f630aec2040.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000016');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000016', 'https://hw.cdn.afrostream.net/vod/national_security_ep17/614bd06e-f1e5-421d-a4d0-8f630aec2040.ism/614bd06e-f1e5-421d-a4d0-8f630aec2040.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000016');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000016', 'http://hw.cdn.afrostream.net/vod/national_security_ep17/614bd06e-f1e5-421d-a4d0-8f630aec2040.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000016');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000017','national_security_ep18', true, null, '0c8f665a-cd35-4393-9589-b9744c7063a3', false, '1496', '76e5cd1cb66b3509467a22eb743e7198');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000017', 'https://hw.cdn.afrostream.net/vod/national_security_ep18/0c8f665a-cd35-4393-9589-b9744c7063a3.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000017');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000017', 'https://hw.cdn.afrostream.net/vod/national_security_ep18/0c8f665a-cd35-4393-9589-b9744c7063a3.ism/0c8f665a-cd35-4393-9589-b9744c7063a3.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000017');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000017', 'http://hw.cdn.afrostream.net/vod/national_security_ep18/0c8f665a-cd35-4393-9589-b9744c7063a3.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000017');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000018','national_security_ep19', true, null, '74f781f9-25e7-45b5-b52e-524b4549f497', false, '1449', 'f0575928e56d5436d6f6dce731fef0a2');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000018', 'https://hw.cdn.afrostream.net/vod/national_security_ep19/74f781f9-25e7-45b5-b52e-524b4549f497.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000018');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000018', 'https://hw.cdn.afrostream.net/vod/national_security_ep19/74f781f9-25e7-45b5-b52e-524b4549f497.ism/74f781f9-25e7-45b5-b52e-524b4549f497.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000018');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000018', 'http://hw.cdn.afrostream.net/vod/national_security_ep19/74f781f9-25e7-45b5-b52e-524b4549f497.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000018');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000019','national_security_ep20', true, null, '3857124d-5b12-4093-b8ee-bdfbb7a2850a', false, '1443', '547ec65f90a60e789ebe847b7bdb673e');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000019', 'https://hw.cdn.afrostream.net/vod/national_security_ep20/3857124d-5b12-4093-b8ee-bdfbb7a2850a.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000019');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000019', 'https://hw.cdn.afrostream.net/vod/national_security_ep20/3857124d-5b12-4093-b8ee-bdfbb7a2850a.ism/3857124d-5b12-4093-b8ee-bdfbb7a2850a.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000019');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000019', 'http://hw.cdn.afrostream.net/vod/national_security_ep20/3857124d-5b12-4093-b8ee-bdfbb7a2850a.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000019');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000020','national_security_ep21', true, null, 'bb119069-39c2-4f7d-868d-ce1143ee9915', false, '1408', '2ec5508bb8a579ce416c031a0e43978e');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000020', 'https://hw.cdn.afrostream.net/vod/national_security_ep21/bb119069-39c2-4f7d-868d-ce1143ee9915.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000020');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000020', 'https://hw.cdn.afrostream.net/vod/national_security_ep21/bb119069-39c2-4f7d-868d-ce1143ee9915.ism/bb119069-39c2-4f7d-868d-ce1143ee9915.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000020');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000020', 'http://hw.cdn.afrostream.net/vod/national_security_ep21/bb119069-39c2-4f7d-868d-ce1143ee9915.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000020');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000021','national_security_ep22', true, null, 'dc57ebbb-bfc7-45f5-8f48-164a7ad8a998', false, '1457', 'b8c564cbeab62dc3c40dfb230cebaa9a');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000021', 'https://hw.cdn.afrostream.net/vod/national_security_ep22/dc57ebbb-bfc7-45f5-8f48-164a7ad8a998.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000021');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000021', 'https://hw.cdn.afrostream.net/vod/national_security_ep22/dc57ebbb-bfc7-45f5-8f48-164a7ad8a998.ism/dc57ebbb-bfc7-45f5-8f48-164a7ad8a998.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000021');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000021', 'http://hw.cdn.afrostream.net/vod/national_security_ep22/dc57ebbb-bfc7-45f5-8f48-164a7ad8a998.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000021');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000022','national_security_ep23', true, null, '1eb86874-6254-4a0f-9d5e-371228242330', false, '1337', '76dca650e1a3aec491f8451b429d30ba');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000022', 'https://hw.cdn.afrostream.net/vod/national_security_ep23/1eb86874-6254-4a0f-9d5e-371228242330.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000022');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000022', 'https://hw.cdn.afrostream.net/vod/national_security_ep23/1eb86874-6254-4a0f-9d5e-371228242330.ism/1eb86874-6254-4a0f-9d5e-371228242330.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000022');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000022', 'http://hw.cdn.afrostream.net/vod/national_security_ep23/1eb86874-6254-4a0f-9d5e-371228242330.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000022');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000023','national_security_ep24', true, null, 'b2e7dc2f-b768-4b47-9c5c-05d1f77ceb5b', false, '1502', 'aa746b614579015e6f75a654cbd8029f');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000023', 'https://hw.cdn.afrostream.net/vod/national_security_ep24/b2e7dc2f-b768-4b47-9c5c-05d1f77ceb5b.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000023');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000023', 'https://hw.cdn.afrostream.net/vod/national_security_ep24/b2e7dc2f-b768-4b47-9c5c-05d1f77ceb5b.ism/b2e7dc2f-b768-4b47-9c5c-05d1f77ceb5b.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000023');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000023', 'http://hw.cdn.afrostream.net/vod/national_security_ep24/b2e7dc2f-b768-4b47-9c5c-05d1f77ceb5b.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000023');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000024','national_security_ep25', true, null, '8e1e487b-28e4-4fe0-a3a5-00c521641535', false, '1514', 'c797fc5f0dec4f4fc6df99ade4087798');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000024', 'https://hw.cdn.afrostream.net/vod/national_security_ep25/8e1e487b-28e4-4fe0-a3a5-00c521641535.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000024');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000024', 'https://hw.cdn.afrostream.net/vod/national_security_ep25/8e1e487b-28e4-4fe0-a3a5-00c521641535.ism/8e1e487b-28e4-4fe0-a3a5-00c521641535.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000024');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000024', 'http://hw.cdn.afrostream.net/vod/national_security_ep25/8e1e487b-28e4-4fe0-a3a5-00c521641535.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000024');
INSERT INTO "Videos" ("_id", "name", "active", "importId", "encodingId", "drm", "duration", "pfMd5Hash")VALUES ('01234567-89ab-cdef-0700-000000000025','national_security_ep26', true, null, 'be629ab6-4bbd-4167-b393-225e7114f498', false, '1531', '70cf2c04760b057c62068230efc389a9');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0701-000000000025', 'https://hw.cdn.afrostream.net/vod/national_security_ep26/be629ab6-4bbd-4167-b393-225e7114f498.ism/master.m3u8', 'application/vnd.apple.mpegurl', '01234567-89ab-cdef-0700-000000000025');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0702-000000000025', 'https://hw.cdn.afrostream.net/vod/national_security_ep26/be629ab6-4bbd-4167-b393-225e7114f498.ism/be629ab6-4bbd-4167-b393-225e7114f498.mpd', 'application/dash+xml', '01234567-89ab-cdef-0700-000000000025');INSERT INTO "Assets" (_id, src, type, "videoId") VALUES ('01234567-89ab-cdef-0703-000000000025', 'http://hw.cdn.afrostream.net/vod/national_security_ep26/be629ab6-4bbd-4167-b393-225e7114f498.ism/MANIFEST', 'application/vnd.ms-sstr+xml', '01234567-89ab-cdef-0700-000000000025');
syndr0m commented 7 years ago

done