flytable_update_rows: Update or append rows in a flytable database

In natverse/fafbseg: Support Functions for Analysis of FAFB EM Segmentation

Update or append rows in a flytable database

Description

flytable_update_rows updates existing rows in a table, returning TRUE on success.

flytable_append_rows appends data to an existing table, returning TRUE on success.

flytable_nrow returns the number or rows in one or more flytable tables using a SQL COUNT query.

Usage

flytable_update_rows(
  df,
  table,
  base = NULL,
  append_allowed = TRUE,
  chunksize = 1000L,
  ...
)

flytable_append_rows(df, table, base = NULL, chunksize = 1000L, ...)

flytable_nrow(table, base = NULL)

Arguments

df	A data.frame containing the data to upload including an _id column that can identify each row in the remote table.
table	Character vector naming a table
base	Character vector naming a seatable base (recommended) or a Base object returned by flytable_base (expert use).
append_allowed	Whether rows without row identifiers can be appended.
chunksize	To split large requests into smaller ones with max this many rows.
...	Additional arguments passed to pbsapply which might include cl=2 to specify a number of parallel jobs to run.

Details

seatable automatically maintains a unique id for each row in a _id column. This is returned by flytable_query and friends. If you modify data and then want to update again, you need to keep the column containing this row _id.

You do not need to provide this _id column when appending new rows. Indeed you will get a warning when doing so.

The chunksize argument is required because it seems that there is a maximum of 1000 rows per update action.

Value

Logical indicating success, invisibly (failures will normally cause premature termination with errors written to the console).

See Also

Other flytable: flytable-queries, flytable_list_selected(), flytable_login()

Examples

## Not run: 
fruit=flytable_list_rows('testfruit')
flytable_update_rows(table='testfruit', fruit[1:2, c(1,4:6)])

## End(Not run)
## Not run: 
flytable_append_rows(table="testfruit",
  data.frame(fruitname='lemon', person='David', nid=4))

## End(Not run)

natverse/fafbseg documentation built on Nov. 11, 2024, 9:50 p.m.