### Start All Services

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/cms-webportal-playground/README.md

Starts all Docker services for the CMS Web Portal Playground. The first run may take approximately 5 minutes to install dependencies and build assets.

```powershell
# Start all services
docker compose up -d

# First run takes ~5 minutes (installs WP, Composer deps, npm build)
# Check progress:
docker compose logs -f cms-webportal-playground-cli
docker compose logs -f sage-theme-builder
```

--------------------------------

### Keycloak Quick Start

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/CONFIGURE_AUTH.md

Steps to quickly set up and start Keycloak services using Docker Compose.

```bash
# 1. Create a keycloak/docker-compose.yml (see Section 1 below)
# 2. Start services
docker compose -f keycloak/docker-compose.yml up -d

# 3. Access Keycloak admin
# URL: http://localhost:8480
# Login: admin / admin
```

--------------------------------

### Start Supabase Services

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/CONFIGURE_AUTH.md

Navigate to the Supabase directory and start the services using Docker Compose.

```bash
cd db/supabase
docker compose up -d
```

--------------------------------

### Start Bundled ClickHouse

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/db/CONFIGURE_OLTP_2_OLAP_DATA_WAREHOUSE_SYNC.md

Starts the ClickHouse Docker container for prototyping purposes.

```bash
cd db
docker-compose up -d clickhouse
```

--------------------------------

### Install npm Dependencies (Main Process)

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/README.md

Navigate to the 'app' directory and install dependencies for the Electron main process.

```bash
cd app/
npm install
```

--------------------------------

### Start Sink Connector

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/db/CONFIGURE_OLTP_2_OLAP_DATA_WAREHOUSE_SYNC.md

Starts the Altinity Sink Connector service using Docker Compose.

```bash
cd db
docker-compose up -d clickhouse-sink-connector
```

--------------------------------

### Install and Develop DataPallas Theme

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/cms-webportal-playground/wp-themes/datapallas-theme/README.md

Steps to install the DataPallas theme locally and set up the development environment. This involves installing dependencies and running development servers.

```bash
npm install && npm run dev
```

--------------------------------

### Troubleshooting Keycloak Start

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/CONFIGURE_AUTH.md

Commands to diagnose issues when the Keycloak service fails to start.

```bash
docker-compose logs keycloak
lsof -i :8480
```

--------------------------------

### Start Development Server

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/README.md

Run the application in a local development environment with hot reload enabled.

```bash
npm start
```

--------------------------------

### Build from Source

Source: https://github.com/flowkraft/datapallas/blob/main/frend/rb-webcomponents/README.md

Install dependencies and build the web components from source using npm.

```bash
npm install
npm run build
# Copy dist/rb-webcomponents.umd.js to your project
```

--------------------------------

### Server Configuration: Tabulator DSL Example

Source: https://github.com/flowkraft/datapallas/blob/main/frend/rb-webcomponents/README.md

Configure the tabulator display using Groovy DSL. This example sets up pagination and defines columns with fields and formatters.

```groovy
tabulator {
    pagination true
    paginationSize 20
    columns {
        column(field: 'region', title: 'Region')
        column(field: 'sales', title: 'Sales', formatter: 'money')
    }
}
```

--------------------------------

### Clone Repository

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/README.md

Clone the project repository locally to begin setup.

```bash
git clone https://github.com/maximegris/angular-electron.git
```

--------------------------------

### Start Profiler

Source: https://github.com/flowkraft/datapallas/blob/main/bkend/reporting/src/main/external-resources/template/lib/perf/jip/doc/readme.html

Command to start the profiler remotely. This should be run before the test case.

```batch
Start.bat localhost 15599
```

--------------------------------

### Install WP Bones Blade Boilerplate

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/cms-webportal-playground/wp-plugins/datapallas-portal/README.md

Clone the repository, navigate to the plugin folder, and install dependencies using Composer.

