person.go

// TITLE: user database repository layer
// Author: (Jacky: FafnirZ) (09/21)
// Refactor into database package: Varun

package repositories

import (
	"log"

	"github.com/google/uuid"
)

// Implements IPersonRepository
type personRepository struct {
	frontEndID uuid.UUID
	embeddedContext
}

func (rep personRepository) PersonExists(p Person) bool {
	var result int
	err := rep.ctx.Query("SELECT count(*) from person where email = $1 and frontendid = $2 and password = $3;", []interface{}{p.Email, rep.frontEndID, p.Password}, &result)
	if err != nil {
		log.Println("credentials match err", err.Error())
	}

	return result == 1
}

func (rep personRepository) GetPersonWithDetails(p Person) Person {
	var result Person
	err := rep.ctx.Query("SELECT * from person where email = $1 and frontendid = $2 and password = $3;", []interface{}{p.Email, rep.frontEndID, p.Password},
		&result.UID, &result.Email, &result.FirstName, &result.Password, &result.GroupID, &result.FrontEndID)
	if err != nil {
		log.Print("get permissions error", err.Error())
	}
	return result
}