Skip to content

Add Prisma schema and initial migration #5

Description

@iexwr

Context

The service imports @prisma/client and references PaymentRequest, Cursor, and Webhook models, but there is no prisma/schema.prisma and no migration. npx prisma migrate dev currently fails.

Acceptance criteria

  • Add prisma/schema.prisma with:
    • PaymentRequest { id Int @id @default(autoincrement()), contract String, requestId Int, payee String, asset String, amount String, memo String, status String, createdAt Int, expiresAt Int, lastLedger Int }
    • Cursor { id String @id, ledger Int }
    • Webhook { id String @id @default(uuid()), url String, secret String, createdAt DateTime @default(now()) }
  • Provide an initial migration under prisma/migrations/.
  • npx prisma generate succeeds.

Technical notes

  • Store amounts as String (i128 in contract) to avoid numeric precision loss.
  • Use provider = "postgresql" with env("DATABASE_URL").

Testing

  • npx prisma validate passes; npx prisma migrate dev --name init applies cleanly on a fresh DB.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Stellar WaveStellar Wave for StackPaybugSomething isn't working

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions