about | code

This material presents a router i wrote. It is used in routing
SQL queries for a blog app. Below router sends get request for certain
userid address. User is then searched by primarykey.
Blogs (object) written by the user are in the response also.

router.get('/:id', async (req, res) => {
  let where = {}

  if (req.query.read) {
    where.read = req.query.read === 'true'
  }

  const user = await User.findByPk(req.params.id, {
    attributes: ['name', 'username'],
    include: [
      {
        model: Blog,
        as: 'readings',
        attributes: { exclude: ['createdAt', 'updatedAt', 'userId'] },
        through: {
          attributes: ['id', 'read'],
          where,
        },
      },
    ],
  })
  if (user) {
    res.send(user)
  } else {
    res.status(404).send({ error: 'user blog not found' })
  }
})

User class (model) has id, username and name fields. Below is
postgreql version of modeling user class. Postgreql has some
cababilities to validate emails etc.

class User extends Model {}

User.init(
  {
    id: {
      type: DataTypes.INTEGER,
      primaryKey: true,
      autoIncrement: true,
    },
    username: {
      type: DataTypes.STRING,
      unique: true,
      allowNull: false,
      validate: {
        isEmail: {
          args: true,
          msg: 'username must be an email',
        },
      },
    },
    name: {
      type: DataTypes.STRING,
      allowNull: false,
    },
    disabled: {
      type: DataTypes.BOOLEAN,
      defaultValue: false,
    },
  },
  {
    sequelize,
    underscored: true,
    timestamps: true,
    modelName: 'user',
  }
)

home