class NodeStorage

class NodeStorage extends SqlContentEntityStorage implements NodeStorageInterface {
    
    /**
     * {@inheritdoc}
     */
    public function revisionIds(NodeInterface $node) {
        return $this->database
            ->query('SELECT [vid] FROM {' . $this->getRevisionTable() . '} WHERE [nid] = :nid ORDER BY [vid]', [
            ':nid' => $node->id(),
        ])
            ->fetchCol();
    }
    
    /**
     * {@inheritdoc}
     */
    public function userRevisionIds(AccountInterface $account) {
        return $this->database
            ->query('SELECT [vid] FROM {' . $this->getRevisionDataTable() . '} WHERE [uid] = :uid ORDER BY [vid]', [
            ':uid' => $account->id(),
        ])
            ->fetchCol();
    }
    
    /**
     * {@inheritdoc}
     */
    public function countDefaultLanguageRevisions(NodeInterface $node) {
        return $this->database
            ->query('SELECT COUNT(*) FROM {' . $this->getRevisionDataTable() . '} WHERE [nid] = :nid AND [default_langcode] = 1', [
            ':nid' => $node->id(),
        ])
            ->fetchField();
    }
    
    /**
     * {@inheritdoc}
     */
    public function updateType($old_type, $new_type) {
        return $this->database
            ->update($this->getBaseTable())
            ->fields([
            'type' => $new_type,
        ])
            ->condition('type', $old_type)
            ->execute();
    }
    
    /**
     * {@inheritdoc}
     */
    public function clearRevisionsLanguage(LanguageInterface $language) {
        return $this->database
            ->update($this->getRevisionTable())
            ->fields([
            'langcode' => LanguageInterface::LANGCODE_NOT_SPECIFIED,
        ])
            ->condition('langcode', $language->getId())
            ->execute();
    }

}