search

ynput / ayon-docker

The best way to deploy and test AYON server with frontend
Apache License 2.0
36 stars 26 forks source link

Dump & Restore project in scripts #17

Closed iLLiCiTiT closed 1 year ago

iLLiCiTiT commented 1 year ago

Description

Added commands in manage scripts to dump and restore project from database.

martastain commented 1 year ago

BTW: that part where the insert statement is searched for - if I understand it correctly, it only greps projectname without single quotes.

If there are projects project1 and project10, it would dump both project records from public.projects if you try to backup just project1.

The solution i use in the makefile is just quoting the string, so it searches for 'project1'. Maybe even better would be to look for VALUES ('project1', since the project name is always the first value in the insert statement. just quoting does not handle cases, when there's something like {"description": "this project is exactly like 'project1'. hooray"} in project10's attributes.

iLLiCiTiT commented 1 year ago

BTW: that part where the insert statement is searched for - if I understand it correctly, it only greps projectname without single quotes.

Fixed

rontown commented 1 year ago

Is this available in the web UI and does it still need to be rolled into the docker build?

martastain commented 1 year ago

These are just command line options. which don't affect backend or frontend in any way. We'll examine options to do this using the UI, but at this point, these script just dump project related data to a single SQL file (and restore this file back to the database).

On linux, you run make dump projectname=<yourprojectname> to create dump.<projectname>.sql file in the ayon-docker directory and then make restore projectname=<yourprojectname> takes the file and pushes it back (original project in the database will be overwritten.

On windows i suspect the syntax is slightly different ./manage.ps1 dump <yourprojectname> and ./manage.ps1 restore <youprojectname> respectively.