test.js

import { Clasyquelize, ClasyModel, DataTypes } from '@nodutilus/clasyquelize'

const sequelize = new Clasyquelize('sqlite:database.sqlite')


class Entity extends ClasyModel {

  static id = this.attribute({ type: DataTypes.BIGINT, primaryKey: true, autoIncrement: true })
  static uuid = this.attribute({ type: DataTypes.STRING, allowNull: false })
    .index({ unique: true })

  static async findByUUID(uuid, options = {}) {
    const entity = await this.findOne(Object.assign(options, { where: { uuid } }))

    return entity
  }

}


class User extends Entity {

  static username = DataTypes.STRING
  static iUsername = this.index({ fields: ['username'] })

}


class Company extends Entity {

  static companyname = DataTypes.STRING
  static iCompanyname = this.index({ fields: ['companyname'] })

}


class Book extends Entity {

  static title = DataTypes.STRING
  static author = User
  static chiefEditor = User
  static publisher = Company

}


(async () => {
  sequelize.attachModel(User, Company, Book)
  await sequelize.sync({ force: true })

  const user1 = await User.create({ uuid: 'uuid4_user_1', username: 'username' })
  const user2 = await User.create({ uuid: 'uuid4_user_2', username: 'username' })
  const compan = await Company.create({ uuid: 'uuid4_company_1', companyname: 'companyname' })
  const book1 = await Book.create({
    uuid: 'uuid4_book_1',
    title: 'title',
    author: user1.id,
    chiefEditor: user1.id,
    publisher: compan.id
  })
  const book2 = await Book.create({
    uuid: 'uuid4_book_2',
    title: 'title',
    author: user1.id,
    chiefEditor: user2.id,
    publisher: compan.id
  })
  const book1Read = await Book.findByUUID('uuid4_book_1', {
    include: [Book.author, Book.chiefEditor, Book.publisher]
  })
  const author1Read = await User.findByUUID('uuid4_user_1', {
    include: [User.as(Book.author), User.as(Book.chiefEditor)]
  })

  console.log('Book1.create:', book1.toJSON())
  console.log('Book2.create:', book2.toJSON())
  console.log('Book1.findByUUID:', book1Read.toJSON())
  console.log('User1.findByUUID:', author1Read.toJSON())

  await sequelize.close()
})()