flexgres

flexgres

Flexibly change your Postgres schemas with Flexgres

Installation

npm install flexgres --save

Usage

You will need to use the pg-query package and the pg driver. You can install it by writing:

npm install pg-query pg --save

Configuring your table is really simple all you have to do is define your table structure in JSON. An example usage is:

var name = "chris", password = "12345", host = "localhost", port = "5432", db = "flexgres";

var client    = require("pg");
var queryConn = "postgres://"+name+":"+password+"@"+host+":"+port+"/"+db+"";

    client    = new pg.Client(queryConn);

require("./test.js")({
  "driver": client,
  "logging": true,
  "tables": [
    {
      "tableName": "test",
      "columns": [
        {
        "name": "id",
        "type": "INT",
        "primary": true,
        "null": false
        },
        {
        "name": "name",
        "type": "text",
        "primary": true,
        "null": false
        }
      ]
    },
    {
      "tableName": "testTable",
      "columns": [
        {
        "name": "test",
        "type": "INT",
        "primary": true,
        "null": false
        },
        {
        "name": "test2",
        "type": "text",
        "primary": false,
        "null": false
        }
      ]
    }
  ]
})