loopback-component-storage-postgres

LoopBack storage postgres component provides Node.js and REST APIs to manage binary contents using Postgres Large Object

Installation

Install the storage component as usual for a Node package:

  npm install --save loopback-component-storage-postgres

Using it

Create a table to store file descriptions

  CREATE TABLE "my-tabe-to-store-files" (
    id SERIAL PRIMARY KEY,
    container TEXT NOT NULL,
    filename TEXT NOT NULL,
    mimetype TEXT,
    objectid INTEGER UNIQUE NOT NULL
  );

Edit you datasources.json and add the following part

"pg_file": {
  "name": "pg_file",
  "connector": "loopback-component-storage-postgres",
  "host": "localhost",
  "port": 5432,
  "database": "test",
  "table": "my-table-to-store-files",
  "username": "test-user",
  "password": "test-password"
}

And the you can use it as a datasource of your model.

API

Description	Container model method	REST URI
List all containers	getContainers(callback)	GET /api/
Get information about specified container	getContainer(container, callback)	GET /api//:container
Create a new container	createContainer(options, callback)	PORT /api/
Delete specified container	destroyContainer(options, callback)	DELETE /api//:container
List all files within specified container	getFiles(container, callback)	GET /api//:container/files
Get information for specified file within specified container	getFile(container, file, callback)	GET /api//:container/files/:file
Delete a file within a given container by name	removeFile(container, file, callback)	DELETE /api//:container/files/:file
Upload one or more files into the specified container	upload(container, req, res, callback)	POST /api//:container/upload
Download a file within specified container	download(container, file, res, callback)	GET /api//:container/download/:file