CYPEX add-ons are PostgreSQL extensions which contain ready-to-use fragments such as addresses, currency lists, models to store product data, unit conversion and a lot more. These extensions make our data models more consistent – and when you add them, the time it takes to produce an application significantly decreases. By integrating them, we support full version control as well as access to standard DevOps-related pipelines.
8.2 Create a repository application
First, create a directory for your new application. In this directory, you need an SQL file which contains the data model of your application. Keep in mind that the CYPEX role “authenticator” must have access to your tables, otherwise CYPEX has no permissions to manage the relations directly. The next thing you need is an “uninstall” script. When you deploy an application, you also have to figure out how to get rid of the application after it has fulfilled its purpose. The important part is that running the install and the uninstall script one after the other should leave you with an empty database.
Ideally you should split the model and the sample data into separate files. This is usually more convenient, since it’s easier to remove the test data later or to manage your repository in general.
Once this is done you can create a file called description.json. It will contain a lot of metadata CYPEX will need to manage your application nicely. The easiest way is to copy our sample files, and take it from there.
Finally, you can add your application to Git and easily deploy it using the graphical user interface provided by CYPEX.