- Updated dependencies [a7baab8]
- orchid-core@0.5.2
- Updated dependencies [695f390]
- orchid-core@0.5.1
- 78b65c4: Add query hooks that can select data, run inside transaction, and after commit (#83)
- Updated dependencies [78b65c4]
- orchid-core@0.5.0
- cbc1121: Fix
upsertto return value when created when the query is changed withget(#121)
- 3116713: Throw runtime error when updating/deleting without where (#102). Export more query types (#93).
- c2d3eb0: Fix
transformfunction for relations that does not have column parsers (#93)
- d16ab35: Add
tranformmethod to transform query results (#93) - Updated dependencies [d16ab35]
- orchid-core@0.4.14
- 35c437e: Support json methods in the
updatecolumn callback (#105)
- 96f2cef: Disallow selecting joined tables by only their names, allow selecting them as
table.*
- 31e7d23: Add
LIMIT 1forgetqueries
- d8bc7cf: Support sub-queries for updating and deleting records (#105)'
- 275cc73: Support nested select of the same table as above
- 2881707: Add
makeHelperfunction to define query helper - Updated dependencies [2881707]
- orchid-core@0.4.13
- 8ae4fe3: Add pg dependency to pqb
- e9a4095: Change column.parse function to also process null values
- Updated dependencies [e9a4095]
- orchid-core@0.4.12
- 4893640: Rename addParserToQuery to setParserToQuery, add overrideParserInQuery (#92)
- Updated dependencies [4893640]
- orchid-core@0.4.11
- 0535450: Fix
thenandcatchmethods - Updated dependencies [0535450]
- orchid-core@0.4.10
- 4287137: Add
sqlmethod to accept raw SQL via template literals - Updated dependencies [4287137]
- orchid-core@0.4.9
- 2e8e2a3: Support $ syntax in raw method for column names
- a33d1a1: Update docs links in README.md and in package.json
- 83d8eed: Support defining hooks on tables (#83)
- Updated dependencies [9610b44]
- orchid-core@0.4.8
- c7298d6: Throw when passing null or undefined to the find method
- 64353f7: Make identity column optional when creating
- 63934b5: Fix ordering and using where for the column of selected relation
- 23d8a2a: Fix
nowSQLto be wrapped into parens automatically - Updated dependencies [23d8a2a]
- orchid-core@0.4.7
- Support returning data from a callback for creating record in
upsert,orCreate - e8a863d: Support
.join()on relations to have JOIN LATERAL instead of LEFT JOIN LATERAL
- Allow to customize timestamp default value with
nowSQLoption of base table - Updated dependencies
- orchid-core@0.4.6
- Fix selecting a plain value from a sub query in select
- Fix aliasing relation sub queries in select; Fix ordering by selected value
- Fix selecting nested relations
- Fix selecting relation pluck with query methods like orderBy
- Handle releations selects with
JOIN LATERALinternally - dfc2b87: Remove ability to select a relation with a string in
selectbecause it may be confusing
- Change
createFactorytotableFactoryandormFactory; Add factory.buildMany and factory.createMany - 96504ef: Support
asin joinLateral relation - Updated dependencies
- orchid-core@0.4.5
- cfdc2bb: Support nested transactions
- Add testTransaction utility for tests
- orchid-core@0.4.4
- Rename timestampWithoutTimezone to timestampNoTZ; Add methods for it
- Updated dependencies
- orchid-core@0.4.4
- Support joining a relation with a callback
- Updated dependencies
- orchid-core@0.4.3
- Make passing this not required when customizing column types
- Updated dependencies
- orchid-core@0.4.2
- Fix update method type to accept values by 'inputType' of the column instead of 'type'
- Support joinLateral
- Support selecting joined table with alias
- Change result handling to a sync function as optimization
- Support selecting full joined record
- Updated dependencies
- orchid-core@0.4.1
- Updated dependencies
- orchid-core@0.4.0
- Accept string, number, Date in date time columns
- Updated dependencies
- orchid-core@0.3.1
- Updated dependencies
- orchid-core@0.3.0
- Implicitly pass transaction object by using AsyncLocalStorage
- Updated dependencies
- orchid-core@0.2.0
- Update dependencies
- Allow ordering by a sub-query in select
- Initial support for db views
- Updated dependencies
- orchid-core@0.1.17
- Favor timestamptz over timestamp
- Updated dependencies
- orchid-core@0.1.16
- Support conditional sub query result
- Support identity columns
- Updated dependencies
- orchid-core@0.1.15
- Simplify current_timestamp, transaction_timestamp() to the equivalent now() in db pull
- Use gen_random_uuid as a default uuid default
- Updated dependencies
- orchid-core@0.1.14
- Type-check required columns in createRaw
- Support NULLS NOT DISTINCT for unique index
- Change setting order nulls first/last
- Ignore undefined where values
- Remove undefined and void from json schema
- Updated dependencies
- orchid-core@0.1.13
- Support db table checks and constraints
- Updated dependencies
- orchid-core@0.1.12
- Support schema connection option
- Improve error classes
- Fix selecting value in a sub select
- Improve join arg types
- Updated dependencies
- orchid-core@0.1.11
- Improve select and from types
- Improve onConflict without argument behavior
- Updated dependencies
- orchid-core@0.1.10
- Fix generating enum column from db pull to ORM
- Updated dependencies
- Updated dependencies [c8df1f9]
- orchid-core@0.1.9
- Support validation error messages
- Updated dependencies
- orchid-core@0.1.8
- Fix handling undefined values in foreign key when pulling db
- Updated dependencies
- orchid-core@0.1.7
- Support snakeCase option
- Updated dependencies
- orchid-core@0.1.6
- Support selecting *
- Support runtime default; Add createManyRaw and createManyFrom
- Updated dependencies
- orchid-core@0.1.5
- Add citext
- 8d35851: Handle unsupported types
- Support domain types
- Updated dependencies
- orchid-core@0.1.4
- Support database CHECK validation
- Updated dependencies
- orchid-core@0.1.3
- Improve .unique code gen, save migration verion after db pull
- Support raw in a callback in a select
- Use readonly for table in the table class
- 384fbfc: Support enum, array columns in db pull
- Updated dependencies
- orchid-core@0.1.2
- Fix creating belongsTo relation when id has no default
- Updated dependencies
- orchid-core@0.1.1
- Move common code into separate orchid-core package
- Updated dependencies
- orchid-core@0.1.0
- Add
rawto column types to use in defaults
- Support join subquery
- Fix pluck in sub query
- Fix pluck subquery with empty result
- Fix returning pluck from sub query
- Fix returning related records in an extra array
- Add method $from to orm
- Fix number column operators
- Support from(query) with proper result, operators, parsers
- aa92f25: Remove
asargument fromfrommethod in favor of specificasmethod
- Leave only dist in shipped packages
- Fix sub query columns parsing
- Store error stack trace in error cause
- Add createEnum and dropEnum to rake-db
- Fix TS error when using nullable type in migration
- Restructure for mysql init
- Restructure for mysql init
- Add orCreate method
- Improve code generation, fix ssl databaseUrl option
- Add init script
- Override column types via callback
- ee1961e: Make columnTypes optional in configs
- Handle table ordering by foreign key when pulling db
- Fix import timestamps issue
- Mix query builder into migration db interface
- Improve esm support
- Change package.json exports for esm support
- Improve pulling db structure
- Add command for pulling database structure into a migration
- Change index options: column or expression is required, operator renamed to opclass
- f1cd5db: Handle multiple indexes and foreignKeys of the column
- Change inner aspects of columns
- Add --code cli argument to rake-db
- Improve codegen
- Fix export
- Add code generator to change project files after migrations
- Add ability to convert columns to code
- 3f25b4d: Rename all model words to table words, because all models here are not models in OOP meaning
- Refactor create and update of relations
- Improve usability of raw SQL
- Allow to open connections after closing
- Fix incrorrect order on queries for automatic wrapping into transaction
- Set proper stack trace on errors
- Change connectionString to databaseURL option, add ssl option
- Change QueryError implemetation details
- Remove force flag from update and delete in favor of empty where
- Make text operators case insensitive by default
- Update homepage link in package.json
- Add required min and max parameters to text column
- 9b8b3d5: Prefix unique columns with sequences in test factory
- Handle tables without primary key
- 883c3e4: Add changeset