```bash
git clone -b main https://github.com/wpbones/WPKirk-Blade-Boilerplate.git <your plugin folder>
cd <your plugin folder>
composer install
```

--------------------------------

### Server Configuration: Parameters DSL Example

Source: https://github.com/flowkraft/datapallas/blob/main/frend/rb-webcomponents/README.md

Define report parameters using Groovy DSL. This example shows how to configure 'startDate' and 'endDate' parameters with types, labels, default values, and validation rules.

```groovy
parameters {
    parameter(id: 'startDate', type: 'date') {
        label 'Start Date'
        defaultValue '2025-01-01'
        required true
    }
    parameter(id: 'endDate', type: 'date') {
        label 'End Date'
        required true
        min { ref: 'startDate' }
    }
}
```

--------------------------------

### Development: Install and Run Commands

Source: https://github.com/flowkraft/datapallas/blob/main/frend/rb-webcomponents/README.md

Standard npm commands for installing dependencies, running the development server with Hot Module Replacement (HMR), building for production, and performing TypeScript validation.

```bash
npm install     # Install dependencies
npm run dev     # Dev server with HMR
npm run build   # Production build
npm run check   # TypeScript validation
```

--------------------------------

### Server Configuration: Chart DSL Example

Source: https://github.com/flowkraft/datapallas/blob/main/frend/rb-webcomponents/README.md

Configure chart options using Groovy DSL. This example defines a bar chart with a label field and datasets, specifying colors.

```groovy
chart {
    type 'bar'
    labelField 'region'
    datasets {
        dataset(field: 'sales', label: 'Total Sales', color: '#3b82f6')
    }
}
```

--------------------------------

### Keycloak Client Setup

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/CONFIGURE_AUTH.md

Configuration details for setting up a confidential client in Keycloak for service account access.

```text
Client ID: admin-service-account
Access Type: confidential
Service Accounts Enabled: ON
```

--------------------------------

### Install npm Dependencies (Renderer)

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/README.md

Install dependencies required for the Electron renderer process using npm.

```bash
npm install
```

--------------------------------

### Start DataPallas Server with Docker Compose

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/docker/README.md

Use this command to start the DataPallas server and its associated services in detached mode.

```bash
# Start the server
docker compose up -d
```

--------------------------------

### Install ngx-bootstrap

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/HOW_TO.md

Use this command to add the ngx-bootstrap library to your Angular project.

```bash
ng add ngx-bootstrap
```

--------------------------------

### Install ng-bootstrap

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/HOW_TO.md

Use this command to add the ng-bootstrap library to your Angular project.

```bash
ng add @ng-bootstrap/ng-bootstrap
```

--------------------------------

### Example Batch Script for Profiling Standalone Java Application

Source: https://github.com/flowkraft/datapallas/blob/main/bkend/reporting/src/main/external-resources/template/lib/perf/jip/doc/release-notes.html

This batch script provides an example of how to profile a standalone Java application, specifically profiling ANT building the profiler.

```batch
example.bat

```

--------------------------------

### Install Angular Material

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/HOW_TO.md

Use this command to add Angular Material to your project. Follow the prompts for theme, typography, and animations.

```bash
ng add @angular/material
```

```bash
? Choose a prebuilt theme name, or "custom" for a custom theme: *Choose any theme you like here*
? Set up global Angular Material typography styles? *Yes* 
? Set up browser animations for Angular Material? *Yes*
```

```bash
Your project is not using the default builders for "build". The Angular Material schematics cannot add a theme to the workspace configuration if the builder has been changed.
```

```bash
@import '@angular/material/prebuilt-themes/indigo-pink.css'
```

--------------------------------

### Get Include List

Source: https://github.com/flowkraft/datapallas/blob/main/bkend/reporting/src/main/external-resources/template/lib/perf/jip/doc/readme.html

Command to retrieve the current include list from the profiler. Output appears in the profiled JVM's stdout.

