The GetAll command retrieves all rows from a PersistentTable object that satisfy all of the specified conditions. The result is a set of lists, one for each row. Each such list contains all values for one row.

The GetKeys command retrieves all rows from a PersistentTable object that satisfy all of the specified conditions. The result is a set of lists, one for each row. Each such list contains the primary key values for one row. This can be considerably faster than the GetAll command if there are many columns outside the primary key and many rows in the result.

The Count command counts all rows from a PersistentTable object that satisfy all of the specified conditions. The returned value is the number of such rows.

Each condition must have one of the following forms:

expr1 = expr2,  expr1 <> expr2, expr1 < expr2, expr1 > expr2, expr1 <= expr2, expr1 >= expr2

where expr1 and expr2 are polynomial expressions in the column names of connection of types integer or float. These conditions are evaluated in the SQLite database engine, so Maple's standard rules for precision in floating-point arithmetic are not followed.

c = expr, c <> expr

where c is a column name of connection of type anything or boolean. Boolean columns can only be compared to the constants true and false.

If you expect a particular query to occur frequently, it can be very beneficial to add a suitable index. See the Open command for how to do that.

Persistent tables are in general thread safe as of Maple 2021; see the Thread Safety section of the PersistentTable overview page for more details and caveats.

For more information on thread safety, see index/threadsafe.

$\mathrm{with}\left(\mathrm{PersistentTable}\right)$

$\left[\mathrm{Close}\&comma;\mathrm{Count}\&comma;\mathrm{Get}\&comma;\mathrm{GetAll}\&comma;\mathrm{GetKeys}\&comma;\mathrm{Has}\&comma;\mathrm{MaybeGet}\&comma;\mathrm{Open}\&comma;\mathrm{RawCommand}\&comma;\mathrm{Set}\right]$

$\mathrm{connection}≔\mathrm{Open}\left('':memory:''\&comma;\mathrm{style}=\left[\mathrm{k1}::\mathrm{anything}\&comma;\mathrm{k2}::\mathrm{integer}\&comma;\mathrm{v1}::\mathrm{anything}\&comma;\mathrm{v2}::\mathrm{integer}\&comma;\mathrm{primarykey}=2\right]\right)$

$\mathrm{connection}≔\mathrm{<<\; 4-column\; persistent\; table\; at\; :memory:\; >>}$

$\mathrm{connection}\left[x,3\right]≔y^2,4$

${\mathrm{connection}}_{x,3}≔y^2,4$

$\mathrm{connection}\left[z,5\right]≔y^3,5$

${\mathrm{connection}}_{z,5}≔y^3,5$

$\mathrm{connection}\left[a,4\right]≔1,6$

${\mathrm{connection}}_{a,4}≔1,6$

$\mathrm{connection}\left[b,5\right]≔y^6,7$

${\mathrm{connection}}_{b,5}≔y^6,7$

$\mathrm{GetAll}\left(\mathrm{connection}\right)$

$\left\{\left[a\&comma;4\&comma;1\&comma;6\right]\&comma;\left[b\&comma;5\&comma;y^6\&comma;7\right]\&comma;\left[x\&comma;3\&comma;y^2\&comma;4\right]\&comma;\left[z\&comma;5\&comma;y^3\&comma;5\right]\right\}$

$\mathrm{GetKeys}\left(\mathrm{connection}\right)$

$\left\{\left[a\&comma;4\right]\&comma;\left[b\&comma;5\right]\&comma;\left[x\&comma;3\right]\&comma;\left[z\&comma;5\right]\right\}$

$\mathrm{Count}\left(\mathrm{connection}\right)$

$4$

$\mathrm{GetAll}\left(\mathrm{connection}\&comma;\mathrm{v1}=y^3\right)$

$\left\{\left[z\&comma;5\&comma;y^3\&comma;5\right]\right\}$

$\mathrm{GetKeys}\left(\mathrm{connection}\&comma;\mathrm{v1}=y^3\right)$

$\left\{\left[z\&comma;5\right]\right\}$

$\mathrm{Count}\left(\mathrm{connection}\&comma;\mathrm{v1}=y^3\right)$

$1$

$\mathrm{GetAll}\left(\mathrm{connection}\&comma;100<\mathrm{k2}{\mathrm{v2}}^2\&comma;\mathrm{k1}\ne a\right)$

$\left\{\left[b\&comma;5\&comma;y^6\&comma;7\right]\&comma;\left[z\&comma;5\&comma;y^3\&comma;5\right]\right\}$

$\mathrm{GetKeys}\left(\mathrm{connection}\&comma;100<\mathrm{k2}{\mathrm{v2}}^2\&comma;\mathrm{k1}\ne a\right)$

$\left\{\left[b\&comma;5\right]\&comma;\left[z\&comma;5\right]\right\}$

$\mathrm{Count}\left(\mathrm{connection}\&comma;100<\mathrm{k2}{\mathrm{v2}}^2\&comma;\mathrm{k1}\ne a\right)$

$2$

$\mathrm{Close}\left(\mathrm{connection}\right)$

The PersistentTable[GetAll], PersistentTable[GetKeys] and PersistentTable[Count] commands were introduced in Maple 2021.

For more information on Maple 2021 changes, see Updates in Maple 2021.