frappe-remote-cli 0.1.0

A Click-based CLI to communicate with remote Frappe sites.

Frappe Remote CLI Tool

A Python command-line utility built with Click and Requests to communicate with a remote Frappe site (v15).

Features

• Local Configuration: Securely store connection URLs and API credentials locally in ~/.frappe-cli.json (permissions enforced at 0600). Supports multiple site profiles.
• Interactive Prompts: Prompts you for configuration parameters when setting up connection configs if options are omitted.
• SSL Verification Control: Bypass SSL certificate validation using the --no-verify option for local or development environments.
• Remote RPC Executions: Call any remote whitelisted Python methods on the site via frappe.call.
• REST DocType CRUD: Query, fetch, insert, update, or delete DocType records using clean subcommand interfaces.
• Rich Formatting: Display API responses in raw JSON format by default (ideal for scripting/piping), with an optional -t / --table toggle flag to print formatted human-readable ASCII tables.
• Robust Exception Handling: Clean terminal error formatting without raw stack traces.

---

Installation

Ensure you have Python 3.10+ installed.

1. Clone this repository.
2. Initialize virtual environment and install the package in editable mode:

python3 -m venv .venv
source .venv/bin/activate
pip install -e ".[dev]"

---

Usage

Verify the CLI is registered in your path:

frappe-cli --help

Global Options

You can specify these options before any subcommand:

• --profile <name>: Run the command against a specific profile configuration.
• --no-verify: Disable SSL certificate verification (useful for self-signed certificates).

1. Configuration Setup

# Set connection parameters (prompts interactively for missing arguments)
frappe-cli config set \
  --site-url "https://my-frappe-site.com" \
  --api-key "ab12cd34ef56" \
  --api-secret "gh78ij90kl12" \
  --profile production

# Interactive config (will prompt for all missing values)
frappe-cli config set --profile staging

# List all configured profiles
frappe-cli config list

# Switch default profile
frappe-cli config use staging

# Inspect active profile configuration
frappe-cli config show

# Run connection diagnostic for active profile
frappe-cli config check

# Run connection diagnostic for a specific profile with SSL validation disabled
frappe-cli --profile staging --no-verify config check

2. Method Execution (call)

Trigger any remote method decorated with @frappe.whitelist():

# Check logged-in user
frappe-cli call frappe.auth.get_logged_user

# Execute method with key-value parameters
frappe-cli call my_app.api.add -p a 10 -p b 20

# Format output as table instead of default JSON
frappe-cli call frappe.auth.get_logged_user --table

3. Document CRUD (doc)

List records:

frappe-cli doc list User --fields "name,email,first_name"

Get record:

frappe-cli doc get User Administrator

Create record:

frappe-cli doc create User -d '{"email": "[e-mail]", "first_name": "New"}'

Update record:

frappe-cli doc update User [e-mail] -d '{"first_name": "UpdatedName"}'

Delete record:

frappe-cli doc delete User [e-mail]

---

Running Tests

Run the test suite containing unit, integration, and formatting tests:

pytest