typeCastMysql.ts

export const listMeetings = (
  groupId: GroupDTO['id'],
  callback: QueryCallback
) =>
  connection.query(
    {
      sql: /* sql */ `
      SELECT
        id, meeting_name, group_id, date
      FROM
        meetings
      WHERE
        group_id = ?
      ORDER BY date DESC
    `,
      typeCast: (field, orig) => {
        return field.type === 'DATE' ? new Date(field.string()) : orig();
      },
      values: [groupId],
    },
    callback
  );