Skip to content

Sync-in · Sovereign platform for file storage, sharing, synchronization, and collaboration.

2.8 KB
Raw Blame
import { faker } from '@faker-js/faker'
import type { ResultSetHeader } from 'mysql2/promise'
import { USER_PERMISSION, USER_ROLE } from '../../../../applications/users/constants/user.js'
import type { Group } from '../../../../applications/users/schemas/group.interface.js'
import { groups } from '../../../../applications/users/schemas/groups.schema.js'
import type { User } from '../../../../applications/users/schemas/user.interface.js'
import { usersGroups } from '../../../../applications/users/schemas/users-groups.schema.js'
import { users } from '../../../../applications/users/schemas/users.schema.js'
import { hashPassword } from '../../../../common/functions.js'
import { getDB } from '../db.js'

const alreadyUsed = ['sync-in', '[email protected]']

export const usersAndGroups = async () => {
  const newUsers: Partial<User>[] = [
    {
      login: 'sync-in',
      email: '[email protected]',
      firstName: 'Sync-in',
      lastName: 'Admin',
      role: USER_ROLE.ADMINISTRATOR,
      password: await hashPassword('password'),
      permissions: Object.values(USER_PERMISSION).join(',')
    }
  ]
  const newGroups: Partial<Group>[] = []

  for (let i = 0; i < 10; i++) {
    let login = faker.person.firstName()
    let email = faker.internet.email()
    while (alreadyUsed.includes(login) || alreadyUsed.includes(email)) {
      login = faker.person.firstName()
      email = faker.internet.email()
    }
    alreadyUsed.push(login, email)
    newUsers.push({
      login: login,
      email: email,
      firstName: faker.person.firstName(),
      lastName: faker.person.lastName(),
      password: await hashPassword('password'),
      permissions: faker.helpers.arrayElements(Object.values(USER_PERMISSION)).join(',')
    })
  }

  for (let i = 0; i < 5; i++) {
    let name = faker.commerce.department()
    while (alreadyUsed.includes(name)) {
      name = faker.commerce.department()
    }
    alreadyUsed.push(name)
    newGroups.push({
      name: name,
      description: faker.company.buzzPhrase(),
      type: 0
    })
  }

  const db = await getDB()

  try {
    console.log('Seed start')
    const usersInfo: ResultSetHeader = (await db.insert(users).values(newUsers as any))[0]
    console.log('users: ', usersInfo.info)
    const groupsInfo: ResultSetHeader = (await db.insert(groups).values(newGroups as any))[0]
    console.log('groups: ', groupsInfo.info)

    const usersId = (await db.select({ id: users.id }).from(users)).map((r) => r.id)
    const groupsId = (await db.select({ id: groups.id }).from(groups)).map((r) => r.id)
    const newUsersGroups = usersId.map((uid) => ({ userId: uid, groupId: groupsId[Math.floor(Math.random() * groupsId.length)] }))
    const usersGroupsInfo: ResultSetHeader = (await db.insert(usersGroups).values(newUsersGroups))[0]
    console.log('users & groups: ', usersGroupsInfo.info)
  } finally {
    await db.$client.end()
  }
}