Struct perspective_js::Table

pub struct Table(/* private fields */);

Table is Perspective’s columnar data frame, analogous to a Pandas DataFrame or Apache Arrow, supporting append & in-place updates, removal by index, and update notifications.

A Table contains columns, each of which have a unique name, are strongly and consistently typed, and contains rows of data conforming to the column’s type. Each column in a Table must have the same number of rows, though not every row must contain data; null-values are used to indicate missing values in the dataset.

The schema of a Table is immutable after creation, which means the column names and data types cannot be changed after the Table has been created. Columns cannot be added or deleted after creation either, but a View can be used to select an arbitrary set of columns from the Table.

Implementations

impl Table

pub fn get_table(&self) -> &Table

impl Table

pub async fn get_index(&self) -> Option<String>

Returns the name of the index column for the table.

JavaScript Examples

const table = await client.table("x,y\n1,2\n3,4", { index: "x" });
const index = table.get_index(); // "x"

Python Examples

table = client.table("x,y\n1,2\n3,4", index="x");
index = table.get_index() # "x"

Examples

let options = TableInitOptions {index: Some("x".to_string()), ..default() };
let table = client.table("x,y\n1,2\n3,4", options).await;
let tables = client.open_table("table_one").await;

pub async fn get_client(&self) -> Client

Get a copy of the Client this Table came from.

pub async fn get_limit(&self) -> Option<u32>

Returns the user-specified row limit for this table.

pub async fn clear(&self) -> ApiResult<()>

Removes all the rows in the Table, but preserves everything else including the schema, index, and any callbacks or registered View instances.

Calling Table::clear, like Table::update and Table::remove, will trigger an update event to any registered listeners via View::on_update.

pub async fn delete(self) -> ApiResult<()>

Delete this Table and cleans up associated resources, assuming it has no View instances registered to it (which must be deleted first).

Tables do not stop consuming resources or processing updates when they are garbage collected in their host language - you must call this method to reclaim these.

JavaScript Examples

const table = await client.table("x,y\n1,2\n3,4");

// ...

await table.delete();

Python Examples

table = client.table("x,y\n1,2\n3,4")

// ...

table.delete()

Examples

let opts = TableInitOptions::default();
let data = TableData::Update(UpdateData::Csv("x,y\n1,2\n3,4".into()));
let table = client.table(data, opts).await?;

// ...

table.delete().await?;

pub async fn size(&self) -> ApiResult<f64>

Returns the number of rows in a Table.

pub async fn schema(&self) -> ApiResult<JsValue>

Returns a table’s Schema, a mapping of column names to column types.

The mapping of a Table’s column names to data types is referred to as a Schema. Each column has a unique name and a data type, one of:

• "boolean" - A boolean type
• "date" - A timesonze-agnostic date type (month/day/year)
• "datetime" - A millisecond-precision datetime type in the UTC timezone
• "float" - A 64 bit float
• "integer" - A signed 32 bit integer (the integer type supported by JavaScript)
• "string" - A String data type (encoded internally as a dictionary)

Note that all Table columns are nullable, regardless of the data type.

pub async fn columns(&self) -> ApiResult<JsValue>

Returns the column names of this Table in “natural” order (the ordering implied by the input format).

JavaScript Examples

const columns = await table.columns();

Python Examples

columns = table.columns()

Examples

let columns = table.columns().await;

pub async fn make_port(&self) -> ApiResult<i32>

Create a unique channel ID on this Table, which allows View::on_update callback calls to be associated with the Table::update which caused them.

pub async fn on_delete(&self, on_delete: Function) -> ApiResult<u32>

Register a callback which is called exactly once, when this Table is deleted with the Table::delete method.

Table::on_delete resolves when the subscription message is sent, not when the delete event occurs.

pub fn remove_delete(&self, callback_id: u32) -> ApiFuture<()>

Removes a listener with a given ID, as returned by a previous call to Table::on_delete.

pub async fn remove(&self, value: &JsValue) -> ApiResult<()>

Replace all rows in this Table with the input data, coerced to this Table’s existing Schema, notifying any derived View and View::on_update callbacks.

Calling Table::replace is an easy way to replace all the data in a Table without losing any derived View instances or View::on_update callbacks. Table::replace does not infer data types like Client::table does, rather it coerces input data to the Schema like Table::update. If you need a Table with a different Schema, you must create a new one.

JavaScript Examples

await table.replace("x,y\n1,2");

Python Examples

table.replace("x,y\n1,2")

Examples

let data = UpdateData::Csv("x,y\n1,2".into());
let opts = UpdateOptions::default();
table.replace(data, opts).await?;

pub async fn replace(&self, input: &JsValue) -> ApiResult<()>

Replace all rows in this Table with the input data, coerced to this Table’s existing Schema, notifying any derived View and View::on_update callbacks.

Calling Table::replace is an easy way to replace all the data in a Table without losing any derived View instances or View::on_update callbacks. Table::replace does not infer data types like Client::table does, rather it coerces input data to the Schema like Table::update. If you need a Table with a different Schema, you must create a new one.

JavaScript Examples

await table.replace("x,y\n1,2");

Python Examples

table.replace("x,y\n1,2")

Examples

