search

Afrostream / afrostream-back-end

Simple backo for afrostream
1 stars 0 forks source link

database: missing pfMd5Hash #350

Closed syndr0m closed 7 years ago

syndr0m commented 7 years ago

@see https://docs.google.com/spreadsheets/d/1-Tz9AdreKSm4t5BQfPLZGJkkgVkTqBCKL_vEg66d0MQ/edit#gid=0

syndr0m commented 7 years ago

1ère requête : 

-- ERROR: "6e350d7e9d344a65": unknown encodingId in PF ?
-- ERROR: "e1e433cb1e338fb6": unknown encodingId in PF ?
-- ERROR: "0220acc39afe3f33": unknown encodingId in PF ?
-- ERROR: "3cc99b1969aa7c78": unknown encodingId in PF ?
-- ERROR: "902201fbf1087ffc": unknown encodingId in PF ?
-- ERROR: "72c570650fc0a95a": unknown encodingId in PF ?
-- ERROR: "eca25db1b4c38072": unknown encodingId in PF ?
-- ERROR: "ffdca4fae1849c99": unknown encodingId in PF ?
-- ERROR: "b57724bdf19bc097": unknown encodingId in PF ?
-- ERROR: "c98f9889207c9b56": unknown encodingId in PF ?
-- ERROR: "920bcb65ff6ff2c8": unknown encodingId in PF ?
-- ERROR: "cf10cb1ddc825714": unknown encodingId in PF ?
-- ERROR: "5a9c5dcc1ab9df54": unknown encodingId in PF ?
-- ERROR: "c561f18c45fcd00d": unknown encodingId in PF ?
-- ERROR: "e508b188f72e858f": unknown encodingId in PF ?
-- ERROR: "e2611d9d5253d2f3": unknown encodingId in PF ?
-- ERROR: "3ab8b66b8b10b1fa": unknown encodingId in PF ?
-- ERROR: "27099f462d623be9": unknown encodingId in PF ?
-- ERROR: "6be6bfb876a3700e": unknown encodingId in PF ?
-- ERROR: "53a7f98e6287cad3": unknown encodingId in PF ?
-- ERROR: "c81746107e7c89a8": unknown encodingId in PF ?
-- ERROR: "d7efbbdb83c6739b": unknown encodingId in PF ?
-- ERROR: "4d66ede335a3ddba": unknown encodingId in PF ?
-- ERROR: "b783eb27eaaf736c": unknown encodingId in PF ?
-- ERROR: "79760f6b7fcd93f4": unknown encodingId in PF ?
-- ERROR: "1db198bd84702689": unknown encodingId in PF ?
-- ERROR: "fa8a483808c032ca": unknown encodingId in PF ?
-- ERROR: "5b339b4c3480f41f": unknown encodingId in PF ?
-- ERROR: "e1601c4cab6bb247": unknown encodingId in PF ?
-- ERROR: "4ae493efafb78d8d": unknown encodingId in PF ?
-- ERROR: "5dfb1725669bf0e5": unknown encodingId in PF ?
-- ERROR: "57874c51c029203b": unknown encodingId in PF ?
-- ERROR: "9fd976a90e63b686": unknown encodingId in PF ?
-- ERROR: "2bca37907319deed": unknown encodingId in PF ?
-- ERROR: "8bb5e12b236accea": unknown encodingId in PF ?
-- ERROR: "bf632a412037373d": unknown encodingId in PF ?
-- ERROR: "b50b9465af403984": unknown encodingId in PF ?
-- ERROR: "5c5d2be74efbdc00": unknown encodingId in PF ?
-- ERROR: "eed309b43db223ef": unknown encodingId in PF ?
-- ERROR: "1d3316cc3095284e": unknown encodingId in PF ?
-- ERROR: "34d826b3fc9d1568": unknown encodingId in PF ?
-- ERROR: "beb033f72cbac4b4": unknown encodingId in PF ?
-- ERROR: "21e565e417bd0e28": unknown encodingId in PF ?
-- ERROR: "644b4119b656d65f": unknown encodingId in PF ?
-- ERROR: "386e3c5a1375faa1": unknown encodingId in PF ?
-- ERROR: "11156641eb71ca7d": unknown encodingId in PF ?
-- ERROR: "6a53d134e4a9c378": unknown encodingId in PF ?
-- ERROR: "c65aa147b5d0cfef": unknown encodingId in PF ?
-- ERROR: "98575fca123a09f0": unknown encodingId in PF ?
-- ERROR: "a7b1dc843f59e198": unknown encodingId in PF ?
-- ERROR: "fee443d84e16d92c": unknown encodingId in PF ?
-- ERROR: "55dc3d3e2ab27604": unknown encodingId in PF ?
-- ERROR: "39b339bbddd84bc2": unknown encodingId in PF ?
-- ERROR: "5637d646afe514e1": unknown encodingId in PF ?
-- ERROR: "62007351cf9d2d7f": unknown encodingId in PF ?
-- ERROR: "1de2af809d70935c": unknown encodingId in PF ?
-- ERROR: "9b14b2c2ac92cee3": unknown encodingId in PF ?
-- ERROR: "b6f69783a5a4efac": unknown encodingId in PF ?
-- ERROR: "b23628b16662a2de": unknown encodingId in PF ?
-- ERROR: "6cdd1e68a9b8ecd1": unknown encodingId in PF ?
-- ERROR: "8c8cf93b94becc36": unknown encodingId in PF ?
-- ERROR: "46e01ddd7519fd34": unknown encodingId in PF ?
-- ERROR: "ee1800a482557155": unknown encodingId in PF ?
-- ERROR: "29ff1612ddb24570": unknown encodingId in PF ?
-- ERROR: "69b463b5c0c7fac4": unknown encodingId in PF ?
-- ERROR: "47d70a1ed83785f2": unknown encodingId in PF ?
-- ERROR: "0128281a1bab8bf0": unknown encodingId in PF ?
-- ERROR: "e183edcff2637a99": unknown encodingId in PF ?
-- ERROR: "180c5fd0ba9ffea5": unknown encodingId in PF ?
-- ERROR: "0d8a72ab42eac098": unknown encodingId in PF ?
-- ERROR: "efbd4c7a7ad41d22": unknown encodingId in PF ?
-- ERROR: "a8992d6133eba93e": unknown encodingId in PF ?
-- ERROR: "795866ac7f163e1a": unknown encodingId in PF ?
-- ERROR: "22eaa2ff233b464e": unknown encodingId in PF ?
-- ERROR: "02535e2399a926a8": unknown encodingId in PF ?
-- ERROR: "bdca06140721324e": unknown encodingId in PF ?
-- ERROR: "874c9857ad1394ad": unknown encodingId in PF ?
-- ERROR: "cea8a86d3681f4a0": unknown encodingId in PF ?
-- ERROR: "d67265a789698ad0": unknown encodingId in PF ?
UPDATE "Videos" SET "pfMd5Hash" = 'c166b4e54b82bb0e24002409b7c4b595' WHERE "encodingId" = '877eb16922bdbf9a';
UPDATE "Videos" SET "pfMd5Hash" = 'd76fb2ad19494d631c09d803d3f8f7fc' WHERE "encodingId" = '6b374e96eeec1db9';
UPDATE "Videos" SET "pfMd5Hash" = 'ac3d59091d58cfc6e3b8af0958a3b39f' WHERE "encodingId" = 'aacca7aeb63aa9b8';
UPDATE "Videos" SET "pfMd5Hash" = 'e8fd268f906f7be70a15e6206bf8a933' WHERE "encodingId" = '064609571b058281';
UPDATE "Videos" SET "pfMd5Hash" = 'ea9b3bf8d650be9c61215333b0ce384e' WHERE "encodingId" = 'e82685f648fd2c01';
UPDATE "Videos" SET "pfMd5Hash" = '0f644054664131044a6002463f9b46c7' WHERE "encodingId" = 'd6ba591448a72288';
UPDATE "Videos" SET "pfMd5Hash" = 'b038cfd46e3f3b91eeee0e1a85d52dbe' WHERE "encodingId" = 'ab3bf92c208a22ba';
UPDATE "Videos" SET "pfMd5Hash" = 'd9f3e71d95fe1906c3be5d6d6011e230' WHERE "encodingId" = '52ef222968508148';
UPDATE "Videos" SET "pfMd5Hash" = 'b68b31522f2a67128bdc89c64eaa64b1' WHERE "encodingId" = '584ee98edb7801a1';
UPDATE "Videos" SET "pfMd5Hash" = '20aabee7ddd7c86fbac3b02d768fb1d4' WHERE "encodingId" = '0e5ddc974270304b';
-- ERROR: "a8c79718cd01b641": unknown encodingId in PF ?
-- ERROR: "7c442f0b63424003": unknown encodingId in PF ?
-- ERROR: "b25552bf920b82c5": unknown encodingId in PF ?
-- ERROR: "f4565cd07fc24d41": unknown encodingId in PF ?
-- ERROR: "2b398bc245eb5764": unknown encodingId in PF ?
-- ERROR: "f3574a6faba35a5b": unknown encodingId in PF ?
-- ERROR: "4269d5fac2cb6c83": unknown encodingId in PF ?
-- ERROR: "c3a3774d972bbd07": unknown encodingId in PF ?
-- ERROR: "56f74fb0c568c545": unknown encodingId in PF ?
-- ERROR: "2dbb03340c39b43b": unknown encodingId in PF ?
-- ERROR: "1150e30f874167ef": unknown encodingId in PF ?
-- ERROR: "fa9c3421cd35efc1": unknown encodingId in PF ?
-- ERROR: "b165ecbba481ed35": unknown encodingId in PF ?
-- ERROR: "e4511e29b29bad2f": unknown encodingId in PF ?
-- ERROR: "bd2a914c6f73a954": unknown encodingId in PF ?
-- ERROR: "db7d69b1341dcdfc": unknown encodingId in PF ?
-- ERROR: "0fd48f01884b4d51": unknown encodingId in PF ?
-- ERROR: "08cc99ed6b2d545e": unknown encodingId in PF ?
-- ERROR: "612776303fb823ad": unknown encodingId in PF ?
-- ERROR: "8cd80242a5d6f90d": unknown encodingId in PF ?
-- ERROR: "7f05e0fad1c33ba7": unknown encodingId in PF ?
-- ERROR: "42ce5b1edeb4f685": unknown encodingId in PF ?
-- ERROR: "b000fa9644ec9f38": unknown encodingId in PF ?
-- ERROR: "b915dccf01eb4d26": unknown encodingId in PF ?
-- ERROR: "45cd6dd7c01d7339": unknown encodingId in PF ?
-- ERROR: "6122c65593ffea3c": unknown encodingId in PF ?
-- ERROR: "de7df201630325b9": unknown encodingId in PF ?
-- ERROR: "1149062f095c71cb": unknown encodingId in PF ?
-- ERROR: "3e4ea860b4eb4c31": unknown encodingId in PF ?
-- ERROR: "089b29c514c10c00": unknown encodingId in PF ?
-- ERROR: "60fae0014be1f989": unknown encodingId in PF ?
-- ERROR: "5890bd647f0734de": unknown encodingId in PF ?
-- ERROR: "055ef13facc3e972": unknown encodingId in PF ?
-- ERROR: "b7c7a0f735d7c6ab": unknown encodingId in PF ?
-- ERROR: "ac16f55e897b3eb1": unknown encodingId in PF ?
-- ERROR: "6a38aea96c56b120": unknown encodingId in PF ?
-- ERROR: "b7d86b179eb47d89": unknown encodingId in PF ?
-- ERROR: "e4065eb820516353": unknown encodingId in PF ?
-- ERROR: "21e7f3cf4ddd4a98": unknown encodingId in PF ?
UPDATE "Videos" SET "pfMd5Hash" = 'e03624416450bd36add6a860a68967f2' WHERE "encodingId" = '14ba01c2c6a332c5';
-- ERROR: "1b1a80e0311aefe3": unknown encodingId in PF ?
-- ERROR: "bbac53e60893fa6c": unknown encodingId in PF ?
-- ERROR: "42d1218dfbe75202": unknown encodingId in PF ?
-- ERROR: "4d412a5d229c3285": unknown encodingId in PF ?
UPDATE "Videos" SET "pfMd5Hash" = '523341f28083350251466f732760ee05' WHERE "encodingId" = 'dcc4ef38061b703d';
-- ERROR: "288e494fe50d2355": unknown encodingId in PF ?
-- ERROR: "ff5ca2694f30cd60": unknown encodingId in PF ?
UPDATE "Videos" SET "pfMd5Hash" = '83d05d2cf7c212b7190f9f976a65c499' WHERE "encodingId" = '072b7097bdfcbb67';
UPDATE "Videos" SET "pfMd5Hash" = 'd820ad0a2e888a9d80d90327e6db740d' WHERE "encodingId" = '11e6e5adbb9659af';
UPDATE "Videos" SET "pfMd5Hash" = 'ebda10503e929f730468a22bf68df99f' WHERE "encodingId" = 'da8ed52dd66b74e3';
-- ERROR: "a2c9ebb2e2bfcf7b": unknown encodingId in PF ?
-- ERROR: "d98d29e639600962": unknown encodingId in PF ?
UPDATE "Videos" SET "pfMd5Hash" = '9130ba598f4f65dc401a98f01084fb83' WHERE "encodingId" = '3c732208304a9e3d';
-- ERROR: "d4ef1b9bc6ae8e07": unknown encodingId in PF ?
-- ERROR: "c0e48b7493d8f7c7": unknown encodingId in PF ?
-- ERROR: "a10437a68acf9af3": unknown encodingId in PF ?
-- ERROR: "237e30f5703d5911": unknown encodingId in PF ?
-- ERROR: "7f77945c388ad6b2": unknown encodingId in PF ?
-- ERROR: "1f43faee5dfa4b1c": unknown encodingId in PF ?
-- ERROR: "3a3f46f814c44b74": unknown encodingId in PF ?
-- ERROR: "4bdf1643ce491843": unknown encodingId in PF ?
-- ERROR: "b4687290e10162b1": unknown encodingId in PF ?
-- ERROR: "217fbce9b89552de": unknown encodingId in PF ?
-- ERROR: "ead20331d6b4fa37": unknown encodingId in PF ?
-- ERROR: "7ee9965e94e7cf75": unknown encodingId in PF ?
-- ERROR: "b973fb630783e518": unknown encodingId in PF ?
-- ERROR: "a4d014146a90f6e5": unknown encodingId in PF ?
-- ERROR: "a008a1b96755cbbd": unknown encodingId in PF ?
-- ERROR: "50e0913ad80642cd": unknown encodingId in PF ?
-- ERROR: "3505fb5e85811034": unknown encodingId in PF ?
-- ERROR: "4c41496b0bce786b": unknown encodingId in PF ?
-- ERROR: "6e1a6493220e129f": unknown encodingId in PF ?
-- ERROR: "3f788122e8fe1b0d": unknown encodingId in PF ?
-- ERROR: "7d8af988c5590100": unknown encodingId in PF ?
-- ERROR: "b3563a1897514d2f": unknown encodingId in PF ?
-- ERROR: "3eeeb440a0cbb587": unknown encodingId in PF ?
-- ERROR: "87ccaf548a8c7703": unknown encodingId in PF ?
-- ERROR: "7f3d292c882b198a": unknown encodingId in PF ?
-- ERROR: "ded78790b18f7cd2": unknown encodingId in PF ?
-- ERROR: "d0583dffbd44d416": unknown encodingId in PF ?
-- ERROR: "b17ca4e316a6b670": unknown encodingId in PF ?
-- ERROR: "65f03587c0f71450": unknown encodingId in PF ?
-- ERROR: "71437d2402f4ad91": unknown encodingId in PF ?
-- ERROR: "b0037913c23a9983": unknown encodingId in PF ?
-- ERROR: "56505f0d2603fb47": unknown encodingId in PF ?
-- ERROR: "2b9a455432508118": unknown encodingId in PF ?
-- ERROR: "3af6f6dbafd1bfc4": unknown encodingId in PF ?
-- ERROR: "d45458386744cedb": unknown encodingId in PF ?
-- ERROR: "539ea81e92d7b651": unknown encodingId in PF ?
-- ERROR: "cdf3990451593e76": unknown encodingId in PF ?
-- ERROR: "fe9db4f079d58dcd": unknown encodingId in PF ?
-- ERROR: "c0fde7997427ca6b": unknown encodingId in PF ?
-- ERROR: "1e721b47213ed7a2": unknown encodingId in PF ?
-- ERROR: "8633ff123c1bd840": unknown encodingId in PF ?
-- ERROR: "1292d9e5e9212e56": unknown encodingId in PF ?
-- ERROR: "1beac89efbc0f6e2": unknown encodingId in PF ?
-- ERROR: "3c99944c96d4e238": unknown encodingId in PF ?
-- ERROR: "3913874d09184ac5": unknown encodingId in PF ?
-- ERROR: "21878361f789fd29": unknown encodingId in PF ?
-- ERROR: "3e09d76836dd8dfe": unknown encodingId in PF ?
-- ERROR: "3d4d6ad617eb4d96": unknown encodingId in PF ?
-- ERROR: "70caffaa9fa9c4a0": unknown encodingId in PF ?
-- ERROR: "028dfd094644d6dc": unknown encodingId in PF ?
-- ERROR: "7723fe498c2909c3": unknown encodingId in PF ?
-- ERROR: "3f6d53c93686d14a": unknown encodingId in PF ?
-- ERROR: "98a3776d81901d34": unknown encodingId in PF ?
-- ERROR: "9ba871562c24a125": unknown encodingId in PF ?
-- ERROR: "cf26afe7aa84cc8c": unknown encodingId in PF ?
-- ERROR: "3e017eb78c81d0ec": unknown encodingId in PF ?
-- ERROR: "6092063971f3b10f": unknown encodingId in PF ?
-- ERROR: "d3cd983315f1cd58": unknown encodingId in PF ?
-- ERROR: "45ccf7facfc702ca": unknown encodingId in PF ?
-- ERROR: "60f794d152aa9aa9": unknown encodingId in PF ?
-- ERROR: "a71a1cfb55e67e31": unknown encodingId in PF ?
-- ERROR: "491fcec158c95bde": unknown encodingId in PF ?
-- ERROR: "339014884f809971": unknown encodingId in PF ?
-- ERROR: "578d71fdff675a52": unknown encodingId in PF ?
-- ERROR: "bd2d501caeb18b14": unknown encodingId in PF ?
-- ERROR: "a43da27d2eeeeb1b": unknown encodingId in PF ?
-- ERROR: "730f35bab6371914": unknown encodingId in PF ?
-- ERROR: "0fdc6369d6e7fe57": unknown encodingId in PF ?
syndr0m commented 7 years ago