```bash
java -jar client.jar getincludelist localhost 15599
```

--------------------------------

### Install Chocolatey Package Manager

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/readme-Prerequisites.txt

Execute this command in an Administrator PowerShell session to install Chocolatey. This is required if Chocolatey is not already installed.

```powershell
Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
```

--------------------------------

### Install Java 17 using Chocolatey

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/readme-Prerequisites.txt

After ensuring Chocolatey is installed, run this command in a new Administrator PowerShell window to install Java 17 (Eclipse Temurin).

```powershell
choco install temurin17 --yes
```

--------------------------------

### Starter Pack Iteration and Display

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/src/app/components/starter-packs/starter-packs.template.html

Iterates over filtered starter packs and displays each pack's details, including display name, status, tags, and command.

```html
@for (pack of filteredStarterPacks; track trackPackById($index, pack)) {

{{ pack.displayName }}
**@if (pack.status === 'starting' || pack.status === 'stopping') { } {{ pack.status === 'running' ? 'running' : pack.status === 'starting' ? 'starting' : pack.status === 'stopping' ? 'stopping' : 'stopped' }}**
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

@if (pack.tags && pack.tags.length > 0) {

@for (tag of pack.tags; track tag) { {{ tag }} }

}

Command 

@if (pack.status !== 'starting' && pack.status !== 'stopping') { @if (pack.status === 'running') { } @else { } } @if (pack.status === 'starting' || pack.status === 'stopping') { } {{ pack.status === 'running' ? 'Stop' : pack.status === 'starting' ? 'Starting' : pack.status === 'stopping' ? 'Stopping' : 'Start' }}

  
@if (pack.target === 'supabase') {

[https://supabase.com/](https://supabase.com/) {{ pack.description }}

} @if (pack.target === 'redis') {

[https://redis.io/](https://redis.io/) {{ pack.description }}

} @if (pack.target === 'timescaledb') {

[https://www.timescale.com/](https://www.timescale.com/) {{ pack.description }}

}
@if (pack.lastOutput) {

    {{ pack.lastOutput }}

}

}
```

--------------------------------

### Check Chocolatey Installation

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/readme-Prerequisites.txt

Verify if Chocolatey package manager is installed by running this command in PowerShell.

```powershell
choco -v
```

--------------------------------

### Deploy Application with Docker Compose

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/grails-playground/README.md

Instructions for building and running the application using Docker Compose. Includes commands for starting, managing logs, and stopping the containerized application.

```bash
# Build and run with Docker Compose
docker-compose up --build

# Run in background
docker-compose up -d --build

# View logs
docker-compose logs -f

# Stop
docker-compose down
```

--------------------------------

### Docker Compose Orchestration for CMS Webportal Playground

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/cms-webportal-playground/README.md

Illustrates the steps involved in setting up the CMS webportal playground using Docker Compose. This includes creating a fresh Sage theme, activating a WordPress plugin, applying theme patches, and building the theme's assets.

```bash
┌─────────────────────────────────────────────────────────────────────────────┐
│  DOCKER COMPOSE ORCHESTRATION                                               │
├─────────────────────────────────────────────────────────────────────────────┤
│                                                                             │
│  1. cms-webportal-playground-cli:
│     └── composer create-project roots/sage → Fresh Sage theme              
│     └── wp plugin activate DataPallas-integration                        
│                                                                             │
│  2. sage-theme-builder:
│     └── cp /patches/header.php .                    ← Apply patches         
│     └── cp /patches/footer.php .                                            
│     └── cp /patches/resources/css/app.css resources/css/app.css            
│     └── npm install                                                         
│     └── npm run build → Tailwind scans plugin, generates CSS               
│                                                                             
└─────────────────────────────────────────────────────────────────────────────┘
```

--------------------------------

### Display Get License Key Prompt

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/src/app/components/license/license.component.html

