File size: 801 Bytes
ae76db4 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | //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)
}
}
|