Macro is a unified workspace for teams: email, chat, docs, tasks, agents, calls, and CRM — @-linked together with shared AI memory.
TypeScript agentaiai-agentsall-in-onecrmcrm-systememaillinearmcpmessagingnotesnotionofficerustslackslack-alternativestartupstartup-toolstypescriptworkspace
import { throwOnErr } from '@core/util/result';
import { storageServiceClient } from '@service-storage/client';
import type { ColumnCast as ServerColumnCast } from '@service-storage/generated/schemas/columnCast';
import { queryOptions, useQuery } from '@tanstack/solid-query';
import type { Accessor } from 'solid-js';
import { match } from 'ts-pattern';
import type {
DatabaseColumnCast,
DatabaseColumnCasts,
DatabaseColumnCastsSource,
} from '../../database/core/column-schema';
import { databaseColumnKeys } from './keys';
function columnCastsQueryOptions(
databaseId: string,
tableId: string,
columnId: string,
version: number,
enabled: boolean
) {
return queryOptions({
queryKey: databaseColumnKeys.casts(databaseId, tableId, columnId, version)
.queryKey,
queryFn: () =>
throwOnErr(() =>
storageServiceClient.databases.columnCasts({
id: databaseId,
tableId,
columnId,
})
),
enabled,
select: (casts: ServerColumnCast[]) => ({
version,
casts: casts.map(toMenuCast),
}),
});
}
/** The type menu's dry runs for one table, fetched when a menu opens. */
export function createColumnCasts(params: {
databaseId: string;
tableId: string;
version: Accessor<number>;
}): DatabaseColumnCastsSource {
return (columnId, open) => {
const query = useQuery(() =>
columnCastsQueryOptions(
params.databaseId,
params.tableId,
columnId,
params.version(),
open()
)
);
// Gated on status: an unopened menu's query is pending and must not suspend.
return (): DatabaseColumnCasts =>
query.isSuccess
? { status: 'ready', ...query.data }
: query.isError
? { status: 'error' }
: { status: 'loading' };
};
}
function toMenuCast(cast: ServerColumnCast) {
return {
target: {
dataType: cast.data_type,
isMultiSelect: cast.is_multi_select,
specificEntityType: cast.specific_entity_type ?? undefined,
relation: cast.relation,
},
cast: match(cast.cast)
.returnType<DatabaseColumnCast>()
.with('safe', () => ({ verdict: 'safe' }))
.with('checked', () => ({
verdict: 'checked',
failures: cast.failures,
summary: cast.summary ?? undefined,
examples: cast.examples,
}))
.with('never', () => ({ verdict: 'never', reason: cast.reason ?? '' }))
.exhaustive(() => ({ verdict: 'never', reason: cast.reason ?? '' })),
};
}