scrape-and-load

Scrape Wookieepedia data, convert to CDS format, and load into SQLite.

89|47|Updated Dec 1, 2020
One-click install
npx skills add https://github.com/SAP-samples/cloud-cap-hana-swapi --skill scrape-and-load
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: scrape-and-load
Source: https://github.com/SAP-samples/cloud-cap-hana-swapi/tree/main/.claude/skills/scrape-and-load
Command: npx skills add https://github.com/SAP-samples/cloud-cap-hana-swapi --skill scrape-and-load

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill orchestrates end-to-end data collection from Wookieepedia, converts the data into a CDS-ready format, and loads it into a local SQLite datastore for testing and migration validation.

Core Features & Use Cases

  • End-to-end data pipeline: Scrape data from Wookieepedia, transform it for CDS compatibility, and persist into SQLite for quick experimentation.
  • CDS artifact preparation: Build CDS artifacts from the scraped data to enable testing and migration scenarios.
  • Validation & testing: Run migration tests and a full test suite to ensure data integrity and compatibility with the target schema.

Quick Start

Run the full data pipeline from the cap directory to scrape, build, load, and validate migrations.

Frequently Asked Questions about scrape-and-load

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I scrape Wookieepedia data and load it into SQLite for testing?

You can scrape Wookieepedia data and load it into SQLite by running an end-to-end pipeline that extracts the data, converts it to a CDS-ready format, and persists it locally. The pipeline coordinates scraping, building CDS artifacts, and loading fixture data for testing.

What is a CDS-ready format for scraped data?

A CDS-ready format is a transformed data structure compatible with CAP's Core Data Services. The scraping pipeline converts raw Wookieepedia data into this format to enable building CDS artifacts, running migration tests, and validating schema compatibility in SQLite.

Can I use scraped Star Wars data for migration tests in SQLite?

Yes, scraped Star Wars data can be used for migration tests in SQLite. The pipeline loads fixture data from Wookieepedia into a local SQLite datastore and runs a full test suite to ensure data integrity and compatibility with the target schema.

How does the scraping pipeline handle failures and caching?

The scraping pipeline implements a cache-first strategy to avoid redundant requests and stops on failure to prevent cascading errors. It reports summary metrics for each step, including scraping, building CDS artifacts, loading fixtures, and running tests.

Do I need any external dependencies to run the Wookieepedia scraping pipeline?

No external dependencies are required to run the Wookieepedia scraping pipeline. The skill operates independently to scrape data, convert it to a CDS-ready format, and load it into SQLite for testing and migration validation.

What is the best way to validate scraped data against a target schema?

The best way to validate scraped data against a target schema is to run a pipeline that builds CDS artifacts from the data and executes migration tests. This ensures data integrity and compatibility by loading fixtures into SQLite and running a full test suite.