Hello everyone,
I'm currently working on integrating version control and CI/CD into our Oracle DB and Oracle APEX development lifecycle. I've been using SQLcl to export workspace files in source code format, but I also need them in a readable format like YAML, similar to what the APEX export command does for applications.
With the introduction of the new SQLcl project command, I was hoping it would manage this, but I found that workspace files are not included. I'm looking for advice on the best approach to manage these files within the SQLcl project command. Specifically:
- Is there a way to include workspace files in the SQLcl project command?
- Should I use the
project stage add-custom part to manage these files? If so, how can I ensure they are correctly added and updated?
- While I'm aware of the
apex export -workspaceid xxx -expfiles option, it doesn't cover exporting in a readable format. Is there any option to get these files in a readable format for CI/CD purposes? If so, where should I store them in the project folder since they are not naturally managed by SQLcl? Additionally, I do not plan to install the readable format, similar to how the SQLcl project command does not install readable files, just the source files.
My ultimate goal is to automate this process using scripts to achieve CI/CD, so using the Oracle APEX web browser IDE to download the files as a zip is not a viable solution.
Any guidance or examples would be greatly appreciated!
Thank you, and kudos to this amazing SQLcl project command!
PS: Oracle SQLDeveloper Command-Line (SQLcl) version: 24.3.2.0 build: 24.3.2.330.1718