Class: BaseUserRouteSQL

Defined in: src/routes/sql/BaseUserRouteSQL.ts:11

Extends

• BaseUserRoute<UserSQL>

Constructors

Constructor

new BaseUserRouteSQL(): BaseUserRouteSQL

Returns

BaseUserRouteSQL

Inherited from

BaseUserRoute.constructor

Properties

_objectFactory?

protected optional _objectFactory?: ObjectFactory

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:101

Inherited from

BaseUserRoute._objectFactory

---

aclUtils?

protected optional aclUtils?: ACLUtils

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:102

Inherited from

BaseUserRoute.aclUtils

---

authConfig?

protected optional authConfig?: any

Defined in: src/routes/BaseUserRoute.ts:46

Inherited from

BaseUserRoute.authConfig

---

config?

protected optional config?: any

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:104

The global application configuration.

Inherited from

BaseUserRoute.config

---

defaultACLUid

protected defaultACLUid: string

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:106

The unique identifier of the default ACL for the model type.

Inherited from

BaseUserRoute.defaultACLUid

---

defaultScopes

protected defaultScopes: string[] = []

Defined in: src/routes/BaseUserRoute.ts:43

Inherited from

BaseUserRoute.defaultScopes

---

logger

protected logger: any

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:107

Inherited from

BaseUserRoute.logger

---

notificationUtils?

protected optional notificationUtils?: NotificationUtils

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:108

Inherited from

BaseUserRoute.notificationUtils

---

repoUtils?

protected optional repoUtils?: RepoUtils<UserSQL>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:112

The repository utility class to use for common operations.

Inherited from

BaseUserRoute.repoUtils

---

repoUtilsClass

protected readonly repoUtilsClass: any = RepoUtils

Defined in: src/routes/sql/BaseUserRouteSQL.ts:12

The class of the RepoUtils to use when instantiating the utility.

Overrides

BaseUserRoute.repoUtilsClass

---

tokenUtils?

protected optional tokenUtils?: TokenUtils

Defined in: src/routes/BaseUserRoute.ts:49

Inherited from

BaseUserRoute.tokenUtils

---

trackChanges

protected trackChanges: number

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:117

The number of previous document versions to store in the database. A negative value indicates storing all versions, a value of 0 stores no versions.

Inherited from

BaseUserRoute.trackChanges

---

trustedRoles

protected trustedRoles: string[]

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:118

Inherited from

BaseUserRoute.trustedRoles

Accessors

modelClass

Get Signature

get modelClass(): any

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:122

The class type of the model this route is associated with.

Returns

any

Inherited from

BaseUserRoute.modelClass

Methods

count()

count(params, query, res, user?): Promise<any>

Defined in: src/routes/BaseUserRoute.ts:59

Parameters

params

any

query

any

res

HttpResponse

user?

JWTUser

Returns

Promise<any>

Inherited from

BaseUserRoute.count

---

create()

create(obj, req, res, user?): Promise<AuthResult>

Defined in: src/routes/BaseUserRoute.ts:89

Parameters

obj

UserSQL

req

HttpRequest

res

HttpResponse

user?

JWTUser

Returns

Promise<AuthResult>

Inherited from

BaseUserRoute.create

---

delete()

delete(id, version, purge, req, user?): Promise<void>

Defined in: src/routes/BaseUserRoute.ts:149

Parameters

id

string

version

string | undefined

purge

string | undefined

req

HttpRequest

user?

JWTUser

Returns

Promise<void>

Inherited from

BaseUserRoute.delete

---

doBulkCreate()

protected doBulkCreate(objs, options): Promise<UserSQL[]>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:151

Attempts to store a collection of objects provided in options.req.body into the datasource. Upon success, sets the newly persisted object(s) to the result property of the options.res argument, otherwise sends a 400 BAD REQUEST response to the client.

Parameters

objs

Partial<UserSQL>[]

The object(s) to store in the database.

options

CreateRequestOptions

The options to process the request using.

Returns

Promise<UserSQL[]>

Inherited from

BaseUserRoute.doBulkCreate

---

doBulkUpdate()

protected doBulkUpdate(objs, options): Promise<UserSQL[]>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:203

Attempts to modify a collection of existing data model objects.

Parameters

objs

UpdateObject<UserSQL>[]

The object(s) to bulk update in the database.

options

UpdateRequestOptions<UserSQL>

The options to process the request using.

Returns

Promise<UserSQL[]>

Inherited from

BaseUserRoute.doBulkUpdate

---

doCount()

protected doCount(options): Promise<HttpResponse>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:133

Attempts to retrieve the number of data model objects matching the given set of criteria as specified in the request query. Any results that have been found are set to the content-length header of the res argument.

Parameters

options

FindRequestOptions

The options to process the request using.

Returns

Promise<HttpResponse>

Inherited from

BaseUserRoute.doCount

---

doCreate()

protected doCreate(obj, options): Promise<UserSQL | UserSQL[]>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:160

Attempts to store one or more objects provided in options.req.body into the datasource. Upon success, sets the newly persisted object(s) to the result property of the options.res argument, otherwise sends a 400 BAD REQUEST response to the client.

Parameters

obj

Partial<UserSQL> | Partial<UserSQL>[]

The object(s) to store in the database.

options

CreateRequestOptions

The options to process the request using.

Returns

Promise<UserSQL | UserSQL[]>

Inherited from

BaseUserRoute.doCreate

---

doCreateObject()

protected doCreateObject(obj, options): Promise<UserSQL>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:142

