nukak-sqlite
Advanced tools
Comparing version 1.0.0 to 1.0.1
@@ -7,2 +7,7 @@ # Changelog | ||
## [1.0.1] - 2024-08-10 | ||
- Rename `$project` operator to `$select` for consistency with most established frameworks so far. | ||
- Rename `$filter` operator to `$where` for consistency with most established frameworks so far. | ||
## [1.0.0] - 2024-08-10 | ||
@@ -9,0 +14,0 @@ |
@@ -6,3 +6,3 @@ { | ||
"license": "MIT", | ||
"version": "1.0.0", | ||
"version": "1.0.1", | ||
"type": "module", | ||
@@ -19,5 +19,5 @@ "main": "./index.js", | ||
"peerDependencies": { | ||
"nukak": "^1.0.0", | ||
"sqlite": "^4.1.2", | ||
"sqlite3": "^5.1.2", | ||
"nukak": "^1.0.0" | ||
"sqlite3": "^5.1.2" | ||
}, | ||
@@ -24,0 +24,0 @@ "dependencies": { |
@@ -15,4 +15,4 @@ <!-- ![code](/assets/code.webp 'code') --> | ||
const companyUsers = await userRepository.findMany({ | ||
$project: { email: true, profile: ['picture'] }, | ||
$filter: { email: { $endsWith: '@domain.com' } }, | ||
$select: { email: true, profile: ['picture'] }, | ||
$where: { email: { $endsWith: '@domain.com' } }, | ||
$sort: { createdAt: 'desc' }, | ||
@@ -158,3 +158,3 @@ $limit: 100, | ||
const users = await querier.findMany(User, { | ||
$project: { id: true, name: true, email: true }, | ||
$select: { id: true, name: true, email: true }, | ||
$sort: { createdAt: 'desc' }, | ||
@@ -161,0 +161,0 @@ $limit: limit, |
@@ -1,7 +0,7 @@ | ||
import { QueryFilterMap, Type, QueryComparisonOptions, Scalar } from 'nukak/type'; | ||
import { QueryWhereMap, Type, QueryComparisonOptions, Scalar } from 'nukak/type'; | ||
import { AbstractSqlDialect } from 'nukak/dialect'; | ||
export declare class SqliteDialect extends AbstractSqlDialect { | ||
constructor(); | ||
compare<E, K extends keyof QueryFilterMap<E>>(entity: Type<E>, key: K, val: QueryFilterMap<E>[K], opts?: QueryComparisonOptions): string; | ||
compare<E, K extends keyof QueryWhereMap<E>>(entity: Type<E>, key: K, val: QueryWhereMap<E>[K], opts?: QueryComparisonOptions): string; | ||
escape(value: any): Scalar; | ||
} |
@@ -21,2 +21,2 @@ import sqlstring from 'sqlstring-sqlite'; | ||
} | ||
//# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJmaWxlIjoic3FsaXRlRGlhbGVjdC5qcyIsInNvdXJjZVJvb3QiOiIiLCJzb3VyY2VzIjpbIi4uL3NyYy9zcWxpdGVEaWFsZWN0LnRzIl0sIm5hbWVzIjpbXSwibWFwcGluZ3MiOiJBQUFBLE9BQU8sU0FBUyxNQUFNLGtCQUFrQixDQUFDO0FBQ3pDLE9BQU8sRUFBRSxPQUFPLEVBQUUsTUFBTSxjQUFjLENBQUM7QUFFdkMsT0FBTyxFQUFFLGtCQUFrQixFQUFFLE1BQU0sZUFBZSxDQUFDO0FBRW5ELE1BQU0sT0FBTyxhQUFjLFNBQVEsa0JBQWtCO0lBQ25EO1FBQ0UsS0FBSyxDQUFDLEdBQUcsRUFBRSxtQkFBbUIsQ0FBQyxDQUFDO0lBQ2xDLENBQUM7SUFFUSxPQUFPLENBQ2QsTUFBZSxFQUNmLEdBQU0sRUFDTixHQUF5QixFQUN6QixJQUE2QjtRQUU3QixJQUFJLEdBQUcsS0FBSyxPQUFPLEVBQUUsQ0FBQztZQUNwQixNQUFNLElBQUksR0FBRyxPQUFPLENBQUMsTUFBTSxDQUFDLENBQUM7WUFDN0IsTUFBTSxNQUFNLEdBQUcsR0FBZ0MsQ0FBQztZQUNoRCxNQUFNLE1BQU0sR0FBRyxNQUFNLENBQUMsT0FBTyxDQUFDLEdBQUcsQ0FBQyxDQUFDLEtBQUssRUFBRSxFQUFFLENBQUMsSUFBSSxDQUFDLFFBQVEsQ0FBQyxJQUFJLENBQUMsTUFBTSxDQUFDLEtBQUssQ0FBQyxFQUFFLElBQUksSUFBSSxLQUFLLENBQUMsQ0FBQyxDQUFDO1lBQy9GLE9BQU8sR0FBRyxJQUFJLENBQUMsUUFBUSxDQUFDLElBQUksQ0FBQyxJQUFJLENBQUMsV0FBVyxNQUFNLENBQUMsSUFBSSxDQUFDLEdBQUcsQ0FBQyxPQUFPLElBQUksQ0FBQyxNQUFNLENBQUMsTUFBTSxDQUFDLE1BQU0sQ0FBQyxFQUFFLENBQUM7UUFDbkcsQ0FBQztRQUNELE9BQU8sS0FBSyxDQUFDLE9BQU8sQ0FBQyxNQUFNLEVBQUUsR0FBRyxFQUFFLEdBQUcsRUFBRSxJQUFJLENBQUMsQ0FBQztJQUMvQyxDQUFDO0lBRVEsTUFBTSxDQUFDLEtBQVU7UUFDeEIsT0FBTyxTQUFTLENBQUMsTUFBTSxDQUFDLEtBQUssQ0FBQyxDQUFDO0lBQ2pDLENBQUM7Q0FDRiIsInNvdXJjZXNDb250ZW50IjpbImltcG9ydCBzcWxzdHJpbmcgZnJvbSAnc3Fsc3RyaW5nLXNxbGl0ZSc7XG5pbXBvcnQgeyBnZXRNZXRhIH0gZnJvbSAnbnVrYWsvZW50aXR5JztcbmltcG9ydCB7IFF1ZXJ5RmlsdGVyTWFwLCBRdWVyeVRleHRTZWFyY2hPcHRpb25zLCBUeXBlLCBRdWVyeUNvbXBhcmlzb25PcHRpb25zLCBTY2FsYXIgfSBmcm9tICdudWthay90eXBlJztcbmltcG9ydCB7IEFic3RyYWN0U3FsRGlhbGVjdCB9IGZyb20gJ251a2FrL2RpYWxlY3QnO1xuXG5leHBvcnQgY2xhc3MgU3FsaXRlRGlhbGVjdCBleHRlbmRzIEFic3RyYWN0U3FsRGlhbGVjdCB7XG4gIGNvbnN0cnVjdG9yKCkge1xuICAgIHN1cGVyKCdgJywgJ0JFR0lOIFRSQU5TQUNUSU9OJyk7XG4gIH1cblxuICBvdmVycmlkZSBjb21wYXJlPEUsIEsgZXh0ZW5kcyBrZXlvZiBRdWVyeUZpbHRlck1hcDxFPj4oXG4gICAgZW50aXR5OiBUeXBlPEU+LFxuICAgIGtleTogSyxcbiAgICB2YWw6IFF1ZXJ5RmlsdGVyTWFwPEU+W0tdLFxuICAgIG9wdHM/OiBRdWVyeUNvbXBhcmlzb25PcHRpb25zLFxuICApOiBzdHJpbmcge1xuICAgIGlmIChrZXkgPT09ICckdGV4dCcpIHtcbiAgICAgIGNvbnN0IG1ldGEgPSBnZXRNZXRhKGVudGl0eSk7XG4gICAgICBjb25zdCBzZWFyY2ggPSB2YWwgYXMgUXVlcnlUZXh0U2VhcmNoT3B0aW9uczxFPjtcbiAgICAgIGNvbnN0IGZpZWxkcyA9IHNlYXJjaC4kZmllbGRzLm1hcCgoZmllbGQpID0+IHRoaXMuZXNjYXBlSWQobWV0YS5maWVsZHNbZmllbGRdPy5uYW1lID8/IGZpZWxkKSk7XG4gICAgICByZXR1cm4gYCR7dGhpcy5lc2NhcGVJZChtZXRhLm5hbWUpfSBNQVRDSCB7JHtmaWVsZHMuam9pbignICcpfX0gOiAke3RoaXMuZXNjYXBlKHNlYXJjaC4kdmFsdWUpfWA7XG4gICAgfVxuICAgIHJldHVybiBzdXBlci5jb21wYXJlKGVudGl0eSwga2V5LCB2YWwsIG9wdHMpO1xuICB9XG5cbiAgb3ZlcnJpZGUgZXNjYXBlKHZhbHVlOiBhbnkpOiBTY2FsYXIge1xuICAgIHJldHVybiBzcWxzdHJpbmcuZXNjYXBlKHZhbHVlKTtcbiAgfVxufVxuIl19 | ||
//# sourceMappingURL=data:application/json;base64,eyJ2ZXJzaW9uIjozLCJmaWxlIjoic3FsaXRlRGlhbGVjdC5qcyIsInNvdXJjZVJvb3QiOiIiLCJzb3VyY2VzIjpbIi4uL3NyYy9zcWxpdGVEaWFsZWN0LnRzIl0sIm5hbWVzIjpbXSwibWFwcGluZ3MiOiJBQUFBLE9BQU8sU0FBUyxNQUFNLGtCQUFrQixDQUFDO0FBQ3pDLE9BQU8sRUFBRSxPQUFPLEVBQUUsTUFBTSxjQUFjLENBQUM7QUFFdkMsT0FBTyxFQUFFLGtCQUFrQixFQUFFLE1BQU0sZUFBZSxDQUFDO0FBRW5ELE1BQU0sT0FBTyxhQUFjLFNBQVEsa0JBQWtCO0lBQ25EO1FBQ0UsS0FBSyxDQUFDLEdBQUcsRUFBRSxtQkFBbUIsQ0FBQyxDQUFDO0lBQ2xDLENBQUM7SUFFUSxPQUFPLENBQ2QsTUFBZSxFQUNmLEdBQU0sRUFDTixHQUF3QixFQUN4QixJQUE2QjtRQUU3QixJQUFJLEdBQUcsS0FBSyxPQUFPLEVBQUUsQ0FBQztZQUNwQixNQUFNLElBQUksR0FBRyxPQUFPLENBQUMsTUFBTSxDQUFDLENBQUM7WUFDN0IsTUFBTSxNQUFNLEdBQUcsR0FBZ0MsQ0FBQztZQUNoRCxNQUFNLE1BQU0sR0FBRyxNQUFNLENBQUMsT0FBTyxDQUFDLEdBQUcsQ0FBQyxDQUFDLEtBQUssRUFBRSxFQUFFLENBQUMsSUFBSSxDQUFDLFFBQVEsQ0FBQyxJQUFJLENBQUMsTUFBTSxDQUFDLEtBQUssQ0FBQyxFQUFFLElBQUksSUFBSSxLQUFLLENBQUMsQ0FBQyxDQUFDO1lBQy9GLE9BQU8sR0FBRyxJQUFJLENBQUMsUUFBUSxDQUFDLElBQUksQ0FBQyxJQUFJLENBQUMsV0FBVyxNQUFNLENBQUMsSUFBSSxDQUFDLEdBQUcsQ0FBQyxPQUFPLElBQUksQ0FBQyxNQUFNLENBQUMsTUFBTSxDQUFDLE1BQU0sQ0FBQyxFQUFFLENBQUM7UUFDbkcsQ0FBQztRQUNELE9BQU8sS0FBSyxDQUFDLE9BQU8sQ0FBQyxNQUFNLEVBQUUsR0FBRyxFQUFFLEdBQUcsRUFBRSxJQUFJLENBQUMsQ0FBQztJQUMvQyxDQUFDO0lBRVEsTUFBTSxDQUFDLEtBQVU7UUFDeEIsT0FBTyxTQUFTLENBQUMsTUFBTSxDQUFDLEtBQUssQ0FBQyxDQUFDO0lBQ2pDLENBQUM7Q0FDRiIsInNvdXJjZXNDb250ZW50IjpbImltcG9ydCBzcWxzdHJpbmcgZnJvbSAnc3Fsc3RyaW5nLXNxbGl0ZSc7XG5pbXBvcnQgeyBnZXRNZXRhIH0gZnJvbSAnbnVrYWsvZW50aXR5JztcbmltcG9ydCB7IFF1ZXJ5V2hlcmVNYXAsIFF1ZXJ5VGV4dFNlYXJjaE9wdGlvbnMsIFR5cGUsIFF1ZXJ5Q29tcGFyaXNvbk9wdGlvbnMsIFNjYWxhciB9IGZyb20gJ251a2FrL3R5cGUnO1xuaW1wb3J0IHsgQWJzdHJhY3RTcWxEaWFsZWN0IH0gZnJvbSAnbnVrYWsvZGlhbGVjdCc7XG5cbmV4cG9ydCBjbGFzcyBTcWxpdGVEaWFsZWN0IGV4dGVuZHMgQWJzdHJhY3RTcWxEaWFsZWN0IHtcbiAgY29uc3RydWN0b3IoKSB7XG4gICAgc3VwZXIoJ2AnLCAnQkVHSU4gVFJBTlNBQ1RJT04nKTtcbiAgfVxuXG4gIG92ZXJyaWRlIGNvbXBhcmU8RSwgSyBleHRlbmRzIGtleW9mIFF1ZXJ5V2hlcmVNYXA8RT4+KFxuICAgIGVudGl0eTogVHlwZTxFPixcbiAgICBrZXk6IEssXG4gICAgdmFsOiBRdWVyeVdoZXJlTWFwPEU+W0tdLFxuICAgIG9wdHM/OiBRdWVyeUNvbXBhcmlzb25PcHRpb25zLFxuICApOiBzdHJpbmcge1xuICAgIGlmIChrZXkgPT09ICckdGV4dCcpIHtcbiAgICAgIGNvbnN0IG1ldGEgPSBnZXRNZXRhKGVudGl0eSk7XG4gICAgICBjb25zdCBzZWFyY2ggPSB2YWwgYXMgUXVlcnlUZXh0U2VhcmNoT3B0aW9uczxFPjtcbiAgICAgIGNvbnN0IGZpZWxkcyA9IHNlYXJjaC4kZmllbGRzLm1hcCgoZmllbGQpID0+IHRoaXMuZXNjYXBlSWQobWV0YS5maWVsZHNbZmllbGRdPy5uYW1lID8/IGZpZWxkKSk7XG4gICAgICByZXR1cm4gYCR7dGhpcy5lc2NhcGVJZChtZXRhLm5hbWUpfSBNQVRDSCB7JHtmaWVsZHMuam9pbignICcpfX0gOiAke3RoaXMuZXNjYXBlKHNlYXJjaC4kdmFsdWUpfWA7XG4gICAgfVxuICAgIHJldHVybiBzdXBlci5jb21wYXJlKGVudGl0eSwga2V5LCB2YWwsIG9wdHMpO1xuICB9XG5cbiAgb3ZlcnJpZGUgZXNjYXBlKHZhbHVlOiBhbnkpOiBTY2FsYXIge1xuICAgIHJldHVybiBzcWxzdHJpbmcuZXNjYXBlKHZhbHVlKTtcbiAgfVxufVxuIl19 |
23173
12