let data = UpdateData::Csv("x,y\n1,2".into());
let opts = UpdateOptions::default();
table.replace(data, opts).await?;

pub async fn update( &self, input: &JsTableInitData, options: Option<JsUpdateOptions>, ) -> ApiResult<()>

Updates the rows of this table and any derived View instances.

Calling Table::update will trigger the View::on_update callbacks register to derived View, and the call itself will not resolve until all derived View’s are notified.

When updating a Table with an index, Table::update supports partial updates, by omitting columns from the update data.

Arguments

• input - The input data for this Table. The schema of a Table is immutable after creation, so this method cannot be called with a schema.
• options - Options for this update step - see UpdateOptions.

JavaScript Examples

await table.update("x,y\n1,2");

Python Examples

table.update("x,y\n1,2")

Examples

let data = UpdateData::Csv("x,y\n1,2".into());
let opts = UpdateOptions::default();
table.update(data, opts).await?;

pub async fn view(&self, config: Option<JsViewConfig>) -> ApiResult<View>

Create a new View from this table with a specified ViewConfigUpdate.

See View struct.

JavaScript Examples

const view = await table.view({
    columns: ["Sales"],
    aggregates: { Sales: "sum" },
    group_by: ["Region", "Country"],
    filter: [["Category", "in", ["Furniture", "Technology"]]],
});

Python Examples

view = table.view(
  columns=["Sales"],
  aggregates={"Sales": "sum"},
  group_by=["Region", "Country"],
  filter=[["Category", "in", ["Furniture", "Technology"]]]
)

Examples

use crate::config::*;
let view = table
    .view(Some(ViewConfigUpdate {
        columns: Some(vec![Some("Sales".into())]),
        aggregates: Some(HashMap::from_iter(vec![("Sales".into(), "sum".into())])),
        group_by: Some(vec!["Region".into(), "Country".into()]),
        filter: Some(vec![Filter::new("Category", "in", &[
            "Furniture",
            "Technology",
        ])]),
        ..ViewConfigUpdate::default()
    }))
    .await?;

pub async fn validate_expressions(&self, exprs: &JsValue) -> ApiResult<JsValue>

Validates the given expressions.

Python Examples

exprs = client.validate_expressions({"computed": '"Quantity" + 4'})

Trait Implementations

impl Clone for Table

fn clone(&self) -> Table

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl From<Table> for JsValue

fn from(value: Table) -> Self

Converts to this type from the input type.

impl From<Table> for Table

fn from(value: Table) -> Self

Converts to this type from the input type.

impl FromWasmAbi for Table

type Abi = u32

The wasm ABI type that this converts from when coming back out from the ABI boundary.

unsafe fn from_abi(js: u32) -> Self

Recover a Self from Self::Abi.

impl IntoWasmAbi for Table

type Abi = u32

The wasm ABI type that this converts into when crossing the ABI boundary.

fn into_abi(self) -> u32

Convert self into Self::Abi so that it can be sent across the wasm ABI boundary.

impl LongRefFromWasmAbi for Table

type Abi = u32

Same as RefFromWasmAbi::Abi

type Anchor = Ref<'static, Table>

Same as RefFromWasmAbi::Anchor

unsafe fn long_ref_from_abi(js: Self::Abi) -> Self::Anchor

Same as RefFromWasmAbi::ref_from_abi

impl OptionFromWasmAbi for Table

fn is_none(abi: &Self::Abi) -> bool

Tests whether the argument is a “none” instance. If so it will be deserialized as None, and otherwise it will be passed to FromWasmAbi.

impl OptionIntoWasmAbi for Table

fn none() -> Self::Abi

Returns an ABI instance indicating “none”, which JS will interpret as the None branch of this option.

impl RefFromWasmAbi for Table

type Abi = u32

The wasm ABI type references to Self are recovered from.

type Anchor = Ref<'static, Table>

The type that holds the reference to Self for the duration of the invocation of the function that has an &Self parameter. This is required to ensure that the lifetimes don’t persist beyond one function call, and so that they remain anonymous.

unsafe fn ref_from_abi(js: Self::Abi) -> Self::Anchor

Recover a Self::Anchor from Self::Abi.

impl RefMutFromWasmAbi for Table

type Abi = u32

Same as RefFromWasmAbi::Abi

type Anchor = RefMut<'static, Table>

Same as RefFromWasmAbi::Anchor

unsafe fn ref_mut_from_abi(js: Self::Abi) -> Self::Anchor

Same as RefFromWasmAbi::ref_from_abi

impl TryFromJsValue for Table

type Error = JsValue

The type returned in the event of a conversion error.

fn try_from_js_value(value: JsValue) -> Result<Self, Self::Error>

Performs the conversion.

impl VectorFromWasmAbi for Table

type Abi = <Box<[JsValue]> as FromWasmAbi>::Abi

unsafe fn vector_from_abi(js: Self::Abi) -> Box<[Table]>

impl VectorIntoWasmAbi for Table

type Abi = <Box<[JsValue]> as IntoWasmAbi>::Abi

fn vector_into_abi(vector: Box<[Table]>) -> Self::Abi

impl WasmDescribe for Table

fn describe()

impl WasmDescribeVector for Table

fn describe_vector()