MCPcopy Create free account
hub / github.com/UsefulSoftwareCo/executor / queryCollection

Function queryCollection

packages/core/sdk/src/executor.ts:1725–1779  ·  view source on GitHub ↗
(
    definition: TDefinition,
    queryInput?: PluginStorageCollectionQueryInput<TDefinition>,
  )

Source from the content-addressed store, hash-verified

1723 });
1724
1725 const queryCollection = <TDefinition extends PluginStorageCollectionDefinition>(
1726 definition: TDefinition,
1727 queryInput?: PluginStorageCollectionQueryInput<TDefinition>,
1728 ) =>
1729 Effect.gen(function* () {
1730 const validationError = pluginStorageQueryValidationError(
1731 definition,
1732 queryInput as
1733 | PluginStorageCollectionQueryInput<PluginStorageCollectionDefinition>
1734 | undefined,
1735 );
1736 if (validationError) return yield* validationError;
1737
1738 const rows = yield* input.core.findMany("plugin_storage", {
1739 where: whereFor(definition.name),
1740 });
1741 const filtered = sortByOwnerPrecedence(rows)
1742 .filter((row) =>
1743 queryInput?.keyPrefix === undefined ? true : row.key.startsWith(queryInput.keyPrefix),
1744 )
1745 .filter((row) =>
1746 rowMatchesPluginStorageWhere(
1747 row,
1748 queryInput?.where as Readonly<Record<string, unknown>> | undefined,
1749 ),
1750 );
1751
1752 const sorted =
1753 queryInput?.orderBy && queryInput.orderBy.length > 0
1754 ? [...filtered].sort((left, right) => {
1755 for (const order of queryInput.orderBy ?? []) {
1756 const direction = order.direction === "desc" ? -1 : 1;
1757 const compared =
1758 comparePluginStorageValues(
1759 pluginStorageDataField(left.data, order.field),
1760 pluginStorageDataField(right.data, order.field),
1761 ) * direction;
1762 if (compared !== 0) return compared;
1763 }
1764 return (
1765 ownerRank(left.owner as Owner) - ownerRank(right.owner as Owner) ||
1766 left.key.localeCompare(right.key)
1767 );
1768 })
1769 : filtered;
1770
1771 const offset = queryInput?.offset ?? 0;
1772 const limited =
1773 queryInput?.limit === undefined
1774 ? sorted.slice(offset)
1775 : sorted.slice(offset, offset + queryInput.limit);
1776 return limited.map((row) =>
1777 pluginStorageEntryFromRow<PluginStorageCollectionData<TDefinition>>(row),
1778 );
1779 });
1780
1781 return {
1782 collection: (definition) => ({

Callers 1

makePluginStorageFacadeFunction · 0.85

Calls 8

whereForFunction · 0.85
sortByOwnerPrecedenceFunction · 0.85
pluginStorageDataFieldFunction · 0.85
ownerRankFunction · 0.70

Tested by

no test coverage detected