@kblue/pg-tools
tools for working with postgresql database
Last updated 10 months ago by lichr .
ISC · Repository · Original npm · Tarball · package.json
$ cnpm install @kblue/pg-tools 
SYNC missed versions from official npm registry.

Restful Database Tools for PostgreSQL

Features

  • schema management
    • load-schema
      • resource template
        • tables
        • functions
      • sql files
    • load-data
  • json validation

Sub-Commands

# load schema from file
pg-tools schema --schema schema.yaml

# load schema and commit the changes
pg-tools schema --schema schema.yaml --no-tables
# load schema from file
pg-tools db --connection connection.yaml --force 

Create Tables For Resources

Type Description
function-resource access data via functions

Function Resources

Access the data via functions.

Entity

create table si.account (
    uuid                uuid primary key default uuid_generate_v4(),
    head                jsonb not null,
    body                jsonb not null,
    tags                text[] not null default '{}'::text[]
);

Example

head:
    id: chris-default-account
    uuid: 
    type: account
    tags:
        - default
body:

Dictionaries

Currencies

https://www.currency-iso.org/dam/downloads/lists/list_one.xml

Current Tags

  • 1.0.6                                ...           latest (10 months ago)

7 Versions

  • 1.0.6                                ...           10 months ago
  • 1.0.5                                ...           10 months ago
  • 1.0.4                                ...           10 months ago
  • 1.0.3                                ...           10 months ago
  • 1.0.2                                ...           10 months ago
  • 1.0.1                                ...           10 months ago
  • 1.0.0                                ...           10 months ago
Maintainers (1)
Downloads
Today 0
This Week 0
This Month 0
Last Day 0
Last Week 0
Last Month 0
Dependencies (12)
Dev Dependencies (14)
Dependents (0)
None

Copyright 2014 - 2017 © taobao.org |