import db from '@adonisjs/lucid/services/db'

export const CURRENCY: string = await db
  .rawQuery(`SELECT symbol FROM currencies WHERE is_active = TRUE LIMIT 1`)
  .then((result) => {
    return result[0][0]?.symbol || 'USD'
  })

export const TIME_ZONE: string = await db
  .rawQuery(`SELECT variable_value FROM variable_settings WHERE variable_name = 'time_zone'`)
  .then((result) => {
    return result[0][0]?.variable_value || 'Asia/Bahrain'
  })