@sqb/connect
Advanced tools
Comparing version 4.0.1-beta.32 to 4.0.1-beta.33
@@ -36,2 +36,4 @@ import type { Repository } from '../repository.class'; | ||
sort?: string[]; | ||
prefix?: string; | ||
suffix?: string; | ||
}): Promise<void>; | ||
@@ -38,0 +40,0 @@ private _selectColumn; |
@@ -81,2 +81,4 @@ "use strict"; | ||
opts.sort.map(x => x.toLowerCase()) : undefined; | ||
const prefix = opts.prefix || ''; | ||
const suffix = opts.suffix || ''; | ||
for (const key of entity.elementKeys) { | ||
@@ -95,3 +97,3 @@ const col = entity.getElement(key); | ||
if (orm_helper_1.isColumnElement(col)) { | ||
const fieldAlias = this._selectColumn(tableAlias, col); | ||
const fieldAlias = this._selectColumn(tableAlias, col, prefix, suffix); | ||
// Add column to converter | ||
@@ -117,2 +119,4 @@ if (!col.hidden) | ||
entity: typ, | ||
prefix: col.fieldNamePrefix, | ||
suffix: col.fieldNameSuffix, | ||
elements: extractSubElements(colNameLower, requestElements), | ||
@@ -177,7 +181,10 @@ exclude: extractSubElements(colNameLower, excludeElements), | ||
} | ||
_selectColumn(tableAlias, el) { | ||
const fieldAlias = tableAlias + '_' + el.name.toUpperCase(); | ||
_selectColumn(tableAlias, el, prefix, suffix) { | ||
const fieldName = (prefix || '').toLowerCase() + | ||
el.fieldName.toUpperCase() + | ||
(suffix || '').toLowerCase(); | ||
const fieldAlias = tableAlias + '_' + fieldName; | ||
this._selectColumns[fieldAlias] = { | ||
element: el, | ||
statement: tableAlias + '.' + el.fieldName + ' as ' + fieldAlias | ||
statement: tableAlias + '.' + fieldName + ' as ' + fieldAlias | ||
}; | ||
@@ -184,0 +191,0 @@ return fieldAlias; |
{ | ||
"name": "@sqb/connect", | ||
"description": "Multi-dialect database connection framework written with TypeScript", | ||
"version": "4.0.1-beta.32", | ||
"version": "4.0.1-beta.33", | ||
"author": "Panates Ltd.", | ||
@@ -48,3 +48,3 @@ "contributors": [ | ||
"peerDependencies": { | ||
"@sqb/builder": "^4.0.1-beta.32" | ||
"@sqb/builder": "^4.0.1-beta.33" | ||
}, | ||
@@ -51,0 +51,0 @@ "main": "dist/index.js", |
181426
4552