events.go

package goautowp

import (
	"github.com/doug-martin/goqu/v9"
)

type Event struct {
	UserID  int64
	Message string
	Users   []int64
}

type Events struct {
	db *goqu.Database
}

func NewEvents(db *goqu.Database) *Events {
	return &Events{
		db: db,
	}
}

func (s *Events) Add(event Event) error {
	res, err := s.db.Insert("log_events").Cols("description", "user_id", "add_datetime").
		Vals(goqu.Vals{event.Message, event.UserID, goqu.L("NOW()")}).Executor().Exec()
	if err != nil {
		return err
	}

	rowID, err := res.LastInsertId()
	if err != nil {
		return err
	}

	for _, id := range event.Users {
		_, err = s.db.Insert("log_events_user").Cols("log_event_id", "user_id").
			Vals(goqu.Vals{rowID, id}).Executor().Exec()

		if err != nil {
			return err
		}
	}

	return nil
}