package main import ( "context" "errors" "fmt" "net/url" "strconv" "time" "github.com/jackc/pgx/v5" "github.com/jackc/pgx/v5/pgxpool" ) type BitrixEvent struct { eventId int eventType string taskId int eventTimestamp time.Time } func (e *BitrixEvent) GetTaskId() int { return e.taskId } func (e *BitrixEvent) GetEventId() int { return e.eventId } func (e *BitrixEvent) GetEventType() string { return e.eventType } func CreateFromEventDB(ctx context.Context, pool *pgxpool.Pool) (*BitrixEvent, error) { const query = ` SELECT id, event_type, event_timestamp, request_body FROM event_queue WHERE status = 'pending' ORDER BY event_timestamp LIMIT 1; ` var event BitrixEvent var eventDataURLEncoded string err := pool.QueryRow(ctx, query).Scan(&event.eventId, &event.eventType, &event.eventTimestamp, &eventDataURLEncoded) if err != nil { if errors.Is(err, pgx.ErrNoRows) { return nil, nil } return nil, fmt.Errorf("error during event pull from db: %w", err) } eventDataDecoded, err := url.ParseQuery(eventDataURLEncoded) if err != nil { return nil, fmt.Errorf("request body is malformed: %w", err) } event.taskId, err = strconv.Atoi(eventDataDecoded.Get("data[FIELDS_AFTER][ID]")) if err != nil { return nil, fmt.Errorf("task id is malformed or not found: %w", err) } return &event, nil }