Skip to content

Shorten foreign key names #35

Description

@wqyeo

Title;

Key names are being truncated as they are too long. Might as well shorten it.

npm run migrate

> aphasia-backend-stack@1.0.0 migrate
> npx tsx migrate.ts

{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "word_retrieval_session_message_session_id_word_retrieval_session_id_fk" will be truncated to "word_retrieval_session_message_session_id_word_retrieval_sessio"',
  where: 'compilation of PL/pgSQL function "inline_code_block" near line 1',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "word_retrieval_session_message_session_id_word_retrieval_session_id_fk" will be truncated to "word_retrieval_session_message_session_id_word_retrieval_sessio"',
  position: '15',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}
{
  severity_local: 'NOTICE',
  severity: 'NOTICE',
  code: '42622',
  message: 'identifier "word_retrieval_session_message_session_id_word_retrieval_session_id_fk" will be truncated to "word_retrieval_session_message_session_id_word_retrieval_sessio"',
  where: 'SQL statement "ALTER TABLE "word_retrieval_session_message" ADD CONSTRAINT "word_retrieval_session_message_session_id_word_retrieval_session_id_fk" FOREIGN KEY ("session_id") REFERENCES "public"."word_retrieval_session"("id") ON DELETE cascade ON UPDATE no action"\n' +
    'PL/pgSQL function inline_code_block line 2 at SQL statement',
  file: 'scansup.c',
  line: '99',
  routine: 'truncate_identifier'
}

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    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