waiverRejector.js

const keys = require('./private/api-keys.json')
const admin = require("firebase-admin");
const fetch = require('node-fetch');
const fs = require('fs')
const moment = require('moment')
const endPoint = 'https://api.sendgrid.com/v3/contactdb/recipients'
let requestBody = []
let emails = []

admin.initializeApp({
  credential: admin.credential.cert(keys.firebase),
  databaseURL: "https://hyphen-hacks-2019.firebaseio.com"
});

function Person(input) {
  this.email = input.email
  this.name = input.name
  this.referrer = 'hyphen-hacks_2019'
  this.years_involved = '2019'
  this.waiver_completed = 'false'
  if (input.ticket_class_name === 'High school Student') {
    this.role = 'attendee'
  } else {
    this.role = 'mentor'
  }
}

const db = admin.firestore();
const peopleRef = db.collection('people');
const queryRef = peopleRef.where('waiverStatus', '<', 2);
let counter = 0;
peopleRef.get().then(data => {
  data.forEach(snap => {
    const person = snap.data()
    if (person.waiverStatus === 2) {
      counter ++
      peopleRef.doc(person.id).update({waiverStatus: 0})
    }

  })
})
console.log('updated', counter)