Method upsertSingleton

api/src/services/items.ts:1279–1289

* Upsert/treat collection as singleton. * * Uses `this.createOne` / `this.updateOne` under the hood.

(data: Partial<Item>, opts?: MutationOptions)

	 * Uses `this.createOne` / `this.updateOne` under the hood.
	 */
	async upsertSingleton(data: Partial<Item>, opts?: MutationOptions): Promise<PrimaryKey> {
		const primaryKeyField = this.schema.collections[this.collection]!.primary;

		const record = await this.knex.select(primaryKeyField).from(this.collection).limit(1).first();

		if (record) {
			return await this.updateOne(record[primaryKeyField], data, opts);
		}

		return await this.createOne(data, opts);
	}
}