MergeContextWithJoinType

type MergeContextWithJoinType<TContext, TNewSchema, TJoinType> = Omit<TContext, "schema" | "refsSchema" | "hasJoins" | "joinTypes"> & object;

Defined in: packages/db/src/query/builder/types.ts:983

MergeContextWithJoinType - Creates a new context after a join operation

This is the core type that handles the complex logic of merging schemas when tables are joined, applying the correct optionality based on join type.

Key Responsibilities:

1. Schema Merging: Combines existing schema with newly joined tables
2. Optionality Logic: Applies join-specific optionality rules:
   • LEFT JOIN: New table becomes optional
   • RIGHT JOIN: Existing tables become optional
   • FULL JOIN: Both existing and new become optional
   • INNER JOIN: No tables become optional
3. State Tracking: Updates hasJoins and joinTypes for future operations

Context Evolution:

• baseSchema: Unchanged (always the original from() tables)
• schema: Expanded with new tables and proper optionality
• hasJoins: Set to true
• joinTypes: Updated to track this join type
• result: Preserved from previous operations
• All other context state is preserved

Type Declaration

baseSchema

baseSchema: TContext["baseSchema"];

fromSourceName

fromSourceName: TContext["fromSourceName"];

hasJoins

hasJoins: true;

joinTypes

joinTypes: TContext["joinTypes"] extends Record<string, any> ? TContext["joinTypes"] : object & { [K in keyof TNewSchema & string]: TJoinType };

refsSchema

refsSchema: ApplyJoinOptionalityToMergedSchema<RefsSchemaForContext<TContext>, TNewSchema, TJoinType, FromSourceNamesForOptionality<TContext>>;

schema

schema: ApplyJoinOptionalityToMergedSchema<TContext["schema"], TNewSchema, TJoinType, FromSourceNamesForOptionality<TContext>>;

Type Parameters

TContext

TContext extends Context

TNewSchema

TNewSchema extends ContextSchema

TJoinType

TJoinType extends "inner" | "left" | "right" | "full" | "outer" | "cross"