# 第一步：取 CSRF 令牌并保存 Cookie
csrf=$(curl -s -c cj.txt http://localhost:8128/auth/login/ \
  | grep -oP 'name="csrfmiddlewaretoken" value="\K[^"]+' | head -1)
# 第二步：提交登录（表单字段 username/password）
curl -s -b cj.txt -c cj.txt -o /dev/null -w 'login: %{http_code}\n' \
  -X POST http://localhost:8128/auth/login/ \
  --data-urlencode "csrfmiddlewaretoken=$csrf" \
  --data-urlencode "username=admin" \
  --data-urlencode "password=q1w2e3r4" \
  -H "Referer: http://localhost:8128/auth/login/"

# 匿名即可调用（system.* 无需登录，实测验证）
curl -s -X POST http://localhost:8128/api/rpc/v0/ \
  -H 'Content-Type: application/json' \
  -d '[{"id":1,"jsonrpc":"2.0","method":"system.listMethods","params":{}}]' \
  | python3 -m json.tool | head -8

[
    {
        "id": 1,
        "jsonrpc": "2.0",
        "result": [
            "analytics.disable",
            "analytics.get_state",
            "analytics.initialize",
            "analytics.upload_feedback",
            "analytics.view_report",
            "collaborators.add",
            ...

curl -s -X POST http://localhost:8128/api/rpc/v0/ \
  -H 'Content-Type: application/json' \
  -d '[{"id":1,"jsonrpc":"2.0","method":"databases.configured.list","params":{}}]'

[{"id": 1, "jsonrpc": "2.0", "error": {"code": -32603, "message": "Authentication failed when calling \"databases.configured.list\""}}]

curl -s -b cj.txt -X POST http://localhost:8128/api/rpc/v0/ \
  -H 'Content-Type: application/json' \
  -d '[{"id":11,"jsonrpc":"2.0","method":"system.methodHelp","params":{"method_name":"records.list"}}]'

[{"id": 11, "jsonrpc": "2.0", "result": "<p>List records from a table, and its row count. Exposed as `list`.</p><p>Args:     table_oid: Identity of the table in the user's database.     database_id: The Django id of the database containing the table.     limit: The maximum number of rows we'll return.     offset: The number of rows to skip before returning records from following rows.     order: An array of ordering definition objects.     filter: An array of filter definition objects.     grouping: An array of group definition objects. ...</p>"}]

{"server": {"id": 2, "host": "mathesar-0.12.0-extpg", "port": 5432, "sslmode": "prefer"},
 "database": {"id": 2, "name": "business", "server_id": 2, "last_confirmed_sql_version": "0.12.0", "needs_upgrade_attention": false, "nickname": "外部业务库"},
 "configured_role": {"id": 2, "name": "pgadmin", "server_id": 2}}

curl -s -b cj.txt -X POST http://localhost:8128/api/rpc/v0/ \
  -H 'Content-Type: application/json' \
  -d '[{"id":101,"jsonrpc":"2.0","method":"databases.configured.list","params":{}}]'

[{"id": 101, "jsonrpc": "2.0", "result": [{"id": 1, "name": "warehouse", "server_id": 1, "last_confirmed_sql_version": "0.12.0", "needs_upgrade_attention": false, "nickname": "仓储示例库"}, {"id": 2, "name": "business", "server_id": 2, "last_confirmed_sql_version": "0.12.0", "needs_upgrade_attention": false, "nickname": "外部业务库"}]}]

[{"id": 1, "host": "mathesar_db", "port": 5432, "sslmode": "prefer"}, {"id": 2, "host": "mathesar-0.12.0-extpg", "port": 5432, "sslmode": "prefer"}]

[{"oid": 17489, "name": "Library Management", "owner_oid": 10, "description": null, "table_count": 7, "current_role_owns": true, "current_role_priv": ["USAGE", "CREATE"]},
 {"oid": 2200, "name": "public", "owner_oid": 6171, "description": "standard public schema", "table_count": 2, "current_role_owns": true, "current_role_priv": ["USAGE", "CREATE"]}]

[{"oid": 17574, "name": "employees", "type": "table", "schema": 2200, "owner_oid": 10, "description": null, "current_role_owns": true, "current_role_priv": ["SELECT", "INSERT", "UPDATE", "DELETE", "TRUNCATE", "REFERENCES", "TRIGGER"]},
 {"oid": 17594, "name": "departments", "type": "table", "schema": 2200, "owner_oid": 10, "description": null, "current_role_owns": true, "current_role_priv": ["SELECT", "INSERT", "UPDATE", "DELETE", "TRUNCATE", "REFERENCES", "TRIGGER"]}]

{"joinable_tables": [{"base": 17574, "target": 17594, "join_path": [[[17574, 5], [17594, 1]]], "fkey_path": [[17602, false]], "depth": 1, "multiple_results": false}], "target_table_info": {"17594": {"name": "departments", "columns": {"1": {"name": "id", "type": "integer", "primary_key": true}, "2": {"name": "dname", "type": "character varying", "primary_key": false}}}}}

[{"id": 1, "name": "id", "type": "integer", "type_options": null, "nullable": false, "primary_key": true, "default": {"value": "identity", "is_dynamic": true}, "has_dependents": false, "description": null, "current_role_priv": ["SELECT", "INSERT", "UPDATE", "REFERENCES"]},
 {"id": 2, "name": "name", "type": "character varying", ...},
 {"id": 3, "name": "salary", "type": "numeric", ...},
 {"id": 4, "name": "hired_on", "type": "date", ...}]

curl -s -b cj.txt -X POST http://localhost:8128/api/rpc/v0/ \
  -H 'Content-Type: application/json' \
  -d '[{"id":6,"jsonrpc":"2.0","method":"records.list","params":{"database_id":1,"table_oid":17574,"limit":2}}]'

{"count": 2, "results": [{"1": 1, "2": "关羽", "3": 9500.75, "4": "2023-04-01 AD", "5": 1}, {"1": 2, "2": "张飞", "3": 8100, "4": "2023-07-15 AD", "5": null}], "grouping": null, "linked_record_summaries": {"5": {"1": "骑兵部"}}, "record_summaries": null, "joined_record_summaries": null, "download_links": null}

{"results": [{"1": 4, "2": "张三丰", "3": 8800, "4": "2024-01-08 AD"}], "linked_record_summaries": null, "record_summaries": null}

{"results": [{"1": 1, "2": "关羽", "3": 9500.75, "4": "2023-04-01 AD"}]}

// 请求 params（节选）
{"database_id": 1, "name": "薪资一览", "base_table_oid": 17574, "schema_oid": 2200,
 "initial_columns": [{"attnum": 1}, {"attnum": 2}, {"attnum": 3}, {"attnum": 5}],
 "display_names": {"5": "部门"}, "description": "员工与部门关联查询"}
// 响应 result
{"id": 1, "database_id": 1, "name": "薪资一览", "base_table_oid": 17574, "schema_oid": 2200, "initial_columns": [{"attnum": 1}, {"attnum": 2}, {"attnum": 3}, {"attnum": 5}], "transformations": null, "display_options": null, "display_names": {"5": "部门"}, "description": "员工与部门关联查询"}

curl -s -b cj.txt -X POST http://localhost:8128/api/rpc/v0/ \
  -H 'Content-Type: application/json' -d '[
{"id":17,"jsonrpc":"2.0","method":"explorations.run","params":{"database_id":1,"exploration_def":{"database_id":1,"name":"临时运行","base_table_oid":17574,"schema_oid":2200,"initial_columns":[{"attnum":1,"alias":"id"},{"attnum":2,"alias":"name"},{"attnum":3,"alias":"salary"},{"attnum":5,"alias":"dept_id"}],"display_names":{"dept_id":"部门"},"limit":10,"offset":0}}}]'

{"query": {"database_id": 1, "name": "临时运行", "base_table_oid": 17574, "schema_oid": 2200, "initial_columns": [{"attnum": 1, "alias": "id"}, {"attnum": 2, "alias": "name"}, {"attnum": 3, "alias": "salary"}, {"attnum": 5, "alias": "dept_id"}], "display_names": {"dept_id": "部门"}, "limit": 10, "offset": 0},
 "records": {"count": 2, "results": [{"id": 1, "name": "关羽", "salary": "9500.75", "dept_id": 1}, {"id": 2, "name": "张飞", "salary": "8100", "dept_id": null}]},
 "output_columns": ["id", "name", "salary", "dept_id"],
 "column_metadata": {"dept_id": {"alias": "dept_id", "display_name": "部门", "type": "integer", ...}}}

[{"id": 1, "name": "mathesar", "server_id": 1}]

{"id": 2, "username": "zhangsan", "is_superuser": false, "email": "zhangsan@example.com", "full_name": "", "display_language": "en"}

{"id": 2, "user_id": 2, "database_id": 1, "configured_role_id": 1, "user_info": {"id": 2, "username": "zhangsan", "is_superuser": false, "email": "zhangsan@example.com", "full_name": "", "display_language": "en"}}

[{"id": 2, "username": "zhangsan", "is_superuser": false, "email": "zhangsan@example.com", "full_name": "", "display_language": "en"}, {"id": 1, "username": "admin", "is_superuser": true, "email": "admin@example.com", "full_name": null, "display_language": "en"}]

{"count": 2, "results": [{"1": 2, "2": "张飞", "3": 8100, "4": "2023-07-15 AD", "5": null}, {"1": 1, "2": "关羽", "3": 9500.75, "4": "2023-04-01 AD", "5": 1}]}