googleapis / googleapis/go-gorm-spanner

Feature Request: AutoMigrate supports placement of geo-partitioning

Open
#121 0 comments 0 reactions 0 assignees View on GitHub
priority: p3 type: feature request
Dominant language
Go
Stars
43
Forks
9
Avg merge
11h 6m
Merged PRs (30d)
2

Description

Now the AutoMigrate does not support the placement in `Create Table` SQL statement.

Please refer to the following SQL statement

```
CREATE TABLE Companies (
id INT64 NOT NULL,
create_at timestamp,
update_at timestamp,
name STRING(MAX) NOT NULL,
Location STRING(MAX) NOT NULL PLACEMENT KEY
) PRIMARY KEY(id)
```

Please add the support to placement key in the AutoMigrate tool.

Contributor guide

Open the contributing guide

Research direction

Start by locating the AutoMigrate implementation that generates CREATE TABLE SQL and trace how column definitions are rendered. Check how the placement key is represented in the provided statement, then add coverage for a table using PLACEMENT KEY and verify that AutoMigrate emits valid SQL supporting geo-partitioning.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, google-cloud
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.