Repository navigation
Expand file tree
/
Copy pathsqlite-driver.ts
More file actions
72 lines (63 loc) · 2.41 KB
/
Copy pathsqlite-driver.ts
File metadata and controls
72 lines (63 loc) · 2.41 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
import sqlite3 from "sqlite3"
import { Effect, Layer } from "effect"
import {
SqliteDriver,
SqliteDriverBusy,
type SqliteBinding,
type SqliteConnection,
type SqliteDriverError,
type SqliteDriverService,
SqliteDriverFailure,
} from "@magnitudedev/daemon-management/sqlite-driver"
interface Sqlite3Error extends Error {
readonly code: string
}
const isSqlite3Error = (error: Error): error is Sqlite3Error =>
"code" in error && typeof error.code === "string"
const failure = (error: Error): SqliteDriverError =>
isSqlite3Error(error) && error.code === "SQLITE_BUSY"
? new SqliteDriverBusy()
: new SqliteDriverFailure({ message: error.message })
const execute = (
database: sqlite3.Database,
sql: string,
bindings: readonly SqliteBinding[],
): Effect.Effect<void, SqliteDriverError> => Effect.async((resume) => {
database.run(sql, [...bindings], (error) => resume(error === null
? Effect.void
: Effect.fail(failure(error))))
return Effect.sync(() => database.interrupt())
})
const query = (
database: sqlite3.Database,
sql: string,
bindings: readonly SqliteBinding[],
): Effect.Effect<readonly unknown[], SqliteDriverError> => Effect.async((resume) => {
database.all(sql, [...bindings], (error, rows) => resume(error === null
? Effect.succeed(rows)
: Effect.fail(failure(error))))
return Effect.sync(() => database.interrupt())
})
const close = (database: sqlite3.Database): Effect.Effect<void> =>
Effect.async((resume) => {
database.close((error) => resume(error === null ? Effect.void : Effect.die(error)))
})
const connection = (database: sqlite3.Database): SqliteConnection => ({
execute: (sql, bindings = []) => execute(database, sql, bindings),
query: (sql, bindings = []) => query(database, sql, bindings),
})
export const NodeSqliteDriver: SqliteDriverService = {
open: (path, options) => Effect.acquireRelease(
Effect.async<sqlite3.Database, SqliteDriverFailure>((resume) => {
const mode = sqlite3.OPEN_READWRITE | (options.create ? sqlite3.OPEN_CREATE : 0)
const database = new sqlite3.Database(path, mode, (error) => resume(error === null
? Effect.succeed(database)
: Effect.fail(new SqliteDriverFailure({
message: error.message,
}))))
return Effect.sync(() => database.close())
}),
close,
).pipe(Effect.map(connection)),
}
export const NodeSqliteDriverLayer = Layer.succeed(SqliteDriver, NodeSqliteDriver)