Tool: table |
Access tables from Glish |
|
Method: table |
Construct table tool |
tablename |
string |
Name of table on disk |
tabledesc |
any |
Table descriptor |
nrow |
int |
Number of rows |
readonly |
bool |
Open Read-only? |
lockoptions |
any |
locking to be used |
ack |
bool |
Acknowledge creations, etc |
dminfo |
any |
Data manager info for new table |
endian |
string |
Endian format of new table |
memorytable |
bool |
Hold new table in memory? |
tableserver |
any |
Table handler to be used |
tablenote |
any |
note function to be used Any note function |
handle |
any |
attach to this table handle for internal use only |
|
|
Method: tablefromfits |
Create an \aipspp\ table from binary FITS |
tablename |
string |
Name of table to be created |
fitsfile |
string |
Name of FITS file to be read |
whichhdu |
int |
Which HDU to read (0-relative to primary HDU i.e. 1 is the smallest valid value) |
storage |
string |
Storage manager to use (standard or incremental) |
convention |
string |
Convention to use (SDFITS or none) |
readonly |
bool |
Open Read-only? |
lockoptions |
any |
locking to be used |
ack |
bool |
Acknowledge creations, etc |
tableserver |
any |
Table server to be used |
|
|
Method: tablefromascii |
Create an \aipspp\ table from an ASCII format |
tablename |
string |
Name of table to be created |
asciifile |
string |
Name of ASCII file to be read |
headerfile |
string |
Name of an optional file defining the format |
autoheader |
bool |
Determine header information automatically |
autoshape |
intArray |
Shape to be used if autoheader=T |
sep |
string |
Value separator |
commentmarker |
string |
Regex indicating comment line |
firstline |
int |
First line to use |
lastline |
int |
Last line to use |
readonly |
bool |
Open Read-only? |
lockoptions |
any |
locking to be used |
ack |
bool |
Acknowledge creations, etc |
tableserver |
any |
Table server to be used |
|
|
Method: open |
open and existing table |
tablename |
string |
lockoptions |
any |
locking to be used |
nomodify |
bool |
|
|
Method: flush |
flush the current contents to disk |
|
|
Method: resync |
resync the table tool with table file |
|
|
Method: close |
close the table tool |
|
|
Method: copy |
copy a table |
newtablename |
string |
Name of newtable on disk |
deep |
bool |
Make a deep copy of a reference table? |
valuecopy |
bool |
Make a deep copy of any table? |
dminfo |
any |
Data manager info for new table |
endian |
string |
Endian format of new table |
memorytable |
bool |
Hold new table in memory? |
returnobject |
bool |
Return a tool object for the new table |
|
|
Method: copyrows |
copy rows from this table to another |
outtable |
string |
table object of output table |
startrowin |
int |
First row to take from input table |
startrowout |
int |
First row to write in output table, -1 (=end) |
nrow |
int |
Nr of rows to copy, -1 (=all) |
|
|
Method: done |
end the table tool |
|
|
Method: iswritable |
is the table writable? |
|
|
Method: endianformat |
get the endian format used for this table |
|
|
Method: lock |
acquire a lock on the table |
write |
bool |
Write lock? (F=read lock) |
nattempts |
int |
Nr of attempts |
|
|
Method: unlock |
unlock and flush the table |
|
|
Method: datachanged |
has data changed in table? |
|
|
Method: haslock |
has this process a lock on the table? |
write |
bool |
Has it a write lock? (F=read lock) |
|
|
Method: lockoptions |
get the lock options used for this table |
|
|
Method: ismultiused |
is the table in use in another process? |
checksubtables |
bool |
check if subtables are multiused?) |
|
|
Method: browse |
browse a table using a graphical browser |
|
|
Method: name |
return name on disk |
|
|
Method: toasciifmt |
Write \aipspp\ table into an ASCII format |
asciifile |
string |
Name of ASCII file to be written |
headerfile |
string |
Name of an optional file defining the format |
columns |
stringArray |
Names of columns to be written, default is all |
sep |
string |
Value separator |
|
|
Method: query |
Make a table from a query |
query |
string |
Query string |
name |
string |
Name of resulting reference table |
sortlist |
string |
Sort string (one or more expressions separated by commas) |
columns |
string |
List of column names separated by commas |
|
|
Method: queryC |
Alternative table query function |
query |
string |
the query expression |
resultTable |
string |
Name of the results table |
sortlist |
string |
Sort list of the results table |
columns |
string |
Columns to return in the sort table, leave blank for all |
|
|
Method: calc |
Calculate an expression on a table |
expr |
string |
Expression string |
|
|
Method: selectrows |
Make a table from a selection of rows |
rownrs |
intArray |
0-based Row Numbers |
name |
string |
Name of resulting table |
|
|
Method: putinfo |
set the info record |
value |
any |
Info record |
|
|
Method: addreadmeline |
add a readme line to the info record |
value |
string |
readme line |
|
|
Method: summary |
summarize the contents of the table |
recurse |
bool |
Summarize subtables recursively |
|
|
Method: colnames |
return the names of the columns |
|
|
Method: rownumbers |
return the row numbers in the (reference) table |
tab |
any |
Table to which the row numbers refer |
nbytes |
int |
Maximum cache size in bytes |
|
|
Method: setmaxcachesize |
set maximum cache size for column in the table |
columnname |
string |
Name of column |
nbytes |
int |
Maximum cache size in bytes |
|
|
Method: isscalarcol |
is the specified column scalar? |
columnname |
string |
Name of column |
|
|
Method: isvarcol |
tell if column contains variable shaped arrays |
columnname |
string |
Name of column |
|
|
Method: coldatatype |
return the column data type |
columnname |
string |
Name of column |
|
|
Method: colarraytype |
return the column array type |
columnname |
string |
Name of column |
|
|
Method: ncols |
return number of columns |
|
|
Method: nrows |
return number of rows |
|
|
Method: addrows |
add a specified number of rows |
nrow |
int |
Number of rows to add |
|
|
Method: removerows |
remove the specified rows |
rownrs |
intArray |
Row numbers to remove |
|
|
Method: addcols |
add one or more columns |
desc |
any |
Description of one or more columns |
dminfo |
any |
Optional description data manager to use |
|
|
Method: renamecol |
rename a column |
oldname |
string |
name of column to be renamed |
newname |
string |
new name of column |
|
|
Method: removecols |
remove one or more columns |
columnames |
stringArray |
names of columns to be removed |
|
|
Method: iscelldefined |
test if a specific cell contains a value |
columnname |
string |
Name of column |
rownr |
int |
Row number, starting at 0 |
|
|
Method: getcell |
get a specific cell |
columnname |
string |
Name of column |
rownr |
int |
Row number, starting at 1 |
|
|
Method: getcellslice |
get a slice from a specific cell |
columnname |
string |
Name of column |
rownr |
int |
Row number, starting at 0 |
blc |
intArray |
Bottom left corner (e.g. [1,1,1] is start of 3D array) |
trc |
intArray |
Top right corner |
incr |
intArray |
Stride (defaults to 1 for all axes) |
|
|
Method: getcol |
get a specific column |
columnname |
string |
Name of column |
startrow |
int |
First row to read (default 0) |
nrow |
int |
Number of rows to read (default -1 means till the end) |
rowincr |
int |
Increment in rows to read (default 1) |
|
|
Method: getvarcol |
get a specific column (for variable arrays) |
columnname |
string |
Name of column |
startrow |
int |
First row to read (default 1) |
nrow |
int |
Number of rows to read (default -1 means till the end) |
rowincr |
int |
Increment in rows to read (default 1) |
|
|
Method: getcolslice |
get a slice from a specific columnarray |
columnname |
string |
Name of column |
blc |
intArray |
Bottom left corner (e.g. [1,1,1] is start of 3D array) |
trc |
intArray |
Top right corner |
incr |
intArray |
Stride (defaults to 1 for all axes) |
startrow |
int |
First row to read (default 1) |
nrow |
int |
Number of rows to read (default -1 means till the end) |
rowincr |
int |
Increment in rows to read (default 1) |
|
|
Method: putcell |
put a specific cell |
columnname |
string |
Name of column |
rownr |
intArray |
Row number(s) (0-relative) |
thevalue |
any |
Value |
|
|
Method: putcellslice |
put a slice into a specific cell |
columnname |
string |
Name of column |
rownr |
int |
Row number, starting at 0 |
value |
any |
Value |
blc |
intArray |
Bottom left corner (e.g. [1,1,1] is start of 3D array) |
trc |
intArray |
Top right corner |
incr |
intArray |
Stride (defaults to 1 for all axes) |
|
|
Method: putcol |
put a specific column |
columnname |
string |
Name of column |
value |
any |
Array |
startrow |
int |
First row to put (default 1) |
nrow |
int |
Number of rows to put (default -1 means till the end) |
rowincr |
int |
Increment in rows to put (default 1) |
|
|
Method: putvarcol |
put a specific column (for variable arrays) |
columnname |
string |
Name of column |
value |
any |
Record with values |
startrow |
int |
First row to put (default 1) |
nrow |
int |
Number of rows to put (default -1 means till the end) |
rowincr |
int |
Increment in rows to put (default 1) |
|
|
Method: putcolslice |
put a slice into a specific column |
columnname |
string |
Name of column |
value |
any |
Array |
blc |
intArray |
Bottom left corner (e.g. [1,1,1] is start of 3D array) |
trc |
intArray |
Top right corner |
incr |
intArray |
Stride (defaults to 1 for all axes) |
startrow |
int |
First row to put (default 1) |
nrow |
int |
Number of rows to put (default -1 means till the end) |
rowincr |
int |
Increment in rows to put (default 1) |
|
|
Method: getcolshapestring |
get shape of arrays in a specific column |
columnname |
string |
Name of column |
startrow |
int |
First row to read (default 1) |
nrow |
int |
Number of rows to read (default -1 means till the end) |
rowincr |
int |
Increment in rows to read (default 1) |
|
|
Method: getkeyword |
get value of specific table keyword |
keyword |
any |
Name or seqnr of keyword, string or int |
|
|
Method: getkeywords |
get values of all table keywords |
|
|
Method: getcolkeyword |
get value of specific column keyword |
columnname |
string |
Name of column |
keyword |
any |
Name or seqnr of keyword, string or int |
|
|
Method: getcolkeywords |
get values of all keywords for a column |
columnname |
string |
Name of column |
|
|
Method: putkeyword |
put a specific table keyword |
keyword |
any |
Name or seqnr of keyword, string or in |
value |
any |
Value of keyword |
makesubrecord |
bool |
Create intermediate records |
|
|
Method: putkeywords |
put multiple table keywords |
value |
any |
Record of keyword=value pairs |
|
|
Method: putcolkeyword |
put a specific keyword for a column |
columnname |
string |
Name of column |
keyword |
any |
Name or seqnr of keyword,string or int |
value |
any |
Value of keyword |
|
|
Method: putcolkeywords |
put multiple keywords for a column |
columnname |
string |
Name of column |
value |
any |
Record of keyword=value pairs |
|
|
Method: removekeyword |
remove a specific table keyword |
keyword |
any |
Name or seqnr of keyword, string or int |
|
|
Method: removecolkeyword |
remove a specific keyword for a column |
columnname |
string |
Name of column |
keyword |
any |
Name or seqnr of keyword, string or int |
|
|
Method: getdminfo |
get the info about data managers |
|
|
Method: keywordnames |
get the names of all table keywords |
|
|
Method: fieldnames |
get the names of fields in a table keyword |
keyword |
string |
keyword name |
|
|
Method: colkeywordnames |
get the names of all keywords in a column |
columnname |
string |
column name |
|
|
Method: colfieldnames |
get the names of fields in a keyword in a column |
columnname |
string |
column name |
keyword |
string |
keyword name |
|
|
Method: getdesc |
get the table description |
actual |
bool |
actual table description? |
|
|
Method: getcoldesc |
get the description of a specific column |
columnname |
string |
Name of column |
|
|
Method: ok |
Is the table tool ok? |
|
|