Oops! There seems to be a syntax error near "NOT" in TypeORM

Question

Oops! There seems to be a syntax error near "NOT" in TypeORM

I am currently developing an app using NestJs with a Postgres database and TypeOrm as the ORM. I have created my migration file, configured the package.json file, but when I try to run yarn typeorm migration:run, I encounter the following error:

query failed: CREATE TABLE "users" ("id" NOT NULL, "name" varchar NOT NULL, "email" varchar NOT NULL, "password" varchar NOT NULL, "biography" varchar NOT NULL, "links" varchar NOT NULL, "posts" int NOT NULL, "created_at" date NOT NULL DEFAULT now(), CONSTRAINT "UQ_97672ac88f789774dd47f7c8be3" UNIQUE ("email"), CONSTRAINT "posts" FOREIGN KEY ("posts") REFERENCES "posts" ("id") ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT "PK_a3ffb1c0c8416b9fc6f907b7433" PRIMARY KEY ("id"))
error: error: syntax error at or near "NOT"
    (...)

The complete migration code is quite large, so here is the link for it: https://pastebin.com/Ww2d0F16

I have searched extensively for a solution to this error but couldn't find anything relevant. Can someone please assist me in resolving this issue?

typescript postgresql nestjs typeorm

Answer 1

Answer №1

type: 'id' does not exist in PostgreSQL!

https://i.sstatic.net/fpNxA.png

You can try this =>

export class post1617813884949 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.createTable(
      new Table({
        name: 'users',
        columns: [
          {
            name: 'id',
            type: 'number', // Use number if your primary key is a number, otherwise use varchar for UUID
            isPrimary: true,
            isGenerated: true,
            generationStrategy: 'increment',
          },
          {
            name: 'name',
            type: 'varchar',
          },
          {
            name: 'email',
            type: 'varchar',
            isUnique: true,
          },
          {
            name: 'password',
            type: 'varchar',
          },
          {
            name: 'biography',
            type: 'varchar',
          },
          {
            name: 'links',
            type: 'varchar',
          },
          {
            name: 'posts',
            type: 'int',
          },
          {
            name: 'created_at',
            type: 'date',
            default: 'now()',
          },
        ],
        foreignKeys: [
          {
            name: 'posts',
            columnNames: ['posts'],
            referencedTableName: 'posts',
            referencedColumnNames: ['id'],
            onUpdate: 'CASCADE',
            onDelete: 'CASCADE',
          },
        ],
      }),
    );
    ...other_table
}

Answer 2

type: 'id' does not exist in PostgreSQL!

https://i.sstatic.net/fpNxA.png

You can try this =>

export class post1617813884949 implements MigrationInterface {
  public async up(queryRunner: QueryRunner): Promise<void> {
    await queryRunner.createTable(
      new Table({
        name: 'users',
        columns: [
          {
            name: 'id',
            type: 'number', // Use number if your primary key is a number, otherwise use varchar for UUID
            isPrimary: true,
            isGenerated: true,
            generationStrategy: 'increment',
          },
          {
            name: 'name',
            type: 'varchar',
          },
          {
            name: 'email',
            type: 'varchar',
            isUnique: true,
          },
          {
            name: 'password',
            type: 'varchar',
          },
          {
            name: 'biography',
            type: 'varchar',
          },
          {
            name: 'links',
            type: 'varchar',
          },
          {
            name: 'posts',
            type: 'int',
          },
          {
            name: 'created_at',
            type: 'date',
            default: 'now()',
          },
        ],
        foreignKeys: [
          {
            name: 'posts',
            columnNames: ['posts'],
            referencedTableName: 'posts',
            referencedColumnNames: ['id'],
            onUpdate: 'CASCADE',
            onDelete: 'CASCADE',
          },
        ],
      }),
    );
    ...other_table
}

Oops! There seems to be a syntax error near "NOT" in TypeORM

Answer №1

Similar questions

What is the process for specifying a data type for a pre-existing npm package module?

Troubleshooting issue with absolute paths in Vite project using React and TypeScript

What could be the culprit behind the database connection timeouts on our production environment with the Prisma ORM, PgBouncer, and Supabase stack?

Utilizing TypeScript with Express.js req.params: A Comprehensive Guide

Keep an eye out for any instances of new files being created in nodemon js or npm

The attribute 'modify, adjust, define' is not found in the 'Observable<{}>' type

Utilizing the dialogue feature within Angular 6

Exploring methods to successfully upload a blob to Firebase and modify it using cloud functions

Angular Dynamic CSS Library by BPNM

Tips and tricks for accessing the state tree within effects in @ngrx/effects 2.x

Prevent Promise / Property not found error in Angular2 by Instantiating Class

Intellisense in VS Code is failing to work properly in a TypeScript project built with Next.js and using Jest and Cypress. However, despite this issue,

The application within the Main Module is not being acknowledged by the other components within the module

Using TypeScript to automatically determine the argument type of a function by analyzing the return type of a different function

Issue: Angular is indicating that the 'feedbackFormDirective' member is implicitly assigned with type 'any'

Issue: Unable to link with 'dataSource' as it is not a recognized feature of 'mat-tree'

Tips for correctly decorating constructors in TypeScript

Choosing from a list in Angular

The property 1 cannot be added because the object is not extendable in React

Encountering the error "TypeError: Unable to access property 'controls' of undefined" when utilizing formArray in Reactive forms