Co-authored-by: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
62 KiB
@effect/sql
0.10.1
Patch Changes
- Updated dependencies [
79859e7,f6a469c,dcb9ec0,79aa6b1]:- effect@3.7.1
- @effect/experimental@0.24.1
- @effect/platform@0.63.1
- @effect/schema@0.72.1
0.10.0
Patch Changes
- Updated dependencies [
db89601,2f456cc,8745e41,e557838,d6e7e40,8356321,192f2eb,718cb70,e9d0310,6bf28f7]:- effect@3.7.0
- @effect/platform@0.63.0
- @effect/experimental@0.24.0
- @effect/schema@0.72.0
0.9.7
Patch Changes
- Updated dependencies [
e809286]:- effect@3.6.8
- @effect/experimental@0.23.7
- @effect/platform@0.62.5
- @effect/schema@0.71.4
0.9.6
Patch Changes
- Updated dependencies [
e7a65e3,50ec889]:- @effect/platform@0.62.4
- effect@3.6.7
- @effect/experimental@0.23.6
- @effect/schema@0.71.3
0.9.5
Patch Changes
- Updated dependencies [
f960bf4,46a575f]:- effect@3.6.6
- @effect/experimental@0.23.5
- @effect/platform@0.62.3
- @effect/schema@0.71.2
0.9.4
Patch Changes
-
#3483
35be739Thanks @tim-smart! - infer Model repository id schema from id column name -
#3480
f8326ccThanks @tim-smart! - add Model.makeDataLoaders, for deriving CRUD data loaders -
#3488
8dd3959Thanks @tim-smart! - move VariantSchema.extract to factory, and copy type level behaviour -
#3477
2cb6ebbThanks @tim-smart! - update Model docs categories -
#3476
5e9f51eThanks @tim-smart! - add Model.FieldOption, for optional fields that are nullable for the db -
#3479
83a108aThanks @tim-smart! - add Model.makeRepository, for deriving a simple CRUD repo -
#3493
f2c8dbbThanks @tim-smart! - add VariantSchema.Union constructor -
#3476
5e9f51eThanks @tim-smart! - add Model.Date, a schema which represents a DateTime.Utc without time -
Updated dependencies [
00670d0,413994c,14a47a8,0c09841,8dd3959,dba570a,f2c8dbb,da52556]:- @effect/experimental@0.23.4
- @effect/platform@0.62.2
- effect@3.6.5
- @effect/schema@0.71.1
0.9.3
Patch Changes
0.9.2
Patch Changes
-
#3467
cfcfbdfThanks @tim-smart! - add VariantSchema.fields for accessing the fields -
Updated dependencies [
cfcfbdf]:
0.9.1
Patch Changes
-
#3455
e9da539Thanks @tim-smart! - add Model module to /sqlThe
Modelmodule can be used to create domain schemas with common variants for the database and serializing to JSON.import { Schema } from "@effect/schema" import { Model } from "@effect/sql" export const GroupId = Schema.Number.pipe(Schema.brand("GroupId")) export class Group extends Model.Class<Group>("Group")({ id: Model.Generated(GroupId), name: Schema.NonEmptyTrimmedString, createdAt: Model.DateTimeInsertFromDate, updatedAt: Model.DateTimeUpdateFromDate }) {} // schema used for selects Group // schema used for inserts Group.insert // schema used for updates Group.update // schema used for json api Group.json Group.jsonCreate Group.jsonUpdate // you can also turn them into classes class GroupJson extends Schema.Class<GroupJson>("GroupJson")(Group.json) { get upperName() { return this.name.toUpperCase() } } -
#3460
4fabf75Thanks @tim-smart! - support partial objects in sql helpers -
Updated dependencies [
e9da539]:
0.9.0
Minor Changes
-
#3457
a07990dThanks @IMax153! - Add support for executing raw SQL queries with the underlying SQL client.This is primarily useful when the SQL client returns special results for certain query types.
For example, because MySQL does not support the
RETURNINGclause, themysql2client will return aResultSetHeaderforINSERT,UPDATE,DELETE, andTRUNCATEoperations.To gain access to the raw results of a query, you can use the
.rawproperty on theStatement:import * as Effect from "effect/Effect" import * as SqlClient from "@effect/sql/SqlClient" import * as MysqlClient from "@effect/sql/MysqlClient" const DatabaseLive = MysqlClient.layer({ database: Config.succeed("database"), username: Config.succeed("root"), password: Config.succeed(Redacted.make("password")) }) const program = Effect.gen(function* () { const sql = yield* SqlClient.SqlClient const result = yield* sql`INSERT INTO usernames VALUES ("Bob")`.raw console.log(result) /** * ResultSetHeader { * fieldCount: 0, * affectedRows: 1, * insertId: 0, * info: '', * serverStatus: 2, * warningStatus: 0, * changedRows: 0 * } */ }) program.pipe(Effect.provide(DatabaseLive), Effect.runPromise)
Patch Changes
- Updated dependencies [
c1987e2,8295281,c940df6,00b6c6d,1ceed14,f8d95a6,0e42a8f]:- @effect/schema@0.71.0
- effect@3.6.4
- @effect/platform@0.62.0
0.8.7
Patch Changes
- Updated dependencies [
04adcac]:- effect@3.6.3
- @effect/platform@0.61.8
- @effect/schema@0.70.4
0.8.6
Patch Changes
0.8.5
Patch Changes
- Updated dependencies [
99ad841,d829b57,fd4b2f6]:- @effect/schema@0.70.3
- @effect/platform@0.61.6
- effect@3.6.2
0.8.4
Patch Changes
- Updated dependencies [
056b710]:
0.8.3
Patch Changes
- Updated dependencies [
e7cb109]:
0.8.2
Patch Changes
- Updated dependencies [
510a34d,fb9f786,45dbb9f]:- effect@3.6.1
- @effect/platform@0.61.3
- @effect/schema@0.70.2
0.8.1
Patch Changes
0.8.0
Minor Changes
Patch Changes
- Updated dependencies [
11223bf]:
0.7.0
Patch Changes
- Updated dependencies [
1e0fe80,8135294,cd255a4,3845646,2d09078,4bce5a0,4ddbff0,e74cc38,bb069b4,cd255a4,7d02174]:- effect@3.6.0
- @effect/schema@0.70.0
- @effect/platform@0.61.0
0.6.3
Patch Changes
- Updated dependencies [
7c0da50,2fc0ff4,6359644,f262665,7f41e42,9bbe7a6,f566fd1]:- @effect/schema@0.69.3
- effect@3.5.9
- @effect/platform@0.60.3
0.6.2
Patch Changes
- Updated dependencies [
eb4d014,1ba640c,c8c71bd,a26ce58,fc20f73]:- @effect/platform@0.60.2
- effect@3.5.8
- @effect/schema@0.69.2
0.6.1
Patch Changes
- Updated dependencies [
f241154]:
0.6.0
Patch Changes
- Updated dependencies [
20807a4]:
0.5.3
Patch Changes
-
#3310
99bddcfThanks @fubhy! - Added additional pure annotations to improve tree-shakeability -
Updated dependencies [
3afcc93,99bddcf,6921c4f]:- effect@3.5.7
- @effect/platform@0.59.3
- @effect/schema@0.68.27
0.5.2
Patch Changes
- Updated dependencies [
f0285d3,8ec4955,3ac2d76,cc327a1,4bfe4fb,2b14d18]:- @effect/schema@0.68.26
- effect@3.5.6
- @effect/platform@0.59.2
0.5.1
Patch Changes
- Updated dependencies [
a9d7800,fcecff7,adbf753,adbf753]:- effect@3.5.5
- @effect/platform@0.59.1
- @effect/schema@0.68.25
0.5.0
Minor Changes
Patch Changes
- Updated dependencies [
53c0db0,ed0dde4,ada68b3,ca775ce,5be9cc0,203658f,eb1c4d4]:- @effect/platform@0.59.0
- effect@3.5.4
- @effect/schema@0.68.24
0.4.27
Patch Changes
- Updated dependencies [
edb0da3,edb0da3,a1db40a,c8d3fb0,dabd028,786b2ab,fc57354]:- effect@3.5.3
- @effect/schema@0.68.23
- @effect/platform@0.58.27
0.4.26
Patch Changes
- Updated dependencies [
639208e,6684b4c,6684b4c,6684b4c]:- effect@3.5.2
- @effect/platform@0.58.26
- @effect/schema@0.68.22
0.4.25
Patch Changes
- Updated dependencies [
0623fca]:
0.4.24
Patch Changes
- Updated dependencies [
55fdd76]:- effect@3.5.1
- @effect/platform@0.58.24
- @effect/schema@0.68.21
0.4.23
Patch Changes
- Updated dependencies [
a1f5b83,a1f5b83,a1f5b83,60bc3d0,5ab348f,60bc3d0,3e04bf8,e7fc45f,a1f5b83,4626de5,f01e7db,60bc3d0,79d2d91,ac71f37,8432360,e4bf1bf,13cb861,79d2d91,e7fc45f,9f66825]:- effect@3.5.0
- @effect/platform@0.58.23
- @effect/schema@0.68.20
0.4.22
Patch Changes
- Updated dependencies [
7af137c,ee4b3dc,366f2ee,366f2ee,097d25c]:- effect@3.4.9
- @effect/platform@0.58.22
- @effect/schema@0.68.19
0.4.21
Patch Changes
- Updated dependencies [
5d5cc6c,a435e0f,b5554db,359ff8a,a9c4fb3,f7534b9]:- @effect/schema@0.68.18
- effect@3.4.8
- @effect/platform@0.58.21
0.4.20
Patch Changes
- Updated dependencies [
15967cf,2328e17,a5737d6]:- @effect/schema@0.68.17
- effect@3.4.7
- @effect/platform@0.58.20
0.4.19
Patch Changes
0.4.18
Patch Changes
- Updated dependencies [
7f8900a]:
0.4.17
Patch Changes
- Updated dependencies [
5c0ceb0,5c0ceb0,34faeb6,33735b1,5c0ceb0,139d4b3]:- effect@3.4.6
- @effect/schema@0.68.15
- @effect/platform@0.58.17
0.4.16
Patch Changes
- Updated dependencies [
61e5964]:
0.4.15
Patch Changes
0.4.14
Patch Changes
0.4.13
Patch Changes
- Updated dependencies [
a047af9,dbd53ea,d990544]:- effect@3.4.5
- @effect/platform@0.58.13
- @effect/schema@0.68.12
0.4.12
Patch Changes
- Updated dependencies [
74e0ad2,74e0ad2,72638e3,d7dde2b,9b2fc3b,d71c192]:- @effect/platform@0.58.12
- effect@3.4.4
- @effect/schema@0.68.11
0.4.11
Patch Changes
0.4.10
Patch Changes
-
Updated dependencies [
a48ee84,c342739,8898e5e,a48ee84,a48ee84,ff78636,c86bd4e,bbdd365,ab3180f,bbdd365]:- @effect/platform@0.58.10
- effect@3.4.3
- @effect/schema@0.68.10
0.4.9
Patch Changes
- Updated dependencies [
0b47fdf]:
0.4.8
Patch Changes
- Updated dependencies [
192261b,3da1497]:- @effect/schema@0.68.8
- effect@3.4.2
- @effect/platform@0.58.8
0.4.7
Patch Changes
- Updated dependencies [
027004a]:
0.4.6
Patch Changes
- Updated dependencies [
66a1910,2e8e252]:- effect@3.4.1
- @effect/platform@0.58.6
- @effect/schema@0.68.7
0.4.5
Patch Changes
- Updated dependencies [
37a07a2]:
0.4.4
Patch Changes
- Updated dependencies [
b77fb0a]:
0.4.3
Patch Changes
- Updated dependencies [
530fa9e]:
0.4.2
Patch Changes
- Updated dependencies [
1d62815]:
0.4.1
Patch Changes
- Updated dependencies [
5a248aa]:
0.4.0
Minor Changes
Patch Changes
- Updated dependencies [
c0ce180,63dd0c3,61707b6,9c1b5b3,a35faf8,ff73c0c,984d516,8c3b8a2,017e2f9,91bf8a2,c6a4a26]:- effect@3.4.0
- @effect/platform@0.58.0
- @effect/schema@0.68.4
0.3.18
Patch Changes
- Updated dependencies [
3ba7ea1]:
0.3.17
Patch Changes
- Updated dependencies [
d473800]:
0.3.16
Patch Changes
- Updated dependencies [
eb341b3]:
0.3.15
Patch Changes
- Updated dependencies [
b8ea6aa]:
0.3.14
Patch Changes
- Updated dependencies [
b51e266,6c89408]:- @effect/schema@0.68.1
- effect@3.3.5
- @effect/platform@0.57.4
0.3.13
Patch Changes
- Updated dependencies [
f6c7977,a67b8fe]:- @effect/schema@0.68.0
- effect@3.3.4
- @effect/platform@0.57.3
0.3.12
Patch Changes
- Updated dependencies [
3b15e1b,06ede85,3a750b2,7204ca5]:- @effect/schema@0.67.24
- effect@3.3.3
- @effect/platform@0.57.2
0.3.11
Patch Changes
- Updated dependencies [
2ee4f2b,07e12ec,3572646,1aed347,df4bf4b,f085f92,9b3b4ac]:- @effect/schema@0.67.23
- @effect/platform@0.57.1
- effect@3.3.2
0.3.10
Patch Changes
- Updated dependencies [
eb98c5b,184fed8,4d3fbe8,6068e07,3a77e20,d79ca17]:- effect@3.3.1
- @effect/platform@0.57.0
- @effect/schema@0.67.22
0.3.9
Patch Changes
- Updated dependencies [
2b9ddfc,1f4ac00,9305b76,0f40d98,188f0a5,b761ef0,b53f69b,0f40d98,5bd549e,67f160a,67f160a]:- @effect/platform@0.56.0
- effect@3.3.0
- @effect/schema@0.67.21
0.3.8
Patch Changes
0.3.7
Patch Changes
- Updated dependencies [
8c5d280,6ba6d26,cd7496b,3f28bf2,5817820,349a036,799aa20]:- effect@3.2.9
- @effect/schema@0.67.19
- @effect/platform@0.55.6
0.3.6
Patch Changes
- Updated dependencies [
a0dd1c1]:
0.3.5
Patch Changes
- Updated dependencies [
d9d22e7,3c080f7,3c080f7,7d6d875,70cda70,fb91f17]:- @effect/schema@0.67.17
- effect@3.2.8
- @effect/platform@0.55.4
0.3.4
Patch Changes
- Updated dependencies [
5745886,6801fca]:- @effect/schema@0.67.16
- effect@3.2.7
- @effect/platform@0.55.3
0.3.3
Patch Changes
- Updated dependencies [
2c2280b,e2740fc,cc8ac50,60fe3d5]:- @effect/platform@0.55.2
- @effect/schema@0.67.15
- effect@3.2.6
0.3.2
Patch Changes
0.3.1
Patch Changes
- Updated dependencies [
c5846e9]:
0.3.0
Minor Changes
Patch Changes
- Updated dependencies [
608b01f,031c712,a44e532,5133ca9]:- effect@3.2.5
- @effect/platform@0.55.0
- @effect/schema@0.67.13
0.2.17
Patch Changes
- Updated dependencies [
1af94df,1af94df,f8038ca,e376641,c07e0ce,e313a01,1af94df]:- effect@3.2.4
- @effect/platform@0.54.0
- @effect/schema@0.67.12
0.2.16
Patch Changes
- Updated dependencies [
5af633e,45578e8]:- @effect/schema@0.67.11
- effect@3.2.3
- @effect/platform@0.53.14
0.2.15
Patch Changes
- Updated dependencies [
5d9266e,9f8122e,6a6f670,c1eaef9,78ffc27]:- effect@3.2.2
- @effect/platform@0.53.13
- @effect/schema@0.67.10
0.2.14
Patch Changes
- Updated dependencies [
5432fff]:
0.2.13
Patch Changes
- Updated dependencies [
c1e991d]:- effect@3.2.1
- @effect/platform@0.53.11
- @effect/schema@0.67.8
0.2.12
Patch Changes
-
#2778
7135748Thanks @tim-smart! - capture stack trace for tracing spans -
Updated dependencies [
146cadd,7135748,7135748,963b4e7,64c9414,7135748,2cbb76b,870c5fa,146cadd,7135748,64c9414]:- effect@3.2.0
- @effect/platform@0.53.10
- @effect/schema@0.67.7
0.2.11
Patch Changes
- Updated dependencies [
17da864,17fc22e,810f222,596aaea,ff0efa0]:- @effect/schema@0.67.6
- @effect/platform@0.53.9
- effect@3.1.6
0.2.10
Patch Changes
- Updated dependencies [
9c514de]:
0.2.9
Patch Changes
-
#2712
01b4553Thanks @vecerek! - Use constants from@opentelemetry/semantic-conventionsas span attribute names instead of hard-coded values
0.2.8
Patch Changes
- Updated dependencies [
6ac4847,6ac4847]:- @effect/platform@0.53.6
- effect@3.1.5
- @effect/schema@0.67.3
0.2.7
Patch Changes
0.2.6
Patch Changes
- Updated dependencies [
e41e911]:- effect@3.1.4
- @effect/platform@0.53.4
- @effect/schema@0.67.1
0.2.5
Patch Changes
- Updated dependencies [
d7e4997]:
0.2.4
Patch Changes
- Updated dependencies [
1f6dc96]:- effect@3.1.3
- @effect/platform@0.53.2
- @effect/schema@0.66.16
0.2.3
Patch Changes
- Updated dependencies [
121d6d9]:
0.2.2
Patch Changes
- Updated dependencies [
d57fbbb]:
0.2.1
Patch Changes
- Updated dependencies [
5866c62]:
0.2.0
Minor Changes
-
#2693
0724274Thanks @tim-smart! - make @effect/sql dialect agnosticAll of the client implementations now share the same Context.Tag. This means you can create services that support multiple SQL flavors.
You can now use the
@effect/sqlpackage to access the client apis:import * as Sql from "@effect/sql" import { Effect } from "effect" Effect.gen(function* () { const sql = yield* Sql.client.Client yield* sql`SELECT * FROM users` })If you need a functionality that is specific to a implementation, you can use the tag from the implementation package:
import * as Sqlite from "@effect/sql-sqlite-node" import { Effect } from "effect" Effect.gen(function* () { const sql = yield* Sqlite.client.SqliteClient const dump = yield* sql.export })If you need to run a different query depending on the dialect, you can use the
sql.onDialectapi:import * as Sql from "@effect/sql" import { Effect } from "effect" Effect.gen(function* () { const sql = yield* Sql.client.Client yield* sql.onDialect({ sqlite: () => sql`SELECT * FROM sqlite_master`, mysql: () => sql`SHOW TABLES`, mssql: () => sql`SELECT * FROM sys.tables`, pg: () => sql`SELECT * FROM pg_catalog.pg_tables` }) })
Patch Changes
- #2693
0724274Thanks @tim-smart! - add .returning helper to insert and update apis
0.1.17
Patch Changes
-
#2679
2e1cdf6Thanks @tim-smart! - ensure all type ids are annotated withunique symbol -
#2685
d3cf2d8Thanks @giacomoran! - fixsql.updatedefault arguments -
#2684
56ec8ddThanks @giacomoran! - fix placeholder count in sql helpers -
Updated dependencies [
2e1cdf6]:- @effect/platform@0.52.2
- effect@3.1.2
- @effect/schema@0.66.14
0.1.16
Patch Changes
- Updated dependencies [
e5e56d1]:- effect@3.1.1
- @effect/platform@0.52.1
- @effect/schema@0.66.13
0.1.15
Patch Changes
0.1.14
Patch Changes
-
#2543
a023f28Thanks @github-actions! - set spankindwhere applicable -
Updated dependencies [
c3c12c6,ba64ea6,b5de2d2,a1c7ab8,a023f28,0ec93cb,1c9454d,a023f28,92d56db]:- effect@3.1.0
- @effect/platform@0.51.0
- @effect/schema@0.66.12
0.1.13
Patch Changes
- Updated dependencies [
16039a0,557707b,d1d33e1,f4ed306,661004f,e79cb83]:- @effect/platform@0.50.8
- effect@3.0.8
- @effect/schema@0.66.11
0.1.12
Patch Changes
- Updated dependencies [
18de56b]:- effect@3.0.7
- @effect/platform@0.50.7
- @effect/schema@0.66.10
0.1.11
Patch Changes
-
#2626
027418eThanks @fubhy! - Reintroduce customNoInfertype -
#2621
f363af0Thanks @tim-smart! - add sql transaction tracing spans -
#2609
ac1898eThanks @patroza! - change: BatchedRequestResolver works with NonEmptyArray -
#2621
f363af0Thanks @tim-smart! - update sql span attributes to follow semantic conventions -
#2621
f363af0Thanks @tim-smart! - add sql....unprepared, to run a query without trying to PREPARE it -
Updated dependencies [
ffe4f4e,027418e,ac1898e,ffe4f4e,8206529]:- effect@3.0.6
- @effect/schema@0.66.9
- @effect/platform@0.50.6
0.1.10
Patch Changes
- Updated dependencies [
6222404,868ed2a]:- effect@3.0.5
- @effect/platform@0.50.5
- @effect/schema@0.66.8
0.1.9
Patch Changes
- Updated dependencies [
dd41c6c,9a24667]:- @effect/schema@0.66.7
- effect@3.0.4
- @effect/platform@0.50.4
0.1.8
Patch Changes
0.1.7
Patch Changes
0.1.6
Patch Changes
- Updated dependencies [
773b8e0]:
0.1.5
Patch Changes
- Updated dependencies [
6f38dff,a7b4b84,a3b0e6c,6f38dff]:- @effect/platform@0.50.0
- effect@3.0.3
- @effect/schema@0.66.3
0.1.4
Patch Changes
-
Updated dependencies [
2cecdbd]:- @effect/platform@0.49.4
- effect@3.0.2
- @effect/schema@0.66.2
0.1.3
Patch Changes
- Updated dependencies [
8d39d65]:
0.1.2
Patch Changes
- Updated dependencies [
5ef0a1a]:
0.1.1
Patch Changes
-
#2544
f838c15Thanks @tim-smart! - support column names forsql.inhelper -
#2555
8edaccaThanks @tim-smart! - prevent use ofArrayas import name to solve bundler issues -
Updated dependencies [
3da0cfa,570e8d8,b2b5d66,87c5687,8edacca]:- effect@3.0.1
- @effect/schema@0.66.1
- @effect/platform@0.49.1
0.1.0
Minor Changes
-
#2104
1499974Thanks @IMax153! - initial @effect/sql release -
#2207
2fb7d9cThanks @github-actions! - Release Effect 3.0 🎉
Patch Changes
-
#2529
78b767cThanks @fubhy! - RenamedReadonlyArrayandReadonlyRecordmodules for better discoverability. -
Updated dependencies [
1b5f0c7,d50a652,9aeae46,9a3bd47,6460414,cf69f46,cf69f46,e542371,be9d025,78b767c,aa4a3b5,1499974,1b5f0c7,5c2b561,6c6087a,a18f594,1499974,2f96d93,5a2314b,25d74f8,6c6087a,271b79f,1b5f0c7,2fb7d9c,53d1c2a,e7e1bbe,10c169e,6424181]:- effect@3.0.0
- @effect/schema@0.66.0
- @effect/platform@0.49.0