I am using CTE to check database rows, delete rows by filtering and finally to insert row into the database. Below is the go function to Insert a row: func (vm VoteModel) Insert(vote *Vote) error { ctx, cancel := context.WithTimeout(context.Background(),…
I have a little project in Go basically with a connection. Dockerfile FROM golang:1.22.3 AS build-stage WORKDIR /app COPY go.mod go.sum ./ RUN go mod download COPY . . RUN CGO_ENABLED=0 GOOS=linux go build -o /go-start ./cmd/server/main.go FROM scratch WORKDIR…
I have a code which does unit testing, where I prepare a database for the tests (I do not use sql-go-mock), so I want to insert returning id with a simple sql INSERT INTO, but for some reason pgx errors…
Got [error] failed to initialize database, got error dial tcp 192.168.16.2:3306: connect: connection refused when run docker compose up -d docker-compose.yml version: "3" services: app: container_name: app build: context: . dockerfile: api.Dockerfile restart: always ports: - 8071:8080 environment: - GIN_MODE=$GIN_MODE…
I need to parse json into a struct in golang and the final value is a float64 But it seems that some inputs encode it as a string and some encode it as a float64 This is across a lot…
I'm just starting my journey with Go and wonder why I have warnings about Go source code in the IDE. Is there an easy way to disable these? Why is VScode even reporting them? I'm using the default Go extension…
Using Go lang with Linux (ubuntu). A service (running as deamon, can be found with systemctl but not ps for example) runs a command (see code) that runs an executable (not sure if worth mentioning but - they are actually…
I am trying to run docker compose up -d --build an exisiting successfully built project (by docker-compose build), namely DeathStarBench which is a system for running multiple microservices to interact with each other (can be found in this Github repository).…
I am trying to connect to mongodb from go. My func for getting me the collection func dbConnection() *mongo.Collection { serverAPI := options.ServerAPI(options.ServerAPIVersion1) opts := options.Client().ApplyURI("mongodb+srv://username:pwd@domain").SetServerAPIOptions(serverAPI) client, err := mongo.Connect(context.TODO(), opts) if err != nil { panic(err) } defer func()…
users.sql -- name: CreateUser :one INSERT INTO "users" ("id", "created_at", "updated_at", "name") VALUES ($1, $2, $3, $4) RETURNING *; sqlc.yaml version: "2" sql: - engine: "postgresql" queries: "sql/queries" schema: "sql/schema" gen: go: # package: "internal" out: "internal/database" sql_package: "pgx/v5" 001_users.sql…