Amount of the payment in cents
The amount of the payment in the smallest currency unit (e.g., cents for EUR). For example, 1000 represents 10.00 EUR.
Timestamp of when the payment was created
The date and time when this payment was created.
Currency of the payment
The three-letter ISO currency code (e.g., 'eur', 'usd').
Description of the payment
A human-readable description of what the payment is for.
Unique identifier for the payment
Auto-generated primary key for the payment entity.
Status of the payment
The current status of the payment (e.g., 'requires_payment_method', 'pending', 'succeeded', 'failed').
ID of the Stripe PaymentIntent
The unique identifier of the Stripe PaymentIntent associated with this payment. This is used to track the payment in Stripe.
Number of surveys that will be added to the user's quota
The number of surveys that will be added to the user's quota when the payment is successful. This is determined by the package purchased.
Timestamp of when the payment was last updated
The date and time when this payment was last updated.
Relation to the User entity
The user who made this payment. This is a many-to-one relationship with the User entity.
ID of the user who made the payment
The ID of the user who made this payment.
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.
Static
averageStatic
clearStatic
countStatic
countStatic
createCreates a new entity instance.
Creates a new entities and copies all entity properties from given objects into their new entities. Note that it copies only properties that present in entity schema.
Creates a new entity instance and copies all entity properties from this object into a new entity. Note that it copies only properties that present in entity schema.
Static
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
findStatic
findStatic
findStatic
findFinds entities by ids. Optionally find options can be applied.
use findBy
method instead in conjunction with In
operator, for example:
.findBy({ id: In([1, 2, 3]) })
Static
findStatic
findStatic
findFinds first entity that matches given options.
use findOneBy
method instead in conjunction with In
operator, for example:
.findOneBy({ id: 1 // where "id" is your primary column name })
Static
findStatic
findStatic
getStatic
getStatic
hasStatic
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
saveSaves all given entities in the database. If entities do not exist in the database then inserts, otherwise updates.
Saves a given entity in the database. If entity does not exist in the database then inserts, otherwise updates.
Static
softRecords the delete date of all given entities.
Records the delete date of a given entity.
Static
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
use
Payment Entity
Description
Represents a payment entity in the database. This class defines the structure of the payment entity in database:
id
: unique identifier for the payment.amount
: amount of the payment in cents.currency
: currency of the payment (e.g., 'eur').status
: status of the payment (e.g., 'succeeded', 'failed').stripePaymentIntentId
: ID of the Stripe PaymentIntent.description
: description of the payment.surveyCount
: number of surveys that will be added to the user's quota.userId
: ID of the user who made the payment.user
: relation to the User entity.createdAt
: timestamp of when the payment was created.updatedAt
: timestamp of when the payment was last updated.Example