Tables via the API

from noxus_sdk.client import Client

client = Client(api_key="your_api_key_here")

table = client.tables.create(
    name="Customers",
    columns=[
        {"name": "email", "type": "string"},
        {"name": "signups", "type": "number"},
    ],
)

table.insert_rows([
    {"email": "[email protected]", "signups": 3},
    {"email": "[email protected]", "signups": 7},
])

result = client.tables.query(
    "SELECT email, signups FROM customers ORDER BY signups DESC"
)
for row in result.rows:
    print(row)

# 1. Create the table (the response includes its id and sql_name)
curl -X POST https://backend.noxus.ai/v1/tables \
  -H "X-API-KEY: $NOXUS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Customers",
    "columns": [
      {"name": "email", "type": "string"},
      {"name": "signups", "type": "number"}
    ]
  }'

# 2. Insert rows
curl -X POST https://backend.noxus.ai/v1/tables/$TABLE_ID/rows/bulk \
  -H "X-API-KEY: $NOXUS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"rows": [
    {"email": "[email protected]", "signups": 3},
    {"email": "[email protected]", "signups": 7}
  ]}'

# 3. Query
curl -X POST https://backend.noxus.ai/v1/tables/query \
  -H "X-API-KEY: $NOXUS_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"sql": "SELECT email, signups FROM customers ORDER BY signups DESC"}'