test_db.go

//go:build ignore

package main

import (
	"fmt"
	"log"
	"gorm.io/driver/postgres"
	"gorm.io/gorm"
	"time"
)

type Order struct {
	ID            uint
	OrderNumber   string
	PaymentStatus string
	TotalAmount   int
	PaidAmount    int
	PaymentMethod string
	CreatedAt     time.Time
}

func main() {
	dsn := "postgres://postgres.gmzonnwzocuhtjhywtdd:Imtoky0d3vjava@aws-1-ap-south-1.pooler.supabase.com:5432/postgres"
	db, err := gorm.Open(postgres.Open(dsn), &gorm.Config{})
	if err != nil {
		log.Fatal(err)
	}

	var orders []Order
	db.Order("id desc").Limit(5).Find(&orders)
	for _, o := range orders {
		fmt.Printf("ID: %d | Ref: %s | Status: %s | Total: %d | Paid: %d | Method: %s | Created: %v\n", o.ID, o.OrderNumber, o.PaymentStatus, o.TotalAmount, o.PaidAmount, o.PaymentMethod, o.CreatedAt)
	}
}