DEV Community: Oussama Heloulou

When using browser API, shoud I write one code or one for Chrome and one for Firefox?

Oussama Heloulou — Sat, 25 Feb 2023 07:10:40 +0000

When developing in the BEX mode and using browser API, Does Quasar take care to polyfill the code, or should I write it twice? e.g. Firefox uses browser.tabs and Chrome uses chrome.tabs.

Error: SQLITE_ERROR: no such function: YEAR

Oussama Heloulou — Tue, 06 Dec 2022 18:26:34 +0000

Dec 6 '22 Comments: 1 Answers: 0

I have an SQLite database with a table named BoxActivity. I need to query this DB to fetch records of a specific month of a year to make a report I've written the query:

BoxActivity.findAll({
    attributes: [
      [sequelize.fn('SUM', sequelize.col('boxActivity.quantity')), 'total_qty']
    ],
    where: {
      quantity: {
        [Op.lt]: 0
      },
      [Op.and]: [

…

Open Full Question

Get the sum of quantities grouped by an Id that is not in the current table

Oussama Heloulou — Sat, 03 Dec 2022 09:28:16 +0000

Dec 3 '22 Comments: 1 Answers: 0

I have three models that look something like this:

const Reagent = sequelize.define('reagent', {
    name: {
      type: DataTypes.STRING
      allowNull: false,
    },
    ...
  })
  const Box = sequelize.define('box', {
    code: {
      type: DataTypes.STRING,
      allowNull: false,
      unique: true,
    },
    quantity: {
      type: DataTypes.INTEGER,
      allowNull: false,
    },
    ...
  })

  const BoxActivity = sequelize.define('boxActivity',

…

Open Full Question