Files
forge/models/db/driver_postgresschema.go
zeekayandHanzo Dev aa87442fdd Record upstream authorship centrally in NOTICE instead of in every file header
Source files keep their SPDX-License-Identifier and Hanzo copyright line; the
Gitea, Gogs and LFS Test Server copyrights they used to repeat now live once in
NOTICE, alongside LICENSE. The header lint accepts any copyright line above the
SPDX line, so it no longer demands an upstream one.

Co-authored-by: Hanzo Dev <[email protected]>
2026-09-10 17:50:35 -07:00

50 lines
1.3 KiB
Go

// Copyright 2026 Hanzo AI, Inc. All rights reserved.
// SPDX-License-Identifier: MIT
package db
import (
"context"
"database/sql"
"database/sql/driver"
"errors"
"sync"
"github.com/hanzoai/git/modules/setting"
"github.com/lib/pq"
"github.com/hanzoai/xorm/dialects"
)
type postgresSchemaDriver struct{}
var registerPostgresSchemaDriver = sync.OnceFunc(func() {
sql.Register(sqlDriverPostgresSchema, &postgresSchemaDriver{})
dialects.RegisterDriver(sqlDriverPostgresSchema, dialects.QueryDriver("postgres"))
})
// Open opens the postgres connection in the default manner with default schema support.
// It immediately runs "set_config" to set the search_path appropriately.
func (*postgresSchemaDriver) Open(connStr string) (driver.Conn, error) {
conn, err := pq.Driver{}.Open(connStr)
if err != nil {
return nil, err
}
connExec, ok := conn.(driver.ExecerContext)
if !ok {
return nil, errors.New("postgres driver does not implement ExecerContext interface")
}
_, err = connExec.ExecContext(context.Background(), `SELECT set_config(
'search_path',
$1 || ',' || current_setting('search_path'),
false)`,
[]driver.NamedValue{{Ordinal: 1, Value: setting.Database.Schema}},
)
if err != nil {
_ = conn.Close()
return nil, err
}
return conn, nil
}