Skip to main content

loadOne

Similar to DataLoader's load method, uses the given callback function to read a single result from your business logic layer. To load a list, see loadMany.

Enhancements over DataLoader​

Thanks to the planning system in Grafast, loadOne can expose features that are not possible in DataLoader.

Attribute and parameter tracking​

A loadOne step (technically a LoadedRecordStep) keeps track of the attribute names accessed via .get(attrName) and any parameters set via .setParam(key, value). This information will be passed through to your callback function such that you may make more optimal calls to your backend business logic, only retrieving the data you need.

Input/output equivalence​

If you (optionally) pass an ioEquivalence parameter to loadOne then you can use it to indicate which field(s) on the output is equivalent to the input(s). This enables an optimization where a chained fetch can instead be performed in parallel if the child only depends on an output which is equivalent to an input. Hopefully an example will make this clearer...

Imagine you're loading a user and their organization:

{
  currentUser {
    id
    name
    friends {
      id
      name
    }
  }
}

You might have plan resolvers such as:

const objects = {
  Query: {
    plans: {
      currentUser() {
        const $currentUserId = context().get("userId");
        return loadOne($currentUserId, {
          load: batchGetUserById,
        });
      },
    },
  },
  User: {
    plans: {
      friends($user) {
        const $userId = $user.get("id");
        return loadMany($userId, batchGetFriendsByUserId);
      },
    },
  },
};

In its current state the system doesn't know that the $user.get("id") is equivalent to the context().get("userId"), so this would result in a chained fetch:

However, we can indicate that the output of the loadOne step's id property ($user.get("id")) is equivalent to its input (context().get("userId")):

 const objects = {
   Query: {
     plans: {
       currentUser() {
         const $currentUserId = context().get("userId");
         return loadOne($currentUserId, {
           load: batchGetUserById,
+          ioEquivalence: "id",
         });
       },
     },
   },
   User: {
     plans: {
       friends($user) {
         const $userId = $user.get("id");
         return loadMany($userId, batchGetFriendsByUserId);
       },
     },
   },
 };

Now the access to $user.get("id") will be equivalent to context().get("userId") - we no longer need to wait for the $user to load in order to fetch the friends:

Usage​

function loadOne(options: {
  lookup: Step | Step[] | Record<string, Step>;
  load: LoadOneCallback;
  ioEquivalence?: string | Record<string, string>;
  shared?: Step | Step[] | Record<string, Step>;
}): Step;
type LoadOneCallback = (
  specs: TLookup[],
  info: LoadOneInfo,
) => PromiseOrDirect<TResult[]>;
interface LoadOneInfo {
  shared: TShared;
  attributes: string[];
  params: Readonly<string, any>;
}

loadOne accepts an options object accepting 2-4 attributes:

  • lookup (mostly required) - the step (or multistep) that specifies which records to load - only not required when the load function can load data without requiring identification.
  • load (required) - the callback function called with the values from lookup responsible for loading the associated records
  • $shared (optional) - any unary step (or multistep), useful for passing things from context or arguments without complicating the lookup; see Shared step usage below
  • ioEquivalence (optional, advanced) - a string, an array of strings, or a string-string object map used to indicate which attributes on output are equivalent of those on input - see ioEquivalence usage below

Callback​

The callback function is called with two arguments, the first is a list of the values from the specifier step $spec and the second is options that may affect the fetching of the records.

function callback(
  specs: ReadonlyArray<unknown>,
  options: {
    shared: unknown;
    attributes: ReadonlyArray<string>;
    params: Record<string, unknown>;
  },
): PromiseOrDirect<ReadonlyArray<unknown>>;
tip

For optimal results, we strongly recommend that the callback function is defined in a common location so that it can be reused over and over again, rather than defined inline. This will allow the underlying steps to optimize calls to this function.

Within this definition of callback:

  • specs is the runtime values of each value that $spec represented
  • options is an object containing:
    • shared: the runtime value that $shared (if any) represented
    • attributes: the list of keys that have been accessed via $record.get('<key>')
    • params: the params set via $record.setParam('<key>', <value>)

specs is deduplicated using strict equality; so it is best to keep $spec simple - typically it should only represent a single scalar value - which is why $shared exists.

options.shared is very useful to keep specs simple (so that fetch deduplication can work optimally) whilst passing in global values that you may need such as a database or API client.

options.attributes is useful for optimizing your fetch - e.g. if the user only ever requested $record.get('id') and $record.get('avatarUrl') then there's no need to fetch all the other attributes from your datasource.

options.params can be used to pass additional context to your callback function, perhaps options like "should we include archived records" or "should we expand 'customer' into a full object rather than just returning the identifier".

Basic usage​

