Sql Csv Pago

# bash or zsh: see the payment challenge. Nothing is charged.
curl -sS -g -i -X POST 'https://api.vextorium.com/sql-csv-pago' \
  -H 'content-type: application/json' \
  --data-raw '{"consulta":"SELECT city, SUM(sales) AS total FROM datos GROUP BY city ORDER BY total DESC","contenido":"city,sales\nMadrid,100\nBarcelona,80\nMadrid,120"}'

# x402 v2 sends the challenge base64-encoded in the PAYMENT-REQUIRED header (v1 sends it in the body).
# To read the header:
curl -sS -g -o /dev/null -D - -X POST 'https://api.vextorium.com/sql-csv-pago' \
  -H 'content-type: application/json' \
  --data-raw '{"consulta":"SELECT city, SUM(sales) AS total FROM datos GROUP BY city ORDER BY total DESC","contenido":"city,sales\nMadrid,100\nBarcelona,80\nMadrid,120"}' \
  | grep -i '^payment-required:' | cut -d' ' -f2 | tr -d '\r' | base64 --decode

// npm i @x402/fetch @x402/evm viem
import { wrapFetchWithPayment, x402Client } from "@x402/fetch";
import { registerExactEvmScheme } from "@x402/evm/exact/client";
import { privateKeyToAccount } from "viem/accounts";

// Pays at most $0.004 per call.
const client = new x402Client().setSpendControls({ maxAmountPerPayment: "$0.004" });
registerExactEvmScheme(client, { signer: privateKeyToAccount(process.env.EVM_PRIVATE_KEY) });
const pay = wrapFetchWithPayment(fetch, client);

// Not sure it's safe to pay? ToolVet checks it first for $0.005. Pay for that from a separate
// client: this one is capped at $0.004 per payment. GET https://toolvet.app/api/v1/check?url=https%3A%2F%2Fapi.vextorium.com%2Fsql-csv-pago&method=POST
const res = await pay("https://api.vextorium.com/sql-csv-pago", {
  method: "POST",
  headers: { "content-type": "application/json" },
  body: JSON.stringify({
    "consulta": "SELECT city, SUM(sales) AS total FROM datos GROUP BY city ORDER BY total DESC",
    "contenido": "city,sales\nMadrid,100\nBarcelona,80\nMadrid,120"
  }),
});
console.log(res.status, await res.text());

# pip install "x402[requests,evm]"
import os
from eth_account import Account
from x402 import x402ClientSync
from x402.http.clients import x402_requests
from x402.mechanisms.evm import EthAccountSigner
from x402.mechanisms.evm.exact.register import register_exact_evm_client

# Pays at most $0.004 per call.
client = x402ClientSync().set_spend_controls({"max_amount_per_payment": "$0.004"})
register_exact_evm_client(client, EthAccountSigner(Account.from_key(os.environ["EVM_PRIVATE_KEY"])))

with x402_requests(client) as session:
    res = session.post(
        "https://api.vextorium.com/sql-csv-pago",
        json={
            "consulta": "SELECT city, SUM(sales) AS total FROM datos GROUP BY city ORDER BY total DESC",
            "contenido": "city,sales\nMadrid,100\nBarcelona,80\nMadrid,120",
        },
    )
    print(res.status_code, res.text)