33 lines
1.4 KiB
Markdown
33 lines
1.4 KiB
Markdown
|
# Building SQL DDL into Drone
|
||
|
|
|
||
|
|
These folders contain the code for the different of databases that drone can use. They contain the SQL necessary to create the necessary tables and migrate between versions (IE the DDL). This SQL is generated into a go file and included as part of the Drone binary.
|
||
|
|
|
||
|
|
## Making a changes to the database DDL
|
||
|
|
|
||
|
|
Any new changes to the database structure are always put into a new SQL file. Follow the naming scheme in the `store/shared/migrate/<db>/files` of the SQL files by incrementing the number file name and give it a good description of what changes are being made.
|
||
|
|
|
||
|
|
Changes will need to be implemented for all supported databases, making similar changes for eg Mysql/Postgres/Sqllite.
|
||
|
|
|
||
|
|
**NB** Any changes to the database structure will need to be reflected for the relevant `struct` in the `core` directory. Changing the objects in the `store` directory for the ORM. Finally Possibly in the repositories github.com/drone/drone-go and github.com/drone/runner-go.
|
||
|
|
|
||
|
|
## Generating Go from the SQL files
|
||
|
|
|
||
|
|
To generate the go files you will need to install the golang command line tool `Togo` so it is on your users PATH.
|
||
|
|
|
||
|
|
### Steps to install Togo
|
||
|
|
|
||
|
|
``` bash
|
||
|
|
# in your workspace
|
||
|
|
git clone git@github.com:bradrydzewski/togo.git
|
||
|
|
cd togo
|
||
|
|
go get github.com/bradrydzewski/togo
|
||
|
|
```
|
||
|
|
|
||
|
|
### Generating go DDL
|
||
|
|
|
||
|
|
Enter the desired database's implementation folder, and run the following. It will update the `ddl_gen.go` file.
|
||
|
|
|
||
|
|
``` bash
|
||
|
|
go generate
|
||
|
|
```
|