Shows a prompt to get a license key if no key is present and the license status is not active or is 0.

```html
@if ( !licenseService?.licenseDetails?.license.key && (!licenseService?.licenseDetails?.license.status || licenseService?.licenseDetails?.license.status === 0) ) {

[{{ "COMPONENTS.LICENSE.GET-LICENSE-KEY" | translate }}](https://store.datapallas.com)

}
```

--------------------------------

### Timeline Profiler Output Example

Source: https://github.com/flowkraft/datapallas/blob/main/bkend/reporting/src/main/external-resources/template/lib/perf/jip/doc/readme.html

This is an example of the output generated by the JIP Timeline profiler, showing method entry and exit events with thread IDs and timestamps.

```text
START	[9]	ProjectComponent:getProject()Lorg/apache/tools/ant/Project;	(org.apache.tools.ant)
END	[9]	ProjectComponent:getProject()Lorg/apache/tools/ant/Project;	(org.apache.tools.ant)
START	[9]	Project:log(Lorg/apache/tools/ant/Task;Ljava/lang/String;I)V	(org.apache.tools.ant)
Time: 3260 ms.
START	[9]	Project:fireMessageLogged(Lorg/apache/tools/ant/Task;Ljava/lang/String;I)V	(org.apache.tools.ant)
ALLOC	[9]	BuildEvent	(org.apache.tools.ant)
START	[9]	BuildEvent:(Lorg/apache/tools/ant/Task;)V	(org.apache.tools.ant)
START	[9]	ProjectComponent:getProject()Lorg/apache/tools/ant/Project;	(org.apache.tools.ant)
END	[9]	ProjectComponent:getProject()Lorg/apache/tools/ant/Project;	(org.apache.tools.ant)
START	[9]	Task:getOwningTarget()Lorg/apache/tools/ant/Target;	(org.apache.tools.ant)
END	[9]	Task:getOwningTarget()Lorg/apache/tools/ant/Target;	(org.apache.tools.ant)
END	[9]	BuildEvent:(Lorg/apache/tools/ant/Task;)V	(org.apache.tools.ant)
```

--------------------------------

### Project Structure Overview

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/grails-playground/README.md

Provides a hierarchical view of the application's directory and file structure, highlighting key components like controllers, domains, services, and views.

```bash
app/
├── grails-app/
│   ├── controllers/com/flowkraft/
│   │   ├── AdminController.groovy       # Admin dashboard & settings
│   │   ├── PayslipController.groovy     # Admin payslip CRUD
│   │   ├── InvoiceController.groovy     # Admin invoice CRUD
│   │   ├── PaymentController.groovy     # Payment API endpoints
│   │   ├── HomeController.groovy        # Portal home
│   │   ├── PortalPayslipController.groovy
│   │   ├── PortalInvoiceController.groovy
│   │   └── UrlMappings.groovy
│   ├── domain/com/flowkraft/
│   │   ├── Payslip.groovy              # Employee payslip domain
│   │   └── Invoice.groovy              # Customer invoice domain
│   ├── services/com/flowkraft/
│   │   ├── StripeService.groovy        # Stripe payment integration
│   │   └── PayPalService.groovy        # PayPal payment integration
│   └── views/
│       ├── layouts/
│       │   ├── admin.gsp               # Admin layout with dark sidebar
│       │   └── portal.gsp              # Portal layout with top nav
│       ├── admin/                      # Admin dashboard & settings
│       ├── payslip/                    # Admin payslip views
│       ├── invoice/                    # Admin invoice views
│       ├── home/                       # Portal home
│       ├── portalPayslip/              # Customer payslip views
│       └── portalInvoice/              # Customer invoice views
├── docker-compose.yml
├── Dockerfile
└── README.md
```

--------------------------------

### Install Angular CLI Globally

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/README.md

Install the Angular CLI globally to generate Angular components. Ensure you follow Angular CLI documentation for previous version upgrades.