Attempts to store an object provided in options.req.body into the datasource. Upon success, sets the newly persisted object(s) to the result property of the options.res argument, otherwise sends a 400 BAD REQUEST response to the client.

Parameters

obj

Partial<T>

The object to store in the database.

options

CreateRequestOptions

The options to process the request using.

Returns

Promise<UserSQL>

Inherited from

BaseUserRoute.doCreateObject

---

doDelete()

protected doDelete(id, options): Promise<void>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:168

Attempts to delete an existing data model object with a given unique identifier encoded by the URI parameter id.

Parameters

id

string

The unique identifier of the object to delete.

options

DeleteRequestOptions

The options to process the request using.

Returns

Promise<void>

Inherited from

BaseUserRoute.doDelete

---

doExists()

protected doExists(id, options): Promise<any>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:175

Attempts to determine if an existing object with the given unique identifier exists.

Parameters

id

string

The unique identifier of the object to verify exists.

options

FindRequestOptions

The options to process the request using.

Returns

Promise<any>

Inherited from

BaseUserRoute.doExists

---

doFind()

protected doFind(options): Promise<UserSQL[]>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:183

Attempts to retrieve all data model objects matching the given set of criteria as specified in the request query. Any results that have been found are set to the result property of the res argument. result is never null.

Parameters

options

FindRequestOptions

The options to process the request using.

Returns

Promise<UserSQL[]>

Inherited from

BaseUserRoute.doFind

---

doFindById()

protected doFindById(id, options): Promise<UserSQL | null>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:189

Attempts to retrieve a single data model object as identified by the id parameter in the URI.

Parameters

id

string

options

FindRequestOptions

The options to process the request using.

Returns

Promise<UserSQL | null>

Inherited from

BaseUserRoute.doFindById

---

doTruncate()

protected doTruncate(options): Promise<void>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:196

Attempts to remove all entries of the data model type from the datasource matching the given parameters and query.

Parameters

options

TruncateRequestOptions

The options to process the request using.

Returns

Promise<void>

Inherited from

BaseUserRoute.doTruncate

---

doUpdate()

protected doUpdate(id, obj, options): Promise<UserSQL>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:210

Attempts to modify an existing data model object as identified by the id parameter in the URI.

Parameters

id

string

obj

UpdateObject<UserSQL>

The object to update in the database

options

UpdateRequestOptions<UserSQL>

The options to process the request using.

Returns

Promise<UserSQL>

Inherited from

BaseUserRoute.doUpdate

---

doUpdateProperty()

protected doUpdateProperty(id, propertyName, value, options): Promise<UserSQL>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:221

Attempts to modify a single property of an existing data model object as identified by the id parameter in the URI.

Note that this effectively bypasses optimistic locking and can cause unexpected data overwrites. Use with care.

Parameters

id

string

The unique identifier of the object to update.

propertyName

string

The name of the property to update.

value

any

The value of the property to set.

options

UpdateRequestOptions<UserSQL>

The options to process the request using.

Returns

Promise<UserSQL>

Inherited from

BaseUserRoute.doUpdateProperty

---

exists()

exists(id, query, res, user?): Promise<any>

Defined in: src/routes/BaseUserRoute.ts:167

Parameters

id

string

query

any

res

HttpResponse

user?

JWTUser

Returns

Promise<any>

Inherited from

BaseUserRoute.exists

---

find()

find(params, query, user?): Promise<UserSQL[]>

Defined in: src/routes/BaseUserRoute.ts:181

Parameters

params

any

query

any

user?

JWTUser

Returns

Promise<UserSQL[]>

Inherited from

BaseUserRoute.find

---

findById()

findById(id, query, user?): Promise<UserSQL | null>

Defined in: src/routes/BaseUserRoute.ts:190

Parameters

id

string

query

any

user?

JWTUser

Returns

Promise<UserSQL | null>

Inherited from

BaseUserRoute.findById

---

truncate()

truncate(params, query, user?): Promise<void>

Defined in: src/routes/BaseUserRoute.ts:200

Parameters

params

any

query

any

user?

JWTUser

Returns

Promise<void>

Inherited from

BaseUserRoute.truncate

---

update()

update(id, obj, req, user?): Promise<UserSQL>

Defined in: src/routes/BaseUserRoute.ts:244

Parameters

id

string

obj

UpdateObject<UserSQL>

req

HttpRequest

user?

JWTUser

Returns

Promise<UserSQL>

Inherited from

BaseUserRoute.update

---

validate()

validate(objs, options?): Promise<void>

Defined in: node_modules/@rapidrest/service-core/dist/types/routes/ModelRoute.d.ts:225

Calls repoUtils.validate() to validate the object(s) provided.

Parameters

objs

Partial<UserSQL> | Partial<UserSQL>[]

options?

CreateRequestOptions | UpdateRequestOptions<UserSQL>

Returns

Promise<void>

Inherited from

BaseUserRoute.validate

---

validateCreate()

protected validateCreate(obj, user?): Promise<void>

Defined in: src/routes/BaseUserRoute.ts:68

Parameters

obj

Partial<T>

user?

JWTUser

Returns

Promise<void>

Inherited from

BaseUserRoute.validateCreate

---

validateUpdate()

protected validateUpdate(id, obj, user?): Promise<void>

Defined in: src/routes/BaseUserRoute.ts:204

Parameters

id

string

obj

UpdateObject<UserSQL>

user?

JWTUser

Returns

Promise<void>

Inherited from

BaseUserRoute.validateUpdate