Changeset View
Changeset View
Standalone View
Standalone View
swh/storage/cassandra/storage.py
| Show All 9 Lines | |||||
| from typing import Any, Dict, List, Iterable, Optional, Union | from typing import Any, Dict, List, Iterable, Optional, Union | ||||
| import uuid | import uuid | ||||
| import attr | import attr | ||||
| import dateutil | import dateutil | ||||
| from swh.model.model import ( | from swh.model.model import ( | ||||
| Revision, Release, Directory, DirectoryEntry, Content, | Revision, Release, Directory, DirectoryEntry, Content, | ||||
| SkippedContent, OriginVisit, Snapshot, Origin | SkippedContent, OriginVisit, OriginVisitUpdate, Snapshot, Origin | ||||
| ) | ) | ||||
| from swh.model.hashutil import DEFAULT_ALGORITHMS | from swh.model.hashutil import DEFAULT_ALGORITHMS | ||||
| from swh.storage.objstorage import ObjStorage | from swh.storage.objstorage import ObjStorage | ||||
| from swh.storage.writer import JournalWriter | from swh.storage.writer import JournalWriter | ||||
| from ..exc import StorageArgumentException, HashCollision | from ..exc import StorageArgumentException, HashCollision | ||||
| from .common import TOKEN_BEGIN, TOKEN_END | from .common import TOKEN_BEGIN, TOKEN_END | ||||
| from .converters import ( | from .converters import ( | ||||
| revision_to_db, revision_from_db, release_to_db, release_from_db, | revision_to_db, revision_from_db, release_to_db, release_from_db, | ||||
| ) | ) | ||||
| from .cql import CqlRunner | from .cql import CqlRunner | ||||
| from .schema import HASH_ALGORITHMS | from .schema import HASH_ALGORITHMS | ||||
| from ..validate import convert_validation_exceptions | |||||
| # Max block size of contents to return | # Max block size of contents to return | ||||
| BULK_BLOCK_CONTENT_LEN_MAX = 10000 | BULK_BLOCK_CONTENT_LEN_MAX = 10000 | ||||
| def now(): | def now(): | ||||
| return datetime.datetime.now(tz=datetime.timezone.utc) | return datetime.datetime.now(tz=datetime.timezone.utc) | ||||
| ▲ Show 20 Lines • Show All 527 Lines • ▼ Show 20 Lines | class CassandraStorage: | ||||
| def snapshot_missing(self, snapshots): | def snapshot_missing(self, snapshots): | ||||
| return self._cql_runner.snapshot_missing(snapshots) | return self._cql_runner.snapshot_missing(snapshots) | ||||
| def snapshot_get(self, snapshot_id): | def snapshot_get(self, snapshot_id): | ||||
| return self.snapshot_get_branches(snapshot_id) | return self.snapshot_get_branches(snapshot_id) | ||||
| def snapshot_get_by_origin_visit(self, origin, visit): | def snapshot_get_by_origin_visit(self, origin, visit): | ||||
| try: | try: | ||||
| visit = self._cql_runner.origin_visit_get_one(origin, visit) | visit = self.origin_visit_get_by(origin, visit) | ||||
| except IndexError: | except IndexError: | ||||
| return None | return None | ||||
| return self.snapshot_get(visit.snapshot) | return self.snapshot_get(visit['snapshot']) | ||||
| def snapshot_get_latest(self, origin, allowed_statuses=None): | def snapshot_get_latest(self, origin, allowed_statuses=None): | ||||
| visit = self.origin_visit_get_latest( | visit = self.origin_visit_get_latest( | ||||
| origin, | origin, | ||||
| allowed_statuses=allowed_statuses, | allowed_statuses=allowed_statuses, | ||||
| require_snapshot=True) | require_snapshot=True) | ||||
| if visit: | if visit: | ||||
| ▲ Show 20 Lines • Show All 216 Lines • ▼ Show 20 Lines | def origin_visit_add(self, origin_url: str, | ||||
| raise StorageArgumentException( | raise StorageArgumentException( | ||||
| 'Date must be a datetime or a string') | 'Date must be a datetime or a string') | ||||
| if not self.origin_get_one({'url': origin_url}): | if not self.origin_get_one({'url': origin_url}): | ||||
| raise StorageArgumentException( | raise StorageArgumentException( | ||||
| 'Unknown origin %s', origin_url) | 'Unknown origin %s', origin_url) | ||||
| visit_id = self._cql_runner.origin_generate_unique_visit_id(origin_url) | visit_id = self._cql_runner.origin_generate_unique_visit_id(origin_url) | ||||
| visit_status = 'ongoing' | |||||
| try: | try: | ||||
| visit = OriginVisit.from_dict({ | visit = OriginVisit.from_dict({ | ||||
| 'origin': origin_url, | 'origin': origin_url, | ||||
| 'date': date, | 'date': date, | ||||
| 'type': type, | 'type': type, | ||||
| 'status': 'ongoing', | 'status': visit_status, | ||||
| 'snapshot': None, | 'snapshot': None, | ||||
| 'metadata': None, | 'metadata': None, | ||||
| 'visit': visit_id | 'visit': visit_id | ||||
| }) | }) | ||||
| except (KeyError, TypeError, ValueError) as e: | except (KeyError, TypeError, ValueError) as e: | ||||
| raise StorageArgumentException(*e.args) | raise StorageArgumentException(*e.args) | ||||
| self.journal_writer.origin_visit_add(visit) | self.journal_writer.origin_visit_add(visit) | ||||
| self._cql_runner.origin_visit_add_one(visit) | self._cql_runner.origin_visit_add_one(visit) | ||||
| with convert_validation_exceptions(): | |||||
| visit_update = OriginVisitUpdate( | |||||
| origin=origin_url, | |||||
| visit=visit_id, | |||||
| date=date, | |||||
| status=visit_status, | |||||
| snapshot=None, | |||||
| metadata=None, | |||||
| ) | |||||
| self._origin_visit_update_add(visit_update) | |||||
| return visit | return visit | ||||
| def _origin_visit_update_add( | |||||
| self, origin_visit_update: OriginVisitUpdate) -> None: | |||||
| """Add an origin visit update""" | |||||
| # Inject origin visit update in the schema | |||||
| self._cql_runner.origin_visit_update_add_one( | |||||
| origin_visit_update) | |||||
| def origin_visit_update( | def origin_visit_update( | ||||
| self, origin: str, visit_id: int, status: str, | self, origin: str, visit_id: int, status: str, | ||||
| metadata: Optional[Dict] = None, snapshot: Optional[bytes] = None): | metadata: Optional[Dict] = None, snapshot: Optional[bytes] = None, | ||||
| date: Optional[datetime.datetime] = None): | |||||
| origin_url = origin # TODO: rename the argument | origin_url = origin # TODO: rename the argument | ||||
| # Get the existing data of the visit | # Get the existing data of the visit | ||||
| row = self._cql_runner.origin_visit_get_one(origin_url, visit_id) | visit_ = self.origin_visit_get_by(origin_url, visit_id) | ||||
| if not row: | if not visit_: | ||||
| raise StorageArgumentException('This origin visit does not exist.') | raise StorageArgumentException('This origin visit does not exist.') | ||||
| try: | with convert_validation_exceptions(): | ||||
| visit = OriginVisit.from_dict(self._format_origin_visit_row(row)) | visit = OriginVisit.from_dict(visit_) | ||||
| except (KeyError, TypeError, ValueError) as e: | |||||
| raise StorageArgumentException(*e.args) | |||||
| updates: Dict[str, Any] = { | updates: Dict[str, Any] = { | ||||
| 'status': status | 'status': status | ||||
| } | } | ||||
| if metadata: | if metadata and metadata != visit.metadata: | ||||
| updates['metadata'] = metadata | updates['metadata'] = metadata | ||||
| if snapshot: | if snapshot and snapshot != visit.snapshot: | ||||
| updates['snapshot'] = snapshot | updates['snapshot'] = snapshot | ||||
| try: | with convert_validation_exceptions(): | ||||
| visit = attr.evolve(visit, **updates) | visit = attr.evolve(visit, **updates) | ||||
| except (KeyError, TypeError, ValueError) as e: | |||||
| raise StorageArgumentException(*e.args) | |||||
| self.journal_writer.origin_visit_update(visit) | self.journal_writer.origin_visit_update(visit) | ||||
| self._cql_runner.origin_visit_update(origin_url, visit_id, updates) | last_visit_update = self._origin_visit_get_updated( | ||||
| visit.origin, visit.visit) | |||||
| assert last_visit_update is not None | |||||
| with convert_validation_exceptions(): | |||||
| visit_update = OriginVisitUpdate( | |||||
| origin=origin_url, | |||||
| visit=visit_id, | |||||
| date=date or now(), | |||||
| status=status, | |||||
| snapshot=snapshot or last_visit_update['snapshot'], | |||||
| metadata=metadata or last_visit_update['metadata'], | |||||
| ) | |||||
| self._origin_visit_update_add(visit_update) | |||||
| def _origin_visit_merge( | |||||
| self, visit: Dict[str, Any], | |||||
| visit_update: Dict[str, Any]) -> Dict[str, Any]: | |||||
| """Merge origin_visit and origin_visit_update together. | |||||
| """ | |||||
| return OriginVisit.from_dict({ | |||||
| # default to the values in visit | |||||
| **visit, | |||||
| # override with the last update | |||||
| **visit_update, | |||||
| # visit['origin'] is the URL (via a join), while | |||||
| # visit_update['origin'] is only an id. | |||||
| 'origin': visit['origin'], | |||||
| # but keep the date of the creation of the origin visit | |||||
| 'date': visit['date'] | |||||
| }).to_dict() | |||||
| def _origin_visit_apply_update( | |||||
| self, visit: Dict[str, Any]) -> Dict[str, Any]: | |||||
| """Retrieve the latest visit update information for the origin visit. | |||||
| Then merge it with the visit and return it. | |||||
| """ | |||||
| visit_update = self._cql_runner.origin_visit_update_get_latest( | |||||
| visit['origin'], visit['visit']) | |||||
| assert visit_update is not None | |||||
| return self._origin_visit_merge(visit, visit_update) | |||||
| def _origin_visit_get_updated( | |||||
| self, origin: str, visit_id: int) -> Optional[Dict[str, Any]]: | |||||
| """Retrieve origin visit and latest origin visit update and merge them | |||||
| into an origin visit. | |||||
| """ | |||||
| row_visit = self._cql_runner.origin_visit_get_one(origin, visit_id) | |||||
| if row_visit is None: | |||||
| return None | |||||
| visit = self._format_origin_visit_row(row_visit) | |||||
| return self._origin_visit_apply_update(visit) | |||||
| def origin_visit_upsert(self, visits: Iterable[OriginVisit]) -> None: | def origin_visit_upsert(self, visits: Iterable[OriginVisit]) -> None: | ||||
| for visit in visits: | |||||
| if visit.visit is None: | |||||
| raise StorageArgumentException( | |||||
| f'Missing visit id for visit {visit}') | |||||
| self.journal_writer.origin_visit_upsert(visits) | self.journal_writer.origin_visit_upsert(visits) | ||||
| for visit in visits: | for visit in visits: | ||||
| assert visit.visit is not None | |||||
| self._cql_runner.origin_visit_upsert(visit) | self._cql_runner.origin_visit_upsert(visit) | ||||
| with convert_validation_exceptions(): | |||||
| visit_update = OriginVisitUpdate( | |||||
| origin=visit.origin, | |||||
| visit=visit.visit, | |||||
| date=now(), | |||||
| status=visit.status, | |||||
| snapshot=visit.snapshot, | |||||
| metadata=visit.metadata, | |||||
| ) | |||||
| self._origin_visit_update_add(visit_update) | |||||
| @staticmethod | @staticmethod | ||||
| def _format_origin_visit_row(visit): | def _format_origin_visit_row(visit): | ||||
| return { | return { | ||||
| **visit._asdict(), | **visit._asdict(), | ||||
| 'origin': visit.origin, | 'origin': visit.origin, | ||||
| 'date': visit.date.replace(tzinfo=datetime.timezone.utc), | 'date': visit.date.replace(tzinfo=datetime.timezone.utc), | ||||
| 'metadata': (json.loads(visit.metadata) | 'metadata': (json.loads(visit.metadata) | ||||
| if visit.metadata else None), | if visit.metadata else None), | ||||
| } | } | ||||
| def origin_visit_get(self, origin, last_visit=None, limit=None): | def origin_visit_get( | ||||
| self, origin: str, last_visit: Optional[int] = None, | |||||
| limit: Optional[int] = None) -> Iterable[Dict[str, Any]]: | |||||
| rows = self._cql_runner.origin_visit_get(origin, last_visit, limit) | rows = self._cql_runner.origin_visit_get(origin, last_visit, limit) | ||||
| for row in rows: | |||||
| visit = self._format_origin_visit_row(row) | |||||
| yield self._origin_visit_apply_update(visit) | |||||
| yield from map(self._format_origin_visit_row, rows) | def origin_visit_find_by_date( | ||||
| self, origin: str, | |||||
| def origin_visit_find_by_date(self, origin, visit_date): | visit_date: datetime.datetime) -> Optional[Dict[str, Any]]: | ||||
| # Iterator over all the visits of the origin | # Iterator over all the visits of the origin | ||||
| # This should be ok for now, as there aren't too many visits | # This should be ok for now, as there aren't too many visits | ||||
| # per origin. | # per origin. | ||||
| visits = list(self._cql_runner.origin_visit_get_all(origin)) | rows = list(self._cql_runner.origin_visit_get_all(origin)) | ||||
| def key(visit): | def key(visit): | ||||
| dt = visit.date.replace(tzinfo=datetime.timezone.utc) - visit_date | dt = visit.date.replace(tzinfo=datetime.timezone.utc) - visit_date | ||||
| return (abs(dt), -visit.visit) | return (abs(dt), -visit.visit) | ||||
| if visits: | if rows: | ||||
| visit = min(visits, key=key) | row = min(rows, key=key) | ||||
| return visit._asdict() | visit = self._format_origin_visit_row(row) | ||||
| return self._origin_visit_apply_update(visit) | |||||
| return None | |||||
| def origin_visit_get_by(self, origin, visit): | def origin_visit_get_by( | ||||
| visit = self._cql_runner.origin_visit_get_one(origin, visit) | self, origin: str, visit: int) -> Optional[Dict[str, Any]]: | ||||
| if visit: | row = self._cql_runner.origin_visit_get_one(origin, visit) | ||||
| return self._format_origin_visit_row(visit) | if row: | ||||
| visit_ = self._format_origin_visit_row(row) | |||||
| return self._origin_visit_apply_update(visit_) | |||||
| return None | |||||
| def origin_visit_get_latest( | def origin_visit_get_latest( | ||||
| self, origin, allowed_statuses=None, require_snapshot=False): | self, origin: str, allowed_statuses: Optional[List[str]] = None, | ||||
| visit = self._cql_runner.origin_visit_get_latest( | require_snapshot: bool = False) -> Optional[Dict[str, Any]]: | ||||
| origin, | # TODO: Do not fetch all visits | ||||
| allowed_statuses=allowed_statuses, | rows = self._cql_runner.origin_visit_get_all(origin) | ||||
| require_snapshot=require_snapshot) | latest_visit = None | ||||
| if visit: | for row in rows: | ||||
| return self._format_origin_visit_row(visit) | visit = self._format_origin_visit_row(row) | ||||
| updated_visit = self._origin_visit_apply_update(visit) | |||||
| if allowed_statuses and \ | |||||
| updated_visit['status'] not in allowed_statuses: | |||||
| continue | |||||
| if require_snapshot and updated_visit['snapshot'] is None: | |||||
| continue | |||||
| # updated_visit is a candidate | |||||
| if latest_visit is not None: | |||||
| if updated_visit['date'] < latest_visit['date']: | |||||
| continue | |||||
| if updated_visit['visit'] < latest_visit['visit']: | |||||
| continue | |||||
| latest_visit = updated_visit | |||||
| return latest_visit | |||||
| def origin_visit_get_random(self, type: str) -> Optional[Dict[str, Any]]: | def origin_visit_get_random(self, type: str) -> Optional[Dict[str, Any]]: | ||||
| back_in_the_day = now() - datetime.timedelta(weeks=12) # 3 months back | back_in_the_day = now() - datetime.timedelta(weeks=12) # 3 months back | ||||
| # Random position to start iteration at | # Random position to start iteration at | ||||
| start_token = random.randint(TOKEN_BEGIN, TOKEN_END) | start_token = random.randint(TOKEN_BEGIN, TOKEN_END) | ||||
| # Iterator over all visits, ordered by token(origins) then visit_id | # Iterator over all visits, ordered by token(origins) then visit_id | ||||
| rows = self._cql_runner.origin_visit_iter(start_token) | rows = self._cql_runner.origin_visit_iter(start_token) | ||||
| for row in rows: | for row in rows: | ||||
| visit = self._format_origin_visit_row(row) | visit = self._format_origin_visit_row(row) | ||||
| if visit['date'] > back_in_the_day \ | visit_update = self._origin_visit_apply_update(visit) | ||||
| and visit['status'] == 'full': | if visit_update['date'] > back_in_the_day \ | ||||
| return visit | and visit_update['status'] == 'full': | ||||
| return visit_update | |||||
| else: | else: | ||||
| return None | return None | ||||
| def tool_add(self, tools): | def tool_add(self, tools): | ||||
| inserted = [] | inserted = [] | ||||
| for tool in tools: | for tool in tools: | ||||
| tool = tool.copy() | tool = tool.copy() | ||||
| tool_json = tool.copy() | tool_json = tool.copy() | ||||
| ▲ Show 20 Lines • Show All 55 Lines • Show Last 20 Lines | |||||