import contenus de l'ancienne PF dans la nouvelle (@see https://docs.google.com/spreadsheets/d/1-Tz9AdreKSm4t5BQfPLZGJkkgVkTqBCKL_vEg66d0MQ/edit#gid=0 )

UPDATE "Videos" SET "encodingId" = 'ff1f0f68-0182-4469-a984-665bbd6ff8d2' WHERE _id = '6bd8d29b-af02-4651-9c03-f860c056a19c';
UPDATE "Videos" SET "encodingId" = '672b0197-071c-4549-bd05-c437c7084e3c' WHERE _id = '2c819007-bb14-42ec-91f9-9d852af8806d';
UPDATE "Videos" SET "encodingId" = '258f602c-54c1-4538-af79-a105ea587ee9' WHERE _id = 'ed589818-c50a-4f88-b76c-1ae462a7f1c9';
UPDATE "Videos" SET "encodingId" = '2aa0d9ae-0c33-400d-be75-891b70d4ee3a' WHERE _id = 'a4035313-1643-438f-94e6-361d0bc48733';
UPDATE "Videos" SET "encodingId" = '6fc56b0b-db84-49b5-91cf-c9f2fc5080c4' WHERE _id = 'd45158c3-5c5b-4d71-a566-a47f7637bbf8';
UPDATE "Videos" SET "encodingId" = 'b383fdc1-1b3b-4031-807e-81954f840aa5' WHERE _id = '05d61cec-24ca-4e77-bea1-c3dcb58e41dc';

