// models.go
type Match struct {
	bun.BaseModel `bun:"table:match,alias:m"`

	Match_id      int       `json:"id" bun:",pk,autoincrement"`
	Creator       int       `json:"creator"`
}

type User struct {
	bun.BaseModel `bun:"table:user,alias:u"`

	User_id  int      `json:"id" bun:",pk,autoincrement"`
	Username string   `json:"username"`
	Matches  []*Match `json:"matches" bun:"rel:has-many,join:user_id=creator"`
}

// schema.resolvers.go
var user []*model.User
r.DB.NewSelect().Model(&user).Relation("Matches", func(q *bun.SelectQuery) *bun.SelectQuery {
     return q.Column("match_id", "creator")
}).Scan(ctx)

type Account struct {
	bun.BaseModel `bun:"table:account"`
	ID            int64         `bun:"id,pk,autoincrement"`
	Username      string        `bun:"username,notnull"`
	Email         string        `bun:"email,notnull"`
	Password      string        `bun:"password,notnull"`
	CreatedAt     time.Time     `bun:"created_at,nullzero,default:current_timestamp"`
	PayAccounts   []*PayAccount `bun:"rel:has-many,join:id=account_id"`
}

type PayAccount struct {
	bun.BaseModel `bun:"table:pay_account"`
	ID            int64     `bun:"id,pk,autoincrement"`
	Username      string    `bun:"username,notnull"`
	Email         string    `bun:"email,notnull"`
	Password      string    `bun:"password,notnull"`
	AccountId     int64     `bun:"account_id,notnull"`
	CreatedAt     time.Time `bun:"created_at,nullzero,default:current_timestamp"`
}

func main() {
	postgresURL := &url.URL{
		Scheme: "postgres",
		User:   url.UserPassword("service", "service-pass"),
		Host:   fmt.Sprintf("%s:%s", "localhost", "5433"),
		Path:   "service-db",
	}
	connString := postgresURL.String()

	config, err := pgx.ParseConfig(connString)
	if err != nil {
		log.Panic().Err(err).Msg("Failed to parse PostgreSQL config")
	}

	sqldb := stdlib.OpenDB(*config)

	err = sqldb.Ping()

	if err != nil {
		log.Panic().Err(err).Msg("Failed to ping PostgreSQL")
	}

	db := bun.NewDB(sqldb, pgdialect.New())

	var accounts []*Account

	q := db.NewSelect().Model(&accounts).Relation("PayAccounts")

	err = q.Scan(context.Background())
	fmt.Println(accounts)
}