lucid
lucid copied to clipboard
AdonisJS SQL ORM. Supports PostgreSQL, MySQL, MSSQL, Redshift, SQLite and many more
## Package version @adonisjs/lucid": "^18.1.0 ## Node.js and npm version Node: v16.14.0 NPM: 8.3.1 ## Sample Code (to reproduce the issue) Example: ```ts const users = await User.query().preload('profile') ``` Model:...
## Package version @adonisjs/lucid": "^18.1.0 ## Node.js and npm version Node: v16.14.0 NPM: 8.3.1 ## Sample Code (to reproduce the issue) Example: ```ts const profiles = await Profile.query() .where('userId', user.id)...
I have a User model and it has a Profile collection. However, I need to know what the most current profile is and I created a BelongsTo/HasOne relationship. HasOne can't...
The migration command should emit event on how the migration ran, so that we can hook up to the process. 1 example it to send email when a migration was...
## Why this feature is required ? When fetching a lots of data that need to be parsed to CSV and redirected to a download stream for client. Handling lots...
## Sample Code (to reproduce the issue) ``` // Inventory.ts export default class Inventory extends Base { @hasMany(() => InventoryKey, { localKey: 'uid', foreignKey: 'inventory_uid', }) public keys: HasMany }...
fix(src/database/querybuilder/database.ts): move the query within a subquery in paginate total count The main query has been mooved inside a subquery to keep its original syntax so that paginate() can always...
Fix #820 Hey 👋 So I just added a `dontDrop` property in the `SharedConfigNode` interface, which allows users to give a list of table names not to be dropped when...
## Package version 18.1.0 ## Node.js and npm version Node :- v16.16.0 NPM :- 8.11.0 ## Postgres version v14.2 Recently I was querying JSON object ``` msg_settings: { "jump": false,...
## Why this feature is required (specific use-cases will be appreciated)? [The connection to an Oracle Cloud Autonomous Database instance using mTLS](https://docs.oracle.com/en-us/iaas/autonomous-database-shared/doc/connecting-nodejs.html) with a node.js based application and [node-oracledb](http://oracle.github.io/node-oracledb/) requires...