UPDATE "Videos" SET "encodingId" = 'b135bf98-594e-4317-917c-2f063e2c12a5' WHERE _id = '03387301-60e0-4f88-b826-d63f4afa3bb0';

UPDATE "Videos" SET "encodingId" = '6a247a74-3996-422f-95fa-e93d7fd8512a' WHERE _id = '5384929a-5371-4213-b075-abeb1d8551be';
UPDATE "Videos" SET "encodingId" = '78f967cc-c1c3-466e-b4e6-25084d9ddc2e' WHERE _id = '4cb6aac1-3887-46a4-8d5c-e5a25cacad69';
UPDATE "Videos" SET "encodingId" = 'c3d16f8b-ef1f-4afa-912c-0792d25f8bea' WHERE _id = '04f0ae79-9dc5-416b-89e4-2e69ea5582ba';
UPDATE "Videos" SET "encodingId" = 'da4b0f37-fab4-4b90-a93d-ce9238e1c2f9' WHERE _id = '6eb349a2-d1fb-45e5-b03d-74a57df5e51c';
UPDATE "Videos" SET "encodingId" = 'f9831d79-cfb2-4836-92ec-427d809cbbbb' WHERE _id = '55c99428-c790-4b84-b1c3-3ba9c4f061a1';
UPDATE "Videos" SET "encodingId" = '132f6182-fe87-4cbc-b240-4f5926b92db8' WHERE _id = 'ac462f81-e00b-4810-be06-6d33a1aae0bb';
UPDATE "Videos" SET "encodingId" = '1fc85b86-c4e7-482c-b51f-daed0f0713de' WHERE _id = 'd6eda77c-d92e-43b9-abcd-84ae1071c6ef';
UPDATE "Videos" SET "encodingId" = '13bd09d5-6226-4e16-b60a-cb1e02e5ca80' WHERE _id = '7cba7585-ed58-4e2d-a732-f45369ce2388';
UPDATE "Videos" SET "encodingId" = '4207ba46-18b8-4e40-9e51-0812398a91f4' WHERE _id = '90f157ef-936b-4efa-8f57-195a56963658';
UPDATE "Videos" SET "encodingId" = '9922c95f-a8a5-46db-954d-f2377f1992ae' WHERE _id = '7125ba1e-5213-4a40-8121-2b110f736080';
UPDATE "Videos" SET "encodingId" = 'd44f6840-5eeb-414c-97ce-506f801e8d07' WHERE _id = '111eaf38-0b2a-4731-b97f-7594587000c1';
UPDATE "Videos" SET "encodingId" = 'cb730936-215e-4ff7-96cb-7c3b3d45a0fa' WHERE _id = 'e9007d71-b4ec-4fe1-9756-936735df8542';
UPDATE "Videos" SET "encodingId" = '21a4e4d8-8d31-4cb9-8785-8cfeee045b4b' WHERE _id = 'fca9c31a-1fcc-4260-9a88-58e24f1a2546';
UPDATE "Videos" SET "encodingId" = '058a8db3-8420-4f8c-8ec6-40b0bb06adda' WHERE _id = 'a0698d06-407d-46d1-959a-d9670498b6c2';
UPDATE "Videos" SET "encodingId" = '83e71c2f-74e9-4455-a222-629993fd6b15' WHERE _id = '3f7b72ab-1004-43b0-96f0-f0b550db03b1';
UPDATE "Videos" SET "encodingId" = 'fbd387f1-0ae8-4e1c-b32d-1e9542bfcc3a' WHERE _id = '960b9c2b-33ac-48de-b457-c08bb77fd071';
UPDATE "Videos" SET "encodingId" = '89e04ba5-32ca-448c-84d0-8f16473ae295' WHERE _id = '2c17b6f8-1bc6-48f5-a57e-8041edfcdb95';
UPDATE "Videos" SET "encodingId" = '6cfaf1e3-a090-4a51-9e70-bbddb4251b7b' WHERE _id = '059bb89d-59ef-44cb-b392-ed6eaf7c87fb';
UPDATE "Videos" SET "encodingId" = '0501783d-5d16-44f8-8899-1dac56b06028' WHERE _id = '294a97ee-6dd4-4b60-8a9a-01026e7a3f24';
UPDATE "Videos" SET "encodingId" = '533f1932-fcc2-452b-a628-9a9b20fd4d49' WHERE _id = 'b2bbe8ea-0c2f-4286-8d75-011f9fbbf42b';
UPDATE "Videos" SET "encodingId" = 'befabe79-7300-4c9a-9ebf-44f81347ebe5' WHERE _id = 'ce4d3498-b020-462f-9494-3656a40eb6b1';
UPDATE "Videos" SET "encodingId" = '29922e90-c19b-4e1b-848b-bb7e0d2887a0' WHERE _id = '9c2de7f1-997a-40bb-bb72-721e9b69565b';
UPDATE "Videos" SET "encodingId" = '29ee59bf-1d59-4a7d-a792-dbd2e4818397' WHERE _id = '6cfa2de4-e5d3-4ef0-b046-1c79384198ea';
UPDATE "Videos" SET "encodingId" = '8e5dad28-7350-42fb-a552-74e243d24943' WHERE _id = '6f05a846-791c-4a6f-b2c0-6dd7113985fa';
UPDATE "Videos" SET "encodingId" = '41b832e5-6757-4ad2-9bb5-c723b4c87e24' WHERE _id = 'e675e809-f62f-4c43-a84e-4fbeb6c3a017';
UPDATE "Videos" SET "encodingId" = '2eb16b50-84b5-48e9-95ee-77042cb878f3' WHERE _id = '0d1439c3-6806-4be3-b82b-79bf558c655b';
syndr0m commented 7 years ago

