{{#isESM}}
import cds from '@sap/cds'

export class AdminService extends cds.ApplicationService { init() {
{{/isESM}}
{{^isESM}}
const cds = require('@sap/cds')

module.exports = class AdminService extends cds.ApplicationService { init() {
{{/isESM}}

  const { Books } = this.entities

  /**
   * Generate IDs for new Books drafts
   */
  this.before ('NEW', Books.drafts, async (req) => {
    if (req.data.ID) return
    const { ID:id1 } = await SELECT.one.from(Books).columns('max(ID) as ID')
    const { ID:id2 } = await SELECT.one.from(Books.drafts).columns('max(ID) as ID')
    req.data.ID = Math.max(id1||0, id2||0) + 1
  })
  return super.init()
}}