將 Spanner 與 GORM (GoogleSQL 方言) 整合

GORM 是 Go 程式設計語言的物件關聯對應工具。這個架構可將物件導向網域模型對應至關聯式資料庫。

您可以使用開放原始碼的 Spanner Dialect (SpannerDialect),將 GoogleSQL 方言資料庫與 GORM 整合。

使用 Spanner GoogleSQL 方言資料庫設定 GORM

如要在應用程式中使用 GoogleSQL GORM 方言,請在初始化 GORM 的檔案中新增下列匯入陳述式:

  import (
    "fmt"

    "gorm.io/gorm"
    _ "github.com/googleapis/go-sql-spanner"
    spannergorm "github.com/googleapis/go-gorm-spanner"
  )

  dsn := fmt.Sprintf("projects/%s/instances/%s/databases/%s", projectId, instanceId, databaseId),
  db, err := gorm.Open(spannergorm.New(spannergorm.Config{DriverName: "spanner", DSN: dsn}), &gorm.Config{})
  ```

See the

[GORM with GoogleSQL documentation][go-driver-documentation]

for more connection options for Spanner.

## Use GORM with Spanner GoogleSQL-dialect databases

For more information about the features and recommendations for using
GORM with Spanner, consult the [reference documentation][spanner-gorm-github]
on GitHub.

## What's next {: #whats-next}

*   Checkout the [sample application][gorm-gsql-sample-application] using
    GORM with GoogleSQL and Spanner.
*   Learn more about [GORM][gorm].
*   [File a GitHub issue][spanner-gorm-issue] to report a bug or ask a question
    about using GORM with Spanner with GoogleSQL.
*   Learn more about [Integrate Spanner with GORM (
    PostgreSQL dialect)](/spanner/docs/use-gorm-postgresql).