Files
bank/collections/accounts.go
zeekay 77c69fb333 fix: bump Base v0.39.0 → v1.3.1 + pin explicit collection IDs
Base v0.39.0 had a startup panic in MigrationsRunner.initMigrationsTable
(nil pointer at base.go:808 → migrations_runner.go:256 because app.DB()
returned nil before serve.go could finish init). Fixed in Base v1.x.

In Base v1.3.1, RelationField.CollectionId validation now requires the
ACTUAL collection ID, not the name (field_relation.go:277-280):

  relCollection, _ := app.FindCachedCollectionByNameOrId(v)
  if relCollection == nil || relCollection.Id != v {
      return validation.NewError("...The relation collection doesn't exist.")
  }

Previous code passed "users" / "accounts" by name; Base looked them up
fine but rejected the field because the stored ID was a random
`hbc_xxxxxxxx` not the name. Two fixes:

- All RelationField{CollectionId: "users"} → "_users_auth_" (Base's
  canonical id for the system users auth collection).
- All NewBaseCollection(Name) → NewBaseCollection(Name, Name) so each
  bank collection gets a stable id matching its name. Sibling collections
  can then keep referencing CollectionId: AccountCollectionName etc.

Verified locally:
  $ bankd serve --http :8070 --dir /tmp/bank-data-test
  Server started at http://0.0.0.0:8070
  $ sqlite3 /tmp/bank-data-test/data.db "SELECT name FROM _collections WHERE NOT system"
  users / accounts / beneficiaries / transactions / fees / sessions /
  balances / audit_log / documents / wallets
2026-05-27 17:49:24 -07:00

109 lines
2.4 KiB
Go

package collections
import "github.com/hanzoai/base/core"
const AccountCollectionName = "accounts"
// EnsureAccountCollection creates the accounts collection if it does not exist.
// Schema mirrors the NestJS bank: owner (auth user), account holder info,
// CurrencyCloud account ID, status, and KYC state.
func EnsureAccountCollection(app core.App) error {
_, err := app.FindCollectionByNameOrId(AccountCollectionName)
if err == nil {
return nil
}
c := core.NewBaseCollection(AccountCollectionName, AccountCollectionName)
// API rules: list/view scoped to owner; create/update/delete superuser only (nil).
ownerRule := `owner = @request.auth.id`
c.ListRule = &ownerRule
c.ViewRule = &ownerRule
c.Fields.Add(
// Owner — relation to the "users" auth collection.
&core.RelationField{
Name: "owner",
CollectionId: "_users_auth_",
Required: true,
MaxSelect: 1,
},
// CurrencyCloud external account id.
&core.TextField{
Name: "ccAccountId",
},
// Legal entity name or individual full name.
&core.TextField{
Name: "entityName",
Required: true,
},
// Entity type: individual | business.
&core.SelectField{
Name: "entityType",
Values: []string{"individual", "business"},
Required: true,
MaxSelect: 1,
},
// ISO-3166 country code.
&core.TextField{
Name: "country",
Required: true,
Min: 2,
Max: 2,
},
// ISO 4217 base currency.
&core.TextField{
Name: "currency",
Required: true,
Min: 3,
Max: 3,
},
// Account status.
&core.SelectField{
Name: "status",
Values: []string{"pending", "active", "suspended", "closed"},
Required: true,
MaxSelect: 1,
},
// KYC / compliance approval state.
&core.SelectField{
Name: "kycStatus",
Values: []string{"not_started", "pending", "approved", "rejected"},
Required: true,
MaxSelect: 1,
},
// Risk rating assigned after compliance review.
&core.SelectField{
Name: "riskRating",
Values: []string{"low", "medium", "high"},
MaxSelect: 1,
},
// Free-form metadata blob (e.g. CurrencyCloud extra fields).
&core.JSONField{
Name: "metadata",
MaxSize: 1 << 20, // 1 MB
},
&core.AutodateField{
Name: "created",
OnCreate: true,
},
&core.AutodateField{
Name: "updated",
OnCreate: true,
OnUpdate: true,
},
)
return app.Save(c)
}