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 "autoincrement"
)

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

from noxus_sdk.resources.tables import ImportColumn

table = client.tables.import_csv(
    "customers.csv",
    name="Customers",
    columns=[
        ImportColumn(index=0, name="email", type="string", label="Email"),
        ImportColumn(index=2, name="signups", type="number"),
    ],
    id_type="uuid",
    has_header=True,
    delimiter=",",          # "," ";" or "\t"
)

table.add_column(name="phone", type="string", label="Phone")
table.rename_column("phone", "mobile")
table.change_column_type("mobile", "number")
table.set_column_label("mobile", "Mobile")
table.reorder_columns(["mobile", "email", "signups", "active"])
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)

from noxus_sdk.resources.tables import RowFilter

page = table.list_rows_page(
    limit=20,
    order_by="signups",
    descending=True,
    filters=[
        RowFilter(field="active", op="is", value="true"),
        RowFilter(field="signups", op="between", value=5, value2=50),
    ],
)
page.rows, page.total

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)

first = client.tables.query(sql, limit=100)                          # first.total set
nxt = client.tables.query(sql, limit=100, offset=100, include_total=False)

stats = table.stats()               # TableStats: row_count, size_bytes, column_count
csv_bytes = table.export_csv()      # -> bytes; also takes search= and filters=