Category of the survey
Timestamp when the survey was created
Description of the survey
Unique identifier for the survey
Whether the survey is public
Questions in the survey
Status of the survey
Title of the survey
Timestamp when the survey was last updated
The user who created the survey
Static
targetReturns object that is managed by this repository. If this repository manages entity from schema, then it returns a name of that schema instead.
Checks if entity has an id. If entity composite compose ids, it will check them all.
Recovers a given entity in the database.
Optional
options: SaveOptionsReloads entity data from the database.
Removes current entity from the database.
Optional
options: RemoveOptionsSaves current entity in the database. If entity does not exist in the database then inserts, otherwise updates.
Optional
options: SaveOptionsRecords the delete date of current entity.
Optional
options: SaveOptionsStatic
averageStatic
clearClears all the data from the given table/collection (truncates/drops it).
Static
countStatic
countStatic
createStatic
createStatic
deleteDeletes entities by a given criteria. Unlike remove method executes a primitive operation without cascades, relations and other operations included. Executes fast and efficient DELETE query. Does not check if entity exist in the database.
Static
existsStatic
existsStatic
findStatic
findFinds entities that match given find options. Also counts all entities that match given conditions, but ignores pagination settings (from and take options).
Static
findStatic
findStatic
findStatic
findStatic
findStatic
findStatic
findStatic
findStatic
getStatic
getStatic
hasChecks entity has an id. If entity composite compose ids, it will check them all.
Static
insertInserts a given entity into the database. Unlike save method executes a primitive operation without cascades, relations and other operations included. Executes fast and efficient INSERT query. Does not check if entity exist in the database, so query will fail if duplicate entity is being inserted.
Static
maximumStatic
mergeStatic
minimumStatic
preloadCreates a new entity from the given plain javascript object. If entity already exist in the database, then it loads it (and everything related to it), replaces all values with the new ones from the given object and returns this new entity. This new entity is actually a loaded from the db entity with all properties replaced from the new object.
Note that given entity-like object must have an entity id / primary key to find entity by. Returns undefined if entity with given id was not found.
Static
queryExecutes a raw SQL query and returns a raw database results. Raw query execution is supported only by relational databases (MongoDB is not supported).
Optional
parameters: any[]Static
removeStatic
saveStatic
softStatic
sumStatic
updateUpdates entity partially. Entity can be found by a given conditions. Unlike save method executes a primitive operation without cascades, relations and other operations included. Executes fast and efficient UPDATE query. Does not check if entity exist in the database.
Static
upsertInserts a given entity into the database, unless a unique constraint conflicts then updates the entity Unlike save method executes a primitive operation without cascades, relations and other operations included. Executes fast and efficient INSERT ... ON CONFLICT DO UPDATE/ON DUPLICATE KEY UPDATE query.
Static
useSets DataSource to be used by entity.
Survey Entity
Description
Represents a survey entity in the database.
Param: name
is the entity's name in database.
This class defines the structure of the survey entity in database:
id
: unique identifier for the survey.title
: title of the survey (must be unique).description
: detailed information or context about the survey.status
: the current state of the survey (draft
,publish
,archive
,censored
), defaults todraft
.public
: defines whether the survey is accessible publicly or only to selected users.user
: the creator of the survey (relation to theUser
entity).category
: the category to which the survey belongs (relation to theCategory
entity).createdAt
: timestamp of when the survey was created.updatedAt
: timestamp of when the survey was last updated.Example
Decorators used:
@Entity()
: Declares the class as a database entity.@PrimaryGeneratedColumn()
: Marks the primary key column with auto-increment.@Column()
: Maps a class property to a database column.@ManyToOne()
: Defines a many-to-one relationship between entities.@OneToMany()
: Defines a one-to-many relationship between entities.@Field()
: Exposes a class property to the GraphQL schema.