go.temporal.io/server@v1.23.0/common/persistence/sql/sqlplugin/postgresql/driver/pgx.go (about)

     1  // The MIT License
     2  //
     3  // Copyright (c) 2020 Temporal Technologies Inc.  All rights reserved.
     4  //
     5  // Copyright (c) 2020 Uber Technologies, Inc.
     6  //
     7  // Permission is hereby granted, free of charge, to any person obtaining a copy
     8  // of this software and associated documentation files (the "Software"), to deal
     9  // in the Software without restriction, including without limitation the rights
    10  // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
    11  // copies of the Software, and to permit persons to whom the Software is
    12  // furnished to do so, subject to the following conditions:
    13  //
    14  // The above copyright notice and this permission notice shall be included in
    15  // all copies or substantial portions of the Software.
    16  //
    17  // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    18  // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    19  // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    20  // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    21  // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    22  // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
    23  // THE SOFTWARE.
    24  
    25  package driver
    26  
    27  import (
    28  	"github.com/jackc/pgx/v5/pgconn"
    29  	_ "github.com/jackc/pgx/v5/stdlib" // register pgx driver for sqlx
    30  	"github.com/jmoiron/sqlx"
    31  )
    32  
    33  type PGXDriver struct{}
    34  
    35  func (p *PGXDriver) CreateConnection(dsn string) (*sqlx.DB, error) {
    36  	return sqlx.Connect("pgx", dsn)
    37  }
    38  
    39  func (p *PGXDriver) IsDupEntryError(err error) bool {
    40  	pgxErr, ok := err.(*pgconn.PgError)
    41  	return ok && pgxErr.Code == dupEntryCode
    42  }
    43  
    44  func (p *PGXDriver) IsDupDatabaseError(err error) bool {
    45  	pqErr, ok := err.(*pgconn.PgError)
    46  	return ok && pqErr.Code == dupDatabaseCode
    47  }