projects
/
oweals
/
peertube.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
findById -> findByPk
[oweals/peertube.git]
/
server
/
initializers
/
migrations
/
0275-video-file-unique.ts
diff --git
a/server/initializers/migrations/0275-video-file-unique.ts
b/server/initializers/migrations/0275-video-file-unique.ts
index fd89188c0ef1e366bf90eab5674e43e8c9ad5605..e321ecb04ea548d298bcfb9512e7b4135f89699b 100644
(file)
--- a/
server/initializers/migrations/0275-video-file-unique.ts
+++ b/
server/initializers/migrations/0275-video-file-unique.ts
@@
-5,6
+5,12
@@
async function up (utils: {
queryInterface: Sequelize.QueryInterface
sequelize: Sequelize.Sequelize
}): Promise<any> {
queryInterface: Sequelize.QueryInterface
sequelize: Sequelize.Sequelize
}): Promise<any> {
+ // Delete duplicated keys
+ {
+ const query = 'DELETE FROM "server" s1 USING "server" s2 WHERE s1.id < s2.id AND s1."host" = s2."host"'
+ await utils.sequelize.query(query)
+ }
+
{
const query = 'DELETE FROM "videoFile" vf1 USING "videoFile" vf2 WHERE vf1.id < vf2.id ' +
'AND vf1."videoId" = vf2."videoId" AND vf1.resolution = vf2.resolution AND vf1.fps IS NULL'
{
const query = 'DELETE FROM "videoFile" vf1 USING "videoFile" vf2 WHERE vf1.id < vf2.id ' +
'AND vf1."videoId" = vf2."videoId" AND vf1.resolution = vf2.resolution AND vf1.fps IS NULL'