$stmt = $this->db->prepare(
<<<SQL
INSERT INTO gamesticks
- (hwId, sessionId, verificationCode)
- VALUES (:hwId, :sessionId, :verificationCode)
+ (hwId, sessionId, verificationCode, created_at, updated_at)
+ VALUES (:hwId, :sessionId, :verificationCode, :created_at, :updated_at)
SQL
);
$stmt->execute(
':hwId' => $hwId,
':sessionId' => 's' . str_replace(':', '', $hwId),
':verificationCode' => date('His'),
+ ':created_at' => date('c'),
+ ':updated_at' => date('c'),
]
);
return $this->getProfileByHardwareId($hwId);
public function updateProfile(string $hwId, array $values): ?Profile
{
$params = [
- 'hwId' => $hwId,
+ ':hwId' => $hwId,
+ ':updated_at' => date('c'),
];
$sql = 'UPDATE gamesticks SET';
- $sqlParts = [];
+ $sqlParts = [
+ ' updated_at = :updated_at'
+ ];
foreach ($values as $column => $value) {
$sqlParts[] = ' ' . $column . '= :' . $column;
$params[':' . $column] = $value;
minAge INTEGER DEFAULT 3 NOT NULL,
avatar TEXT DEFAULT NULL,
- created_at TEXT DEFAULT CURRENT_TIMESTAMP
+ created_at TEXT DEFAULT CURRENT_TIMESTAMP,
+ updated_at TEXT DEFAULT CURRENT_TIMESTAMP
)
SQL
);