fhirbase
FhirbaseDemoDownloadGithub
  • Overview
  • Getting Started
  • Getting Started (Docker version)
  • Writing Queries
  • Schema
  • JSON Format
  • CRUD
  • Command-Line Interface
  • Fhirpath.pg
  • Integrations
    • Python
    • .NET
Powered by GitBook
On this page

CRUD

Fhirbase provides functions to Create, Read, Delete and Update resources. There are two variants of these functions: first accepts txid and second does not.

fhirbase_create (resource jsonb, [txid bigint])

This function creates or recreates a FHIR resource. When a resource with the same ID exist, it will be moved into the history table and the new resource will have recreated status. If resource argument doesn't contain an id attribute, the value returned by fhirbase_genid function will be used as an ID.

SELECT fhirbase_create('{"resourceType": "Patient", "id": "pt1"}'::jsonb);

> {
>  "resourceType": "Patient",
>  "id": "pt1", 
>  "meta": {"versionId": "90", "lastUpdated": "2018-08-11T19:33:37.845344+00:00"}
> }
​
-- without an ID
SELECT fhirbase_create(
 '{"resourceType": "Patient", "name": [{"family": "Smith"}]}'::jsonb
);
​
-- with txid
SELECT fhirbase_create('{"resourceType": "Patient", "id": "pt2"}'::jsonb, 100);

PreviousJSON FormatNextCommand-Line Interface

Last updated 6 years ago