Releases: UN-OCHA/hpc-api-core
Add more options to some utility methods
Add sourceProjectId column to track the source of a cloned project
New column sourceProjectId
got added to project
model (#72)
Don't include deleted data by default
When using find
and findOne
on models defined with sequelize, rows which have deletedAt
field different from null
are now excluded by default. New option includeDeleted
should be used to include virtually deleted rows (#70)
Accept empty array parameter in createMany
[BUG FIX]
When passing empty array to createMany
, error is no longer thrown, but empty array returned instead (#69)
Fix type of category.group field in model definitions
Field catagory.group
is now correctly defined as a string, fixing bug where it was defined as branded integer (#68)
Add new data fetching utility methods
Introduce new custom where condition construction
[BREAKING CHANGE]
New custom where
construction is allowing for specifying conditions like ... IS NOT NULL
, WHERE [NOT] IN ...
, LIKE ...
, WHERE BETWEEN...
, <
, >
comparison operators and more, in type-safe manner (#66)
Allow limit, offset and orderBy inside queries
Define bigint and numeric columns as a union of string and number
Columns with type int8
/bigint
and numeric
in PostgreSQL, which were previously defined with t.bigint
and t.number
codecs respectively, are defined as a union of t.string
and t.number
now (#62)
Define most of the remaining models
Following models have been defined (#46): blueprint
, cache
, category
, categoryGroup
, categoryRef
, client
, currency
, disaggregationCategory
, disaggregationCategoryGroup
, disaggregationModel
, emergency
, emergencyLocation
, endpointLog
, endpointUsage
, externalData
, externalReference
, fileAssetEntity
, fileRecord
, flow
, flowLink
, flowObject
, flowObjectType
, globalCluster
, globalClusterAssociation
, globalIndicator
, iatiActivity
, iatiPublisher
, iatiRecipientCountry
, iatiTransaction
, job
, jobAssociation
, measurement
, measurementVersion
, organizationLocation
, participantCountry
, participantOrganization
, planEmergency
, planLocation
, planReportingPeriod
, planTag
, procedureEntityPrototype
, procedureSection
, procedureSectionField
, projectGlobalClusters
, projectLocations
, projectVersionComment
, projectVersionPlanEntity
, tag
, task
, unit
, unitType
and workflowStatusOptionStep
.