aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models/video/sql
Commit message (Collapse)AuthorAgeFilesLines
* Fix server lintChocobozzz2022-11-151-1/+1
|
* Don't inject untrusted inputChocobozzz2022-11-151-2/+3
| | | | | Even if it's already checked in middlewares It's better to have safe modals too
* Prefer using our pick functionChocobozzz2022-08-173-3/+6
|
* Rename video full loadingChocobozzz2022-06-281-9/+9
|
* Optimize feeds queryChocobozzz2022-06-274-24/+69
|
* Convert followers/following in raw SQL queriesChocobozzz2022-05-051-2/+2
| | | | Prevent weird bug in SQL generation
* TypoChocobozzz2022-05-021-1/+1
|
* Add latency setting supportChocobozzz2022-03-091-0/+1
|
* Refactor a little bit raw sql buildersChocobozzz2022-03-038-38/+16
|
* Fix getting avatars in videos listChocobozzz2022-03-011-3/+5
|
* Implement avatar miniatures (#4639)kontrollanten2022-02-289-24/+49
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * client: remove unused file * refactor(client/my-actor-avatar): size from input Read size from component input instead of scss, to make it possible to use smaller avatar images when implemented. * implement avatar miniatures close #4560 * fix(test): max file size * fix(search-index): normalize res acc to avatarMini * refactor avatars to an array * client/search: resize channel avatar to 120 * refactor(client/videos): remove unused function * client(actor-avatar): set default size * fix tests and avatars full result When findOne is used only an array containting one avatar is returned. * update migration version and version notations * server/search: harmonize normalizing * Cleanup avatar miniature PR Co-authored-by: Chocobozzz <me@florianbigard.com>
* Case insensitive search on tagsChocobozzz2022-02-031-1/+1
|
* Fix subscriptionsChocobozzz2021-12-171-2/+3
|
* Fix internal user subscriptionChocobozzz2021-12-171-2/+2
|
* Add ability to filter out public videos from adminChocobozzz2021-11-121-5/+13
|
* Add ability to filter by file typeChocobozzz2021-11-031-10/+35
|
* Some fixes for admin videos listChocobozzz2021-11-028-40/+39
|
* Add video file size info in admin videos listChocobozzz2021-10-293-6/+6
|
* Deprecate filter video queryChocobozzz2021-10-296-32/+149
| | | | Introduce include and isLocal instead
* Fix useless conditionChocobozzz2021-10-111-1/+1
|
* Add support for saving video files to object storage (#4290)Jelle Besseling2021-08-171-3/+6
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * Add support for saving video files to object storage * Add support for custom url generation on s3 stored files Uses two config keys to support url generation that doesn't directly go to (compatible s3). Can be used to generate urls to any cache server or CDN. * Upload files to s3 concurrently and delete originals afterwards * Only publish after move to object storage is complete * Use base url instead of url template * Fix mistyped config field * Add rudenmentary way to download before transcode * Implement Chocobozzz suggestions https://github.com/Chocobozzz/PeerTube/pull/4290#issuecomment-891670478 The remarks in question: Try to use objectStorage prefix instead of s3 prefix for your function/variables/config names Prefer to use a tree for the config: s3.streaming_playlists_bucket -> object_storage.streaming_playlists.bucket Use uppercase for config: S3.STREAMING_PLAYLISTS_BUCKETINFO.bucket -> OBJECT_STORAGE.STREAMING_PLAYLISTS.BUCKET (maybe BUCKET_NAME instead of BUCKET) I suggest to rename moveJobsRunning to pendingMovingJobs (or better, create a dedicated videoJobInfo table with a pendingMove & videoId columns so we could also use this table to track pending transcoding jobs) https://github.com/Chocobozzz/PeerTube/pull/4290/files#diff-3e26d41ca4bda1de8e1747af70ca2af642abcc1e9e0bfb94239ff2165acfbde5R19 uses a string instead of an integer I think we should store the origin object storage URL in fileUrl, without base_url injection. Instead, inject the base_url at "runtime" so admins can easily change this configuration without running a script to update DB URLs * Import correct function * Support multipart upload * Remove import of node 15.0 module stream/promises * Extend maximum upload job length Using the same value as for redundancy downloading seems logical * Use dynamic part size for really large uploads Also adds very small part size for local testing * Fix decreasePendingMove query * Resolve various PR comments * Move to object storage after optimize * Make upload size configurable and increase default * Prune webtorrent files that are stored in object storage * Move files after transcoding jobs * Fix federation * Add video path manager * Support move to external storage job in client * Fix live object storage tests Co-authored-by: Chocobozzz <me@florianbigard.com>
* Add ability to search by uuids/actor namesChocobozzz2021-07-281-0/+10
|
* Add ability to search by host in serverChocobozzz2021-07-271-0/+19
|
* Use random names for VOD HLS playlistsChocobozzz2021-07-261-1/+2
|
* Add ability for instances to follow any actorChocobozzz2021-07-211-3/+3
|
* Add ability to search playlistsChocobozzz2021-06-251-1/+1
|
* Remove unnecessary logChocobozzz2021-06-111-3/+0
|
* Fix redundancy row grabbingChocobozzz2021-06-111-6/+2
|
* Fix video with all files queryChocobozzz2021-06-111-0/+1
|
* Fix live files includeChocobozzz2021-06-114-14/+17
|
* Fix video rights fetchingChocobozzz2021-06-111-0/+1
|
* Refactor include checksChocobozzz2021-06-111-53/+49
|
* Use raw SQL for most of video queriesChocobozzz2021-06-117-49/+157
|
* Optimize join buildChocobozzz2021-06-114-29/+39
|
* Optimize rows parsingChocobozzz2021-06-117-131/+164
|
* Use separate queries for video filesChocobozzz2021-06-118-56/+231
|
* Use raw SQL for video get requestChocobozzz2021-06-109-362/+873
|
* Refactor video query builderChocobozzz2021-06-104-0/+1020