My Go SQL

Go x DB simple project

Simple run with go command

To run the application with console based mode

go run myfirstgosql/main c

If you want to do database simple migration

go run myfirstgosql/main d

If you want to select a specific environment

go run myfirstgosql/main --env dev c

Please make sure you have dev.env file, if the file is not exist it will try to read operating system environment variable, and if the environment variable does not have the required info, then the app default value will be taken.

The default is try to read .env file, if you do not use --env option. If the .env file is not exist, the same behaviour like statement above.

In the production environment, usually we provide the config in operating system environment variables.

To view Some help

go run myfirstgosql/main --help

Docker build

docker build . -t my-go-sql

Docker images

Check the build result, you should have my-go-sql in the list

docker images 

Test run

docker run -it -e dbuser=root -e dbpassword=P@ssw0rd -e dbhost=host.docker.internal -e dbport=3306 -e dbschema=enigma -e dbengine=mysql --name mygosql --rm my-go-sql

or using docker compose (the environment variables information is provided in .env files)

docker-compose up --build
docker-compose down

You should get the result on console