const $userId = $post.get("author_id");
const $user = loadOne($userId, batchGetUserById);

An example of the callback function might be:

async function batchGetUserById(ids, { attributes }) {
  // Your business logic would be called here; e.g. this might be the same
  // function that your DataLoaders would call, except we can pass additional
  // information to it.

  // For example, load from the database
  const rows = await db.query(
    sql`SELECT id, ${columnsToSql(attributes)} FROM users WHERE id = ANY($1);`,
    [ids],
  );

  // Ensure you return the same number of results, and in the same order!
  return ids.map((id) => rows.find((row) => row.id === id));
}

Shared step usage​

info

A unary step is a step that only ever represents one value, e.g. simple derivatives of context(), fieldArgs, or constant().

In addition to the forms seen in "Basic usage" above, you can pass an additional shared step to loadOne. This step must be a unary step, meaning that it must represent exactly one value across the entire request (not a batch of values like most steps), and is useful for representing values from the GraphQL context or from input values (arguments, variables, etc).

const $userId = $post.get("author_id");
const $dbClient = context().get("dbClient");
const $user = loadOne($userId, {
  load: batchGetUserFromDbById,
  shared: $dbClient,
  // optional:
  ioEquivalence: "id",
});

Since we know it will have exactly one value, we can pass it into the callback as a single value and our callback will be able to use it directly without having to perform any manual grouping.

This shared dependency is useful for fixed values (for example, those from GraphQL field arguments) and values on the GraphQL context such as clients to various APIs and other data sources.

An example of the callback function might be:

async function batchGetUserFromDbById(ids, { attributes, shared }) {
  const dbClient = shared;

  const rows = await dbClient.query(
    sql`SELECT id, ${columnsToSql(attributes)} FROM users WHERE id = ANY($1);`,
    [ids],
  );

  return ids.map((id) => rows.find((row) => row.id === id));
}

ioEquivalence usage​

The ioEquivalence optional parameter can accept the following values:

  • null to indicate no input/output equivalence
  • a string to indicate that the same named property on the output is equivalent to the entire input plan
  • if the step is a list() (or similar) plan, an array containing a list of keys (or null for no relation) on the output that are equivalent to the same entry in the input
  • if the step is a object() (or similar) plan, an object that maps between the attributes of the object and the key(s) in the output that are equivalent to the given entry on the input
Example for a list step
const $member = loadOne([$organizationId, $userId], {
  load: batchGetMemberByOrganizationIdAndUserId,
  ioEquivalence: ["organization_id", "user_id"],
});

// - batchGetMemberByOrganizationIdAndUserId will be called with a list of
//   2-tuples, the first value in each tuple being the organizationId and the
//   second the userId.
// - Due to the io equivalence (2nd argument):
//   - `$member.get("organization_id")` will return `$organizationId` directly
//   - `$member.get("user_id")` will return `$userId` directly
Example for an object step
const $member = loadOne(
  { oid: $organizationId, uid: $userId },
  {
    load: batchGetMemberByOrganizationIdAndUserId,
    ioEquivalence: { oid: "organization_id", uid: "user_id" },
  },
);

// - batchGetMemberByOrganizationIdAndUserId will be called with a list of
//   objects; each object will have the key `oid` set to an organization id,
//   and the key `uid` set to the user ID.
// - Due to the io equivalence (2nd argument):
//   - `$member.get("organization_id")` will return the step used for `oid`
//     (i.e. `$organizationId`) directly
//   - Similarly `$member.get("user_id")` will return `$userId` directly

Passing multiple steps​

The list() or object() step can be used if you need to pass the value of more than one step into your callback:

const $isAdmin = $user.get("admin");
const $stripeId = $customer.get("stripe_id");
const $last4 = loadOne([$isAdmin, $stripeId], getLast4FromStripeIfAdmin);

The first argument to the getLast4FromStripeIfAdmin callback will then be an array of all the tuples of values from these plans: ReadonlyArray<readonly [isAdmin: boolean, stripeId: string]>. The callback might look something like:

async function getLast4FromStripeIfAdmin(tuples) {
  const stripeIds = uniq(
    tuples
      .filter(([isAdmin, stripeId]) => isAdmin)
      .map(([isAdmin, stripeId]) => stripeId),
  );
  const last4s = await getLast4FromStripeIds(stripeIds);

  return tuples.map(([isAdmin, stripeId]) => {
    if (!isAdmin) return null;
    const index = stripeIds.indexOf(stripeId);
    return last4s[index];
  });
}

This technique can also be used with the shared step in advanced usage.

Performance impact from using list/object

Using list() / object() like this will likely reduce the effectiveness of loadOne's built in deduplication; to address this a stable object/list is required - please track this issue: https://github.com/graphile/crystal/issues/2170