The best way to control Claude Code, Codex and more from any computer or phone

main
ts 86 lines 3.13 KB
Raw
1 import type { MySQLConfig } from "@alchemy.run/sql/MySQL";
2 // `@effect/sql-mysql2` (and mysql2 underneath) are optional peers — value
3 // imports are deferred to first use so `@alchemy.run/drizzle` resolves without
4 // them installed.
5 import type * as MysqlClient from "@effect/sql-mysql2/MysqlClient";
6 import { makeExecutionMemo } from "alchemy/Runtime/ExecutionMemo";
7 import { proxyChain } from "alchemy/Util/proxy-chain";
8 import type { AnyRelations, EmptyRelations } from "drizzle-orm";
9 import type { EffectMysql2Database } from "drizzle-orm/effect-mysql2";
10 import type { EffectDrizzleMySqlConfig } from "drizzle-orm/mysql-core/effect/utils";
11 import * as Effect from "effect/Effect";
12 import * as Layer from "effect/Layer";
13 import type * as Redacted from "effect/Redacted";
14
15 /**
16 * Open a Drizzle/MySQL database from a connection URL using the
17 * `drizzle-orm/effect-mysql2` integration.
18 *
19 * ```typescript
20 * const conn = yield* Cloudflare.Hyperdrive.Connect(Hyperdrive);
21 * const db = yield* Drizzle.MySQL(conn.connectionString, { relations });
22 *
23 * fetch: Effect.gen(function* () {
24 * const rows = yield* db.select().from(users);
25 * });
26 * ```
27 *
28 * The pool opens on the first query of an execution, is reused for every
29 * query in it, and closes when the event settles (see
30 * {@link makeExecutionMemo}); plan/deploy never connect. Workers defaults
31 * ({@link resolveMySQLConfig}) are overridden via `config.client`:
32 *
33 * ```typescript
34 * const db = yield* Drizzle.MySQL(connectionString, {
35 * relations,
36 * client: { poolConfig: { ssl: { rejectUnauthorized: true } } },
37 * });
38 * ```
39 *
40 * @binding
41 */
42 export const MySQL = <TRelations extends AnyRelations = EmptyRelations, E = never, R = never>(
43 connectionString: Effect.Effect<Redacted.Redacted<string>, E, R>,
44 config?: EffectDrizzleMySqlConfig<TRelations> & {
45 /**
46 * Overrides for the underlying `@effect/sql-mysql2` client — pool
47 * options (e.g. `poolConfig.ssl` for a direct TLS connection),
48 * `disablePreparedStatements`, `maxConnections`, and friends.
49 */
50 readonly client?: Omit<MySQLConfig, "url">;
51 },
52 ) =>
53 Effect.map(
54 makeExecutionMemo(
55 Effect.gen(function* () {
56 const [MysqlClient, MySqlDrizzle, { resolveMySQLConfig }] = yield* Effect.promise(() =>
57 Promise.all([
58 import("@effect/sql-mysql2/MysqlClient"),
59 import("drizzle-orm/effect-mysql2"),
60 import("@alchemy.run/sql/MySQL"),
61 ]),
62 );
63 const { client, ...drizzleConfig } = config ?? {};
64 const mysqlCtx = yield* Layer.build(
65 MysqlClient.layer(yield* resolveMySQLConfig({ ...client, url: connectionString })),
66 );
67 return yield* MySqlDrizzle.makeWithDefaults(
68 drizzleConfig as EffectDrizzleMySqlConfig<TRelations>,
69 ).pipe(Effect.provideContext(mysqlCtx));
70 }),
71 ),
72 (db) =>
73 proxyChain<
74 EffectMysql2Database<TRelations> & {
75 $client: MysqlClient.MysqlClient;
76 }
77 >(
78 db as Effect.Effect<
79 EffectMysql2Database<TRelations> & {
80 $client: MysqlClient.MysqlClient;
81 },
82 any,
83 any
84 >,
85 ),
86 );