/**
* @param TokenRange[] $ranges
*/
private function _insertMultipleRanges($ranges)
{
$db = TokenRange::conn();
$tableName = (new TokenRange())->getTableName();
$query = ParseQuery::parse($db, 'INSERT INTO %T (startToken, endToken, randomKey, createdAt, updatedAt) VALUES ', $tableName);
$data = [];
foreach ($ranges as $range) {
$nowStr = DateTimeHelper::formattedDateFromAnything(time());
$data[] = ParseQuery::parse($db, "(%s, %s, %d, %s, %s)", $range->startToken, $range->endToken, $range->randomKey, $nowStr, $nowStr);
}
$query .= implode(", ", $data);
Log::debug($query);
$db->query($query);
}