Open-source event management and ticket selling platform — perfect for concerts, conferences, and everything in between 🎟️ If you find this project helpful, please consider giving us a star ⭐️
PHP attendize-alternativedoor-managementevent-check-inevent-managementevent-registrationevent-ticketingeventbrite-alternativeeventslaravelopen-sourcephpreactself-hostedsell-ticketssell-tickets-onlineticket-sellingticketing-systemtickettailor-alternativetito-alternative
<?php
declare(strict_types=1);
namespace HiEvents\Services\Infrastructure\Lock;
use Illuminate\Database\DatabaseManager;
class TransactionLockService
{
public const EVENT_LOCK_KEYSPACE = 0x45564E;
public const ORDER_LOCK_KEYSPACE = 0x4F5244;
public const LINEUP_LOCK_KEYSPACE = 0x4C494E;
public const MAX_LOCK_KEY = 2147483647;
public function __construct(
private readonly DatabaseManager $databaseManager,
) {}
public function lockEvent(int $eventId): void
{
$this->databaseManager->statement(
'SELECT pg_advisory_xact_lock(?, ?)',
[self::EVENT_LOCK_KEYSPACE, $eventId % self::MAX_LOCK_KEY],
);
}
public function lockEventLineup(int $eventId): void
{
$this->databaseManager->statement(
'SELECT pg_advisory_xact_lock(?, ?)',
[self::LINEUP_LOCK_KEYSPACE, $eventId % self::MAX_LOCK_KEY],
);
}
public function lockOrder(string $orderShortId): void
{
$this->databaseManager->statement(
'SELECT pg_advisory_xact_lock(?, hashtext(?))',
[self::ORDER_LOCK_KEYSPACE, $orderShortId],
);
}
}