on relance le script missingPfMd5Hash sur ces nouveaux contenus :

UPDATE "Videos" SET "pfMd5Hash" = 'cc85a621f3bc481ce3a5a1b68f9f0f3c' WHERE "encodingId" = '1fc85b86-c4e7-482c-b51f-daed0f0713de';
UPDATE "Videos" SET "pfMd5Hash" = '42250cafe36769514e2ab6d73eb7da53' WHERE "encodingId" = 'befabe79-7300-4c9a-9ebf-44f81347ebe5';
UPDATE "Videos" SET "pfMd5Hash" = 'a0c03e0df5d1b677ca08382a9a253fc1' WHERE "encodingId" = 'ff1f0f68-0182-4469-a984-665bbd6ff8d2';
UPDATE "Videos" SET "pfMd5Hash" = '5c5cd56d931a4d4141c0d033f34aa34f' WHERE "encodingId" = 'b383fdc1-1b3b-4031-807e-81954f840aa5';
UPDATE "Videos" SET "pfMd5Hash" = '8232c2b97a01fb40f7795524fbcd15a1' WHERE "encodingId" = 'd44f6840-5eeb-414c-97ce-506f801e8d07';
UPDATE "Videos" SET "pfMd5Hash" = 'f0f3059bcf5cc209b7ba88da25c5795c' WHERE "encodingId" = 'b135bf98-594e-4317-917c-2f063e2c12a5';
UPDATE "Videos" SET "pfMd5Hash" = 'b26bcc81c24ca7f1c2429489c1983da6' WHERE "encodingId" = '83e71c2f-74e9-4455-a222-629993fd6b15';
UPDATE "Videos" SET "pfMd5Hash" = '5f3af38e0f9bfa323561d5999af11632' WHERE "encodingId" = '89e04ba5-32ca-448c-84d0-8f16473ae295';
UPDATE "Videos" SET "pfMd5Hash" = 'f079baab66e3fb2dc2136bf1c4e978bc' WHERE "encodingId" = '0501783d-5d16-44f8-8899-1dac56b06028';
UPDATE "Videos" SET "pfMd5Hash" = '2759eef7ba305ea63701c13eb5fedee0' WHERE "encodingId" = '672b0197-071c-4549-bd05-c437c7084e3c';
UPDATE "Videos" SET "pfMd5Hash" = 'dabec5d92fd252f544eb2483fc5f05db' WHERE "encodingId" = 'f9831d79-cfb2-4836-92ec-427d809cbbbb';
UPDATE "Videos" SET "pfMd5Hash" = '8250c1970c9ebf5c2d3b86d8adbc312a' WHERE "encodingId" = '6a247a74-3996-422f-95fa-e93d7fd8512a';
UPDATE "Videos" SET "pfMd5Hash" = '459e2b299e6ed216d4405cf2c382bfe7' WHERE "encodingId" = 'cb730936-215e-4ff7-96cb-7c3b3d45a0fa';
UPDATE "Videos" SET "pfMd5Hash" = '12ca82a99f2df5b0fdad1ef98501c41a' WHERE "encodingId" = '8e5dad28-7350-42fb-a552-74e243d24943';
UPDATE "Videos" SET "pfMd5Hash" = '28d08669fe667623b554bc47e20e32b1' WHERE "encodingId" = 'c3d16f8b-ef1f-4afa-912c-0792d25f8bea';
UPDATE "Videos" SET "pfMd5Hash" = '2042f5defde5d635ffa4e8bd0170727d' WHERE "encodingId" = '41b832e5-6757-4ad2-9bb5-c723b4c87e24';
UPDATE "Videos" SET "pfMd5Hash" = '584ad3489beb95fa59957fef42be74a6' WHERE "encodingId" = '29ee59bf-1d59-4a7d-a792-dbd2e4818397';
UPDATE "Videos" SET "pfMd5Hash" = 'a485df0a061c3d4ce38572f8826b9cc1' WHERE "encodingId" = '4207ba46-18b8-4e40-9e51-0812398a91f4';
UPDATE "Videos" SET "pfMd5Hash" = 'b9af90a2936e80b914b587c22c3b091c' WHERE "encodingId" = 'fbd387f1-0ae8-4e1c-b32d-1e9542bfcc3a';
UPDATE "Videos" SET "pfMd5Hash" = '4396d2c8b04500c6a6fd09889bc3856f' WHERE "encodingId" = '2eb16b50-84b5-48e9-95ee-77042cb878f3';
UPDATE "Videos" SET "pfMd5Hash" = '8a3b9e1d8baf9f3a3e0fc3a860825ba5' WHERE "encodingId" = '29922e90-c19b-4e1b-848b-bb7e0d2887a0';
UPDATE "Videos" SET "pfMd5Hash" = 'c9bec293bfdb8308356adc4032a9b778' WHERE "encodingId" = '2aa0d9ae-0c33-400d-be75-891b70d4ee3a';
UPDATE "Videos" SET "pfMd5Hash" = 'f64ec97b00c6f69f387d3908a5244dc2' WHERE "encodingId" = '533f1932-fcc2-452b-a628-9a9b20fd4d49';
UPDATE "Videos" SET "pfMd5Hash" = 'e66807af40a8cfa5c3c7be45f961b03f' WHERE "encodingId" = '78f967cc-c1c3-466e-b4e6-25084d9ddc2e';
UPDATE "Videos" SET "pfMd5Hash" = 'f41bd35ef53aa50b4a94b18c1a38d56d' WHERE "encodingId" = '058a8db3-8420-4f8c-8ec6-40b0bb06adda';
UPDATE "Videos" SET "pfMd5Hash" = 'b5e50f3d92724610da5541d49b1926c2' WHERE "encodingId" = '258f602c-54c1-4538-af79-a105ea587ee9';
UPDATE "Videos" SET "pfMd5Hash" = 'e57198ba255cb55ee4f2cdfd544c55d1' WHERE "encodingId" = '13bd09d5-6226-4e16-b60a-cb1e02e5ca80';
UPDATE "Videos" SET "pfMd5Hash" = 'b018017e779ea24b28ff780603259a75' WHERE "encodingId" = '9922c95f-a8a5-46db-954d-f2377f1992ae';
UPDATE "Videos" SET "pfMd5Hash" = '159b4d474f97fd79c4917e1e05444423' WHERE "encodingId" = '6cfaf1e3-a090-4a51-9e70-bbddb4251b7b';
UPDATE "Videos" SET "pfMd5Hash" = '31a74aa39dbfd652a8bb1b8f4c0b7e20' WHERE "encodingId" = '6fc56b0b-db84-49b5-91cf-c9f2fc5080c4';
UPDATE "Videos" SET "pfMd5Hash" = '36b631a590194e11175160f0bb11b226' WHERE "encodingId" = 'da4b0f37-fab4-4b90-a93d-ce9238e1c2f9';
UPDATE "Videos" SET "pfMd5Hash" = '1170009e39eecffbbfcb9963c57e783f' WHERE "encodingId" = '21a4e4d8-8d31-4cb9-8785-8cfeee045b4b';
UPDATE "Videos" SET "pfMd5Hash" = 'c001dc6ab976d9383ef89426f0653d7d' WHERE "encodingId" = '132f6182-fe87-4cbc-b240-4f5926b92db8';
syndr0m commented 7 years ago

