albertcito / nodejs-web-typescript Goto Github PK

• Create migration
• Create seed

Use middleware

• user_token_id
• user_id
• name
• revoked
• expires_at
• last_ip
• last_used_at

• API and GraphQL should send the same error format in Validation, Message and Authorization.

• Add tables role, and user_role
• Add mutation CRUD role

rename it as user_token

• Add column user_id as FK
• Update Entity

• Mutation to add or remove user_role from a user

• File src/graphql/public/user/userUpdate.ts rename to userBasicUpdate. Change class name and query name.
• Create UserBasicUpdate.ts class in folder logic/user
• Copy from src/graphql/public/user/userUpdate.ts rename it as userBasicUpdate the class and the function.

class UserBasicUpdate {
  constructor(user: User) {
  }
  // Use decorator to validate this function
  save( firstName:string, lastName: string) {
  }
}

Use this class in src/graphql/public/user/userBasicUpdate.ts mutation
For decorator example here: src/util/db/paginate.ts
branch name: feature/37-user-update-class

Table

Run yarn typeorm migration:create -n Token. Documentation here: Type ORM
// src/db/migrations

• token_id
• token: string
• type: string
• used_at: timestamp
• expired_at: timestamp
• created_by: integre
• updated_by: integre
• created_at: timestamp
• updated_at: timestamp

Entity

// src/db/entities/Token.ts

• token_id -> tokenID
• token
• type
• used_at -> usedAt
• expired_at -> expiredAt

git checkout -b feature/2-token

Table translation

• translation_id: PK
• code: varchar

Table text

• text_id: FK
• translation_id: FK
• lang_id: FK
• text: varchar

See this file /src/db/migrations/1601770752669-OauthAccessToken.ts as example to create FK.

• Add middleware for mutations or queries can be used only for super_user

I tried to do it configuring globalSetup with a function to call Express server and save it in global variable. It prints this error:

SyntaxError: Cannot use import statement outside a module

It's a Jest issue that will be solved https://stackoverflow.com/questions/60372790/node-v13-jest-es6-native-support-for-modules-without-babel-or-esm/61653104#61653104

When it's ready, I'll try again to use the global variable in different files.

1. mutation profileBasicUpdate(firstName, lastName)
2. Auth:data().user.userID to get the session user ID (util/session/Auth)
3. Call function UserBasicUpdate class to update the profile

branch: feature/38-update-profile