leoc11 / elcy Goto Github PK

Useful for accumulative sum. example:

let total = 0;
const accumulateResult = await db.table1Set.setParameters({ total }).select(o => ({
 column1: o.column1,
 accumulativeSum: total += o.column1
})).toArray();

Note: total variable will not be affected.

• Expression builder.
• Query generation speed (with/out cached).
• Result parse speed.

IIncludeRelation should support RelationData.

note: Include via join that result in many-many relation should be consider too

Take/skip query always pass unneeded parameter.

example below will pass (1) and (2) to query parameter

const take = db.orders.skip(1).take(2);
const results = await take.toArray();

note: fixed at schema-builder branch

support virtual and persisted computed column for supported db (ex: mssql)

• New column decorator
• Querybuilder: auto translate JSON member access to correct sql syntax

Refactor expresison builder to follow operator precedence as describe in https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Operator_Precedence

Though some embedded column code has been merged to master. but it still not working yet.
This issue only intended to track pending task.

currently the following code does not work.

1. If true result and false result has different value type, prop1 value will always has true result type. in blow case, prop1 will always be a string.

await db.table1Set.select(o => ({
 prop1: o.condition ? o.string : o.number
})).toArray();

2. Relation is not yet supported in ternary operator. run code below will result in runtime error.

await db.table1Set.select(o => ({
 prop1: o.anycondition ? o.column : o.relation
})).toArray();

• Schema builder.
• Update.
• Insert.
• Delete.
• Batch update.
• Batch delete.
• Querybuilder. (with all supported expression)
• Save changes.
• Changes detection.
• Relation Changes detection
• Add/Remove relation.
• Sqlite test.

Support 3 types of inheritance.

• Table per Concrete class.
• Table per Class.
• Single Table.

Usage Example

Single Table

@Entity()
abstract class ClassA { }

@AbstractEntity()
class ClassA1 extends ClassA{}

Table per Concrete Class

@AbstractEntity()
abstract class ClassA { }

@Entity()
class ClassA1 extends ClassA{}

Table per Class

@Entity()
abstract class ClassA { }

@Entity()
class ClassA1 extends ClassA{}