• Index
• Search by APIs
• Search by Words
• Project Search

• Java
• Python
• JavaScript
• TypeScript
• C++
• Scala
• Blog

• expresso-master
  • .github
    • dependabot.yml
  • .eslintignore
  • src
    • database
      • seeds
        • 20210920102200-UserSeeder.js
        • 20210920013424-RoleSeeder.js
      • models
        • user.ts
        • upload.ts
        • index.ts
        • _instance.ts
        • fcmtoken.ts
        • notification.ts
        • session.ts
        • role.ts
      • migrations
        • 20211206082952-create-notification.js
        • 20210918105918-create-user.js
        • 20211127093730-create-upload.js
        • 20211206084041-create-fcm-token.js
        • 20210918134704-create-session.js
        • 20210917093014-create-role.js
    • app.ts
    • server.ts
    • @expresso
      • providers
        • Email.ts
        • Redis.ts
      • utils
        • SequeliceMigration.js
        • ReaderMigrationSequelize.js
        • DocsSwagger.ts
        • SequelizeAttributes.ts
      • hooks
        • useMulter.ts
        • useValidation.ts
      • helpers
        • Token.ts
        • Excel.ts
        • withState.ts
        • userAgent.ts
        • File.ts
        • Fcm.ts
        • Routing.ts
        • Phone.ts
        • getterObject.ts
        • asyncHandler.ts
        • Formatter.ts
        • hashOTP.ts
        • SendMail.ts
        • Date.ts
        • Multer.ts
        • Currency.ts
      • constants
        • ConstRole.js
        • ConstAllowedOrigins.ts
      • scripts
        • generate.ts
      • interfaces
        • Files.ts
      • docs
        • swagger
          • schemas
            • .gitignore
          • routes
            • auth.js
            • notification.js
            • upload.js
            • role.js
            • user.js
        • repo
          • sequelize.md
          • intro.md
          • docker.md
          • multer.md
          • smtp.md
          • excel.md
      • modules
        • Errors
          • BaseResponse.ts
          • InternalServer.ts
          • NotFound.ts
          • BadRequest.ts
          • Unauthorized.ts
          • Forbidden.ts
        • Response
          • HttpResponse.ts
          • ResponseError.ts
        • SqlizeQuery
          • interface.ts
          • QueryHelper.ts
          • TransformHelper.ts
          • SqlizeQuery.ts
          • PluginSqlizeQuery.ts
    • config
      • firebase.ts
      • Logger.ts
      • baseURL.ts
      • clientRedis.ts
      • database.js
      • Fetcher.ts
      • i18nextConfig.ts
      • clientS3.ts
      • firestore.ts
      • env.ts
    • controllers
      • Upload
        • controller.ts
        • schema.ts
        • service.ts
      • Account
        • FCMToken
          • schema.ts
          • service.ts
        • Session
          • controller.ts
          • schema.ts
          • service.ts
        • User
          • controller.ts
          • schema.ts
          • service.ts
        • Role
          • controller.ts
          • schema.ts
          • service.ts
      • Notification
        • controller.ts
        • schema.ts
        • service.ts
      • Auth
        • interface.ts
        • controller.ts
        • service.ts
    • pathAlias.ts
    • types
      • express
        • index.d.ts
      • sequelize
        • index.d.ts
    • middlewares
      • Authorization.ts
      • PermissionAccess.ts
      • ExpressErrorSequelize.ts
      • ExpressErrorResponse.ts
      • ExpressErrorYup.ts
      • ExpressAutoHandleTransaction.ts
      • NotPermittedAccess.ts
      • ExpressRateLimit.ts
    • jobs
      • ExampleJob.ts
      • index.ts
      • UploadJob.ts
    • routes
      • index.ts
      • v1.ts
  • ecosystem.config.js
  • public
    • locales
      • en
        • translation.json
      • id
        • translation.json
    • images
    • templates
      • emails
        • register.html
    • .gitignore
  • .env.example
  • commitlint.config.js
  • .versionrc.json
  • .editorconfig
  • CHANGELOG.md
  • LICENSE.md
  • .sequelizerc
  • README.md
  • package.json
  • logs
    • .gitignore
  • Dockerfile
  • .eslintrc.js
  • tsconfig.json
  • .gitignore
  • dev.Dockerfile
  • .prettierrc.js
  • .dockerignore
  • .vscode
    • settings.json
  • docker-compose.yml

/* eslint-disable @typescript-eslint/no-floating-promises */
import { LOG_SERVER } from '@config/baseURL'
import { logErrServer } from '@expresso/helpers/Formatter'
import { NextFunction, Request, Response } from 'express'
import { Transaction } from 'sequelize'

async function ExpressAutoHandleTransaction(
  req: Request,
  res: Response,
  next: NextFunction
): Promise<void> {
  res.once('finish', () => {
    const { _transaction } = req
    for (let i = 1; i <= Object.keys(_transaction).length; i += 1) {
      const txn = _transaction[i] as Transaction & {
        finished?: string
      }

      if (!txn?.finished) {
        const endpoint = req.originalUrl

        const errType = 'Sequelize Error:'
        const message = `endpoint ${endpoint} potentianlly can lead to bug`

        console.log(logErrServer(errType, message))
        console.log(`${LOG_SERVER} AUTO COMMIT!!!`)

        txn.commit()
      }
    }
  })

  next()
}

export default ExpressAutoHandleTransaction