Sqlite error near select syntax error

export enum UserType {
    Normal = "normal",
    Admin = "admin",
}

@Entity()
export class User {
    ....
    @Column({
        type: "simple-enum",
        enum: UserType,
    })
    ty: UserType;
}

PS F:bugtypeorm-sqlite-simple-enum-bug> npm run start

> sqlite-simple-enum@0.0.1 start F:bugtypeorm-sqlite-simple-enum-bug
> ts-node src/index.ts

Inserting a new user into the database...
Saved a new user with id: 1
Loading users from the database...
Loaded users:  [ User {
    id: 1,
    firstName: 'Timber',
    lastName: 'Saw',
    age: 25,
    ty: 'admin' } ]
Here you can setup and run express/koa/any other framework.

PS F:bugtypeorm-sqlite-simple-enum-bug> npm run start

> sqlite-simple-enum@0.0.1 start F:bugtypeorm-sqlite-simple-enum-bug
> ts-node src/index.ts

{ QueryFailedError: SQLITE_ERROR: near "-": syntax error
    at new QueryFailedError (F:bugtypeorm-sqlite-simple-enum-bugsrcerrorQueryFailedError.ts:9:9)
    at handler (F:bugtypeorm-sqlite-simple-enum-bugsrcdriversqliteSqliteQueryRunner.ts:53:26)
    at replacement (F:bugtypeorm-sqlite-simple-enum-bugnode_modulessqlite3libtrace.js:19:31)
    at Statement.errBack (F:bugtypeorm-sqlite-simple-enum-bugnode_modulessqlite3libsqlite3.js:16:21)
  message: 'SQLITE_ERROR: near "-": syntax error',
  errno: 1,
  code: 'SQLITE_ERROR',
  name: 'QueryFailedError',
  query:
   'CREATE TABLE "temporary_user" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "firstName" varchar NOT NULL, "lastName" varchar NOT NULL, "age" integer NOT NULL, "ty" simple-enum CHECK( ty IN ('normal','admin') ) NOT NULL)',
  parameters: [] }

Pages 1

You must login or register to post a reply

Pages 1

You must login or register to post a reply

Popularity
9/10 Helpfulness
2/10
Language
sql

Popularity
10/10 Helpfulness
2/10
Language
sql

Popularity
9/10 Helpfulness
1/10
Language
sql

Popularity
9/10 Helpfulness
1/10
Language
sql