HierarchyTable::insertBatch

static function insertBatch(array $data)
{
	$values = [];

	foreach ($data as $row)
	{
		if((int)$row['ANCESTOR_ID'] <= 0 || (int)$row['DESCENDANT_ID'] <= 0)
		{
			continue;
		}

		$values[] = (int)$row['ANCESTOR_ID'].', '.(int)$row['DESCENDANT_ID'].', '.(int)$row['LEVEL'];
	}

	if(!empty($values))
	{
		$values = '(' . implode('), (', $values) . ')';
		$sql = "INSERT IGNORE INTO " . static::getTableName() . " (ANCESTOR_ID, DESCENDANT_ID, LEVEL) VALUES " . $values;
		Application::getConnection()->queryExecute($sql);
	}
}