aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/initializers/database.ts
Commit message (Collapse)AuthorAgeFilesLines
* Support live session in serverChocobozzz2022-05-031-0/+2
|
* Support video views/viewers stats in serverChocobozzz2022-04-151-3/+7
| | | | | | | | | | * Add "currentTime" and "event" body params to view endpoint * Merge watching and view endpoints * Introduce WatchAction AP activity * Add tables to store viewer information of local videos * Add endpoints to fetch video views/viewers stats of local videos * Refactor views/viewers handlers * Support "views" and "viewers" counters for both VOD and live videos
* Add support for saving video files to object storage (#4290)Jelle Besseling2021-08-171-1/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * 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>
* Instance homepage support (#4007)Chocobozzz2021-05-271-1/+3
| | | | | | | | | | | | | | | | | * Prepare homepage parsers * Add ability to update instance hompage * Add ability to set homepage as landing page * Add homepage preview in admin * Dynamically update left menu for homepage * Inject home content in homepage * Add videos list and channel miniature custom markup * Remove unused elements in markup service
* Cleanup models directory organizationChocobozzz2021-05-111-7/+7
|
* Merge branch 'release/3.1.0' into developChocobozzz2021-04-201-2/+11
|\
| * Fix database ssl connectionChocobozzz2021-04-191-2/+11
| |
* | Agnostic actor image storageChocobozzz2021-04-081-4/+4
| |
* | Introduce tags to the loggerChocobozzz2021-03-241-1/+1
|/ | | | | That could help to filter unneeded logs and/or select particular components
* Don't guess remote tracker URLChocobozzz2021-02-181-0/+4
|
* prettify SQL queries during debug (#3635)Rigel Kent2021-01-251-3/+3
| | | | | | | * prettify SQL queries during debug * Use sql-formatter Co-authored-by: Chocobozzz <me@florianbigard.com>
* Live streaming implementation first stepChocobozzz2020-11-091-4/+6
|
* Fix testsChocobozzz2020-08-241-7/+10
|
* Add ssl support to postgresqlChocobozzz2020-08-241-0/+2
|
* Better error message on postgresql connection errChocobozzz2020-08-241-0/+8
|
* Add server API to abuse messagesChocobozzz2020-07-311-0/+2
|
* Use 3 tables to represent abusesChocobozzz2020-07-101-19/+22
|
* Fix video view filenameChocobozzz2020-06-151-1/+1
|
* Move to eslintcontainChocobozzz2020-02-031-2/+0
|
* Update a little bit user dropdown messageChocobozzz2020-01-211-1/+1
|
* WIP plugins: install/uninstallChocobozzz2019-07-241-1/+3
|
* Fix ownership changesChocobozzz2019-04-241-1/+1
|
* Upgrade sequelizeChocobozzz2019-04-241-3/+3
|
* Update sequelizeChocobozzz2019-04-241-4/+9
|
* Create a dedicated table to track video thumbnailsChocobozzz2019-04-241-1/+3
|
* Move config in its own fileChocobozzz2019-04-111-1/+1
|
* Playlist server APIChocobozzz2019-03-181-1/+5
|
* Add hls support on serverChocobozzz2019-02-111-1/+3
|
* Add user notification base codeChocobozzz2019-01-091-1/+5
|
* Speedup peertube startupChocobozzz2018-11-191-15/+17
|
* Add ability for users to block an account/instance on server sideChocobozzz2018-10-161-1/+5
|
* Add user history and resume videosChocobozzz2018-10-051-1/+3
|
* Basic video redundancy implementationChocobozzz2018-09-131-1/+3
|
* Users can change ownership of their video [#510] (#888)Gaƫtan Rizio2018-09-041-0/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | * [#510] Create a new route to get the list of user names To be able to transfer ownership to a user, we need to be able to select him from the list of users. Because the list could be too big, we add a autocomplete feature. This commit does the following: * Add a API endpoint to get a list of user names by searching its name * [#510] The user can choose the next owner of the video To be able to transfer ownership to a user, we need the owner to be able to select the user. The server can autocomplete the name of the user to give the ownership. We add a dialog for the user to actually select it. This commit does the following: * Create a modal for the owner to select the next one * Opens this modal with a button into the menu *more* * Make the dependency injection * [#510] When the user choose the next owner, create a request in database For the change of ownership to happen, we need to store the temporary requests. When the user make the request, save it to database. This commit does the following: * Create the model to persist change ownership requests * Add an API to manage ownership operations * Add a route to persist an ownership request * [#510] A user can fetch its ownership requests sent to him To be able to accept or refuse a change of ownership, the user must be able to fetch them. This commit does the following: * Add an API to list ownership for a user * Add the query to database model * [#510] A user can validate an ownership requests sent to him - server The user can accept or refuse any ownership request that was sent to him. This commit focus only on the server part. This commit does the following: * Add an API for the user to accept or refuse a video ownership * Add validators to ensure security access * Add a query to load a specific video change ownership request * [#510] A user can validate an ownership requests sent to him - web The user can accept or refuse any ownership request that was sent to him. This commit focus only on the web part. This commit does the following: * Add a page to list user ownership changes * Add actions to accept or refuse them * When accepting, show a modal requiring the channel to send the video * Correct lint - to squash * [#510] PR reviews - to squash This commit does the following: * Search parameter for user autocompletion is required from middleware directly * [#510] PR reviews - to squash with creation in database commit This commit does the following: * Add the status attribute in model * Set this attribute on instance creation * Use AccountModel method `loadLocalByName` * [#510] PR reviews - to squash with fetch ownership This commit does the following: * Add the scope `FULL` for database queries with includes * Add classic pagination middlewares * [#510] PR reviews - to squash with ownership validation - server This commit does the following: * Add a middleware to validate whether a user can validate an ownership * Change the ownership status instead of deleting the row * [#510] PR reviews - to squash with ownership validation - client This commit does the following: * Correct indentation of html files with two-spaces indentation * Use event emitter instead of function for accept event * Update the sort of ownership change table for a decreasing order by creation date * Add the status in ownership change table * Use classic method syntax * code style - to squash * Add new user right - to squash * Move the change to my-account instead of video-watch - to squash As requested in pull-request, move the action to change ownership into my videos page. The rest of the logic was not really changed. This commit does the following: - Move the modal into my video page - Create the generic component `button` to keep some styles and logic * [#510] Add tests for the new feature To avoid regression, we add tests for all api of ownership change. This commit does the following: - Create an end-to-end test for ownership change - Divide it to one test per request * [#510] Do not send twice the same request to avoid spam We can send several time the same request to change ownership. However, it will spam the user. To avoid this, we do not save a request already existing in database. This commit does the following: - Check whether the request exist in database - Add tests to verify this new condition * [#510] Change icons Change icons so they remains logic with the rest of the application. This commit does the following: - Add svg for missing icons - Add icons in `my-button` component - Use these new icons * [#510] Add control about the user quota The user should be able to accept a new video only if his quota allows it. This commit does the following: - Update the middleware to control the quota - Add tests verifying the control * Correct merge - Use new modal system - Move button to new directory `buttons` * PR reviews - to squash
* Bufferize videos views in redisChocobozzz2018-08-301-1/+3
|
* Add ability to import video with youtube-dlChocobozzz2018-08-061-1/+3
|
* adding ORM pool configurationRigel Kent2018-07-311-0/+4
|
* Fix last commitChocobozzz2018-07-261-4/+5
|
* Add advanced search in clientChocobozzz2018-07-241-2/+0
|
* Begin advanced searchChocobozzz2018-07-241-0/+43
|
* Implement captions/subtitlesChocobozzz2018-07-161-0/+2
|
* Add ability for uploaders to schedule video updateChocobozzz2018-06-141-1/+3
|
* Move job queue to redisChocobozzz2018-01-251-2/+0
| | | | | | | We'll use it as cache in the future. /!\ You'll loose your old jobs (pending jobs too) so upgrade only when you don't have pending job anymore.
* Create comment on replied mastodon statutesChocobozzz2017-12-221-1/+3
|
* Begin moving video channel to actorChocobozzz2017-12-191-4/+4
|
* Fix database connection (host + port)Chocobozzz2017-12-151-1/+4
|
* Add migrationChocobozzz2017-12-131-2/+2
|
* Move models to typescript-sequelizeChocobozzz2017-12-131-133/+53
|
* Add account avatarChocobozzz2017-12-041-0/+2
|
* Fix well known and json parser with mastodonChocobozzz2017-11-291-0/+2
|