- ✏️ doc updates
- 🐛 when fixing a bug
- 🚀 when making general improvements
- ✅ when adding tests
- ⬆️ when upgrading dependencies
- 🎉 when adding new features
- ⬆️ Update Drizzle to latest version
- ⬆️ Update Drizzle to latest version
- ⬆️ Update Drizzle to latest version
- 🚀 Add support for suppressing
limit()in List withInfinityvalue
- 🚀 Stricter TS config to keep upstream TSC happy
- 🐛 Fix typing on sleep
- ⬆️ Update Drizzle to latest version
- 🐛 Count function was returning a string
- 🚀 Throw 404 error on
committhat doesn't update any rows
- 🚀 Add support for GeometryZ
- ⬆️ Update PeerDep to
drizzle-kit@22
- ⬆️ Update PeerDep to
drizzle-kit@21
- 🐛 Fix bug where a normal insert wouldn't return a value
- 🚀 Allow upsert behavior to be defined on
generate
- 🚀 Add generic
.count()function
- ⬆️ Update Core Deps
- ⬆️ Update to
drizzle-orm@0.30which uses dates as strings for postgres.js
- 🎉 Remove JSON Schema output now that we use drizzle-typebox
- 🎉 Add Order Enum
- 🚀 Expose key helper fns
- 🚀 Simpler type defs
- 🐛 Fix
query.orderin list API
- ⬆️ Update Core Deps
- 🚀 more Types
- 🚀 Add TS
strictmode
- 🐛 Set no-verify option in pgStructure as it uses node-pg
- 🚀 Setup Optional SSL Param for connection settings
- 🚀 Input type is now properly typed
- 🚀 Not found error is now generic
- ✅ Write basic test scaffolding
- Date => date-time
- Time type objects are now always strings, not unix epochs
- Perform migration before schema dump
- Custom migrationsFolder path through opts
- Handle empty table gracefully in stream mode
- Update Return Type
- Remove debug code
- Add
toDriverfor postgis integration
- Add npm ignore
- Just include types
- Just include types
- Just include types
- Add TS build step to release
- Update from
sloniktodrizzleand migrate to TS
- 🐛 Fix version
- 🐛 Allow
falsevalue as default when using Params.boolean
- 🐛 Consistent TZ
- ⬆️ Update Core Deps
- ⬆️ TimeStamps are now formatted as integer by default to align with Slonik Defaults
- ⬆️ Update core deps
- ⬆️ Fix null check
- ⬆️ Fix Batch-Error bug
- ⬆️ Update core deps
- 🚀 Add support for
json[]andjsonb[]
- 🐛 Don't write internal schema props that AJV will reject
- 🎉 Automatically determine Primary Key (no longer always set to
id)
- ⬆️
slonik@32peerDependency
- 🐛 Fix string parsing for Params.string
- 🐛 Fix string parsing for Params.number
- 🐛 Fix string parsing for Params.integer
- 🐛 Fix string parsing for Params.boolean
- 🚀 Merge new schema with existing schema files to allow users to add non-automated key/values
- 🎉 Add support for writing view definitions to disk
- 🚀 Remove columns from disk when they no longer exist in the database
- 🎉 Add support for Classes that should mirror a view
- 🚀 Remove internal
_resproperty in favour ofSchema.from - 🎉 Add
Schema.fromas helper for returning a JSON Schema for a class/instance
- 🎉 Add static
Generic.commitfn
- 🎉 Add support for inserting/updating GeoJSON objects automatically
- ⬆️
slonik@31peerDependency
- 🚀 internal improvements when patching via commit
- 🚀 Add light function arg checks to ensure pool/id are valid
- 🚀 Add error handling for duplicate constraint on commit
- 🚀 Add error handling for duplicate constraint on generate
- 🐛
this._fieldsis no longer a populated field
- 🚀 Use
@openaddressses/batch-errorto remove pin to@openaddresses/batch-schema
- 🚀 Add basic support for PostGIS Geometry type
- 🎉 Automatically generate
descriptionproperty fromCOMMENT
- 🐛 Throw a human readable error if the user passes properties to update that don't exist in the db
- ✅ Tests for properties that don't exist in the database
- ✅ Easier to manage pool.schemas tests
- 🐛 non-json arrays of any kind would fail to be insert/updated
- ✅ Add basic
Schema#writetest
- 🚀 peerDep for
@openaddresses/batch-schema@9
- :todo: Optionally write JSON Schemas to a given directory
- 🎉 Pool is now a custom wrapper around a slonik pool that provides JSON Schemas for each table
- 🎉 Remove all
_resand_patchas these are now automatically generated - 🎉 Pools are now stored when an object is created and as such many endpoints no longer require a
poolarg
- 🎉 Add basic concept for parsing SQL query parameters
- 🐛 Fix sql type check when value is null
- 🐛 Fix sql type check
- 🎉 Add configurable retry for
Pool.connect
- ⬆️ Update base deps
- 🎉 Add ability to patch/commit fields which are not present in the JSON schema
- 🐛
slonik.createPoolnow returns a promise
- ⬆️
Slonik@30 - 🚀 Allow
sqlvalues to be passed through unchanged
- ⬆️
Slonik@29
- 🎉 Add support for Generic.Pool connection configuration
- 🐛 Fix NULL insertions
- ⬆️ Update base deps
- 🚀 Move the
_fieldsgeneration to thedeserializefunction to ensure that overriding the default generate or from functions still benefit from the default commit fn - 🚀 Move list responses to
deserialize_list
- 🚀 Optimize commit SQL if
patchparam is passed
- 🐛 Return nbase on generate
- 🎉 Add support for automatically commiting JS Timestamps (ms => s)
- ✅ Add Dockerfile & Docker Compose for running tests on CI
- ⬆️ Update base deps
- ⬆️
@openaddresses/batch-schema>= 4 now required
- 🐛 Minor test updates to allow sequential test runs for GH Actions
- 🎉 Add
generic.generate
- 🎉 Add
generic.commit
- 🚀 Add automated npm releases
- 🎉 Add the ability to
from&deletevia a custom column (default:id) - 🎉 Add a static
delete()function
- 🐛 ensure
originalErroris present when performing error code checks
- 🎉 Add
.clear()function to allow clearing all entries in a table
- 🚀 Update ES Module System
- ⬆️
slonik@28peerDependency
- 🚀 Fix ESLint errors and remove unused fn params
- ⬆️ Update base deps
- 🎉 Add support for object streams
- 🎉 Add ability for generic
list(<pool>, <query>)fn - ✅ Framework testing strategy
- 🚀 Intial Release