-import * as Sequelize from 'sequelize'
-
-import { logger } from '../../helpers'
-
-import { addMethodsToModel } from '../utils'
-import { OAuthTokenAttributes, OAuthTokenInfo, OAuthTokenInstance, OAuthTokenMethods } from './oauth-token-interface'
+import {
+ AfterDestroy,
+ AfterUpdate,
+ AllowNull,
+ BelongsTo,
+ Column,
+ CreatedAt,
+ ForeignKey,
+ Model,
+ Scopes,
+ Table,
+ UpdatedAt
+} from 'sequelize-typescript'
+import { logger } from '../../helpers/logger'
+import { UserModel } from '../account/user'
+import { OAuthClientModel } from './oauth-client'
+import { Transaction } from 'sequelize'
+import { AccountModel } from '../account/account'
+import { ActorModel } from '../activitypub/actor'
+import { clearCacheByToken } from '../../lib/oauth-model'
+
+export type OAuthTokenInfo = {
+ refreshToken: string
+ refreshTokenExpiresAt: Date,
+ client: {
+ id: number
+ },
+ user: {
+ id: number
+ }
+}
-let OAuthToken: Sequelize.Model<OAuthTokenInstance, OAuthTokenAttributes>
-let getByRefreshTokenAndPopulateClient: OAuthTokenMethods.GetByRefreshTokenAndPopulateClient
-let getByTokenAndPopulateUser: OAuthTokenMethods.GetByTokenAndPopulateUser
-let getByRefreshTokenAndPopulateUser: OAuthTokenMethods.GetByRefreshTokenAndPopulateUser
+enum ScopeNames {
+ WITH_USER = 'WITH_USER'
+}
-export default function (sequelize: Sequelize.Sequelize, DataTypes: Sequelize.DataTypes) {
- OAuthToken = sequelize.define<OAuthTokenInstance, OAuthTokenAttributes>('OAuthToken',
- {
- accessToken: {
- type: DataTypes.STRING,
- allowNull: false
- },
- accessTokenExpiresAt: {
- type: DataTypes.DATE,
- allowNull: false
- },
- refreshToken: {
- type: DataTypes.STRING,
- allowNull: false
- },
- refreshTokenExpiresAt: {
- type: DataTypes.DATE,
- allowNull: false
+@Scopes({
+ [ScopeNames.WITH_USER]: {
+ include: [
+ {
+ model: () => UserModel.unscoped(),
+ required: true,
+ include: [
+ {
+ attributes: [ 'id' ],
+ model: () => AccountModel.unscoped(),
+ required: true,
+ include: [
+ {
+ attributes: [ 'id', 'url' ],
+ model: () => ActorModel.unscoped(),
+ required: true
+ }
+ ]
+ }
+ ]
}
+ ]
+ }
+})
+@Table({
+ tableName: 'oAuthToken',
+ indexes: [
+ {
+ fields: [ 'refreshToken' ],
+ unique: true
},
{
- indexes: [
- {
- fields: [ 'refreshToken' ],
- unique: true
- },
- {
- fields: [ 'accessToken' ],
- unique: true
- },
- {
- fields: [ 'userId' ]
- },
- {
- fields: [ 'oAuthClientId' ]
- }
- ]
+ fields: [ 'accessToken' ],
+ unique: true
+ },
+ {
+ fields: [ 'userId' ]
+ },
+ {
+ fields: [ 'oAuthClientId' ]
}
- )
+ ]
+})
+export class OAuthTokenModel extends Model<OAuthTokenModel> {
- const classMethods = [
- associate,
+ @AllowNull(false)
+ @Column
+ accessToken: string
- getByRefreshTokenAndPopulateClient,
- getByTokenAndPopulateUser,
- getByRefreshTokenAndPopulateUser
- ]
- addMethodsToModel(OAuthToken, classMethods)
+ @AllowNull(false)
+ @Column
+ accessTokenExpiresAt: Date
- return OAuthToken
-}
+ @AllowNull(false)
+ @Column
+ refreshToken: string
+
+ @AllowNull(false)
+ @Column
+ refreshTokenExpiresAt: Date
-// ---------------------------------------------------------------------------
+ @CreatedAt
+ createdAt: Date
-function associate (models) {
- OAuthToken.belongsTo(models.User, {
+ @UpdatedAt
+ updatedAt: Date
+
+ @ForeignKey(() => UserModel)
+ @Column
+ userId: number
+
+ @BelongsTo(() => UserModel, {
foreignKey: {
- name: 'userId',
allowNull: false
},
onDelete: 'cascade'
})
+ User: UserModel
- OAuthToken.belongsTo(models.OAuthClient, {
+ @ForeignKey(() => OAuthClientModel)
+ @Column
+ oAuthClientId: number
+
+ @BelongsTo(() => OAuthClientModel, {
foreignKey: {
- name: 'oAuthClientId',
allowNull: false
},
onDelete: 'cascade'
})
-}
+ OAuthClients: OAuthClientModel[]
-getByRefreshTokenAndPopulateClient = function (refreshToken: string) {
- const query = {
- where: {
- refreshToken: refreshToken
- },
- include: [ OAuthToken['sequelize'].models.OAuthClient ]
+ @AfterUpdate
+ @AfterDestroy
+ static removeTokenCache (token: OAuthTokenModel) {
+ return clearCacheByToken(token.accessToken)
}
- return OAuthToken.findOne(query)
- .then(token => {
- if (!token) return null
-
- const tokenInfos: OAuthTokenInfo = {
- refreshToken: token.refreshToken,
- refreshTokenExpiresAt: token.refreshTokenExpiresAt,
- client: {
- id: token.oAuthClientId
- },
- user: {
- id: token.userId
- }
- }
-
- return tokenInfos
- })
- .catch(err => {
- logger.info('getRefreshToken error.', err)
- throw err
- })
-}
+ static getByRefreshTokenAndPopulateClient (refreshToken: string) {
+ const query = {
+ where: {
+ refreshToken: refreshToken
+ },
+ include: [ OAuthClientModel ]
+ }
-getByTokenAndPopulateUser = function (bearerToken: string) {
- const query = {
- where: {
- accessToken: bearerToken
- },
- include: [
- {
- model: OAuthToken['sequelize'].models.User,
- include: [
- {
- model: OAuthToken['sequelize'].models.Account,
- required: true
+ return OAuthTokenModel.findOne(query)
+ .then(token => {
+ if (!token) return null
+
+ return {
+ refreshToken: token.refreshToken,
+ refreshTokenExpiresAt: token.refreshTokenExpiresAt,
+ client: {
+ id: token.oAuthClientId
+ },
+ user: {
+ id: token.userId
}
- ]
- }
- ]
+ } as OAuthTokenInfo
+ })
+ .catch(err => {
+ logger.error('getRefreshToken error.', { err })
+ throw err
+ })
}
- return OAuthToken.findOne(query).then(token => {
- if (token) token['user'] = token.User
+ static getByTokenAndPopulateUser (bearerToken: string) {
+ const query = {
+ where: {
+ accessToken: bearerToken
+ }
+ }
- return token
- })
-}
+ return OAuthTokenModel.scope(ScopeNames.WITH_USER).findOne(query).then(token => {
+ if (token) token['user'] = token.User
-getByRefreshTokenAndPopulateUser = function (refreshToken: string) {
- const query = {
- where: {
- refreshToken: refreshToken
- },
- include: [
- {
- model: OAuthToken['sequelize'].models.User,
- include: [
- {
- model: OAuthToken['sequelize'].models.Account,
- required: true
- }
- ]
+ return token
+ })
+ }
+
+ static getByRefreshTokenAndPopulateUser (refreshToken: string) {
+ const query = {
+ where: {
+ refreshToken: refreshToken
}
- ]
+ }
+
+ return OAuthTokenModel.scope(ScopeNames.WITH_USER)
+ .findOne(query)
+ .then(token => {
+ if (token) {
+ token['user'] = token.User
+ return token
+ } else {
+ return new OAuthTokenModel()
+ }
+ })
}
- return OAuthToken.findOne(query).then(token => {
- token['user'] = token.User
+ static deleteUserToken (userId: number, t?: Transaction) {
+ const query = {
+ where: {
+ userId
+ },
+ transaction: t
+ }
- return token
- })
+ return OAuthTokenModel.destroy(query)
+ }
}