Ghost/ghost/tinybird/datasources/fixtures/README.md

# Datasource fixtures

## NDJSON files
These files are fixtures used for running tests

## Schema JSON files
The file mockingbird-schema.json is a schema for generating fake data using the Mockingbird CLI.

The CLI is installed via npm:

```
npm install -g @tinybirdco/mockingbird-cli
```

The command I'm currently using to generate the data is:

```
mockingbird-cli tinybird --schema ghost/tinybird/datasources/fixtures/mockingbird-schema.json --endpoint gcp_europe_west3 --token xxxx --datasource analytics_events --eps 50 --limit 5000
```
Added full suite of tinybird datasources and pipes (#20882) ref https://linear.app/tryghost/issue/ANAL-27/setup-tinybird-project-and-cicd ref https://github.com/tinybirdco/web-analytics-starter-kit/blob/main/tinybird/pipes/analytics_sessions.pipe - These datasources and pipes work together to define the main endpoints we need for our stats dashboard - They are based on the web analytics starter kit from tinybird - We've updated them to handle site_uuid - There's more to do to pipe the member-related and post-related data through the system yet 2024-08-30 00:03:31 +03:00			`# Datasource fixtures`

Added a set of tests for our tinybird setup - TODO: make these run in CI - Right now you run them by running `yarn tb` and then `./script/branch_and_test.sh` - These are snapshot tests that check we get the desired result Co-authored-by: alejandromav <hi@alejandromav.com> 2024-09-25 18:53:05 +03:00			`## NDJSON files`
			`These files are fixtures used for running tests`

			`## Schema JSON files`
Added full suite of tinybird datasources and pipes (#20882) ref https://linear.app/tryghost/issue/ANAL-27/setup-tinybird-project-and-cicd ref https://github.com/tinybirdco/web-analytics-starter-kit/blob/main/tinybird/pipes/analytics_sessions.pipe - These datasources and pipes work together to define the main endpoints we need for our stats dashboard - They are based on the web analytics starter kit from tinybird - We've updated them to handle site_uuid - There's more to do to pipe the member-related and post-related data through the system yet 2024-08-30 00:03:31 +03:00			`The file mockingbird-schema.json is a schema for generating fake data using the Mockingbird CLI.`

			`The CLI is installed via npm:`

			```
Added audience handling to stats closes https://linear.app/tryghost/issue/ANAL-23/filtering-by-logged-out-logged-in-traffic - Updated all of our tinybird datasources and pipes to handle member status - Added member_status as an array query param to the API endpoints - Added a really dodgy power select multiple to the stats page to demonstrate it works (needs styling) - Added all of the wiring so each chart updates - This was done pretty fast, and may not be 100% right yet 2024-09-02 14:24:50 +03:00			`npm install -g @tinybirdco/mockingbird-cli`
Added full suite of tinybird datasources and pipes (#20882) ref https://linear.app/tryghost/issue/ANAL-27/setup-tinybird-project-and-cicd ref https://github.com/tinybirdco/web-analytics-starter-kit/blob/main/tinybird/pipes/analytics_sessions.pipe - These datasources and pipes work together to define the main endpoints we need for our stats dashboard - They are based on the web analytics starter kit from tinybird - We've updated them to handle site_uuid - There's more to do to pipe the member-related and post-related data through the system yet 2024-08-30 00:03:31 +03:00			```

			`The command I'm currently using to generate the data is:`

			```
			`mockingbird-cli tinybird --schema ghost/tinybird/datasources/fixtures/mockingbird-schema.json --endpoint gcp_europe_west3 --token xxxx --datasource analytics_events --eps 50 --limit 5000`
			```