url de manifests modifiées

UPDATE "Assets" SET src=replace(src, 'bd2a914c6f73a954', 'ff1f0f68-0182-4469-a984-665bbd6ff8d2') where "videoId"='6bd8d29b-af02-4651-9c03-f860c056a19c';
UPDATE "Assets" SET src=replace(src, 'db7d69b1341dcdfc', '672b0197-071c-4549-bd05-c437c7084e3c') where "videoId"='2c819007-bb14-42ec-91f9-9d852af8806d';
UPDATE "Assets" SET src=replace(src, '0fd48f01884b4d51', '258f602c-54c1-4538-af79-a105ea587ee9') where "videoId"='ed589818-c50a-4f88-b76c-1ae462a7f1c9';
UPDATE "Assets" SET src=replace(src, '08cc99ed6b2d545e', '2aa0d9ae-0c33-400d-be75-891b70d4ee3a') where "videoId"='a4035313-1643-438f-94e6-361d0bc48733';
UPDATE "Assets" SET src=replace(src, '612776303fb823ad', '6fc56b0b-db84-49b5-91cf-c9f2fc5080c4') where "videoId"='d45158c3-5c5b-4d71-a566-a47f7637bbf8';
UPDATE "Assets" SET src=replace(src, '8cd80242a5d6f90d', 'b383fdc1-1b3b-4031-807e-81954f840aa5') where "videoId"='05d61cec-24ca-4e77-bea1-c3dcb58e41dc';

