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

     1  // The MIT License
     2  //
     3  // Copyright (c) 2021 Datadog, Inc.
     4  //
     5  // Copyright (c) 2020 Temporal Technologies Inc.  All rights reserved.
     6  //
     7  // Copyright (c) 2020 Uber Technologies, Inc.
     8  //
     9  // Permission is hereby granted, free of charge, to any person obtaining a copy
    10  // of this software and associated documentation files (the "Software"), to deal
    11  // in the Software without restriction, including without limitation the rights
    12  // to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
    13  // copies of the Software, and to permit persons to whom the Software is
    14  // furnished to do so, subject to the following conditions:
    15  //
    16  // The above copyright notice and this permission notice shall be included in
    17  // all copies or substantial portions of the Software.
    18  //
    19  // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    20  // IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    21  // FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    22  // AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    23  // LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    24  // OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
    25  // THE SOFTWARE.
    26  
    27  package sqlite
    28  
    29  import (
    30  	"errors"
    31  	"regexp"
    32  
    33  	"modernc.org/sqlite"
    34  	sqlite3 "modernc.org/sqlite/lib"
    35  )
    36  
    37  const (
    38  	goSqlDriverName       = "sqlite"
    39  	sqlConstraintCodes    = sqlite3.SQLITE_CONSTRAINT | sqlite3.SQLITE_CONSTRAINT_PRIMARYKEY | sqlite3.SQLITE_CONSTRAINT_UNIQUE
    40  	sqlTableExistsPattern = "SQL logic error: table .* already exists \\(1\\)"
    41  )
    42  
    43  var sqlTableExistsRegex = regexp.MustCompile(sqlTableExistsPattern)
    44  
    45  func (*db) IsDupEntryError(err error) bool {
    46  	var sqlErr *sqlite.Error
    47  	if errors.As(err, &sqlErr) {
    48  		return sqlErr.Code()&sqlConstraintCodes != 0
    49  	}
    50  
    51  	return false
    52  }
    53  
    54  func isTableExistsError(err error) bool {
    55  	var sqlErr *sqlite.Error
    56  	if errors.As(err, &sqlErr) {
    57  		return sqlTableExistsRegex.MatchString(sqlErr.Error())
    58  	}
    59  
    60  	return false
    61  }