```bash
npm install -g @angular/cli
```

--------------------------------

### Self-Host DataPallas with Docker

Source: https://github.com/flowkraft/datapallas/blob/main/README.md

Instructions for self-hosting DataPallas using Docker on Windows, Linux, or macOS. Ensure Docker is installed and running before proceeding.

```bash
docker compose up -d
```

--------------------------------

### Line Items JSON Format Example

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/_ai-hub/agents-output-artifacts/pythia/invoicing-portal-admin-panel-tasks.org

Example of the JSON array format for line items, used to store product details, quantities, prices, and discounts for an invoice.

```json
[
  {"product_name": "Widget A", "quantity": 2, "unit_price": 10.50, "discount": 0.10},
  {"product_name": "Widget B", "quantity": 1, "unit_price": 20.00, "discount": 0}
]
```

--------------------------------

### No Starter Packs Available Message

Source: https://github.com/flowkraft/datapallas/blob/main/frend/reporting/src/app/components/starter-packs/starter-packs.template.html

Displays a message when no starter packs are available or configured, and no errors are present. Indicates an empty or uninitialized state.

```html
@if (!isLoading && !isRefreshing && !error && starterPacks.length === 0) {

No starter packs available or configured.

}
```

--------------------------------

### WordPress vs Grails/Next.js Data Model and Migrations

Source: https://github.com/flowkraft/datapallas/blob/main/asbl/src/main/external-resources/db-template/_apps/flowkraft/_ai-hub/agents-output-artifacts/pythia/notes.md

Compares data modeling and migration strategies between WordPress (PODS) and Grails/Next.js.

```markdown
| Aspect           | WordPress (PODS)              | Grails / Next.js              |
|------------------|-------------------------------|-------------------------------|
| Data model       | PODS CPT in WP Admin UI       | Code (domain classes / schema)|
| Migrations       | None needed — PODS handles it | Liquibase / Drizzle push      |
```

--------------------------------

### Quick Start with rb-report

Source: https://github.com/flowkraft/datapallas/blob/main/frend/rb-webcomponents/README.md

Use the rb-report component by providing report code, API base URL, and API key. The component handles data fetching and rendering.

```html
<rb-report 
    report-code="sales-summary"
    api-base-url="http://localhost:9090/api/reporting"
    api-key="your-api-key">
</rb-report>
```

--------------------------------

### Specify Profile Properties File via VM Parameter

Source: https://github.com/flowkraft/datapallas/blob/main/bkend/reporting/src/main/external-resources/template/lib/perf/jip/doc/release-notes.html

Provide the name of the profile properties file using the '-Dprofile.properties=<file name>' VM parameter.

```bash
-Dprofile.properties=<file name>

```

--------------------------------

### Configure Text, XML, or Both Output

Source: https://github.com/flowkraft/datapallas/blob/main/bkend/reporting/src/main/external-resources/template/lib/perf/jip/doc/release-notes.html

Specify the desired output format for profiling information in the profile properties file. Options include 'text', 'xml', or 'both'. Defaults to 'text'.

```properties
output=text

```

```properties
output=xml

```

```properties
output=both

```

--------------------------------

### Angular Integration Example

Source: https://github.com/flowkraft/datapallas/blob/main/frend/rb-webcomponents/README.md

Integrate rb-report into an Angular component by using CUSTOM_ELEMENTS_SCHEMA and binding attributes.

```typescript
@Component({
  template: `
    <rb-report 
        [attr.report-code]="reportCode"
        [attr.api-base-url]="apiBaseUrl"
        [attr.api-key]="apiKey">
    </rb-report>
  `,
  schemas: [CUSTOM_ELEMENTS_SCHEMA]
})
export class ReportViewComponent {
  reportCode = 'sales-summary';
  apiBaseUrl = 'http://localhost:9090/api/reporting';
  apiKey = 'your-api-key';
}
```