UPDATE "Assets" SET src=replace(src, 'de7df201630325b9', 'b135bf98-594e-4317-917c-2f063e2c12a5') where "videoId"='03387301-60e0-4f88-b826-d63f4afa3bb0';

UPDATE "Assets" SET src=replace(src, '217fbce9b89552de', '6a247a74-3996-422f-95fa-e93d7fd8512a') where "videoId"='5384929a-5371-4213-b075-abeb1d8551be';
UPDATE "Assets" SET src=replace(src, 'ead20331d6b4fa37', '78f967cc-c1c3-466e-b4e6-25084d9ddc2e') where "videoId"='4cb6aac1-3887-46a4-8d5c-e5a25cacad69';
UPDATE "Assets" SET src=replace(src, '7ee9965e94e7cf75', 'c3d16f8b-ef1f-4afa-912c-0792d25f8bea') where "videoId"='04f0ae79-9dc5-416b-89e4-2e69ea5582ba';
UPDATE "Assets" SET src=replace(src, 'b973fb630783e518', 'da4b0f37-fab4-4b90-a93d-ce9238e1c2f9') where "videoId"='6eb349a2-d1fb-45e5-b03d-74a57df5e51c';
UPDATE "Assets" SET src=replace(src, 'a4d014146a90f6e5', 'f9831d79-cfb2-4836-92ec-427d809cbbbb') where "videoId"='55c99428-c790-4b84-b1c3-3ba9c4f061a1';
UPDATE "Assets" SET src=replace(src, 'a008a1b96755cbbd', '132f6182-fe87-4cbc-b240-4f5926b92db8') where "videoId"='ac462f81-e00b-4810-be06-6d33a1aae0bb';
UPDATE "Assets" SET src=replace(src, '50e0913ad80642cd', '1fc85b86-c4e7-482c-b51f-daed0f0713de') where "videoId"='d6eda77c-d92e-43b9-abcd-84ae1071c6ef';
UPDATE "Assets" SET src=replace(src, '3505fb5e85811034', '13bd09d5-6226-4e16-b60a-cb1e02e5ca80') where "videoId"='7cba7585-ed58-4e2d-a732-f45369ce2388';
UPDATE "Assets" SET src=replace(src, '4c41496b0bce786b', '4207ba46-18b8-4e40-9e51-0812398a91f4') where "videoId"='90f157ef-936b-4efa-8f57-195a56963658';
UPDATE "Assets" SET src=replace(src, '6e1a6493220e129f', '9922c95f-a8a5-46db-954d-f2377f1992ae') where "videoId"='7125ba1e-5213-4a40-8121-2b110f736080';
UPDATE "Assets" SET src=replace(src, '3f788122e8fe1b0d', 'd44f6840-5eeb-414c-97ce-506f801e8d07') where "videoId"='111eaf38-0b2a-4731-b97f-7594587000c1';
UPDATE "Assets" SET src=replace(src, '7d8af988c5590100', 'cb730936-215e-4ff7-96cb-7c3b3d45a0fa') where "videoId"='e9007d71-b4ec-4fe1-9756-936735df8542';
UPDATE "Assets" SET src=replace(src, 'b3563a1897514d2f', '21a4e4d8-8d31-4cb9-8785-8cfeee045b4b') where "videoId"='fca9c31a-1fcc-4260-9a88-58e24f1a2546';
UPDATE "Assets" SET src=replace(src, '3eeeb440a0cbb587', '058a8db3-8420-4f8c-8ec6-40b0bb06adda') where "videoId"='a0698d06-407d-46d1-959a-d9670498b6c2';
UPDATE "Assets" SET src=replace(src, '87ccaf548a8c7703', '83e71c2f-74e9-4455-a222-629993fd6b15') where "videoId"='3f7b72ab-1004-43b0-96f0-f0b550db03b1';
UPDATE "Assets" SET src=replace(src, '7f3d292c882b198a', 'fbd387f1-0ae8-4e1c-b32d-1e9542bfcc3a') where "videoId"='960b9c2b-33ac-48de-b457-c08bb77fd071';
UPDATE "Assets" SET src=replace(src, 'ded78790b18f7cd2', '89e04ba5-32ca-448c-84d0-8f16473ae295') where "videoId"='2c17b6f8-1bc6-48f5-a57e-8041edfcdb95';
UPDATE "Assets" SET src=replace(src, 'd0583dffbd44d416', '6cfaf1e3-a090-4a51-9e70-bbddb4251b7b') where "videoId"='059bb89d-59ef-44cb-b392-ed6eaf7c87fb';
UPDATE "Assets" SET src=replace(src, 'b17ca4e316a6b670', '0501783d-5d16-44f8-8899-1dac56b06028') where "videoId"='294a97ee-6dd4-4b60-8a9a-01026e7a3f24';
UPDATE "Assets" SET src=replace(src, '65f03587c0f71450', '533f1932-fcc2-452b-a628-9a9b20fd4d49') where "videoId"='b2bbe8ea-0c2f-4286-8d75-011f9fbbf42b';
UPDATE "Assets" SET src=replace(src, '71437d2402f4ad91', 'befabe79-7300-4c9a-9ebf-44f81347ebe5') where "videoId"='ce4d3498-b020-462f-9494-3656a40eb6b1';
UPDATE "Assets" SET src=replace(src, 'b0037913c23a9983', '29922e90-c19b-4e1b-848b-bb7e0d2887a0') where "videoId"='9c2de7f1-997a-40bb-bb72-721e9b69565b';
UPDATE "Assets" SET src=replace(src, '56505f0d2603fb47', '29ee59bf-1d59-4a7d-a792-dbd2e4818397') where "videoId"='6cfa2de4-e5d3-4ef0-b046-1c79384198ea';
UPDATE "Assets" SET src=replace(src, '2b9a455432508118', '8e5dad28-7350-42fb-a552-74e243d24943') where "videoId"='6f05a846-791c-4a6f-b2c0-6dd7113985fa';
UPDATE "Assets" SET src=replace(src, '3af6f6dbafd1bfc4', '41b832e5-6757-4ad2-9bb5-c723b4c87e24') where "videoId"='e675e809-f62f-4c43-a84e-4fbeb6c3a017';
UPDATE "Assets" SET src=replace(src, 'd45458386744cedb', '2eb16b50-84b5-48e9-95ee-77042cb878f3') where "videoId"='0d1439c3-6806-4be3-b82b-79bf558c655b';