Data Tables

from noxus_sdk.resources.tables import TableColumn

table = client.tables.create(
    name="Customers",
    columns=[
        TableColumn(name="email", type="string"),
        TableColumn(name="signups", type="number"),
        {"name": "active", "type": "boolean"},     # dicts work too
    ],
    description="CRM export",
    id_type="uuid",        # "uuid" (default) or "serial" (autoincrement)
)

client.tables.list()                    # -> list[Table]  (incl. read-only platform views)
client.tables.get(table_id)             # -> Table
client.tables.delete(table_id)          # -> bool

table.add_column(name="phone", type="string", label="Phone")
table.rename_column("phone", "mobile")
table.drop_column("mobile")

table.insert({"email": "[email protected]", "signups": 3, "active": True})   # -> the row
table.insert_rows([{...}, {...}])                                  # bulk, -> count
table.update_row(row_id, {"signups": 4})
table.delete_row(row_id)
table.clear()                                                      # delete all rows -> count

# read
table.list_rows(limit=50, offset=0, search="[email protected]")
for row in table.iter_rows(page_size=500, search=None):            # auto-paginate every row
    print(row)

result = client.tables.query("SELECT email, signups FROM customers WHERE active")
print(result.columns)     # list[str]
for row in result.rows:   # list[dict]
    print(row)

stats = table.stats()               # TableStats: row_count, size_bytes, column_count
csv_bytes = table.export_csv()      # -> bytes