Function insert

  • insert<
        I extends RowLikeStrict,
        TS extends TableSchema,
        K extends string | number | symbol,
        R extends object = I,
        V extends
        
                | {
                    [K in string
                    | number
                    | symbol as TS[K]["required"] extends true ? K : never]: InstanceType<
                        TS[K]["type"],
                    >
                } & Partial<
                    {
                        [K in string
                        | number
                        | symbol as TS[K]["required"] extends false ? K : never]: InstanceType<
                            TS[K]["type"],
                        >
                    },
                >
                | {
                    [K in string
                    | number
                    | symbol]: (
                        {
                            [K in string
                            | number
                            | symbol as TS[K]["required"] extends true ? K : never]: InstanceType<
                                TS[K]["type"],
                            >
                        } & Partial<
                            {
                                [K in string
                                | number
                                | symbol as TS[K]["required"] extends false ? K : never]: InstanceType<
                                    TS[K]["type"],
                                >
                            },
                        >
                    )[K]
                } = Expand<
            {
                [K in string
                | number
                | symbol as TS[K]["required"] extends true ? K : never]: InstanceType<
                    TS[K]["type"],
                >
            } & Partial<
                {
                    [K in string
                    | number
                    | symbol as TS[K]["required"] extends false ? K : never]: InstanceType<
                        TS[K]["type"],
                    >
                },
            >,
        >,
    >(
        tableClause: {
            into: Table<I, TS>;
            overriding?: ["system" | "user", "value"];
        },
        values?: Values<V> | Select<V, any, any> | "defaultValues",
        opts?: { onConflict?: OnConflictInput<I>; returning?: (insertRow: I) => R },
    ): Insert<I, TS, K, R, V>

    Type Parameters

    • I extends RowLikeStrict
    • TS extends TableSchema
    • K extends string | number | symbol
    • R extends object = I
    • V extends
          | {
              [K in string
              | number
              | symbol as TS[K]["required"] extends true ? K : never]: InstanceType<
                  TS[K]["type"],
              >
          } & Partial<
              {
                  [K in string
                  | number
                  | symbol as TS[K]["required"] extends false ? K : never]: InstanceType<
                      TS[K]["type"],
                  >
              },
          >
          | {
              [K in string
              | number
              | symbol]: (
                  {
                      [K in string
                      | number
                      | symbol as TS[K]["required"] extends true ? K : never]: InstanceType<
                          TS[K]["type"],
                      >
                  } & Partial<
                      {
                          [K in string
                          | number
                          | symbol as TS[K]["required"] extends false ? K : never]: InstanceType<
                              TS[K]["type"],
                          >
                      },
                  >
              )[K]
          } = Expand<
          {
              [K in string
              | number
              | symbol as TS[K]["required"] extends true ? K : never]: InstanceType<
                  TS[K]["type"],
              >
          } & Partial<
              {
                  [K in string
                  | number
                  | symbol as TS[K]["required"] extends false ? K : never]: InstanceType<
                      TS[K]["type"],
                  >
              },
          >,
      >

    Parameters

    • tableClause: { into: Table<I, TS>; overriding?: ["system" | "user", "value"] }
    • Optionalvalues: Values<V> | Select<V, any, any> | "defaultValues"
    • Optionalopts: { onConflict?: OnConflictInput<I>; returning?: (insertRow: I) => R }

    Returns Insert<I, TS, K, R, V>

Settings

Member Visibility