Create a post request with following structure
{
"name": "ali",
"age": "23"
}
And send it to this endpoint
0.0.0.0:8080/person/
This will create a new row in postgres database
go to awsomeProject
directory and run the following command
go test -v -cover ./...
First run your postgres, personally used docker version with username:root, and password:secret
docker run --name postgres1 -p 5433:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=secret -d postgres:12-alpine
Here I have port 5433
open to postgres!
Now create a db in it.
docker exec -it postgres1 createdb --username=root --owner=root people
First install migration using this link and then run following command
migrate create -ext sql -dir db/migration -seq init_schema
This command will create two files one for migration up, and the other for migration down. Write your tables here.
Then migrate up using following command
migrate -path db/migration -database "postgresql://root:secret@localhost:5433/people?sslmode=disable" -verbose up
Write your queries in db/query
First install sqlc using this link
Then write following command sqlc init
to create an empty sqlc.yaml file beside project. Config this file with following configuration and then run this command.
sqlc generate
This will automatically generate golang code to connect to Postgres.